A.when the data file of the undo tablespace is autoextensible
B.when there are more than one undo tablespaces available in the database
C.when the undo tablespace is of a fixed size and retention guarantee is not enabled
D.when the undo tablespace is autoextensible and retention guarantee is not enabled
您可能感兴趣的试卷
你可能感兴趣的试题
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 15minutes.
C.The extents containing committed data in the undo tablespace are not overwritten until the instance isshut down.
D.The extents containing committed undo in the undo tablespace are transferred to Flash Recovery Areabefore being overwritten.
View the Exhibit and examine the undo tablespace attributes.
Your database instance is experiencing a large volume of transactions from non-DBA users in the last onehour. The undo tablespace UNDOTBS1 is full with transactions and no transaction was committed morethan one hour ago. The database has two more undo tablespaces.
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
A.The database can have more than one undo tablespace.
B.The UNDO_TABLESPACE parameter is valid in both automatic andmanualundo management.
C.Undo segments automatically grow and shrink as needed， acting as circular storage buffer for their assigned transactions.
D.An undotablespaceis automatically created if the UNDO_TABLESPACEparameter is not set and the UNDO_MANAGEMENT parameter is set to AUTO during the database instance start up.
A.committing a transaction
B.flashing back a transaction
C.recovering a failed transaction
D.running a read-consistent query
E.changing a tablespace status from READ ONLY to READ WRITE
A.An extent cannot spread across data files.
B.A segment cannot spread across data files.
C.A data file can belong to only one tablespace.
D.A data file can have only one segment created in it.
E.A data block can spread across multiple data files as it can consist of multiple operating system （OS） blocks.
ote the following structures in your database server：
1：Extents
2：OS Blocks
3：Tablespace
4：Segments
5：Oracle Data Block
Which option has the correct arrangement of these structures from the smallest to the largest（）
A.2， 5， 1， 4， 3
B.1， 2， 3， 4， 5
C.5， 2， 1， 3， 4
D.2， 1， 5， 4， 3
A.external table
B.partitioned table
C.partitioned index
D.nonclustered table
E.global temporary table
A.Each segment contains one or more extents.
B.Multiple tablespaces can share a single data file.
C.A data block is the smallest unit of input/output （I/O） in data files.
D.It is possible to have tablespaces of different block sizes in a database.
E.Each data block in the database always corresponds to one operating system block.
You have set Tablespace Full Metrics Threshold values for the USERS tablespace as follows： Warning （%）： 90
Critical （%）： 95
Which background process is responsible for issuing alerts when the threshold is crossed（）
A.System monitor （SMON）
B.Process monitor （PMON）
C.Memory manager process （MMAN）
D.Manageability Monitor process （MMON）
A.It is possible to have multiple database writers in an Oracle instance.
B.It writes dirty buffers， if any， to data files whenever a checkpoint occurs.
C.It writes dirty buffers， if any， to data files whenever a transaction commits.
D.It writes dirty buffers， if any， to data files before the log writer （LGWR） writes.
最新试题
Which statements are correct about temporary tables（）
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（）
Why does performance degrade when many UPDATE， INSERT， or DELETE statements are issued on a tablethat has an associated Bitmap index（）
The database instance has the following parameter setting：OS_AUTHENT_PREFIX = OPS$ OS_ROLES = FALSE REMOTE_OS_AUTHENT = FALSEREMOTE_OS_ROLES = FALSE TIMED_OS_STATISTICS = 0 You have a local operating system user SKD.You create a database user OPS$SKD， and then assign external authentication. The user OPS$SKD has theCREATE SESSION privilege. What would you achieve by the above process（）
Which kinds of failures make the Data Recovery Advisor （DRA） generate a manual checklist？（）
Which statements are true regarding the Oracle Data Pump export and import operations（）
Identify the situations in which you use the alert log file in your database to check the detail.（）
Which statements are true about checkpointing（）
Which statements are true regarding a tablespace（）
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（）