首页计算机考试Oracle认证

Oracle认证最新试题

  • (多选题)

    Which two statements regarding the LOGGING clause of the CREATE TABLESPACE. .. statement are correct?()

    答案解析

  • (单选题)

    Your database is open and the LISTENER listener is running. The new DBA of the system stops thelistener by using the command:  LSNRCTL> STOP  What happens to the sessions that are presently connected to the database instance()

    答案解析

  • (单选题)

    You executed the following command to back up your control file:  ALTER DATABASE BACKUP CONTROLFILE TO TRACE;  Which initialization parameter is used to specify the location of the trace file?()

    答案解析

  • (多选题)

    On your Oracle 12c database, you Issue the following commands to create indexes SQL > CREATE INDEX oe.ord_customer_ix1 ON oe.orders (customers_id, sales_rep_id) INVISIBLE; SQL> CREATE BITMAP INDEX oe.ord_customer_ix2 ON oe.orders (customers_id, sales_rep_id); Which two statement are correct?()

    答案解析

  • (单选题)

    The IT department requested a report to list each server name and the name of each department that utilizes resources from each server. You create a tabular layout that breaks on the server name. You ran the report and noticed that the department field is too large for most of the department names. Which field size setting would you use to allow the field to be smaller but not larger than the field layout size?()

    答案解析

  • (单选题)

    在Oracle中,通过命令()可以释放锁。

    答案解析

  • (单选题)

    Given: What is the result?()

    答案解析

  • (单选题)

    In the COURSE_ENROLLMENT form module, you define a master-detail relation between the COURSES_OFFERED data block and the STUDENT data block, respectively. To implement block coordination, which statement must be true?()

    答案解析

  • (单选题)

    You have used the CROSSCHECK BACKUP command to verify that the backups recorded in the RMAN repository actually exist.  Which command should you now use to check if any of the files were missing?()

    答案解析

  • (多选题)

    What two are the prerequisites for enabling Flashback Database?() 

    答案解析

  • (单选题)

    You are analyzing the components of the redo log mechanisms in your Oracle database. Which of the following purposes does the CKPT process serve?()

    答案解析

  • (单选题)

    You need to modify the STUDENTS table to add a primary key on the STUDENT_ID column. The table is currently empty. Which statement accomplishes this task?()

    答案解析

  • (单选题)

    ou executed the command to create a password file in the database server: $ orapwd file=orapworcl entries=5 ignorecase=N  Which statement describes the purpose of the above password file()

    答案解析

  • (多选题)

    What recommendations does the SQL Access Advisor provide for optimizing SQL queries? ()(Choose all that apply.)

    答案解析

  • (单选题)

    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 of the following options would you choose to implement controlled access using remote authentication for your networks?()

    答案解析

  • (单选题)

    You have a production instance running on your server. UNDO_RETENTION is not long enough to satisfy read-consistency requirements. How do you change the UNDO_RETENTION value?()

    答案解析

  • (单选题)

    对于系统表的空间,Oracle建议的大小是()。

    答案解析

  • (多选题)

    Which three possible values can be set for the TIME_ZONE session parameter by using the ALTER SESSION command? ()

    答案解析

  • (单选题)

    You are maintaining your OLTP database in Oracle10g. You have not set the warning level and critical level threshold values for space usage of the DATA1 tablespace. What will be the impact?()

    答案解析

快考试在线搜题