Sail E0 Webinar

MCQs

Total Questions : 34 | Page 1 of 4 pages
Question 1. Which of the following is not a date function?
  1.    Month
  2.    Year
  3.    Now
  4.    Pow
 Discuss Question
Answer: Option D. -> Pow
Question 2. The SQL keyword BETWEEN is used:
  1.    For ranges.
  2.    To limit the columns displayed.
  3.    As a wildcard.
  4.    None of the above
 Discuss Question
Answer: Option A. -> For ranges.
Question 3. Which of the following can add a row to a table?
  1.    Add
  2.    Insert
  3.    Update
  4.    Alter
 Discuss Question
Answer: Option B. -> Insert
Question 4. Which of the following is not a valid aggregate function?
  1.    COUNT
  2.    MIN
  3.    COMPUTE
  4.    MAX
 Discuss Question
Answer: Option C. -> COMPUTE
Question 5. Which statement is used to modify data in a table?
  1.    CHANGE
  2.    MODIFY
  3.    UPDATE
  4.    SAVE AS
 Discuss Question
Answer: Option C. -> UPDATE
Question 6. What SQL clause is used to restrict the rows returned by a query?
  1.    AND
  2.    WHERE
  3.    HAVING
  4.    FROM
 Discuss Question
Answer: Option B. -> WHERE
Question 7. Which of the following is not a DML command?
  1.    Update
  2.    Insert into
  3.    Delete
  4.    Create Table
 Discuss Question
Answer: Option D. -> Create Table
Question 8. Which SQL statement is used to return only different values?
  1.    SELECT DISTINCT
  2.    SELECT UNIQUE
  3.    SELECT DIFF
  4.    SELECT DIFFERENT
 Discuss Question
Answer: Option A. -> SELECT DISTINCT
Question 9. SQL can be used to:
  1.    Create database structures only.
  2.    Query database data only.
  3.    Modify database data only.
  4.    All of the above can be done by SQL.
 Discuss Question
Answer: Option D. -> All of the above can be done by SQL.
Question 10. With SQL, how do you select all the columns from a table named "Persons"?
  1.    SELECT * FROM Persons
  2.    SELECT Persons
  3.    SELECT [all] FROM Persons
  4.    SELECT *.Persons
 Discuss Question
Answer: Option A. -> SELECT * FROM Persons

Latest Videos

Latest Test Papers