1z0-043章節(jié)練習(2019.04.28)

單項選擇題
You are creating the simple resource plan using the DBMS_RESOURCE_MANAGER.CREATE_SIMPLE_PLAN procedure. Which resource allocation policy will be used for the resource plan？（）
A. RATIO
B. EMPHASIS
C. ACTIVE_SESS_POOL_MTH
D. RESOURCE_DEGREE_LIMIT_ABSOLUTE
單項選擇題
You are maintaining your database in Oracle10g. While performing an incremental backup of the database， you want to back uponly those blocks that have changed since the last backup. Which file will you create to increase the performance of the backup operation while performing the incremental backup of the database？（）
A. redo log files
B. password file
C. control file
D. change tracking file
多項選擇題
Which three methods can you use to run an Automatic Database Diagnostic Monitor （ADDM） analysis over a specific time period？（）
A. Enterprise Manager GUI
B. DBMS_TRACE package APIs
C. DBMS_ADVISOR package APIs
D. DBMS_MONITOR package APIs
E. $ORACLE_HOME/rdbms/admin/addmrpt.sql script
多項選擇題
View the Exhibit. You executed the following command to perform a backup of the USERS tablespace： RMAN> BACKUP TABLESPACE USERS; Which three types of files are backed up？（）
A.password file
B.online redo log files
C.the current control file
D.archived redo log files
E.the current server parameter file
F.all the data files belonging to the USERS tablespace
G.data files belonging to the USERS tablespace and all the default tablespaces
單項選擇題
In your datawarehousing application， you generate reports frequently. The data is static in the tables being used to generate reports. You are currently using joins， resulting in a large performance overhead. What kind of database structure would you use to reduce the response time of the query？（）
A.hash clusters
B.index clusters
C.partitioned tables
D.index-organized table （IOT）
單項選擇題
You issued the following command： ALTER DATABASE ENABLE BLOCK CHANGE TRACKING； What will be the result of issuing this command？（）
A. The block change tracking feature is enabled， and the information about the system change number is written in the change tracking file.
B. The block change tracking feature is enabled， and the information about the log sequence number is written in the change tracking file.
C. The block change tracking feature is enabled， and the information about the blocks that are changed since the last backup is written in the change tracking file.
D. The block change tracking feature is enabled， and the information about the locations of the datafiles and the online redo log files are written in the change tracking file.
多項選擇題
You are working on an Oracle Database 10g database. You enabled the Flashback Database feature. Which two statements regarding flashback logs are true？（）
A. Flashback logs are not archived.
B. Flashback logs are maintained in redo log files.
C. Flashback logs are maintained in the Flash Recovery Area.
D. Flashback logs are used to maintain Flashback Database related errors.
E. Flashback logs need to be cleared manually after you disable Flashback Database.
單項選擇題
You execute the following command to perform a backup by using Recovery Manager （RMAN）： RMAN> run {allocate channel c1 type sbt; backup datafile 1; } The command errors out. A part of the error message is as follows： RMAN03009： failure of allocate command on c1 channel ORA19554： error allocating device， device type： SBT_TAPE， device name： What could explain why the statement failed？（）
A.sbt is not a valid device type.
B.Media Management Library was not loaded.
C.The sbt device cannot be used for data file backups.
D.No path was defined in the ALLOCATE CHANNEL command.
E.The channel is currently being used by another RMAN session.
多項選擇題
You work as a database administrator at Certkiller .com. In your production database， you observe that users’ transactions are consuming a lot of resource and you plan to impose resource restrictions by using Resource Manager. For which three resources can you enable usage restrictions by using Resource Manager？（）
A. CPU usage
B. degree of parallelism
C. number of open cursors
D. number of sorts performed
E. idle time for blocking sessions
F. number of disk I/O operations performed
G. number of memory I/O operations performed
單項選擇題
You are maintaining your database in Oracle10g. You set the value of the UNDO_RETENTION initialization parameter to zero in the initialization parameter file. What will be the impact of specifying this setting？（）
A. The database will not start.
B. The database will start but will not retain the undo data in the undo segment.
C. The database will start， and the undo segment will contain the undo data for at least one hour.
D. The database will start， and the undo segment will retain the undo data for at least 15 minutes.

首頁

題庫

網(wǎng)課

在線模考

桌面端

1z0-043章節(jié)練習(2019.04.28)

You are creating the simple resource plan using the DBMS_RESOURCE_MANAGER.CREATE_SIMPLE_PLAN procedure. Which resource allocation policy will be used for the resource plan？（）

Which three methods can you use to run an Automatic Database Diagnostic Monitor （ADDM） analysis over a specific time period？（）

View the Exhibit. You executed the following command to perform a backup of the USERS tablespace： RMAN> BACKUP TABLESPACE USERS; Which three types of files are backed up？（）

You issued the following command： ALTER DATABASE ENABLE BLOCK CHANGE TRACKING； What will be the result of issuing this command？（）

You are working on an Oracle Database 10g database. You enabled the Flashback Database feature. Which two statements regarding flashback logs are true？（）

You are maintaining your database in Oracle10g. You set the value of the UNDO_RETENTION initialization parameter to zero in the initialization parameter file. What will be the impact of specifying this setting？（）

1z0-043章節(jié)練習(2019.04.28)

You are creating the simple resource plan using the DBMS_RESOURCE_MANAGER.CREATE_SIMPLE_PLAN procedure. Which resource allocation policy will be used for the resource plan？（）

Which three methods can you use to run an Automatic Database Diagnostic Monitor （ADDM） analysis over a specific time period？（）

View the Exhibit. You executed the following command to perform a backup of the USERS tablespace： RMAN> BACKUP TABLESPACE USERS; Which three types of files are backed up？ （）

You issued the following command： ALTER DATABASE ENABLE BLOCK CHANGE TRACKING； What will be the result of issuing this command？（）

You are working on an Oracle Database 10g database. You enabled the Flashback Database feature. Which two statements regarding flashback logs are true？ （）

You are maintaining your database in Oracle10g. You set the value of the UNDO_RETENTION initialization parameter to zero in the initialization parameter file. What will be the impact of specifying this setting？（）

You are creating the simple resource plan using the DBMS_RESOURCE_MANAGER.CREATE_SIMPLE_PLAN procedure. Which resource allocation policy will be used for the resource plan？（）

Which three methods can you use to run an Automatic Database Diagnostic Monitor （ADDM） analysis over a specific time period？（）

View the Exhibit. You executed the following command to perform a backup of the USERS tablespace： RMAN> BACKUP TABLESPACE USERS; Which three types of files are backed up？（）

You issued the following command： ALTER DATABASE ENABLE BLOCK CHANGE TRACKING； What will be the result of issuing this command？（）

You are working on an Oracle Database 10g database. You enabled the Flashback Database feature. Which two statements regarding flashback logs are true？（）

You are maintaining your database in Oracle10g. You set the value of the UNDO_RETENTION initialization parameter to zero in the initialization parameter file. What will be the impact of specifying this setting？（）