1Z0-007 試験問題を無料オンラインアクセス

Which statement explicitly names a constraint?

• A.ALTER TABLE student_grades ADD CONSTRAINT NAME = student_id_fk FOREIGN KEY (student_id) REFERENCES students(student_id);
• B.ALTER TABLE student_grades ADD NAMED CONSTRAINT student_id_fk FOREIGN KEY (student_id) REFERENCES students(student_id);
• C.ALTER TABLE student_grades ADD NAME student_id_fk FOREIGN KEY (student_id) REFERENCES students(student_id);
• D.ALTER TABLE student_grades ADD FOREIGN KEY (student_id) REFERENCES students(student_id);
• E.ALTER TABLE student_grades ADD CONSTRAINT student_id_fk FOREIGN KEY (student_id) REFERENCES students(student_id);

Examine the data of the EMPLOYEES table.
EMPLOYEES (EMPLOYEE_ID is the primary key. MGR_ID is the ID of managers and refers to the EMPLOYEE_ID)

Evaluate this SQL statement:
SELECT e.employee_id "Emp_id", e.emp_name "Employee", e.salary,
m.employee_id "Mgr_id", m.emp_name "Manager"
FROM employees e, employees m
WHERE e.mgr_id = m.employee_id
AND e.salary > 4000;
What is its output?

• A.Option D
• B.Option C
• C.Option A
• D.Option B

Which constraint can be defined only at the column level?

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

Examine the statement:
GRANT select, insert, update
ON student_grades
TO manager
WITH GRANT OPTION;
Which two are true? (Choose two.)

• A.It allows the MANAGER to apply all DML statements on the STUDENT_GRADES table.
• B.MANAGER must be a role.
• C.It allows the MANAGER to create tables that refer to the STUDENT_GRADES table.
• D.It allows the MANAGER the ability to select from, delete from, and update the STUDENT_GRADES table.
• E.It allows the MANAGER to pass the specified privileges on to other users.
• F.It allows the MANAGER the ability to select from, insert into, and update the STUDENT_GRADES table.

Which operator can be used with a multiple-row subquery?

• A.IS
• B.LIKE
• C.BETWEEN
• D.=
• E.<>
• F.NOT IN