DBMS-Microsoft SQL Server Questions and Answers
The SQL Server questions with answers topic focuses on essential database management concepts, including queries, joins, stored procedures, and triggers. It provides programming questions and answers that help aspirants prepare for technical interviews and placement exams at leading IT firms like TCS, Infosys, and Accenture. Practicing SQL programming interview questions with answers enhances your ability to manage and optimize relational databases, ensuring success in both coding assessments and real-world development scenarios.
DBMS-Microsoft SQL Server
Showing 10 of
49 questions
11. Which clause is used to filter records in a SQL query?
- FILTER
- WHERE
- HAVING
- CHECK
12. Which SQL keyword is used to sort the result-set?
- SORT
- ORDER BY
- ARRANGE
- GROUP BY
13. Which of the following is used to combine rows from two or more tables?
- MERGE
- UNION
- JOIN
- COMBINE
14. Which SQL constraint ensures that a column cannot have NULL values?
- REQUIRED
- MANDATORY
- NOT NULL
- MUST HAVE
15. Which function returns the number of rows in a table?
- TOTAL()
- SUM()
- COUNT()
- NUMBER()
16. Which statement is used to update existing records in a table?
- MODIFY
- CHANGE
- UPDATE
- ALTER
17. Which statement is used to delete records from a table?
- REMOVE
- DELETE
- ERASE
- CLEAR
18. Which keyword is used to create a new table in SQL?
- ADD TABLE
- CREATE TABLE
- NEW TABLE
- MAKE TABLE
19. Which data type would you use for storing monetary values?
- INT
- FLOAT
- VARCHAR
- MONEY
20. Which keyword is used to add new records to a table?
- ADD RECORD
- INSERT INTO
- NEW ROW
- CREATE ROW