1z0-071 Exam Question 1
Evaluate these commands which execute successfully:
Which two statements are true about the ORD_ITEMStable and the ORD_SEQsequence?
Which two statements are true about the ORD_ITEMStable and the ORD_SEQsequence?
1z0-071 Exam Question 2
Table EMPLOYEES contains columns including EMPLOYEE_ID, JOB_ID and SALARY.
Only the EMPLOYEES_ID column is indexed.
Rows exist for employees 100 and 200.
Examine this statement:
UPDATE employees
SET (job_id, salary) =
(SELECT job_id, salary
FROM employees
WHERE employee_id = 200)
WHERE employee id=100;
Which two statements are true?
Only the EMPLOYEES_ID column is indexed.
Rows exist for employees 100 and 200.
Examine this statement:
UPDATE employees
SET (job_id, salary) =
(SELECT job_id, salary
FROM employees
WHERE employee_id = 200)
WHERE employee id=100;
Which two statements are true?
1z0-071 Exam Question 3
Which three SQL statements would display the value 1890.55 as $1,890.55? (Choose three.)
1z0-071 Exam Question 4
You issued this command:
SQL > DROP TABLE employees;
Which three statements are true? (Choose three.)
SQL > DROP TABLE employees;
Which three statements are true? (Choose three.)
1z0-071 Exam Question 5
Examine this business rule:
Each student can work on multiple projects and each project can have multiple students.
You must design an Entity Relationship(ER) model for optimal data storage and allow for generating reports in this format:
Which two statements are true?
Each student can work on multiple projects and each project can have multiple students.
You must design an Entity Relationship(ER) model for optimal data storage and allow for generating reports in this format:
Which two statements are true?