Sql Server MCQ Quiz

Take SQL Server Quiz To test your Knowledge 

Below are few SQL Server MCQ test that checks your basic knowledge of SQL Server. This SQL Server Test contains around 20 questions of multiple choice with 4 options. You have to select the right answer to a question. You can see the correct answer by clicking view answer link.

Also, Read Best SQL Server interview questions.

1. Which Is The Subset Of SQL Commands Used To Manipulate Oracle Database Structures, Including Tables?

  • Data Manipulation Language(DML)
  • Data Definition Language(DDL)
  • Both Of Above
  • None
View Answer

2. Which Operator Performs Pattern Matching?

  • LIKE Operator
  • BETWEEN Operator
  • EXISTS Operator
  • None Of These
View Answer

3. In SQL, Which Command(s) Is(are) Used To Change A Table's Storage Characteristics?

  • MODIFY TABLE
  • CHANGE TABLE
  • ALTER TABLE
  • All Of The Above
View Answer

4. In SQL, Which Command Is Used To SELECT Only One Copy Of Each Set Of Duplicable Rows

  • SELECT UNIQUE
  • SELECT DISTINCT
  • SELECT DIFFERENT
  • All Of The Above
View Answer

5. Which Of The SQL Statements Is Correct?

  • SELECT Username, Password WHERE Username = 'user1'
  • SELECT Username AND Password FROM Users
  • SELECT Username, Password FROM Users
  • None Of These
View Answer

6. Which SQL Keyword Is Used To Retrieve Only Unique Values?

  • DISTINCT
  • DISTINCTIVE
  • UNIQUE
  • DIFFERENT
View Answer

7. Which Of The Following Is A SQL Aggregate Function?

  • AVG
  • LEFT
  • JOIN
  • LEN

8. The SQL Statement<br>SELECT SUBSTR('123456789', INSTR('abcabcabc', 'b'), 4) FROM DUAL;

  • 6789
  • 1234
  • 2345
  • 456789

9. Which Of The Following Must Be Enclosed In Double Quotes?

  • Dates
  • Column Alias
  • Strings
  • All Of The Above
View Answer

10. Which Of The Following Command Makes The Updates Performed By The Transaction Permanent In The Database?

  • ROLLBACK
  • TRUNCATE
  • DELETE
  • COMMIT

11. Which Command Undo All The Updates Performed By The SQL In The Transaction?

  • ROLLBACK
  • DELETE
  • COMMIT
  • CAPITAL LETTERS.
View Answer

12. Which Of The Following Is Illegal?

  • SELECT SYSDATE - (SYSDATE - 2) FROM DUAL;
  • SELECT SYSDATE - SYSDATE FROM DUAL;
  • SELECT SYSDATE - (SYSDATE + 2) FROM DUAL;
  • None Of These
View Answer

13. Which Of The Following Is NOT A Type Of SQL Constraint?

  • PRIMARY KEY
  • ALTERNATE KEY
  • UNIQUE
  • FOREIGN KEY
View Answer

14. What SQL Command Can Be Used To Delete Columns From A Table?

  • MODIFY TABLE TableName DROP ColumnName
  • MODIFY TABLE TableName DROP COLUMN ColumnName
  • ALTER TABLE TableName DROP ColumnName
  • ALTER TABLE TableName DROP COLUMN ColumnName
View Answer

15. The SQL WHERE Clause:

  • Limits The Row Data Are Returned
  • Limits The Column Data That Are Returned.
  • Both A And B Are Correct.
  • Neither A Nor B Are Correct.
View Answer

16. A Subquery In An SQL SELECT Statement Is Enclosed In:

  • Brackets -- [...].
  • Parenthesis -- (...).
  • Braces -- {...}.
  • CAPITAL LETTERS.
View Answer

Write For Us.

Contribute the Community.