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（）

相似题目

• ou have backed up your database twice without connecting to the recovery catalog. What command do you issue to transfer the control-file metadata to the recovery catalog? （）

  A . synch catalog  B . resync catalog C . replicate catalog  D . update catalog   E . restore catalog

  查看最佳答案

• Before a Flashback Table operation, you execute the following command: ALTER TABLE employees ENABLE ROW MOVEMENT; Why would you need this to be executed?（）

  A . Because row IDs may change during the flashback operation B . Because the object number changes after the flashback operation C . Because the rows are retrieved from the recycle bin during the flashback operation D . Because the table is moved forward and back to a temporary during the flashback opertio

  查看最佳答案

• You execute the following command to audit the database activities：   SQL> AUDIT DROP ANY TABLE BY scott BY SESSION WHENEVER SUCCESSFUL；  What is the effect of this command？（）

  A . One audit record is created for the whole session if user SCOTT successfully drops one or more tables in his session. B . One audit record is created for every session when any user successfully drops a table owned by SCOTT. C . One audit record is created for each successful DROP TABLE command executed by any user to drop tables owned by SCOTT. D . One audit record is generated for the session when SCOTT grants the DROP ANY TABLE privilege to other users in his session. E . One audit record is created for each successful DROP TABLE command executed in the session of SCOTT.

  查看最佳答案

• RMAN enables you to open the target database when it is already mounted. Which command must you execute at the RMAN prompt to open the database？（）

  A . ’SQL ALTER DATABASE OPEN’； B . SQL ALTER DATABASE ’OPEN’； C . OPEN DATABASE； D . DATABASE OPEN

  查看最佳答案

• What is the correct command to stop the currently executing job  "test" in JOBS job stream on a local machine？（）

  A .  conman "k test" B .  conman "cj test" C .  conman "k jobs.test" D .  conman "cj jobs.test&quot

  查看最佳答案

• Examine the following impdp command to import a database over the network from a pre-12c Oracledatabase (source): Which three are prerequisites for successful execution of the command?（）

  A . The import operation must be performed by a user on the target database with the DATAPUMP_IMP_FULL_DATABASE role, and the database link must connect to a user on the source database with the DATAPUMP_EXD_FULL_DATABASE role. B . All the user-defined tablespaces must be in read-only mode on the source database. C . The export dump file must be created before starting the import on the target database. D . The source and target database must be running on the same platform with the same endianness. E . The path of data files on the target database must be the same as that on the source database. F . The impdp operation must be performed by the same user that performed the expdp operation.

  查看最佳答案

• You execute the following command to audit the database activities：  SQL> AUDIT DROP ANY TABLE BY scott BY SESSION WHENEVER SUCCESSFUL;  What is the effect of this command？（）

  A . One audit record is created for the whole session if user SCOTT successfully drops one or more tables in his session. B . One audit record is created for every session when any user successfully drops a table owned by SCOTT. C . One audit record is created for each successful DROP TABLE command executed by any user to drop tables owned by SCOTT. D . One audit record is generated for the session when SCOTT grants the DROP ANY TABLE privilege to other users in his session. E . One audit record is created for each successful DROP TABLE command executed in the session of SCOTT.

  查看最佳答案

• You executed the following command to drop a user：   DROP USER scott CASCADE；   Which two statements regarding the above command are correct？（）

  A .  All the objects of scott are moved to the Recycle Bin. B .  Any objects in the Recycle Bin belonging to scott are purged. C .  All the objects owned by scott are permanently dropped from the database. D .  All the objects of scott in the Recycle Bin must be purged before executing the DROP command. E .  Any objects in the Recycle Bin belonging to scott will not be affected by the above DROP command.

  查看最佳答案

• The following command is executed to create the baseline template: https://assets.asklib.com/images/image2/2018080210262165894.jpg Which statement is true about the effect of the above command?（）

  A . It creates a baseline template that never expires. B . It produces an error because no snapshot information is provided to create the baseline. C . It creates a baseline template that expires after the Automatic Workload Repository (AWR) retention period. D . It creates a repeating baseline template that repeats after the Automatic Workload Repository (AWR) retention period.

  查看最佳答案

• You observe that the senior database administrator always uses the following command when connecting to Recovery Manager （RMAN）， and then starts executing commands to backup the database files：  $ rman target /  What would be the effect of this command？（）

  A . RMAN would use the current operating system location to place the backup. B . RMAN would use the control file of the target database to maintain the backup. C . RMAN would use the recovery catalog of the target database to maintain the backup. D . RMAN would use the control file of the target database to maintain the backup metadata.  E . RMAN would use the recovery catalog of the target database to maintain the backup metadata.

  查看最佳答案

• You executed the STARTUP MOUNT command to start your database. For which database operation do you need to start the database in the MOUNT state？（）

  A . renaming the control files B . dropping a user in your database C . enabling or disabling redo log archiving D . dropping a tablespace in your database E . re-creating the control files， after you lost all the control files in your database

  查看最佳答案

• You execute the following command to change the status of the SALES tablespace：  SQL> ALTER TABLESPACE sales OFFLINE；  Which statements describe the effect of the command（）

  A . The tablespace would require recovery to go back online. B . A checkpoint is taken on all data files that are associated with the SALES tablespace. C . The sessions that subsequently try to access the objects in the SALES tablespace receive an error. D . The new status of the SALES tablespace is recorded in the control file when the database instance is closed.

  查看最佳答案

• Which built-in would you use to test whether the CREATE TABLE command issued in the SALES form executed successfully?（）

  A . FORMS_DDL  B . DO_SQL  C . FORM_SUCCESS  D . FORM_NOT_SUCCESS E . DBMS.ERROR_CODE

  查看最佳答案

• You executed the following command to drop a user: DROP USER scott CASCADE; Which two statements regarding the above command are correct?（）

  A . All the objects of scott are moved to the Recycle Bin. B . Any objects in the Recycle Bin belonging to scott are purged. C . All the objects owned by scott are permanently dropped from the database. D . All the objects of scott in the Recycle Bin must be purged before executing the DROP command. E . Any objects in the Recycle Bin belonging to scott will not be affected by the above DROP command.

  查看最佳答案

• You executed the following command in Recovery Manager （RMAN） to perform a backup of the DETTBS tablespace：  RMAN> BACKUP TABLESPACE DETTBS；  Under which conditions would this command execute successfully？ （）

  A . The database is in NOMOUNT state. B . The database is in ARCHIVELOG mode and the tablespace is online. C . The database is in ARCHIVELOG mode and the tablespace is offline. D . The database is in NOARCHIVELOG mode and the tablespace is online. E . The database is in NOARCHIVELOG mode and the tablespace is offline.

  查看最佳答案

• You execute the following command to change the status of the SALES tablespace：SQL> ALTER TABLESPACE sales OFFLINE； Which statements describe the effect of the command（）

  A . The tablespace would require recovery to go back online. B . A checkpoint is taken on all data files that are associated with the SALES tablespace. C . The sessions that subsequently try to access the objects in the SALES tablespace receive an error D . The new status of the SALES tablespace is recorded in the control file when the database instance isclosed

  查看最佳答案

• You executed the following command in Recovery Manager （RMAN） to perform a backup of the DETTBS tablespace： RMAN> BACKUP TABLESPACE DETTBS；  Under which conditions would this command execute successfully？ （）

  A .  The database is in NOMOUNT state. B .  The database is in NOARCHIVELOG mode and the tablespace is online. C .  The database is in NOARCHIVELOG mode and the tablespace is offline. D .  The database is in ARCHIVELOG mode and the tablespace is offline. E .  The database is in ARCHIVELOG mode and the tablespace is online.

  查看最佳答案

• You executed the following command to back up your control file：  ALTER DATABASE BACKUP CONTROLFILE TO TRACE；  Which initialization parameter is used to specify the location of the trace file？（）

  A . USER_DUMP_DEST B . CORE_DUMP_DEST C . TRACE_DUMP_DEST D . BACKUP_DUMP_DEST E . BACKGROUND_DUMP_DEST

  查看最佳答案

• You execute the following command to audit database activities： SQL> AUDIT DROP ANY TABLE BY scott BY SESSION WHENEVER SUCCESSFUL； What is the effect of this command（）

  A . One audit record is created for every successful DROP TABLE command executed in the session of SCOTT. B . One audit record is generated for the session when SCOTT grants the DROP ANY TABLE privilege to otherusers. C . One audit record is created for the whole session if user SCOTT successfully drops one or more tables inhis session. D . One audit record is created for every session of any other user in which a table owned by SCOTT isdropped successfully. E . One audit record is created for every successful DROP TABLE command executed by any user to drop Tables owned by SCOTT

  查看最佳答案

• The operator needs to execute a long-running shell script. How can the script be executed so the operator does not have to wait until it is complete to access the command prompt?（）

  A . ./script.ksh B . nohup ./script.ksh C . run -b ./script.ksh D . ./script.ksh > nohup.out

  查看最佳答案

• You execute the following command to audit the database activities：  SQL> AUDIT DROP ANY TABLE BY scott BY SESSION WHENEVER SUCCESSFUL；  What is the effect of this command？（）

  A . One audit record is created for the whole session if user SCOTT successfully drops one or more tables in his session. B . One audit record is created for every session when any user successfully drops a table owned by SCOTT. C . One audit record is created for each successful DROP TABLE command executed by any user to drop tables owned by SCOTT. D . One audit record is generated for the session when SCOTT grants the DROP ANY TABLE privilege to other users in his session. E . One audit record is created for each successful DROP TABLE command executed in the session of SCOTT.

  查看最佳答案

• Before a Flashback Table operation，you execute the following command：   ALTER TABLE employees ENABLE ROW MOVEMENT；   Why would you need this to be executed？（）  

  A .  Because row IDs may change during the flashback operation B .  Because the object number changes after the flashback operation C .  Because the rows are retrieved from the recycle bin during the flashback operation D .  Because the table is moved forward and back to a temporary during the flashback opertio

  查看最佳答案

• You executed the following commands in a database session:What could have caused the recycle bin to clean up？（）

  <img src='https://img2.soutiyun.com/shangxueba/ask/17133001-17136000/17135140/f84ceb3fdc962e09d81033fbefe54bf9.jpg' /> A. There is demand for space from the new table B. The undo tablespace does not have sufficient free space C. The new table name is the same as the table name in the recycle bin D. The temporary tablespace that is assigned to you does not have sufficient free space

  查看最佳答案

• Before a Flashback Table operation, you execute the following command:ALTER TABLE employees ENABLE ROW MOVEMENT;Why would you need this to be executed？（）

  A. Because row IDs may change during the flashback operation B. Because the object number changes after the flashback operation C. Because the rows are retrieved from the recycle bin during the flashback operation D. Because the table is moved forward and back to a temporary during the flashback operation

  查看最佳答案