当前分类： 1Z0-052
问题：单选题In which situation may the UNDO_RETENTION parameter be ignored， even if it is set to a value（）A when the data file of the undo tablespace is autoextensibleB when there are more than one undo tablespaces available in the databaseC when the undo tablespa...
查看答案
问题：多选题Which three operations require undo data（）Acommitting a transactionBflashing back a transactionCrecovering a failed transactionDrunning a read-consistent queryEchanging a tablespace status from READ ONLY to READ WRITE...
问题：单选题In which situation is the UNDO_RETENTION parameter be ignored， even if it is set to a value（）A When the data file of the undo tablespace is autoextensibleB When there are more than one undo tablespaces available in the databaseC When the undo tablespac...
问题：单选题The user HR owns the EMP table. The user HR grants privileges to the user SCOTT by using this command： SQL GRANT SELECT，INSERT，UPDATE ON emp TO scott WITH GRANT OPTION； The user SCOTT executes this command to grant privileges to the user JIM： SQL GRAN...
问题：单选题You have issued a SHUTDOWN ABORT command to bring down your database instance. Considerthe steps that will be performed later when you open the database： 1：SGA is allocated. 2：Control file is read. 3：Redo log files are read. 4：Instance recovery is ...
问题：单选题You executed this command to create a temporary table： SQL CREATE GLOBAL TEMPORARY TABLE report_work_area （startdate DATE， enddateDATE， class CHAR（20）） ON COMMIT PRESERVE ROWS； Which statement is true about the rows inserted into the REPORT_WORK_AREA t...
问题：You want to enable archiving on your database. Presently， th...
问题：单选题ote the following structures in your database server： 1：Extents 2：OS Blocks 3：Tablespace 4：Segments 5：Oracle Data Block Which option has the correct arrangement of these structures from the smallest to the largest（）A 2， 5， 1， 4， 3B 1， 2， 3， 4， 5C 5，...
问题：单选题Why does performance degrade when many UPDATE， INSERT， or DELETE statements are issued on a tablethat has an associated Bitmap index（）A The DML operations re-create the Bitmap index blocks.B The Bitmap index is rebuilt automatically after a DML operati...
问题：单选题Your database is open and the LISTENER listener is running. The new DBA of the system stops thelistener by using the command： LSNRCTL STOP What happens to the sessions that are presently connected to the database instance（）A The sessions are able to ...
问题：多选题Which statements are true about checkpointing（）AThe checkpoint frequency decreases with the smaller redo log file size.BIt ensures that all committed data is written to the data files during normal shutdown.CThe frequent full checkpoint in a database ...
问题：单选题Given below is a list of scenarios： 1） A user terminates his session abnormally. 2） The connection between the server and the client application terminates because of a network failure. 3） A schema is accidentally dropped. 4） The tablespace is accident...
问题：Which statements are true about logical structures of the Or...
问题：单选题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...
问题：单选题You have set Tablespace Full Metrics Threshold values for the USERS tablespace as follows：Warning （%）： 90Critical （%）： 95 Which background process is responsible for issuing alerts when the threshold is crossed（）A System monitor （SMON）B Process monitor...
问题：单选题You have set Tablespace Full Metrics Threshold values for the USERS tablespace as follows： Warning （%）： 90 Critical （%）： 95 Which background process is responsible for issuing alerts when the threshold is crossed（）A System monitor （SMON）B Process mon...
问题：多选题A constraint in a table is defined with the INITIALLY IMMEDIATE clause. You executed the ALTER TABLEcommand with the ENABLE VALIDATE option to enable the constraint that was disabled. What are the twoeffects of this command（）AIt fails if any existing ...
问题：单选题in your database instance， the STATISTICS_LEVEL initialization parameter is set to BASIC. What is the impactof this setting（）A Optimizer statistics are collected automatically.B Only timed operating system （OS） statistics and plan execution statistics...
问题：单选题ou executed the command to create a password file in the database server： $ orapwd file=orapworcl entries=5 ignorecase=N Which statement describes the purpose of the above password file（）A It records usernames and passwords of users when granted the D...
