oracle19c-ocp-083模拟题库.pdf
10墨值下载
1、Which three are true about thresholds, metrics, and server-generated alerts? (Choose three.)
A. All metrics are instance related.
B. Cleared stateful alerts are displayed by querying DBA_ALERT_HISTORY.
C. A space usage management alert is automatically cleared after the underlying problem is resolved.
D. They are generated by SMON when a tablespace is 97% full.
E. Metrics are statistical counts for a specific unit.
F. STATISTICS_LEVEL must be set to ALL to generate alerts.
Answer:BCE
2、Which three are true about requirements for various FLASHBACK operations? (Choose three.)
A. FLASHBACK transaction query requires undo to retrieve all versions of a row that existed between two points in time.
B. FLASHBACK drop requires that the RECYCLEBIN parameter be set to ON.
C. FLASHBACK version query requires that the RECYCLEBIN parameter be set to ON.
D. FLASHBACK DATA ARCHIVE requires undo to store all versions of all rows of a table being tracked.
E. FLASHBACK drop requires undo to retrieve all versions of a row that existed between two points in time.
F. FLASHBACK version query requires undo to retrieve all versions of a row that existed between two points in time.
Answer:ABF
3、Which two are prerequisites for performing Flashback Transaction?
A. Fast Recovery Area must be enabled for the database.
B. The EXECUTE privilege must be granted to a user on the DBMS_FLASHBACK package.
C. Undo retention guarantee must be configured for the database.
D. A supplemental log must be enabled for the primary key.
E .Row movement must be enabled.
Answer：BD
4、choose one You enable Flashback Data Archive for a table for which you want to track and save all transactions for
four years. After some time, the requirement changes for keeping transactions from four to two years.
You execute the following command to change the requirement:
SQL> ALTER FLASHBACK ARCHIVE fdal MODIFY RETENTION 2 YEAR; What is the outcome?
A. All historical data older than two years, if any, is purged from the flashback archive FDA1.
B. An error is returned because the retention period cannot be reduced.
C. All the flashback data archives are purged and the subsequently created flashback archives are maintained for two years.
D. All historical data older than two years, if any, is archived to flashback logs and the flashback archive is set to new retention
time.
Answer：A
5、Which three statements are true about Flashback Data Archive?
A. To use Flashback Data Archive, users must have unlimited quota on the Flashback Data Archive tablespace.
B. To enable Flashback Data Archive for a table, it is mandatory to have a default Flashback Data Archive for a database.
C. While enabling Flashback Data Archive for a table, if no name is provided for Flashback Data Archive, it is enabled using the
default Flashback Data Archive.
D. A table enabled for Flashback Data Archive cannot be dropped unless Flashback Data Archive is disabled or disassociated
first.
E. Flashback Data Archive prevents flashback queries from getting a snapshot-too-old error.
Answer：CDE
6、Examine the statements that use flashback technologies:
1. FLASHBACK TABLE customers TO TIMESTAMP TO_TIMESTAMP('2013-02-04 09:30:00', 'YYYY-MM-DD HH:MI:SS');
2. SELECT * FROM customers AS OF SCN 123456;
3. FLASHBACK TABLE customers TO BEFORE DROP;
4. FLASHBACK DATABASE TO TIMESTAMP TO_TIMESTAMP('2013-02-04 09:30:00', 'YYYY-MM-DD HH:MI:SS');
5. SELECT * FROM customers VERSIONS BETWEEN SCN 123456 AND 123999;
6. ALTER TABLE customers FLASHBACK ARCHIVE;
Which set of statements depends on the availability of relevant undo data in the undo tablespace?
A. 1,3,6
B. 1,2,5
C. 3,4,5
D. 2,3,5,6
Answer：B
7、You accidentally drop the CUSTOMERS table, and then recover it by using the FLASHBACK TABLE command.
Which two statements are true about the dependent objects of the CUSTOMERS table?
A. All the triggers associated with the table are flashed back but are disabled.
B. Materialized views that use the CUSTOMERS table are flashed back.
C. LOB segments associated with the CUSTOMERS table are flashed back.
D. All the constraints defined on the table, except the referential integrity constraints, are flashed back.
E. Only the primary key constraint created for the table is flashed back, whereas all other indexes must be retrieved separately.
Answer：CD
8、Which two are true about the Automatic Database Diasnostic Monitor (ADDM)? (Choose two.)
A. It analyzes a period of time corresponding to the 12 hours of activity.
B. It runs automatically after each AWR snapshot.
C. A DBA can run it manually.
D. Results are written to the alert log.
E. It analyzes a period of time corresponding to the last day of activity.
Answer:BC
9、Which four are true about duplicating a database using Recovery Manager (RMAN)? (Choose four.)
A. Duplication can be done by having the auxiliary database instance pull backup sets from the target database instance.
B. A connection to an auxiliary instance is always required.
C. A subset of the target database can be duplicated.
D. A new DBID is always created for the duplicated database.
E. A connection to the recovery catalog instance is always required.
F. A backup of the target database is always required.
G. Duplication can be done by having the target database instance push copies to the auxiliary database instance.
H. A connection to the target database instance is always required.
Answer:ABCG
10、Choose the best answer
You want to create a duplicate database DUP_DB from your production database PROD on the same host. The PROD
database uses Automatic Storage Management (ASM) for storage. Regular backups are taken using RMAN connected
to a recovery catalog. You create an auxiliary instance and want to execute the command:
RMAN> DUPLICATE TARGET DATABASE TO dup_db FROM ACTIVE DATABASE;
What is a prerequisite for the successful execution of this command
A. RMAN must be connected to the target database instance and the auxiliary instance.
B. A most recent backup set of the PROD database must exist.
C. Flashback must be enabled for the PROD database.
D. The target database must be in MOUNT state.
Answer：A
11、Which two are true about changing the LOCAL_UNDO_ENABLED property to false in a CDB? (Choose two.)
A. After the change, only a common user with the required privilege can create an undo tablespace in CDB&ROOT.
B. Any new PDB and existing PDBs are automatically configured to use the default undo tablespace in CDB$ROOT.
C. After the change, only one undo tablespace can exist in CDB$ROOT.
D. After the change, any user with the required privilege can create an undo tablespace in the PDBs.
E. Undo tablespaces existing in PDBs must be dropped before the change.
F. After the change, each existing PDB has to be reopened for the new undo mode to take effect.
of 59
10墨值下载
【版权声明】本文为墨天轮用户原创内容，转载时必须标注文档的来源（墨天轮），文档链接，文档作者等基本信息，否则作者和墨天轮有权追究责任。如果您发现墨天轮中有涉嫌抄袭或者侵权的内容，欢迎发送邮件至：contact@modb.pro进行举报，并提供相关证据，一经查实，墨天轮将立刻删除相关内容。
下载排行榜
评论