首页计算机考试Oracle认证

Oracle认证最新试题

  • (单选题)

    The EMP table has these columns: ENAME VARCHAR2(35) SALARY NUMBER(8,2) HIRE_DATE DATE Management wants a list of names of employees who have been with the company for more than five years. Which SQL statement displays the required results? ()

    答案解析

  • (单选题)

    Examine the following command:   ALTER DISKGROUP data MOUNT FORCE;   In which scenario can you use the above command to mount the disk group?()  

    答案解析

  • (多选题)

    Which three data sources integrations are provided by Coherence out of the box ? ()

    答案解析

  • (简答题)

    程序全局区(PGA)由哪几个部分组成?各部分存放信息的类型是什么?

    答案解析

  • (单选题)

    he DBA is about to enable auditing on the Oracle database in an attempt to discover some suspicious activity. Audit trail information is stored in which of the following database object names?()

    答案解析

  • (单选题)

    A database instance is using an Automatic Storage Management (ASM) instance, which has a disk group, DGROUP1, created as follows: What happens when the whole CONTROLLER1 Failure group is damaged?()

    答案解析

  • (多选题)

    Evaluate the SQL statement DROP TABLE DEPT; Which four statements are true of the SQL statement? ()

    答案解析

  • (多选题)

    Which two statements about subqueries are true? ()

    答案解析

  • (单选题)

    Which script must you to query to display the code associated with RMAN stored scripts?()

    答案解析

  • (单选题)

    Following is the list of locations in random order where oranfstab can be placed.   1./etc/mtab  2.$ORACLE_HOME/dbs/oranfstab  3./etc/oranfstab   What is the sequence in which Direct NFS will search the locations?()  

    答案解析

  • (多选题)

    In your production database, you observe that users’ transactions are consuming a lot of resources and you plan to impose resource restrictions by using Resource Manager. For which three resources can you enable usage restrictions by using Resource Manager? ()

    答案解析

  • (单选题)

    Given a correctly compiled class whose source code is: Assume that the class file is located in /foo/com/sun/sjcp/, the current directory is /foo/, and that theclasspath contains "." (current directory). Which command line correctly runs Commander?()

    答案解析

  • (单选题)

    What is true about joining tables through an equijoin?()

    答案解析

  • (多选题)

    Which two client requests are captured during database replay Capture?()

    答案解析

  • (单选题)

    You created a report from the human resources department based on all the columns in the EMP table. After viewing the report users requested that the cmp_ID columns peers first in the output. How would you change the position of the column?()

    答案解析

  • (单选题)

    下面的时间函数,()用于返回当前Oracle会话时区中的日期信息。

    答案解析

  • (单选题)

    Which of the following statements is true regarding implementing a Flashback Table recovery?  ()

    答案解析

  • (单选题)

    You are designing an application for a telecom company and you have been asked to design a database table to facilitate monthly bill generation. The bill would include details of customer calls, listed in chronological order.  Which method would you follow to achieve this objective without increasing the overhead of sorting the rows?()

    答案解析

  • (单选题)

    Examine the data in the EMPLOYEES and DEPARTMENTS tables: Also examine the SQL statements that create the EMPLOYEES and DEPARTMENTS tables: On the EMPLOYEES table, EMPLOYEE_ID is the primary key. MGR_ID is the ID of managers and refers to the EMPLOYEE_ID. DEPT_ID is foreign key to DEPARTMENT_ID column of the DEPARTMENTS table. On the DEPARTMENTS table, DEPARTMENT_ID is the primary key. Examine this DELETE statement: What happens when you execute the DELETE statement?()

    答案解析

  • (单选题)

    You lost the index tablespace in your database. You are not able to use tablespace point-in-time recovery on the index tablespace. What could be the reason for this?()

    答案解析

快考试在线搜题