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
31. Which clause is used to filter records in a SQL query?
- FILTER
- WHERE
- CONDITION
- HAVING
32. Which SQL keyword is used to sort the result-set?
- SORT
- ORDER BY
- ARRANGE
- SORT BY
33. Which function returns the number of rows in a table?
- TOTAL()
- SUM()
- COUNT()
- NUMBER()
34. Which JOIN returns all records when there is a match in either left or right table?
- INNER JOIN
- LEFT JOIN
- RIGHT JOIN
- FULL OUTER JOIN
35. Which SQL constraint ensures that a column cannot have NULL values?
- NOT NULL
- CHECK
- UNIQUE
- DEFAULT
36. Which statement is used to modify existing records in a table?
- MODIFY
- CHANGE
- UPDATE
- ALTER
37. Which SQL command is used to delete a table?
- DELETE
- REMOVE
- DROP TABLE
- TRUNCATE
38. Which data type can store large binary objects?
- INT
- VARCHAR
- VARBINARY(MAX)
- DECIMAL
39. Which statement is used to create a new table?
- NEW TABLE
- CREATE TABLE
- ADD TABLE
- BUILD TABLE
40. Which operator is used to search for a specified pattern in a column?
- MATCH
- LIKE
- SIMILAR
- PATTERN