当前分类： 1Z0-052
问题：多选题Which two activities are NOT supported by the Data Recovery Advisor （DRA）（）ARecover from failures in the RAC environment.BDiagnose and repair a data file corruption online.CDiagnose and repair a data file corruption offline.DDiagnose and repair failure...
查看答案
问题：多选题Which two statements are true regarding Oracle Data Pump（）AEXPDP and IMPDP are the client components of Oracle Data Pump.BDBMS_DATAPUMP PL/SQL packages can be used independently of the Data Pump clients.COracle Data Pump export and import operations ca...
问题：单选题In your database instance， the user sessions are connected to the database server from the remote machines.You want to achieve the following for these users： 1. The user account must be locked after four unsuccessful login attempts. 2. The user must be...
问题：单选题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 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 executed this command to create a temporary table： SQL CREATE GLOBAL TEMPORARY TABLE report_work_area （startdate DATE， enddate DATE， class CHAR（20））ON COMMIT PRESERVE ROWS； Which statement is true about the rows inserted into the REPORT_WORK_AREA...
问题：单选题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 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 ...
问题：单选题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 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...
问题：You want to enable archiving on your database. Presently， th...
问题：多选题Your database instance is running with full workload after database creation. You have decided to use a fixed-size undo tablespace. You want to use the Undo Advisor to estimate the capacity of the undo tablespace. Which two factors must you consider be...
问题：单选题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...
问题：单选题Note the following points describing various utilities in Oracle Database 11g： 1. It enables the transfer of data from one database to another. 2. It provides a complete solution for the backup， restoration， and recovery needs of the entire database. 3...
问题：多选题Which statements are true regarding the Oracle Data Pump export and import operations（）AYou cannot export data from a remote database.BYou can rename tables during an import operation.CYou can overwrite existing dump files during an export operation.D...
问题：单选题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...
问题：单选题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...
问题：单选题In your database instance， the user sessions are connected to the database server from the remotemachines. You want to achieve the following for these users： 1：The user account must be locked after four unsuccessful login attempts.PASSWORD_LOCK_TIME ...
问题：多选题Which two statements are true regarding the usage of the SQL*Loader utility（）AYou can load data into multiple tables during the same load session.BYou can load data from multiple files to a table during the same load session.CYou cannot perform selecti...
问题：单选题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...
