First123Last
1 of 10 pages
  1. A
    Insert

    B
    Grant

    C
    Delete

    D
    Update

    E
    Revoke

    F
    Commit

    G
    Rollback

    Explanation: Not available 

    1. Twitter
    2. Google+
  2. A
    Set transaction

    B
    Explain plan

    C
    Update

    D
    Grant

    E
    Insert

    F
    Create

    G
    Alter

    H
    Revoke

    Explanation: Not available 

    1. Twitter
    2. Google+
  3. A
    Drop

    B
    Create

    C
    Alter

    D
    Revoke

    E
    Explain plan

    F
    Insert

    G
    Update

    H
    Delete

    Explanation: Not available 

    1. Twitter
    2. Google+
  4. A
    There can only be one primary key in a table

    B
    An index is automatically generated upon creation of a primary key

    C
    A primary key can accept null values

    D
    A primary key can be composite

    E
    A primary key constraint can be either at the column level or at the table level

    F
    There can be more than one primary key in a table

    Explanation: Not available 

    1. Twitter
    2. Google+
  5. A
    The primary key field must contain unique values

    B
    The primary key field can contain null values

    C
    A primary key is the column or set of columns that makes every row in the table unique

    D
    A primary key can be created with a maximum of three columns

    E
    Each table can have more than one primary keys

    F
    Unique key is another name for primary key

    Explanation: Not available 

    1. Twitter
    2. Google+
  6. A
    The definition of a view is stored in data dictionary

    B
    Views provide a more secure way of retrieving data

    C
    Views are actually Tables and store data in the same manner as Tables

    Explanation: Not available 

    1. Twitter
    2. Google+
  7. A
    SELECT * FROM employees where salary > (SELECT MIN(salary) FROM employees GROUP BY department_id);

    B
    SELECT * FROM employees WHERE salary = (SELECT AVG(salary) FROM employees GROUP BY department_id);

    C
    SELECT distinct department_id FROM employees Where salary > ANY (SELECT AVG(salary) FROM employees GROUP BY department_id);

    D
    SELECT department_id FROM employees WHERE SALARY > ALL (SELECT AVG(salary) FROM employees GROUP BY department_id);

    E
    SELECT department_id FROM employees WHERE salary > ALL (SELECT AVG(salary) FROM employees GROUP BY AVG(SALARY));

    Explanation: Not available 

    1. Twitter
    2. Google+
  8. A
    A table is a multiset of rows

    B
    A table is a two-dimensional array of rows and columns

    C
    A table is always dependent on other tables

    D
    A third normal form table is a table free of redundant data

    E
    A table must have a primary key

    Explanation: Not available 

    1. Twitter
    2. Google+
  9. A
    EmpNo

    B
    25Block

    C
    #AccountID

    D
    _CustomerName

    E
    Product.Name

    Explanation: Not available 

    1. Twitter
    2. Google+
First123Last
1 of 10 pages