首页计算机考试Oracle认证

Oracle认证最新试题

  • (单选题)

    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?()  

    答案解析

快考试在线搜题