You Execute the Following command to create a password file in the database server: $ orapwd file = ‘+DATA/PROD/orapwprod entries = 5 ignorecase = N format = 12’ Which two statements are true about the password file?（）

相似题目

• You execute the following command to enable a session in resumable mode：  SQL> ALTER SESSION ENABLE RESUMABLE TIMEOUT 60；  What is the impact of a timeout on the statements being suspended？（）

  A .  The statements remain suspended for at least 60 seconds. B .  The statements are suspended for 60 seconds and then they are executed. C .  The suspended statements error out if the problem is not rectified within 60 seconds. D .  The statements are automatically suspended 60 seconds after an error is received， and then attempt to execute normally again.

  查看最佳答案

• 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.

  查看最佳答案

• You execute the following PL/SQL:Which two statements are true?（）

  A . Fine-Grained Auditing (FGA) is enabled for the PRICE column in the PRODUCTS table for SELECT statements only when a row with PRICE > 10000 is accessed. B . FGA is enabled for the PRODUCTS.PRICE column and an audit record is written whenever a row with PRICE > 10000 is accessed. C . FGA is enabled for all DML operations by JIM on the PRODUCTS.PRICE column. D . FGA is enabled for the PRICE column of the PRODUCTS table and the SQL statements is captured in the FGA audit trial.

  查看最佳答案

• You have created a script in the recovery catalog called backup_database. Which of the following commands would successfully execute that script？（）  

  A .  run { open script backup_database； run script backup_database } B .  run { engage script backup_database； } C .  run { run script backup_database； } D .  Run { execute script backup_database； } E .  The name backup_database is an invalid name for an RMAN script. Trying to run it from RMAN would result in an error.

  查看最佳答案

• You execute the following command to start an Automatic Storage Management （ASM） instance：   SQL>STARTUP；   In which of the following modes will the ASM instance start？（）

  A .  OPEN B .  MOUNT C .  NORMAL D .  NOMOUNT

  查看最佳答案

• 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 execute the following Recovery Manager （RMAN） commands in he following order：   BACKUP VALIDATE DATABAE RECOVER CORRUPTION LIST；   Which two tasks are performed by these commands？（）  

  A .  Repair the corrupted blocks. If any. In the backup created B .  Populate VSCOPV_CORRUPTION with names of files that have corrupted blocks C .  Back up the database after checking whether array of the files have corrupted blocks D .  Discover any corrupt blocks that are viewable with the VSDATABASE_BI-OCK_CORBUPTION view E .  Repair all corrupted blocks that have been logged in the VSDATABASE_BLOCK_ CORRUPTION

  查看最佳答案

• You execute the following command toauditdatabase activities：  SQL>AUDITDROP ANY TABLE BY scott BY SESSION WHENEVER SUCCESSFUL；  What is the effect of this command（）

  A . Oneauditrecord is created for every successful DROP TABLE command executed in the session ofSCOTT. B . Oneauditrecord is generated for the session when SCOTT grants the DROP ANY TABLE privilege toother users. C . One audit record is created for the whole session if user SCOTT successfully drops one or more tablesin his 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 droptables owned by SCOTT.

  查看最佳答案

• You are managing a single instance Oracle 10g database that utilizes the following parameters：  Which of the following set of commands must you execute to enable Flashback Database？（）

  A .   STARTUP MOUNT EXCLUSIVE  ALTER DATABASE FLASHBACK ON；  ALTER DATABASE OPEN； B .   STARTUP MOUNT  ALTER DATABASE FLASHBACK ON；  ALTER DATABASE OPEN RESETLOGS； C .   STARTUP MOUNT EXCLUSIVE  ATLER DATABASE ARCHIVELOG；  ALTER DATABASE FLASHBACK ON；  ALTER DATABASE OPEN RESETLOGS； D .   STARTUP MOUNT  ALTER DATABASE ARCHIVELOG；  ALTER DATABASE FLASHBACK ON；  ALTER DATABASE OPEN；

  查看最佳答案

• 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.

  查看最佳答案

• In your multitenant container database (CDB) containing same pluggable databases (PDBs), you execute the following commands in the root container: Which two statements are true?（）

  A . The C # # ROLE1 role is created in the root database and all the PDBs. B . The C # # ROLE1 role is created only in the root database because the container clause is not used. C . Privileges are granted to the C##A_ADMIN user only in the root database. D . Privileges are granted to the C##A_ADMIN user in the root database and all PDBs. E . The statement for granting a role to a user fails because the CONTAINER clause is not used.

  查看最佳答案

• 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 are the Database Administrator （DBA） of your company. You execute the following statement on an Oracle 10g instance：   SQL> ALTER SYSTEM SWITCH LOGFILE；   Which two tasks are performed when the statement is executed？ （）

  A .  The DBWn process writes to the datafile. B .  Changes in the background process are recorded. C .  The log file is updated with the current SCN number. D .  The System Change Number （SCN） is recorded in the control file. E .  The changes to the listener configuration in the listener.ora file are recorded.

  查看最佳答案

• 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 execute the following RMAN command in the order shown below： BACKUP VALIDATE DATABASE； BLOCKRECOVER CORRUPTION LIST； What will these commands do？（）

  A .  Create a backup of the database and recover all corrupted blocks found in the backup. B .  Run a backup validation and list all the logically corrupt blocks as well as physically corrupt blocks in the database. C .  Run a backup validation to populate V$COPY_CORRUPTION view， and then list any corrupt blocks recorded in the view. D .  Run a backup validation to populate V$DATABASE_BLOCK_CORRUPTION view， and then repair any corrupt blocks recorded in the view. E .  Run a backup validation， repair any corrupt blocks found during the validation process， and then update V$DATABASE_BLOCK_CORRUPTION view to indicate which corrupt blocks have been repaired.

  查看最佳答案

• You execute the following command to enable a session in resumable mode： SQL> ALTER SESSION ENABLE RESUMABLE TIMEOUT 60; What is the impact of a timeout on the statements being suspended？（）

  A . The statements remain suspended for at least 60 seconds. B . The statements are suspended for 60 seconds and then they are executed. C . The suspended statements error out if the problem is not rectified within 60 seconds. D . The statements are automatically suspended 60 seconds after an error is received， and then attempt to execute normally again.

  查看最佳答案

• You use a recovery catalog for maintaining your database backups.You execute the following command:$rman TARGET / CATALOG rman / cat@catdbRMAN > BACKUP VALIDATE DATABASE ARCHIVELOG ALL;Which two statements are true?（）

  A . Corrupted blocks, if any, are repaired. B . Checks are performed for physical corruptions. C . Checks are performed for logical corruptions. D . Checks are performed to confirm whether all database files exist in correct locations E . Backup sets containing both data files and archive logs are created.

  查看最佳答案

• 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

  查看最佳答案

• You execute the following command to enable a session in resumable mode：  SQL> ALTER SESSION ENABLE RESUMABLE TIMEOUT 60；  What is the impact of a timeout on the statements being suspended？（） 

  A . The statements remain suspended for at least 60 seconds. B . The statements are suspended for 60 seconds and then they are executed. C . The suspended statements error out if the problem is not rectified within 60 seconds. D . The statements are automatically suspended 60 seconds after an error is received， and then attempt toexecute normally again.

  查看最佳答案

• 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

  查看最佳答案

• View the Exhibit and examine the steps that you executed to create a database resource plan.Subsequently, you execute the following procedure which results in an error:SQL＞ EXECUTE dbms_resources_manager.validate_pending_area ();What could be the reason？（）

  <img src='https://img2.soutiyun.com/shangxueba/ask/17133001-17136000/17135247/2c9611256b04bdd5ba39c52e4e7dd450.png' /> A. The pending area is automatically submitted after the plan creation B. The procedure must be executed before creating the resources plan directive C. The SYS_GROUP resource consumer group is not included in the resource plan directive D. The OTHER_GROUPS resources consumer group is not included in the resource plan directive

  查看最佳答案

• 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

  查看最佳答案