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？（）
单选题查看答案