Recent Articles

Sql Server MCQ Quiz

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

  • Data Manipulation Language(DML)
  • Data Definition Language(DDL)
  • Both Of Above
  • None
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
  • MODIFY TABLE TableName DROP ColumnName
  • MODIFY TABLE TableName DROP COLUMN ColumnName
  • ALTER TABLE TableName DROP ColumnName
  • ALTER TABLE TableName DROP COLUMN ColumnName
View Answer
  • Brackets -- [...].
  • Parenthesis -- (...).
  • Braces -- {...}.
  • CAPITAL LETTERS.
View Answer
  • LIKE Operator
  • BETWEEN Operator
  • EXISTS Operator
  • None Of These
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
  • Views
  • Table
  • Function
  • Table and Views
View Answer
Related Interview Questions
Subscribe Our NewsLetter

Never Miss an Articles from us.

Featured Categories