1z0-071 Exam Question 11

Which three SQL statements would display the value 1890.55 as $1,890.55? (Choose three.)
  • 1z0-071 Exam Question 12

    Evaluate the following query:

    What would be the outcome of the above query?
  • 1z0-071 Exam Question 13

    View the exhibit and examine the structure of the SALES, CUSTOMERS, PRODUCTS and TIMES tables.

    The PROD_ID column is the foreign key in the SALES tables, which references the PRODUCTS table.
    Similarly, the CUST_ID and TIME_ID columns are also foreign keys in the SALES table referencing the CUSTOMERS and TIMES tables, respectively.
    Evaluate the following CREATE TABLE command:
    CREATE TABLE new_sales (prod_id, cust_id, order_date DEFAULT SYSDATE)
    AS
    SELECT prod_id, cust_id, time_id
    FROM sales;
    Which statement is true regarding the above command?
  • 1z0-071 Exam Question 14

    You issue the following command to drop the PRODUCTStable:
    SQL > DROP TABLE products;
    Which three statements are true about the implication of this command? (Choose three.)
  • 1z0-071 Exam Question 15

    Evaluate the following SQL statement:
    SQL> select cust_id, cust_last_name "Last name"
    FROM customers
    WHERE country_id = 10
    UNION
    SELECT cust_id CUST_NO, cust_last_name
    FROM customers
    WHERE country_id = 30
    Identify three ORDER BY clauses either one of which can complete the query.