1Z1-047 무료 덤프문제 온라인 액세스

Which statements are true? (Choose all that apply.)

• A.The usernames of all the users including the database administrators are stored in the data dictionary.
• B.The data dictionary is created and maintained by the database administrator.
• C.Views with the same name but different prefixes, such as DBA, ALL and USER, use the same base tables from the data dictionary
• D.The USER_CONS_COLUMNS view should be queried to find the names of the columns to which a constraint applies.
• E.The data dictionary views can consist of joins of dictionary base tables and user-defined tables.
• F.Both USER_OBJECTS and CAT views provide the same information about all the objects that are owned by the user.

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_IDRDERS table would not get created because the column names in the CREATE TABLE command and the SELECT clause do not match.
• B.The NEW_IDRDERS table would get created and only the NOT NULL constraint defined on the specified columns would be passed to the new table.
• C.The NEW_IDRDERS table would not get created because the DEFAULT value cannot be specified in the column definition.
• D.The NEW_IDRDERS table would get created and all the constraints defined on the specified columns in the ORDERS table would be passed to the new table.

View the Exhibit and examine the description of the ORDERS table.
The orders in the ORDERS table are placed through sales representatives only. You are given the task to get the SALES_REP_ID from the ORDERS table of those sales representatives who have successfully referred more than 10 customers. Which statement would achieve this purpose?

• A.SELECT sales_rep_id, COUNT(customer_id) "Total"
  FROM orders "
  WHERE COUNT(customer_id) > 10
  GROUP BY sales_rep_id;
• B.SELECT sales_rep_id, COUNT(customer_id) "Total"
  FROM orders "
  GROUP BY sales_rep_id
  HAVING total > 10;
• C.SELECT sales_rep_id, COUNT(customer_id) "Total"
  FROM orders "
  HAVING COUNT(customer_id) > 10;
• D.SELECT sales_rep_id, COUNT(customer_id) "Total"
  FROM orders "
  GROUP BY sales_rep_id
  HAVING COUNT(customer_id) > 10;

View the Exhibit and examine the structure of the PRODUCT_INFORMATION and INVENTORIES tables.
You have a requirement from the supplies department to give a list containing PRODUCT_ID, SUPPLIER_ID, and QUANTITY_ON_HAND for all the products wherein QUANTITY_ON_HAND is less than five.
Which two SQL statements can accomplish the task? (Choose two.)

• A.SELECT i.product_id, i.quantity_on_hand , pi.supplier_id
  FROM product_information pi JOIN inventories i
  USING (product_id) AND quantity_on_hand < 5;
• B.SELECT product_id, quantity_on_hand , supplier_id
  FROM product_information
  NATURAL JOIN inventories AND quantity_on_hand < 5;
• C.SELECT i.product_id, i.quantity_on_hand , pi.supplier_id
  FROM product_information pi JOIN inventories i
  ON (pi. product_id=i. product_id) AND quantity_on_hand < 5;
• D.SELECT i.product_id, i.quantity_on_hand , pi.supplier_id
  FROM product_information pi JOIN inventories i
  ON (pi. product_id=i. product_id)
  WHERE quantity_on_hand < 5;

A non-correlated subquery can be defined as________ .

• A.a set of one or more sequential queries in which generally the result of the inner query is used as the search value in the outer query
• B.a set of sequential queries, all of which must always return a single value
• C.a set of sequential queries, all of which must return values from the same table
• D.a SELECT statement that can be embedded in a clause of another SELECT statement only