Free Oracle 1Z0-007 Exam Dumps Questions & Answers

Examine the structure of the EMPLOYEES table:
EMPLOYEE_ID NUMBER NOT NULL, Primary Key EMP_NAME VARCHAR2(30) JOB_ID NUMBER\ SAL NUMBER MGR_ID NUMBER References EMPLOYEE_ID column DEPARTMENT_ID NUMBER Foreign key to DEPARTMENT_ID column of the
DEPARTMENTS table
You created a sequence called EMP_ID_SEQ in order to populate sequential values for the EMPLOYEE_ID column of the EMPLOYEES table.
Which two statements regarding the EMP_ID_SEQ sequence are true? (Choose two.)

• A.  The EMP_ID_SEQ sequence is dropped automatically when you drop the EMPLOYEE_ID column.
• B.  The EMP_ID_SEQ sequence is invalidated when you modify the EMPLOYEE_ID column.
• C.  The EMP_ID_SEQ sequence is not affected by modifications to the EMPLOYEES table.
• D.  Any other column of NUMBER data type in your schema can use the EMP_ID_SEQ sequence.
• E.  You cannot use the EMP_ID_SEQ sequence to populate the JOB_ID column.
• F.  The EMP_ID_SEQ sequence is dropped automatically when you drop the EMPLOYEES table.

Which is an /SQL*Plus command?

• A.  UPDATE
• B.  DESCRIBE
• C.  DELETE
• D.  SELECT
• E.  RENAME
• F.  INSERT

Examine the structure of the EMPLOYEES and NEW EMPLOYEES tables:

Which MERGE statement is valid?

• A.  MERGE INTO new employees c
  USING employees e
  ON (c.employee_id = e.employee_id)
  WHEN EXISTS THEN
  UPDATE SET
• B.  name = e.first_name ||','|| e.last_name
  WHEN NOT MATCHED THEN
  INSERT INTO new_employees VALUES(e.employee_id, e.first_name ||'.'||e.last_name);
• C.  MERGE INTO new_employees c
  USING employees e
  ON (c.employee_id = e.employee_id)
  WHEN MATCHED THEN
  UPDATE SET
• D.  name = e.first_name ||','|| e.last_name
  WHEN NOT MATCHED THEN
  INSERT VALUES(e.employee_id, e.first_name ||',
  '||e.last_name);
• E.  name = e.first_name ||','|| e.last_name
  WHEN NOT MATCHED THEN
  INSERT VALUES(e.employee_id, e.first_name ||',
  '||e.last_name);
• F.  name = e.first_name ||','|| e.last_name
  WHEN NOT MATCHED THEN
  INSERT VALUES(e.employee_id, e.first_name ||',
  '||e.last_name);
• G.  MERGE new_employees c
  FROM employees e
  ON (c.employee_id = e.employee_id)
  WHEN MATCHED THEN
  UPDATE SET
• H.  MERGE new_employees c
  USING employees e
  ON (c.employee_id = e.employee_id)
  WHEN EXIST THEN
  UPDATE SET

Which syntax turns an existing constraint on?

• A.  ALTER TABLE table_name
  ENABLE CONSTRAINT constraint_name;
• B.  ALTER TABLE table_name
  STATUS ENABLE CONSTRAINT constraint_name;
• C.  ALTER TABLE table_name
  ENABLE constraint_name;
• D.  ALTER TABLE table_name
  TURN ON CONSTRAINT constraint_name;
• E.  ALTER TABLE table_name
  STATUS = ENABLE CONSTRAINT constraint_name;
• F.  ALTER TABLE table_name
  TURN ON CONSTRAINT constraint_name;

Top N analysis requires _____ and _____. (Choose two.)

• A.  only an inline view
• B.  the use of rowid
• C.  a GROUP BY clause
• D.  an inline view and an outer query
• E.  an ORDER BY clause