出自:Oracle认证
Which three statements inserts a row into the table?（）
A:INSERT INTO employees VALUES ( NULL, ‘John’,‘Smith’);
B:INSERT INTO employees( first_name, last_name) VALUES(‘John’,‘Smith’);
C:INSERT INTO employees VALUES (‘1000’,‘John’,NULL);
D:INSERT INTO employees(first_name,last_name, employee_id) VALUES ( 1000, ‘John’,‘Smith’);
E:INSERT INTO employees (employee_id) VALUES (1000);
F:INSERT INTO employees (employee_id, first_name, last_name) VALUES ( 1000, ‘John’,‘’);
Examine these statements: CREATE ROLE registrar GRANT UPDATE ON dtudent_grades TO registrar; GRANT registrar to user1, user2, user3; What does this set of SQL statements do? （）
A:The set of statements contains an error and does not work.
B:It creates a role called REGISTRAR, adds the MODIFY privilege on the STUDENT_GRADES object to the role, and gives the REGISTRAR role to three users.
C:It creates a role called REGISTRAR, adds the UPDATE privilege on the STUDENT_GRADES object to the role, and gives the REGISTRAR role to three users.
D:It creates a role called REGISTRAR, adds the UPDATE privilege on the STUDENT_GRADES object to the role, and creates three users with the role.
E:It creates a role called REGISTRAR, adds the UPDATE privilege on three users, and gives the REGISTRAR role to the STUDENT_GRADES object.
F:It creates a role called STUDENT_GRADES, adds the UPDATE privilege on three users, and gives the UPDATE role to the registrar.
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 manager;
B:GRANT select, insert, update ON student_grades TO ROLE manager;
C:GRANT select, insert, modify ON student_grades TO manager WITH GRANT OPTION;
D:GRANT select, insert, update ON student_grades TO manager WITH GRANT OPTION;
E:GRANT select, insert, update ON student_grades TO ROLE manager WITH GRANT OPTION;
F:GRANT select, insert, modify ON student_grades TO ROLE manager WITH GRANT OPTION;
Which two classes use the Shape class correctly？（）
Which command accomplishes these tasks?（）
Using Database Control， you have scheduled a job to shrink the TRANS table residing on the TT tablespace. The job would run at 5：00 p.m. every Friday.When you examine the space usage of the table after the completion of the job， you find that the table has not been shrunk. What could have been the reason for this？（）
What is the result？（）
What is the result？（）