A.An Automatic Workload Repository snapshot has been taken recently.
B.The non-threshold-based alerts are transferred to DBA_ALERT_HISTORY.
C.The threshold alerts conditions are cleared and the alerts are transferred to DBA_ALERT_HISTORY.
D.The threshold alerts related to database metrics are permanently stored in DBA_ALERT_HISTORY but notthe threshold alerts related to instance metrics

A.It can span multiple databases.
B.It can consist of multiple data files.
C.It can contain blocks of different sizes.
D.It can contain segments of different sizes.
E.It can contain a part of a nonpartitioned segment

A.Listeners use only the TCP/IP protocol.
B.Multiple listener processes can run simultaneously on a host.
C.Multiple database instances can be registered with a single listener.
D.The listener-related errors can be traced only at the administrative level.
E.Only one database instance can be registered with a single listener at any time

A.You must shut down the database instance to perform the backups.
B.You must configure the Flash Recovery Area （FRA） for the database.
C.You can perform complete database backups without closing the database.
D.All the previous closed database backups including control files become invalid after you configure thedatabase to ARCHIVELOG mode.

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

A.An SPFILE is a binary file.
B.An SPFILE cannot reside on a client.
C.An SPFILE cannot contain static parameters.
D.An SPFILE can store changes persistently across instance restarts.
E.An SPFILE can be read by the database server， but it is not written to by the server.
F.An SPFILE must be created manually， before creating a database， even if you use the DatabaseConfiguration Assistant （DBCA） to create the database

A.Redo is not generated while performing conventional path loads.
B.Only PRIMARY KEY， UNIQUE KEY， and NOT NULL constraints are checked.
C.No exclusive locks are acquired when the conventional path loads are performed.
D.Instead of performing transactions， SQL*Loader directly writes data blocks to the data files.
E.INSERT triggers are disabled before the conventional path load and reenabled at the end of the load

A.LOCK TABLE emp IN SHARE MODE；
B.LOCK TABLE emp IN EXCLUSIVE MODE；
C.UPDATE emp SET sal=sal*1.2 WHERE job=ANAGER？UPDATE emp SET sal=sal*1.2 WHERE job=？ANAGER？
D.INSERT INTO emp（empno，ename） VALUES （1289，’Harry’）；
E.SELECT ename FROM emp WHERE job=’CLERK’ FOR UPDATE OF empno

A.System monitor （SMON）
B.Process monitor （PMON）
C.Memory manager process （MMAN）
D.Manageability Monitor process （MMON）

A.A CHECK constraint is created on the OID column.
B.A NOT NULL constraint is created on the OID column.
C.The ORDERS table is the only object created in the USERS tablespace.
D.The ORDERS table and a unique index are created in the USERS tablespace.
E.The ORDERS table is created in the USERS tablespace and a unique index is created on the OID columnin the SYSTEM tablespace.

A.You can perform consistent backups only.
B.You can perform a complete database backup without shutting down the database instance.
C.You can back up data files only when all data files have the same SCN recorded in the control file.
D.You can back up only those data files whose headers are frozen by using ALTER TABLESPACE BEGINBACKUP or ALTER DATABASE BEGIN BACKUP commands