In your production d...

多项选择题In your production database， you have multiple resource plan directives that refer to the customer group DB_GRP. Which two statements are correct？（）

A. The parallel degree limit for DB_GRP will be the minimum of all the incoming values.
B. The parallel degree limit for DB_GRP will be the maximum of all the incoming values.
C. The maximum estimated execution time for DB_GRP would be the most nonrestrictive of all incoming values.
D. If a session switched from the DB_GRP consumer group to another consumer group because it exceeded the prescribed switch time， then that session would not execute if the active session pool for the new consumer group was full.
E. Is a session switched from the DB_GRP consumer group to another consumer group because it exceeded the prescribed switch time， then that session would execute even if the active session pool for the new consumer group was full.

点击查看答案

您可能感兴趣的试卷

你可能感兴趣的试题

1.单项选择题Because of hardware failure， you decided to drop a redo log member from the database. Which condition should be met to drop a redo log file？（）

A. The redo log file should belong to an active group.
B. The redo log file should belong to an inactive group.
C. The redo log file should belong to the current group.
D. The redo log file can be dropped only if all the transactions are stopped.
E. Before a redo log file is dropped， it should be deleted from the operating system （OS）.

点击查看答案

2.单项选择题 You are working in an online transaction processing （OLTP） environment. You used the FLASHBACK TABLE command to flash back the CUSTOMERS table. Before executing the FLASHBACK TABLE command， the System Change Number （SCN） was 663571. After flashing back the CUSTOMERS table， you realize that the table is not in the correct state and the resultant changes are not what you had desired. So， you need to reverse the effects of the FLASHBACK TABLE command while ensuring that：
a） No other user data in the database is affected.
b） The operation takes the minimum possible time.
Which option would you choose？（）

A. Use ROLLBACK command with SCN 663571.
B. Perform Flashback Transaction Query with SCN 663571.
C. Execute the FLASHBACK DATABASE statement to retrieve the CUSTOMERS table as it was at SCN 663571.
D. Execute another FLASHBACK TABLE statement to retrieve the CUSTOMERS table as it was at SCN 663571.

点击查看答案

3.多项选择题Your database is functioning in NOARCHIVELOG mode. Your database contains 15 tablespaces. You want to use Recovery Manager （RMAN） to perform backups. Which two backups would you be able to perform when the database is being accessed by users？（）

A. Backup of offline tablespaces.
B. Backup of read-only tablespaces.
C. Backup of system-critical tablespaces.
D. Backup of online， locally managed tablespaces.
E. Backup of read/write dictionary-managed tablespaces.

点击查看答案

4.单项选择题In one of your online transaction processing （OLTP） applications， most users frequently modify the values， including the key values， of the application tables. Some users generate application reports by using multiple application tables. What is the best table structure that you can use to gain optimal performance？（）

A. Heap table
B. Object table
C. External table
D. Clustered table
E. Global temporary table
F. Index-organized table （IOT）

点击查看答案

5.单项选择题You have been assigned to manage a set of databases. The previous DBA did not leave you notes regarding the structure of each of the databases. While analyzing an instance， you notice that the system identifier （SID） for the instance is set to ’+ASM’. What is the purpose of this instance？（）

A. This instance is being used to manage the operating system files.
B. This instance is being used to manage the files of other databases.
C. This instance is being used to manage the instances of other databases.
D. This instance is being used to manage the background processes of other instances.

点击查看答案

6.单项选择题In an Oracle 10g database， the in-memory statistics are gathered at regular intervals and used to perform growth-trend analysis and capacity planning of the database. Which component stores these statistics？（）

A. Recovery catalog
B. Oracle Enterprise Manager Repository
C. Automatic Workload Repository （AWR）
D. Oracle 10g Enterprise Manager Grid Control
E. Automatic Database Diagnostic Monitor （ADDM）

点击查看答案

7.单项选择题Which type of PL/SQL construct would you use to automatically correct the error resulting from a statement that was suspended due to a space-related problem？（）

A. functions
B. package
C. procedure
D. database trigger
E. anonymous PL/SQL block

点击查看答案

8.单项选择题 Exhibit： View the Exhibit.You have more than one table in the recycle bin having the same original name， DEPT2. You do not have any table with the nameDEPT2 in your schema. You executed the following command：PURGE TABLE dept2； Which statement is correct in this scenario？（）

A. All the tables having the same original name as DEPT2 will be purged from the recycle bin.
B. The table with dropscn = 1928151 （oldest dropscn） will be purged from the recycle bin.
C. The table with dropscn = 1937123 （most recent dropscn） will be purged from the recycle bin.
D. None of the tables will be purged because there are multiple entries with the same original name in the recycle bin.

点击查看答案

9.单项选择题 While designing the database for one of your online transaction processing （OLTP） applications， you want to achieve the following：
a） high availability of data
b） faster primary key access to the table data
c） compact storage for the table
Which type of tables would you use to achieve these objectives？（）

A. heap tables
B. object tables
C. partitioned tables
D. index-organized tables （IOTs）

点击查看答案

10.单项选择题You executed the following query in your database： SELECT oldest_flashback_scn， oldest_flashback_time FROM V$FLASHBACK_DATABASE_LOG； What would you determine from the output？（）

A. The time when the last flashback operation in your database was performed.
B. The time when the first flashback operation in your database was performed.
C. A list of flashback operations performed in your database using SCN and time.
D. The approximate time and the lowest system change number （SCN） to which you can flash back your database.

点击查看答案