OCP
路畅水远
这个作者很懒,什么都没留下…
展开
-
1Z0-051 30. Evaluate thefollowing CREATE TABLE commands
30. Evaluate thefollowing CREATE TABLE commands:CREATE TABLEorders(ord_noNUMBER(2) CONSTRAINT ord_pk PRIMARY KEY,ord_date DATE,cust_idNUMBER(4));CREATE TABLEord_items(ord_noNUMBER(2),ite原创 2017-07-04 11:12:19 · 445 阅读 · 0 评论 -
1Z0-051 35. Which two statements are true regarding constraints? (Choose two.)
35. Which twostatements are true regarding constraints? (Choose two.)A. A table canhave only one primary key and one foreign key.B. A table canhave only one primary key but multiple foreign keys.原创 2017-07-04 11:15:15 · 505 阅读 · 0 评论 -
1Z0-051 37. You issued the following command to drop the PRODUCTS table:
SQL> DROPTABLE products;What is theimplication of this command? (Choose all that apply.)A. All dataalong with the table structure is deleted.B. The pendingtransaction in the session is committed原创 2017-07-05 10:24:32 · 683 阅读 · 0 评论 -
1Z0-051 25. You need to create a table with the following column specifications:
25. You need tocreate a table with the following column specifications:1. Employee ID(numeric data type) for each employee2. Employee Name(character data type) that stores the employee name3. Hi原创 2017-06-28 14:36:29 · 358 阅读 · 0 评论 -
1Z0-051 9.Which statement is true regarding the INTERSECT operator?
9. Whichstatement is true regarding the INTERSECT operator?A. It ignoresNULL values.B. Reversing theorder of the intersected tables alters the result.C. The names ofcolumns in all SELECT stateme原创 2017-06-27 18:07:01 · 508 阅读 · 0 评论