Online Access Free 1Z0-007 Exam Questions

Which four are valid Oracle constraint types? (Choose four.)

• A.PRIMARY KEY
• B.NOT NULL
• C.CONSTANT
• D.CASCADE
• E.UNIQUE
• F.CHECK
• G.NONUNIQUE

The DBA issues this SQL command:
CREATE USER scott
IDENTIFIED by tiger;
What privileges does the user Scott have at this point?

• A.Only the SELECT privilege.
• B.Only the CONNECT privilege.
• C.No privileges.
• D.All the privileges of a default user.

Examine the data in the EMPLOYEES and EMP_HIST tables:

The EMP_HIST table is updated at the end of every year. The employee ID, name, job ID, and salary of each existing employee are modified with the latest data. New employee details are added to the table.
Which statement accomplishes this task?

• A.UPDATE emp_hist SET employee_id, name, job_id, salary = (SELECT employee_id, name, job_id, salary FROM employees) WHERE employee_id IN (SELECT employee_id FROM employees);
• B.MERGE INTO emp_hist eh USING employees e WHEN MATCHED THEN UPDATE emp_hist SET eh.name = e.name, eh.job_id = e.job_id, eh.salary = e.salary WHEN NOT MATCHED THEN INSERT INTO emp_hist VALUES (e.employee_id, e.name, e.job_id, e.salary);
• C.MERGE INTO emp_hist eh USING employees e ON (eh.employee_id = e.employee_id) WHEN MATCHED THEN UPDATE SET eh.name = e.name, eh.job_id = e.job_id, eh.salary = e.salary WHEN NOT MATCHED THEN INSERT VALUES (e.employee id, e.name,
• D.job id, e.salary);
• E.MERGE INTO emp_hist eh USING employees e ON (eh.employee_id = e.employee_id) WHEN MATCHED THEN UPDATE emp hist SET eh.name = e.name, eh.job_id = e.job_id, eh.salary = e.salary WHEN NOT MATCHED THEN INSERT INTO emp_hist VALUES (e.employee_id, e.name, e.job_id, e.salary);

What is true about joining tables through an equijoin?

• A.You can join n tables (all having single column primary keys) in a SQL statement by specifying a minimum of n-1 join conditions.
• B.You can join a maximum of two tables through an equijoin.
• C.To join two tables through an equijoin, the columns in the join condition must be primary key and foreign key columns.
• D.You specify an equijoin condition in the SELECT or FROM clauses of a SELECT statement.
• E.You can join a maximum of two columns through an equijoin.

Which three are true? (Choose three.)

• A.A MERGE statement replaces the data of one table with that of another.
• B.A MERGE statement is used to merge the data of one table with data from another.
• C.A MERGE statement can be used to update existing rows in a table.
• D.A MERGE statement can be used to insert new rows into a table.