Question 166

You must create a table EMPLOYEES in which the values in the columns EMPLOYEES_ID and LOGIN_ID must be unique and not null.
Which two SQL statements would create the required table? (Choose two.) CREATE TABLE employees
  • Question 167

    View 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 CATEGORYJD 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?
  • Question 168

    View the Exhibit and examine the structure of the CUSTOMERS table.

    Evaluate the following SQL statement:

    Which statement is true regarding the outcome of the above query?
  • Question 169

    Examine the structure of the SALES table. (Choose two.)

    Examine this statement:

    Which two statements are true about the SALES1 table? (Choose two.)
  • Question 170

    Examine the structure of the BOOKS_TRANSACTIONS table:

    You want to display the member IDs, due date, and late fee as $2 for all transactions.
    Which SQL statement must you execute?