问题:单选题The TRANS_SUMMARY table contains product-wise transaction details that get updated with every transactionin the system. Each row has cumulative transaction details of a single product and every product is identified bya product code, which is the prima...
查看答案
问题:You are using Enterprise Manager to schedule backups for you...
问题:单选题You execute the following command toauditdatabase activities: SQLAUDITDROP ANY TABLE BY scott BY SESSION WHENEVER SUCCESSFUL; What is the effect of this command()A Oneauditrecord is created for every successful DROP TABLE command executed in the sess...
问题:单选题Automatic Shared Memory Management (ASMM) has been enabled for your database instance. The initialization parameters for the components that are managed by ASMM are not set. After observing the effectsof ASMM, you executed the following command: SQL AL...
问题:单选题View the Exhibit to examine the output of the DBA_OUTSTANDING_ALERTS view. After 30 minutes, you executed the following command: SQL SELECT reason,metric_value FROM dba_outstanding_alerts; REASON METRIC_VALUE ---------------------------------...
问题:单选题You have created a database link, devdb.us.oracle.com, between the databases PRODDB and DEVDB. You want to import schema objects of the HR user using Oracle Data Pump from thedevelopment database, DEVDB, to the production database, PRODDB. You execute ...
问题:多选题Which three descriptions are correct about the effects of the TRUNCATE command on a table()AThe corresponding indexes for the table are also truncated.BDelete triggers on the table are fired during the execution of the TRUNCATE command.CThe child table...
问题:多选题Which two statements are true regarding listeners()AListeners use only the TCP/IP protocol.BMultiple listener processes can run simultaneously on a host.CMultiple database instances can be registered with a single listener.DThe listener-related errors ...
问题:单选题Examine the command: SQL DBMS_STATS.SET_TABLE_PREFS(’SH’, ’CUSTOMERS’, ’PUBLISH’, ’false’); Which statement describes the effect of the above command()A Automatic statistics collection is stopped for the CUSTOMERS table.B Statistics for the CUSTOMERS ...
问题:Examine the commands executed in the following sequence: 1:...
问题:单选题You want to import schema objects of the HR user using Oracle Data Pump from the development database,DEVDB, to the production database, PRODDB. A database link devdb.us.oracle.com is created betweenPRODDB and DEVDB. You execute the following command o...
问题:To make audit information more productive, the DBA executes ...
问题:单选题In your database instance, the STATISTICS_LEVEL initialization parameter is set to BASIC. What isthe impact of this setting()A Optimizer statistics are collected automatically.B Only timed operating system (OS) statistics and plan execution statistics...
问题:单选题You are managing an Oracle Database 11g database with this backup strategy: - Every Sunday night, level 0 backup is performed. - On Monday night and subsequent days, level 1 incremental backup is performed. The backups are not cumulative incremental...
问题:多选题A database user SMITH tries to query the V$SESSION view and fails to access it as follows: SQL connect smith/smith Connected. SQL SELECT * FROM v$session; SELECT * FROM v$session * ERROR at line 1: ORA-00942: table or view does not exist Which ar...
问题:多选题You execute this command to drop the ITEM table, which has the primary key referred in the ORDERS table:SQL DROP TABLE scott.item CASCADE CONSTRAINTS PURGE; Which two statements are true about theeffect of the command()ANo flashback is possible to bri...
问题:多选题You are managing an Oracle Database 11g database with the following backup strategy: 1.On Sunday, an incremental level 0 tape backup is performed. 2.Monday through Saturday, acumulativeincremental level 1 tape backup is performed. Which two statemen...
问题:单选题You want to create a role to meet these requirements: 1:The role is to be protected from unauthorized usage. 2:The password of the role is not to be embedded in the application source code or stored in a table. Which method would you use to restrict...
问题:单选题Automatic Shared Memory Management is disabled for your database instance. You realize that there arecases of SQL statements performing poorly because of repeated parsing activity, resulting in degradation ofperformance. What would be your next step t...
问题:单选题You used the IMMEDIATE option to shut down your database instance. Consider the steps that may occurwhen a database instance is started and database is opened: 1. SGA is allocated. 2. Control file is read. 3. Redo log files are opened.4. Instance recov...