Which three statements are true? (Choose three.)

• A.The data dictionary is created and maintained by the database administrator.
• B.The data dictionary views consist of joins of dictionary base tables and user-defined tables.
• C.The usernames of all the users including database administrators are stored in the data dictionary.
• D.The USER_CONS_COLUMNSview should be queried to find the names of columns to which constraints apply.
• E.Both USER_OBJECTSand CATviews provide the same information about all objects that are owned by the user.
• F.Views with the same name but different prefixes, such as DBA, ALLand USER, reference the same base tables from the data dictionary.

Comment: *

Name: *

Email: *

Verification: *

Which two statements are true about * _ TABLES views?

• A.You must have SELECT privileges on a table to view it in ALL _TABLES.
• B.You must have SELECT privileges on a table to view it in USER TABLES.
• C.All users can query DBA TABLES successfully.
• D.USER_ TABLES displays all tables owned by the current user.
• E.ALL TABLES displays all tables owned by the current user.
• F.You must have SELECT privileges on a table to view it in DBA TABLES.

Comment: *

Name: *

Email: *

Verification: *

View the Exhibit and examine the structure of the ORDERS table. The ORDER_ID column is the PRIMARY KEY in the ORDERS table.

Evaluate the following CREATE TABLE command:
CREATE TABLE new_orders(ord_id, ord_date DEFAULT SYSDATE, cus_id)
AS
SELECT order_id.order_date,customer_id
FROM orders;
Which statement is true regarding the above command?

• A.The NEW_ODRDERS table would get created and all the constraints defined on the specified columns in the ORDERS table would be passed to the new table.
• B.The NEW_ODRDERS table would not get created because the DEFAULT value cannot be specified in the column definition.
• C.The NEW_ODRDERS table would get created and only the NOT NULL constraint defined on the specified columns would be passed to the new table.
• D.The NEW_ODRDERS table would not get created because the column names in the CREATE TABLE command and the SELECT clause do not match.

Comment: *

Name: *

Email: *

Verification: *

Examine the commands used to create DEPARTMENT_DETAILSand COURSE_DETAILS:

You want to generate a report that shows all course IDs irrespective of whether they have corresponding department IDs or not but no department IDs if they do not have any courses.
Which SQL statement must you use?
SELECT course_id, department_id, FROM department_details d RIGHT OUTER JOIN

• A.department_details d ON (c.department_id=d. department_id)
  SELECT c.course_id, d.department_id FROM course_details c FULL OUTER JOIN
• B.course_details c USING (department_id)
  SELECT c.course_id, d.department_id FROM course_details c RIGHT OUTER JOIN
• C..department_details d ON (c.depatrment_id=d.department_id)
  SELECT c.course_id, d.department_id FROM course_details c FULL OUTER JOIN
• D.department_details d ON (c.department_id<>d. department_id)

Comment: *

Name: *

Email: *

Verification: *

View the Exhibit and examine the structure of ORDERS and ORDER_ITEMS tables.
ORDER_ID is the primary key in the ORDERS table. It is also the foreign key in the ORDER_ITEMS table wherein it is created with the ON DELETE CASCADE option.
Which DELETE statement would execute successfully?

• A.DELETE ordersWHERE order_total < 1000;
• B.DELETEFROM ordersWHERE (SELECT order_idFROM order_items);
• C.DELETE orders o, order_items IWHERE o.order_id = i.order_id;
• D.DELETE order_idFROM ordersWHERE order_total < 1000;

Comment: *

Name: *

Email: *

Verification: *