1Z0-052 题目列表
单选题In your database instance， the STATISTICS_LEVEL initialization parameter is set to BASIC. What isthe impact of this setting（）AOptimizer statistics are collected automatically.BOnly timed operating system （OS） statistics and plan execution statistics are collected.CThe snapshots for the Automatic Workload Repository （AWR） are not generated automatically.DSnapshots cannot be collected manually by using the DBMS_WORKLOAD_REPOSITORY package.EThe Oracle server dynamically generates the necessary statistics on tables as part of query optimization.
多选题You perform differential incremental level 1 backups of your database on each working day and level 0 backupon Sundays， to tape. Which two statements are true about differential incremental backups（）AThe backup performed on Sundays contains all the blocks that have ever been used in the database.BThe backup performed on Sundays contains all the blocks that have changed since the last level 1 backup.CThe backup performed on each working day contains all the blocks that have changed since the last level 0 backup.DThe backup performed on Monday contains all the blocks that have changed since the level 0 backup， and every other working day contains all the blocks that have changed since the level 1 backup
单选题All the database users are presently connected to the database instance and working. The HR userhas opened three database sessions and executed the following command in one of his sessions： SQL UPDATE persons SET ccode=’U031’ WHERE ccode=’U029’； 123 rows updated. SQL DELETE FROM persons WHERE exp=’Y’； 3 rows deleted. The SYS user opens a new session after HR executed the above commands. Which sessions can seethe effect of the UPDATE and DELETE commands （）Aall sessions of the HR user onlyBall sessions of the HR user and the SYS userCthe session of the HR user that executed the commandsDall the sessions for which the database users have access privilege to the PERSONS table
多选题Which statements regarding the server parameter file （SPFILE） are true（）AAn SPFILE is a binary file.BAn SPFILE cannot reside on a client.CAn SPFILE cannot contain static parameters.DAn SPFILE can store changes persistently across instance restarts.EAn SPFILE can be read by the database server， but it is not written to by the server.FAn SPFILE must be created manually， before creating a database， even if you use the DatabaseConfiguration Assistant （DBCA） to create the database
多选题You plan to move data from a flat file to a table in your database. You decide to use SQL*Loader direct pathload method to perform this task. The table in which you plan to load data is an important table having variousintegrity constraints defined on it. Which constraints will remain enabled by default during this operation（）ACHECKBUNIQUECNOT NULLDPRIMARY KEYEFOREIGN KEY
单选题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 table during a transaction（）AThe rows stay in the table only until session termination.BThe rows stay in the table only until the next transaction starts on the table.CThe rows are visible to all current sessions after the transaction is committed.DThe rows stay available for subsequent sessions after the transaction is committed
单选题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 recovery is started. 5. Background processes are started. 6. Data file headers are checked for consistency. 7. Server parameter file or the initialization parameter file is read. Which option has the correct order in which these steps occur（）A7， 1， 5， 2， 3， 6， 4B1， 5， 7， 2， 3， 6； step 4 is not requiredC7， 1， 5， 2， 3， 6； step 4 is not requiredThis document was downloaded from = http：//www.amaderforum.comD1， 2， 3， 5， 6， 4； step 7 is not required
多选题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
单选题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（）AThe sessions are able to perform only queries.BThe sessions are not affected and continue to function normally.CThe sessions are terminated and the active transactions are rolled back.DThe sessions are not allowed to perform any operations till the listener is started.
单选题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（）AIt records usernames and passwords of users when granted the DBA role.BIt contains usernames and passwords of users for whom auditing is enabled.CIt is used by Oracle to authenticate users for remote database administration.DIt records usernames and passwords of all users when they are added to OSDBA or OSOPER operating system groups.
多选题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 can cause the overall degradation of the database performance.DIt prompts the Checkpoint （CKPT） process to write data to the data files and redo information to the onlineredo log files
单选题In which situation is the UNDO_RETENTION parameter be ignored， even if it is set to a value（）AWhen the data file of the undo tablespace is autoextensibleBWhen there are more than one undo tablespaces available in the databaseCWhen the undo tablespace is of a fixed size and retention guarantee is not enabledDWhen the undo tablespace is autoextensible and retention guarantee is not enabled
单选题You want to enable archiving on your database. Presently， the database is running in NOARCHIVELOG mode.Given below are the steps to accomplish the task in random order： 1. Shut down the instance. 2. Execute the ALTER DATABASE ARCHIVELOG command. 3. Start up the instance and mount the database. 4. Set the DB_RECOVERY_FILE_DEST initialization parameter to $ORACLE_HOME/dest_1. 5. Open the database. Which is the correct sequence of steps for accomplishing the task（）A4， 1， 3， 2， 5B1， 3， 4， 5， 2C1， 3， 2， 5； 4 not requiredD4， 1， 5， 2； 3 not requiredE1， 3， 4， 5； 2 not required
单选题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 accidentally dropped from the database. 5） The hard disk gets corrupted and the data files in the disk are lost. 6） The database instance abnormally shuts down because of power failure. Which scenarios require DBAintervention to perform recovery（）A1， 3， and 6B4， 5， and 6C3， 4， and 5D1， 2， and 6
单选题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（）ASystem monitor （SMON）BProcess monitor （PMON）CMemory manager process （MMAN）DManageability Monitor process （MMON）