These are points that describe the contents of different memory components: 1: Descriptive information or metadata about schema objects that are queried by using SQL statements 2: The run-time area for data manipulation language (DML) or data definition language (DDL) statements 3: Results of SQL queries and PL/SQL functions 4: Executable forms of SQL cursors, PL/SQL programs, and Java classes 5: The information necessary to reconstruct changes made to the database by a transaction Which of these will be stored in theShared Poolif the necessary configurations are done()
A1 and 2
B2 and 5
C1,3,and 4
D3,4,and 5
E1,2,3,and 4
正确答案
答案解析
相似试题
(单选题)
Which statements listed below describe the data dictionary views() 1) These are stored in the SYSTEM tablespace. 2) These are the based on the virtual tables. 3) These are owned by the SYS user. 4) These can be queried by a normal user only if O7_DICTIONARY_ACCESSIBILTY parameter is set to TRUE. 5) The V$FIXED_TABLE view can be queried to list the names of these views.
(多选题)
You are managing an Oracle Database 11g database. The database is open, and you plan to performRecovery Manager (RMAN) backups. Which three statements are true about these backups()
(多选题)
You are managing an Oracle Database 11g database. The database is open, and you plan to perform Recovery Manager (RMAN) backups. Which three statements are true about these backups()
(单选题)
Note the points about data dictionary views and dynamic performance views: 1.These are stored in the SYSTEM tablespace. 2.These are the based on the virtual tables. 3.These are owned by the SYSuser. 4.These can be queried by a normal user only if O7_DICTIONARY_ACCESSIBILTY parameter is set toTRUE. 5.V$FIXED_TABLE view can be queried to list the names of these views. Which statements listed describe the data dictionary views()
(多选题)
You execute the following Recovery Manager (RMAN) commands in he following order: BACKUP VALIDATE DATABAE RECOVER CORRUPTION LIST; Which two tasks are performed by these commands?()
(单选题)
You issue these LSNRCTL commands: LSNRCTL> SET CURRENT_LISTENER listener01 LSNRCTL> START listener02 What is the result of issuing these commands?()
(单选题)
Which of these formats represents the correct hierarchy for the ADR?()
(单选题)
When importing a table into a database,the import process performs these tasks: 1. Triggers are imported. 2. Data is imported. 3. New tables are created. 4. Indexes are built. 5. Any bitmap, functional, and/or domain indexes are built. 6. Integrity constraints are enabled on the new tables. Which option shows the tasks in the order in which they are performed?()
(单选题)
You are using RMAN to perform a closed database backup of your database. You issue these RMAN commands: STARTUP MOUNT; BACKUP FORMAT ’/BACKUP/df_%d_%s_%p.bus’ DATABASE filesperset = 2; Which components are included in the backup?()
(单选题)
This is the online redo log files and the control file configurations: Based on these configurations, which statement is true?()