Which are DML statements? (Choose all that apply)

• A. UPDATE...
• B. COMMIT...
• C. MERGE...
• D. DELETE...
• E. DROP...
• F. CREAT..

解説: (Fast2test メンバーにのみ表示されます)

Examine the structure of the EMPLOYEES and DEPARTMENTS tables:

You want to create a report displaying employee last names, department names, and locations. Which query should you use to create an equi-join?

• A. SELECT e.last_name, d.department_name, d.location_id
  FROM employees e, departments D
  WHERE manager_id =manager_id;
• B. SELECT e.last_name, d.department_name, d.location_id
  FROM employees e, departments D
  WHERE e.department_id =d.department_id;
• C. SELECT employees.last_name, departments.department_name,
  departments.location_id
  FROM employees e, departments D
  WHERE e.department_id =d.department_id;
• D. SELECT last_name, department_name, location_id
  FROM employees , departments ;

解説: (Fast2test メンバーにのみ表示されます)

You need to give the MANAGER role the ability to select from, insert into, and modify existing rows in the STUDENT_GRADES table. Anyone given this MANAGER role should be able to pass those privileges on to others.
Which statement accomplishes this?

• A. GRANT select, insert, update ON student_grades TO ROLE manager;
• B. GRANT select, insert, modify ON student_grades TO manager WITH GRANT OPTION;
• C. GRANT select, insert, update ON student_grades TO manager WITH GRANT OPTION;
• D. GRANT select, insert, update ON student_grades TO manager;
• E. GRANT select, insert, modify ON student_grades TO ROLE manager WITH GRANT OPTION;
• F. GRANT select, insert, update ON student_grades TO ROLE manager WITH GRANT OPTION;

解説: (Fast2test メンバーにのみ表示されます)

Which view should a user query to display the columns associated with the constraints on a table owned by the user?

• A. USER_COLUMNS
• B. USER_CONSTRAINTS
• C. USER_OBJECTS
• D. USER_CONS_COLUMNS
• E. ALL_CONSTRAINTS

解説: (Fast2test メンバーにのみ表示されます)

You need to modify the STUDENTS table to add a primary key on the STUDENT_ID column. The table is currently empty.
Which statement accomplishes this task?

• A. ALTER TABLE students ADD PRIMARY KEY student_id;
• B. ALTER TABLE studentsMODIFY CONSTRAINT stud_id_pk PRIMARY KEY (student_id);
• C. ALTER TABLE students ADD CONSTRAINT PRIMARY KEY (student_id);
• D. ALTER TABLE students ADD CONSTRAINT stud_id_pk PRIMARY KEY student_id;
• E. ALTER TABLE students ADD CONSTRAINT stud_id_pk PRIMARY KEY (student_id);

解説: (Fast2test メンバーにのみ表示されます)