GoConqr has a new look! Let us know what you think.

Sign up free

Quiz

Total Tester

Brandon Gagon 14 questions

Take the quiz

Questions in this quiz (14)

  1. 1Which of the following are not valid DML statements?
    1. AINSERT
    2. BTRUNCATE
    3. CMERGE
    4. DDELETE
    5. ECOMMIT
  2. 2Which of the following queries result in a Cartesian product?
    1. Aselect product_name from customers natural join orders natural join product;
    2. Bselect product_name from customers cross join products using (product_id) cross join orders using (order_id)
    3. Cselect product_name from customers natural join products
    4. Dselect product_name from customers join orders using (customer_id) join products using (product_id)
  3. 3Which of these statements, if any, CANNOT be reversed with a ROLLBACK?
    1. ADELETE
    2. BINSERT
    3. CMERGE
    4. DTRUNCATE
    5. EUPDATE
    6. FAll these statements can be rolled back, if not committed
  4. 4Which of these do not represent a valid type of column constraint?
    1. AFOREIGN KEY
    2. BPRIMARY KEY
    3. CNOT NULL
    4. DUNIQUE
    5. ECHECK
    6. FNOVALIDATE
  5. 5Which of these queries will give an error?
    1. ASELECT last_name, first_name FROM employees ORDER BY hire_date;
    2. BSELECT last_name, first_name FROM employees ORDER BY 2;
    3. CSELECT last_name last, first_name first FROM employees ORDER BY last;
    4. DA, B, and C will all run successfully
  6. 6If you create a table without specifying a schema, where will it be created?
    1. AIn your current schema
    2. Bin the PUBLIC schema
    3. CIn the SYS schema
    4. DIt will be created as a nonschema object
  7. 7This compound query uses four set operators, without any parentheses to force an order of precedence:

    SELECT last_name from employees
    UNION
    SELECT last_name from contractors
    MINUS
    SELECT last_name from black_list
    INTERSECT
    SELECT last_name from europeans

    The intention is to return a list made up of all employees, plus all contractors who are not blacklisted, and then to remove all the people who are not European.

    Is this what will happen?
    1. AYes
    2. BNo. The INTERSECT operator will remove all non-Europeans from the blacklist before the blacklist is applied
    3. CNo. The MINUS will remove the blacklisted employees, as well as the blacklisted contractors.
    4. DThe result is not predictable. In the absence of parentheses to control operator precedence, the query optimizer could develop different execution plans depending on circumstances.
  8. 8Which DML command can affect rows in more than one table with a single statment?
    1. ADELETE
    2. BINSERT
    3. CTRUNCATE
    4. DUPDATE
  9. 9Within a schema, objects within the same namespace cannot have the same name. If you already created a table in your schema called EXAMPLE, which of the following commands will succeed? (CHOOSE TWO)
    1. ACREATE INDEX EXAMPLE
    2. BCREATE PROCEDURE EXAMPLE
    3. CCREATE SEQUENCE EXAMPLE
    4. DCREATE VIEW EXAMPLE
  10. 10Which of these statements will terminate a transaction?
    1. AROLLBACK TO SAVEPOINT savepoint_name;
    2. BCREATE VIEW viewname AS select_statement;
    3. CGRANT SELECT ON table_name TO username
    4. DTRUNCATE TABLE table_name

Information

Description
Quiz on Total Tester, created by Brandon Gagon on 28/05/2019.
Language
English
Views
0
Rating
No ratings yet
Rate this quiz
Rate this quiz

Feedback

What is it about?

What do you think of the new look?

How do you like it?