Observe the information in the columns： 1： The SGA a. Text and parsed forms of all SQL statements 2： The cursor state b. Run-time memory values for the SQL statement， such as rows retrieved 3： User-session data c. Security and resource usage information 4：The stack space d. Local variables for the process Which option has the correct match between the memory areas and their contents（）
单选题查看答案
View Exhibit1 and Exhibit2 to examine the current memory allocation and parameter settings，respectively. Why are advisors not available for the shared pool and the buffer cache（ ）
单选题查看答案
Consider the recovery steps in each of the cases given below： Case 1： Shut down the database and perform a backup. Restore all the data files. Mount the database. Recover the database. Without applying all the redo log files， open the database using the RESETLOGS option. Back up the database. Case 2： Shut down the database and perform a backup. Restore only the data files of the tablespace where user error damaged the data. Mount the database. Recover the database. Open the database with the RESETLOGS option. Back up the database. Case 3： Shut down the database Restore the data files Open the database Perform recovery to the current point in time. Which case has the correct steps for an incomplete recovery？（）
单选题查看答案
Click the Exhibit button. Given: ClassA a = new ClassA（ ）; a.methodA（ ）; What is the result? （）
单选题查看答案
Examine the structure of the EMPLOYEES table: EMPLOYEE_ID NUMBER Primary Key FIRST_NAME VARCHAR2(25) LAST_NAME VARCHAR2(25) HIRE_DATE DATE Which INSERT statement is valid? （）
单选题查看答案
Which canvas built-in display the given canvas in front of any stacked canvases?（）
单选题查看答案
Examine the following command: CREATE TABLE (prod_id number(4), Prod_name varchar2 (20), Category_id number(30), Quantity_on_hand number (3) INVISIBLE); Which three statements are true about using an invisible column in the PRODUCTS table?（）
多选题查看答案
You are working on a CATDB database that contains an Oracle Database version 11.1 catalog schema owned by the user RCO11. The INST1 database contains an Oracle Database version 10.1 catalog schema owned by the user RCAT10. You want the RMAN to import metadata for database IDs 1423241 and 1423242， registered in RCAT10， into the recovery catalog owned by RCO11. You executed the following commands： RMAN> CONNECT CATALOG rco11/password@catdb RMAN> IMPORT CATALOG rcat10/oracle@inst1 NO UNREGISTER； Which two statements are true regarding the tasks accomplished with these commands？（）
多选题查看答案
You are managing a 24*7 database. The backup strategy for the database is to perform user-managed backups. Identify two prerequisites to perform the backups.（）
多选题查看答案
You have enabled backup optimization in RMAN. You issue the following RMAN command to configure a redundancy-based retention policy： CONFIGURE RETENTION POLICY TO REDUNDANCY 3； Which statement is true？（）
单选题查看答案
Which two PL/SQL8 features are supported in Oracle Forms?（）
多选题查看答案
当需要重建某个索引ix_customername，可以使用（）方式。
单选题查看答案
You enable block change tracking. You issue the following command: BACKUP INCREMENTAL LEVEL 0 DATABASE; The next day, you issue the following command: BACKUP INCREMENTAL LEVEL 1 CUMULATIVE DATABASE; Which statement about the use of the change tracking file is true?（）
单选题查看答案
Data files of which three tablespaces can be recovered by performing an open recovery？（）
多选题查看答案
The ORDERS table in the database of a company contains one million records. The table is stored in the DATA tablespace and the index created on the ORDERS table is stored in the index tablespace named INDEXES. On Monday， you failed to start the database because the datafiles of the INDEXES tablespace were missing. You dropped and recreated the INDEXES tablespace by issuing the following command： SQL>DROP TABLESPACE INDEXES INCLUDING CONTENTS； SQL> CREATE TABLESPACE INDEXES DATAFILE ’C:///ORACLE/ORADATA/ORA101t/INDEX01.DBF’ SIZE 50m； After that， you issued the following command to recreate the index： CREATE UNIQUE INDEX sales_index_pk ON sales （order_id） PCTFREE 10 INITRANS 2 MAXTRANS 255 TABLESPACE indexes STORAGE （ INITIAL 1m NEXT 1m PCTINCREASE 0 MINEXTENTS 1 MAXEXTENTS 8192 ） NOLOGGING PARALLEL（ degree 4） Which two clauses are responsible for reducing the time for the recreation of the index？（）
多选题查看答案
Which three statements regarding the server parameter file （SPFILE） are true（）
多选题查看答案
You executed the following procedure to collect statistics regarding an index： SQL>ANALYZE INDEX EMP_ID VALIDATE STRUCTURE； Which view will you use to determine whether you need to rebuild the index or not？（）
单选题查看答案
Which two are attributes of iSQL*Plus? （）
多选题查看答案
For which database operation would you need the database to be in the MOUNT state（）
单选题查看答案
You are maintaining your database in Oracle10g. You find that the number of languages that should be supported in your database has increased. The character set of your database is UTF8. You decide to migrate your database to the AL16UTF16 national character set. How will you migrate your database from UTF8 to AL16UTF16？（）
单选题查看答案