全国
Oracle认证考试
切换题库
考试题库
章节练习
[单项选择题]Examine these statements:CREATE ROLE registrarGRANT UPDATE ON dtudent_grades TO registrar;GRANT registrar to user1, user2, user3;What does this set of SQL statements do? ()
2024-05-16
[单项选择题]You need to design a student registration database that contains several tables storing academic information.The STUDENTS table stores information about a student. The STUDENT_GRADES table storesinformation about the student's grades. Both of the tables have a column named STUDENT_ID. The STUDENT_ID column in the STUDENTS table is a primary key.You need to create a foreign key on the STUDENT_ID column of the STUDENT_GRADES table thatpoints to the STUDENT_ID column of the STUDENTS table. Which statement creates the foreign key?()
2024-05-16
[多项选择题]Which are /SQL*Plus commands? ()
2024-05-16
[单项选择题]Examine the structure of the STUDENTS table:STUDENT_ID NUMBER NOT NULL, Primary KeySTUDENT_NAME VARCHAR2(30)COURSE_ID VARCHAR2(10) NOT NULLMARKS NUMBERSTART_DATE DATEFINISH_DATE DATEYou need to create a report of the 10 students who achieved the highest ranking in the course INT SQL and who completed the course in the year 1999.Which SQL statement accomplishes this task? ()
2024-05-16
1Z0-007章节练习
2020-05-28
1Z0-007章节练习
2020-05-26
1Z0-007章节练习
2020-05-19
1Z0-007章节练习
2020-05-19
+ 点击查看更多
备考
搜题
练习
网校
登录