¡GoConqr estrena diseño! Cuéntanos qué te parece.

Regístrate gratis

Test

1Z0-047_2.pdf - Part III

anillvap 10 preguntas

Hacer el test

Preguntas del test (10)

  1. 1Which statements are true? (Choose all that apply.)
    1. AA. The data dictionary is created and maintained by the database administrator.
    2. BB. The data dictionary views can consist of joins of dictionary base tables and user-defined

      tables.
    3. CC. The usernames of all the users including the database administrators are stored in the data

      dictionary.
    4. DD. The USER_CONS_COLUMNS view should be queried to find the names of the columns to

      which a constraint applies.
    5. EE. Both USER_OBJECTS and CAT views provide the same information about all the objects that

      are owned by the user.
    6. FF. Views with the same name but different prefixes, such as DBA, ALL and USER, use the same

      base tables from the data dictionary
  2. 2View the Exhibit and examine the details of the PRODUCT_INFORMATION table.
    You have the requirement to display PRODUCT_NAME and LIST_PRICE from the table where

    the CATEGORY_ID column has values 12 or 13, and the SUPPLIER_ID column has the value

    102088. You executed the following SQL statement:

    SELECT product_name, list_price

    FROM product_information

    WHERE (category_id = 12 AND category_id = 13) AND supplier_id = 102088;

    Which statement is true regarding the execution of the query?
    1. AA. It would execute but the output would return no rows.
    2. BB. It would execute and the output would display the desired result.
    3. CC. It would not execute because the entire WHERE clause condition is not enclosed within the

      parentheses.
    4. DD. It would not execute because the same column has been used in both sides of the AND logical

      operator to form the condition.
  3. 3Given below is the list of meta character syntaxes and their descriptions in random order:



    Meta character syntax Description

    1) ^ a) Matches character not in the list

    2) [^...] b) Matches character when it occurs at the beginning of a line

    3) | c) Treats the subsequent meta character as a literal

    4) \ d) Matches one of the characters such as the OR operator



    Identify the option that correctly matches the meta character syntaxes with their descriptions.
    1. AA. 1-b, 2-a, 3-d, 4-c
    2. BB. 1-a, 2-b, 3-d, 4-c
    3. CC. 1-d, 2-b, 3-a, 4-c
    4. DD. 1-b, 2-c, 3-d, 2-a
  4. 4View the Exhibit and examine the structure of ORDERS and CUSTOMERS tables.
    Evaluate the following UPDATE statement:

    UPDATE

    (SELECT order_date, order_total, customer_id
    FROM orders)

    SET order_date = '22-mar-2007'

    WHERE customer_id =

    (SELECT customer_id

    FROM customers

    WHERE cust_last_name = 'Roberts' AND

    credit_limit = 600);

    Which statement is true regarding the execution of the above UPDATE statement?
    1. AA. It would not execute because two tables cannot be used in a single UPDATE statement.
    2. BB. It would execute and restrict modifications to only the columns specified in the SELECT

      statement.
    3. CC. It would not execute because a subquery cannot be used in the WHERE clause of an

      UPDATE statement.
    4. DD. It would not execute because the SELECT statement cannot be used in place of the table

      name.
  5. 5Which statement correctly differentiates a system privilege from an object privilege?
    1. AA. System privileges can be granted only by the DBA whereas object privileges can be granted

      by DBAs or the owner of the object.
    2. BB. System privileges give the rights to only create user schemas whereas object privileges give

      rights to manipulate objects in a schema.
    3. CC. Users require system privileges to gain access to the database whereas they require object

      privileges to create objects in the database.
    4. DD. A system privilege is the right to perform specific activities in a database whereas an object

      privilege is a right to perform activities on a specific object in the database.
  6. 6View the Exhibit and examine the data in the PRODUCT_INFORMATION table.
    Which two tasks would require subqueries? (Choose two.)
    1. AA. displaying the minimum list price for each product status
    2. BB. displaying all supplier IDs whose average list price is more than 500
    3. CC. displaying the number of products whose list prices are more than the average list price
    4. DD. displaying all the products whose minimum list prices are more than the average list price of

      products having the product status orderable
    5. EE. displaying the total number of products supplied by supplier 102071 and having product status

      OBSOLETE
  7. 7Which two statements are true regarding constraints? (Choose two.)
    1. AA. A foreign key cannot contain NULL values.
    2. BB. A column with the UNIQUE constraint can contain NULL.
    3. CC. A constraint is enforced only for the INSERT operation on a table.
    4. DD. A constraint can be disabled even if the constraint column contains data.
    5. EE. All the constraints can be defined at the column level as well as the table level.
  8. 8View the Exhibit and examine the description of the ORDER_ITEMS table.
    The following SQL statement was written to retrieve the rows for the PRODUCT_ID that has a

    UNIT_PRICE of more than 1,000 and has been ordered more than five times:

    SELECT product_id, COUNT(order_id) total, unit_price

    FROM order_items

    WHERE unit_price>1000 AND COUNT(order_id)>5

    GROUP BY product_id, unit_price;

    Which statement is true regarding this SQL statement?
    1. AA. The statement would execute and give you the desired result.
    2. BB. The statement would not execute because the aggregate function is used in the WHERE

      clause.
    3. CC. The statement would not execute because the WHERE clause should have the OR logical

      operator instead of AND.
    4. DD. The statement would not execute because in the SELECT clause, the UNIT_PRICE column is

      placed after the column having the aggregate function.
  9. 9Which two statements best describe the benefits of using the WITH clause? (Choose two.)
    1. AA. It enables users to store the results of a query permanently.
    2. BB. It enables users to store the query block permanently in the memory and use it to create

      complex queries.
    3. CC. It enables users to reuse the same query block in a SELECT statement, if it occurs more than

      once in a complex query.
    4. DD. It can improve the performance of a large query by storing the result of a query block having

      the WITH clause in the user's temporary tablespace.
  10. 10View the Exhibit and examine the structure of the ORDERS and ORDER_ITEMS tables.

    In the ORDERS table, ORDER_ID is the PRIMARY KEY and ORDER_DATE has the DEFAULT

    value as SYSDATE.

    Evaluate the following statement:

    UPDATE orders

    SET order_date=DEFAULT

    WHERE order_id IN (SELECT order_id FROM order_items

    WHERE qty IS NULL);

    What would be the outcome of the above statement?
    1. AA. The UPDATE statement would not work because the main query and the subquery use

      different tables.
    2. BB. The UPDATE statement would not work because the DEFAULT value can be used only in

      INSERT statements.
    3. CC. The UPDATE statement would change all ORDER_DATE values to SYSDATE provided the

      current ORDER_DATE is NOT NULL and QTY is NULL.
    4. DD. The UPDATE statement would change all the ORDER_DATE values to SYSDATE irrespective

      of what the current ORDER_DATE value is for all orders where QTY is NULL.

Información

Descripción
Test sobre 1Z0-047_2.pdf - Part III , creado por anillvap el 28/01/2014.
Idioma
English
Visitas
189
Valoración
Aún sin valoraciones
Valora este test
Valora este test

Escríbenos

¿Sobre qué es tu mensaje?

¿Qué te parece el nuevo diseño?

¿Te gusta?