Sql Server MCQ Quiz

  1. What SQL Command Can Be Used To Delete Columns From A Table?
  2. Which Is The Subset Of SQL Commands Used To Manipulate Oracle Database Structures, Including Tables?
  3. Which Operator Performs Pattern Matching?
  4. In SQL, Which Command(s) Is(are) Used To Change A Table's Storage Characteristics?
  5. In SQL, Which Command Is Used To SELECT Only One Copy Of Each Set Of Duplicable Rows
  6. Which Of The SQL Statements Is Correct?
  7. Which SQL Keyword Is Used To Retrieve Only Unique Values?
  8. Which Of The Following Is A SQL Aggregate Function?
  9. The SQL Statement<br>SELECT SUBSTR('123456789', INSTR('abcabcabc', 'b'), 4) FROM DUAL;
  10. Which Of The Following Must Be Enclosed In Double Quotes?
  11. Which Of The Following Command Makes The Updates Performed By The Transaction Permanent In The Database?
  12. Which Command Undo All The Updates Performed By The SQL In The Transaction?
  13. Which Of The Following Is Illegal?
  14. Which Of The Following Is NOT A Type Of SQL Constraint?
Sql Server MCQ

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.

  • MODIFY TABLE TableName DROP ColumnName
  • MODIFY TABLE TableName DROP COLUMN ColumnName
  • ALTER TABLE TableName DROP ColumnName
  • ALTER TABLE TableName DROP COLUMN ColumnName
View Answer
  • Data Manipulation Language(DML)
  • Data Definition Language(DDL)
  • Both Of Above
  • None
View Answer
  • LIKE Operator
  • BETWEEN Operator
  • EXISTS Operator
  • None Of These
View Answer
  • MODIFY TABLE
  • CHANGE TABLE
  • ALTER TABLE
  • All Of The Above
View Answer
  • SELECT UNIQUE
  • SELECT DISTINCT
  • SELECT DIFFERENT
  • All Of The Above
View Answer
  • SELECT Username, Password WHERE Username = 'user1'
  • SELECT Username AND Password FROM Users
  • SELECT Username, Password FROM Users
  • None Of These
View Answer
  • Dates
  • Column Alias
  • Strings
  • All Of The Above
View Answer
  • SELECT SYSDATE - (SYSDATE - 2) FROM DUAL;
  • SELECT SYSDATE - SYSDATE FROM DUAL;
  • SELECT SYSDATE - (SYSDATE + 2) FROM DUAL;
  • None Of These
View Answer
  • PRIMARY KEY
  • ALTERNATE KEY
  • UNIQUE
  • FOREIGN KEY
View Answer
  • 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
  • Brackets -- [...].
  • Parenthesis -- (...).
  • Braces -- {...}.
  • CAPITAL LETTERS.
View Answer