SQL MCQ - English

Set 2 MCQ Questions and Answers

Home | SQL | Set 2

SQL Objective Questions and Answers Pdf Free Download : Here learn sql quiz questions and answers related to Structured Query Language and test online of objective questions and free download pdf.

SQL  Pdf Download Click Here 

Page: 1/7

1) Which of the following SQL query is correct for selecting the name of staffs from 'staffinfo' table where salary is 10,000 or 25,000?

    SELECT name FROM staffinfo WHERE salary BETWEEN 10000 AND 25000;
    SELECT name FROM staffinfo WHERE salary IN (10000, 25000);
    Both A and B
    None of the above

Answer : B Discuss

2) Select the right statement to insert values to the student table.

    INSERT student VALUES (
    INSERT VALUES (
    INSERT INTO student VALUES (
    INSERT VALUES INTO student (

Answer : C Discuss

3) ............. joins two or more tables based on a specified column value not equaling a specified column value in another table.

    EQUIJOIN
    NON-EQUIJOIN
    OUTER JOIN
    NATURAL JOIN

Answer : B Discuss

4) In SQL, which command is used to change a table's storage characteristics?

    ALTER TABLE
    MODIFY TABLE
    CHANGE TABLE
    None of these

Answer : A Discuss

5) 'AS' clause is used in SQL for

    Selection operation.
    Rename operation.
    Join operation.
    Projection operation.

Answer : B Discuss

6) Count function in SQL returns the number of

    values.
    distinct values.
    groups.
    columns.

Answer : A Discuss

7) Which of the following is a valid SQL type?

    CHARACTER
    NUMERIC
    FLOAT
    All of the above

Answer : D Discuss

8) NULL is

    the same as 0 for integer
    the same as blank for character
    the same as 0 for integer and blank for character
    not a value

Answer : D Discuss

9) When was the first version of Microsoft SQL Server released ?

    1983
    1988
    1990
    1991

Answer : B Discuss

10) Which of the following companies originally worked together to create and market the first version of SQL Server?

    Microsoft
    Sybase
    Ashton-Tate
    All of the Mentioned

Answer : D Discuss

Jump to Pages:

1 2 3 4 5 6 7

MCQ Category