Online Access Free 1Z0-007 Practice Test

Which constraint can be defined only at the column level?

• A.FOREIGN KEY
• B.UNIQUE
• C.NOT NULL
• D.CHECK
• E.PRIMARY KEY

Which three statements about subqueries are true? (Choose three.)

• A.Multiple columns or expression can be compared between the subquery and main query.
• B.The subquery and main query must retrieve data from the same table.
• C.A main query can have more than one subquery.
• D.A subquery can have more than one main query.
• E.The subquery and main query can retrieve data from different tables.
• F.Only one column or expression can be compared between the subquery and main query.

User Mary has a view called EMP_DEPT_LOC_VU that was created based on the EMPLOYEES, DEPARTMENTS, and LOCATIONS tables. She has the privilege to create a public synonym, and would like to create a synonym for this view that can be used by all users of the database.
Which SQL statement can Mary use to accomplish that task?

• A.CREATE SYNONYM EDL_VU FOR EACH USER ON emp_dept_loc_vu;
• B.CREATE PUBLIC SYNONYM EDL_VU ON emp_dept_loc_vu FOR ALL USERS;
• C.CREATE PUBLIC SYNONYM EDL_VU FOR emp_dept_loc_vu;
• D.CREATE SYNONYM EDL_VU ON emp_dept_loc_vu FOR EACH USER;
• E.CREATE PUBLIC SYNONYM EDL:VU FOR mary (emp_dept_loc_vu);
• F.CREATE PUBLIC SYNONYM EDL_VU ON emp_dept_loc_vu;

Examine the data from the EMP table:

The COMMISSION column shows the monthly commission earned by the employee.
Which three tasks would require subqueries or joins in order to perform in a single step? (Choose three)

• A.Finding the number of employees who do NOT earn commission and are working for department 20.
• B.Creating a table called COMMISSION that has the same structure and data as the columns EMP_ID and COMMISSIONS of the EMP table.
• C.Inserting into the table a new employee 10 who works for department 20 and earns a commission that is equal to the commission earned by employee 3.
• D.Deleting the records of employees who do not earn commission.
• E.Decreasing the commission by 150 for the employees who are working in department 30 and earning a commission of more then 800.
• F.Increasing the commission of employee 3 by the average commission earned in department 20.

Scott issues the SQL statements:

If Sue needs to select from Scott's DEPT table, which command should she use?

• A.SELECT *
  FROM DBA.SCOTT.DEPT;
• B.SELECT *
  FROM SCOTT.DEPT;
• C.SELECT *
  FROM DEPT;
• D.SELECT *
  FROM ALL_USERS
  WHERE USER_NAME = 'SCOTT'
  AND TABLE NAME = 'DEPT';