SQL

  1. Question: Which are not DCL operations?

    A
    Insert

    B
    Grant

    C
    Delete

    D
    Update

    E
    Revoke

    F
    Commit

    G
    Rollback

    Note: Not available
    1. Report

  2. Question: Which of the following is not a DML command?

    A
    Set transaction

    B
    Explain plan

    C
    Update

    D
    Grant

    E
    Insert

    F
    Create

    G
    Alter

    H
    Revoke

    Note: Not available
    1. Report

  3. Question: Which of the following is not a DDL command?

    A
    Drop

    B
    Create

    C
    Alter

    D
    Revoke

    E
    Explain plan

    F
    Insert

    G
    Update

    H
    Delete

    Note: Not available
    1. Report

  4. Question: Which of the following statements are not true regarding the primary key?

    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

    Note: Not available
    1. Report

  5. Question: Which of the following statements are wrong about primary keys?

    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

    Note: Not available
    1. Report

  6. Question: Which statements are true for views?

    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

    Note: Not available
    1. Report

  7. Question: Examine the data in the EMPLOYEES table given below: LAST_NAME DEPARTMENT_ID SALARY ALLEN 10 3000 MILLER 20 1500 KING 20 2200 DAVIS 30 5000 Which of the following Subqueries work?

    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));

    Note: Not available
    1. Report

  8. Question: Examine the description of the STUDENTS table: STD_ID NUMBER (4) COURSE_ID VARCHAR2 (10) START_DATE DATE END_DATE DATE The aggregate functions valid on the START_DATE column are:

    A
    SUM(start_date)

    B
    AVG(start_date)

    C
    COUNT(start_date)

    D
    AVG(start_date, end_date)

    E
    MIN(start_date)

    Note: Not available
    1. Report

  9. Question: Select all the appropriate options.

    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

    Note: Not available
    1. Report

  10. Question: Which of the following field names are correct?

    A
    EmpNo

    B
    25Block

    C
    #AccountID

    D
    _CustomerName

    E
    Product.Name

    Note: Not available
    1. Report
First123Last
/10
Copyright © 2024. Powered by Intellect Software Ltd