站内搜索
1Z0-052 问题列表
问题
单选题You plan to configure the new Oracle Database 11g installation by performing these tasks： - Use Automatic Storage Management （ASM） as the storage option. - Use Oracle Enterprise Manager Database Control to manage the database. - Provide the same password for SYS， SYSTEM， SYSMAN， and DBSNMP accounts during theinstallation. - Configure the database to send email notifications. Some tools available to you for installation are： 1：Oracle Universal Installer （OUI） 2：Database Configuration Assistant （DBCA） 3：Database Upgrade Assistant （DBUA） 4：Oracle Net Configuration Assistant Which tools would you use for this installation（）A
2B
3C
1 and 2D
3 and 4E
1，2，and 4
问题
单选题Your database is open and the LISTENER listener is running. The new DBA of the system stops the listener byusing the command：LSNRCTL STOP What happens to the sessions that are presently connected to the database instance（）A
The sessions are able to perform only queries.B
The sessions are not affected and continue to function normally.C
The sessions are terminated and the active transactions are rolled back.D
The sessions are not allowed to perform any operations till the listener is started
问题
多选题You are managing an Oracle Database 11g database. You configured the database to run inARCHIVELOG mode. Which two statements are true in this scenario（）AYou must shut down the database instance to perform the backups.BYou must configure the Flash Recovery Area （FRA） for the database.CYou can perform complete database backups without closing the database.DAll the previous closed database backups including control files become invalid after you configure thedatabase to ARCHIVELOG mode.
问题
单选题User A executes the following command to drop a large table in your database： SQL DROP TABLE trans； While the drop table operation is in progress， user B executes the following command on the same table： SQL DELETE FROM trans WHERE tr_type=’SL’； Which statement is true regarding the DELETE command（）A
It fails with a Resource Busy error.B
It deletes the rows successfully because the table is locked in SHARE mode.C
It fails to delete the records because the table is locked in EXCLUSIVE mode.D
It deletes the rows successfully because the table is locked in SHARE ROW EXCLUSIVE mode.
问题
多选题Which two statements correctly describe the relation between a data file and the logical database structures（）AAn extent cannot spread across data files.BA segment cannot spread across data files.CA data file can belong to only one tablespace.DA data file can have only one segment created in it.EA data block can spread across multiple data files as it can consist of multiple operating system （OS）blocks
问题
单选题You are installing Oracle Database 11g on your server. During the installation Oracle UniversalInstaller （OUI） prompts you to enter the path of the inventory directory and also prompts you to specify anoperating system group name. Which statement is true in this case（）A
The ORACLE_BASE parameter is not set.B
The installation is being performed by the root user.C
The operating system group that will be specified should have root user as its member.D
The installation is being performed without the Create Starter Database option selected.E
The operating system group that will be specified must have permission to write to the inventorydirectory.
问题
多选题Which two statements are true regarding transactions in an Oracle database（）AMultiple transactions can use the same undo segment.BA transaction is assigned an undo segment when it is started.CMore than one transaction cannot share the same extent in the undo tablespace.DThe transactions use system undo segment to store undo data if all the segments in the undo tablespaceare used.
问题
多选题Examine the command： SQL ALTER USER skd ACCOUNT LOCK； Which two statements are true after the command is executed（）AThe SKD user cannot log in to the database instance.BThe objects owned by the SKD user are not accessible to any user.CThe other users can access the objects owned by the SKD user， on which they have access.DThe password for the SKD user expires and the user is forced to change the password at the next log in.
问题
单选题Which statement is true about the UNDO_RETENTION parameter when retention guarantee is notenabled（）A
It is the time period after which the undo data becomes obsolete.B
It is the time period after which the committed undo data would be transferred to a temporarytablespace.C
It is the minimum time period up to which the committed undo data would be retained if free undo spaceis available.D
It is the time period after which the undo data is transferred to the Flash Recovery Area to provide readconsistency.
问题
单选题You want to configure and schedule offline database backups to run automatically. Which tool or utility wouldyou use to achieve this（）A
The XML scriptB
The PL/SQL scriptC
The DBMS_SCHEDULER packageD
Enterprise Manager to schedule the backup
问题
多选题Which two statements are true regarding B-tree index（）AThe leaf blocks in the index are doubly linked.BThe leaf node stores a bitmap for each key value.CThe rows with NULL value in key columns also have entries in the index.DThe deletion of a row from the table causes a logical deletion in index leaf block and the space becomes available for the new leaf entry.
问题
多选题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 before using the Undo Advisor to estimate the capacity of the undotablespace（）AThe retention period to support flashbackBThe expected length of the longest-running queryCThe number of undo tablespaces in the databaseDThe size of the Flash Recovery Area for the database instance
问题
单选题Which statement is true about loading data using the conventional path of SQL*Loader（）A
Redo is not generated while performing conventional path loads.B
Only PRIMARY KEY， UNIQUE KEY， and NOT NULL constraints are checked.C
No exclusive locks are acquired when the conventional path loads are performed.D
Instead of performing transactions， SQL*Loader directly writes data blocks to the data files.E
INSERT triggers are disabled before the conventional path load and reenabled at the end of the load
问题
多选题Which two statements are true about setting the FAST_START_MTTR_TARGET initializationparameter to a nonzero value（）AThe MTTR advisor will be disabled.BAutomatic checkpoint tuning will be enabled.CThe value for the LOG_CHECKPOINT_INTERVAL initialization parameter will be override the value forFAST_START_MTTR_TARGET.DThe time taken to recover the instance after the crash is always exactly the same as the value given forthe FAST_START_MTTR_TARGET initialization parameter.
问题
多选题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 failures on a standby database