单项选择题
You executed the command to create a password file in the database server: $ orapwd file=orapworcl entries=5ignorecase=N
Which statement describes the purpose of the above password file()
A.It records usernames and passwords of users when granted the DBA role.
B.It contains usernames and passwords of users for whom auditing is enabled.
C.It is used by Oracle to authenticate users for remote database administration.
D.It records usernames and passwords of all users when they are added to OSDBA or OSOPER operatingsystem groups
相关考题
-
单项选择题
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()
A.7, 1, 5, 2, 3, 6, 4
B.1, 5, 7, 2, 3, 6; step 4 is not required
C.7, 1, 5, 2, 3, 6; step 4 is not requiredThis document was downloaded from =>> http://www.amaderforum.com
D.1, 2, 3, 5, 6, 4; step 7 is not required -
单项选择题
Your database instance is configured with automatic undo management and the UNDO_RETENTIONparameter is set to 900 seconds. You executed the following command to enable retention guarantee: SQL> ALTER TABLESPACE undotbs1 RETENTION GUARANTEE; What effect would this command have onthe database()
A.The extents in the undo tablespace retain data until the next full database backup.
B.The extents containing committed undo in the undo tablespace are not overwritten for at least 15 minutes.
C.The extents containing committed data in the undo tablespace are not overwritten until the instance is shutdown.
D.The extents containing committed undo in the undo tablespace are transferred to Flash Recovery Areabefore being overwritten -
单项选择题
Youwanttoenablearchivingonyourdatabase.Presently,thedatabaseisrunninginNOARCHIVELOGmode.Givenbelowarethestepstoaccomplishthetaskinrandomorder: 1.Shutdowntheinstance. 2.ExecutetheALTERDATABASEARCHIVELOGcommand. 3.Startuptheinstanceandmountthedatabase. 4.SettheDB_RECOVERY_FILE_DESTinitializationparameterto$ORACLE_HOME/dest_1. 5.Openthedatabase. Whichisthecorrectsequenceofstepsforaccomplishingthetask()
A.4, 1, 3, 2, 5
B.1, 3, 4, 5, 2
C.1, 3, 2, 5; 4 not required
D.4, 1, 5, 2; 3 not required
E.1, 3, 4, 5; 2 not required
