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
您可能感兴趣的试卷
你可能感兴趣的试题
You want to enable archiving on your database. Presently， the database is running in NOARCHIVELOG mode.Given below are the steps to accomplish the task in random order：
1. Shut down the instance.
2. Execute the ALTER DATABASE ARCHIVELOG command.
3. Start up the instance and mount the database.
4. Set the DB_RECOVERY_FILE_DEST initialization parameter to $ORACLE_HOME/dest_1.
5. Open the database.
Which is the correct sequence of steps for accomplishing the task（）
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
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 temporary tablespace.
C.It is the minimum time period up to which the committed undo data would be retained if free undo space isavailable.
D.It is the time period after which the undo data is transferred to the Flash Recovery Area to provide readconsistency.
View the Exhibit and examine the undo tablespace attributes. Your database instance is experiencing a largevolume of transactions from non-DBA users in the last one hour. The undo tablespace UNDOTBS1 is full withtransactions and no transaction was committed more than one hour ago. The database has two more undotablespaces.
What happens to the new DML operations in this scenario（）
A.The DML commands will fail.
B.The undo data generated by the DML is stored in one of the two other undo tablespaces.
C.The undo data generated by the DML will overwrite the extents that contain committed undo data.
D.The undo data generated by the DML is stored in the SYSTEM undo segment of the SYSTEM tablespace
You want to access employee details contained in flat files as part of the EMPLOYEE table. You plan to add anew column to the EMPLOYEE table to achieve this.
Which data type would you use for the new column（）
A.CLOB
B.BLOB
C.BFILE
D.LONG RAW
Note the following functionalities of various background processes：
1. Record the checkpoint information in data file headers.
2. Perform recovery at instance startup.
3. Cleanup unused temporary segments.
4. Free the resources used by a user process when it fails.
5. Dynamically register database services with listeners.
6. Monitor sessions for idle session timeout.
Which option has the correct functionalities listed for a background process（）
A.Archiver Process （ARCn）： 1， 2， 5
B.System Monitor Process （SMON）： 1， 4， 5
C.Process Monitor Process （PMON）： 4， 5， 6
D.Database Writer Process （DBWn）： 1， 3， 4
You are using Enterprise Manager to schedule backups for your database.
Which type of script would begenerated by the backup scheduler（）
A.XML script
B.PL/SQL script
C.Operating system scriptThis document was downloaded from =>> http：//www.amaderforum.com
D.Recovery Manager （RMAN） script
in your database instance， the STATISTICS_LEVEL initialization parameter is set to BASIC.
What is the impactof this setting（）
A.Optimizer statistics are collected automatically.
B.Only timed operating system （OS） statistics and plan execution statistics are collected.
C.The snapshots for the Automatic Workload Repository （AWR） are not generated automatically.
D.Snapshots cannot be collected manually by using the DBMS_WORKLOAD_REPOSITORY package.
E.The Oracle server dynamically generates the necessary statistics on tables as part of query optimization.
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
Which statements listed below describe the data dictionary views（）
1） These are stored in the SYSTEM tablespace.
2） These are the based on the virtual tables.
3） These are owned by the SYS user.
4） These can be queried by a normal user only if O7_DICTIONARY_ACCESSIBILTY parameter is set to TRUE.
5） The V$FIXED_TABLE view can be queried to list the names of these views.
A.1 and 3
B.2， 3， and 5
C.1， 2， and 3
D.2， 3， 4， and 5
You plan to move data from a flat file to a table in your database. You decide to use SQL*Loader direct pathload method to perform this task. The table in which you plan to load data is an important table having variousintegrity constraints defined on it.
Which constraints will remain enabled by default during this operation（）
A.CHECK
B.UNIQUE
C.NOT NULL
D.PRIMARY KEY
E.FOREIGN KEY
最新试题
You have two database servers SEMP and SACCT. The database in the SEMP server maintains the employeeinformation and the database in the SACCT server maintains the accounts payable information. The employeessubmit the expense reports to the accounts payable department. A user of the accounts payable databasewants to extract the employee information from the database in the SEMP server for cross-verification. Whichschema object enables the user to access the information from the remote database（）
Which statement is true about loading data using the conventional path of SQL*Loader（）
The session of user SCOTT receives the following error after executing an UPDATE command on the EMPtable：ERROR at line 1：ORA-00060： deadlock detected while waiting for resource On investigation， you find that a session opened byuser JIM has a transaction that caused the deadlock. Which two statements are true regarding the session ofSCOTT in this scenario（）
Which kinds of failures make the Data Recovery Advisor （DRA） generate a manual checklist？（）
View the Exhibit and examine the privileges granted to the SL_REP user. The EMP table is owned by theSCOTT user. The SL_REP user executes the following command：SQL> GRANT SELECT ON scott.emp TO hr；Which statement describes the outcome of the command（）
Which statements are true regarding the Oracle Data Pump export and import operations（）
Which statements are true about checkpointing（）
View the Exhibit to examine the output of the DBA_OUTSTANDING_ALERTS view. After 30 minutes, youexecuted the following command:SQL> SELECT reason,metric_value FROM dba_outstanding_alerts; REASON METRIC_VALUE------------------------------ ---------------------- Tablespace [TEST] is [28 perce 28.125 nt] fullWhat could be the reason for the elimination of the other rows in the output（）
Your database is functional with a peak load for the last one hour. You want to preserve the performancestatistics collected during this period to be used for comparison when you analyze the performance of thedatabase in the future. What action would you take to achieve this task（）
Which statements are true about logical structures of the Oracle database（）