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
21. Which operator is used to search for a specified pattern in a column?
- MATCH
- SIMILAR
- PATTERN
- LIKE
22. Which statement is used to remove a table from database?
- REMOVE
- DELETE
- DROP TABLE
- ERASE
23. Which clause is used to group rows that have same values?
- CATEGORIZE
- COMBINE
- GROUP BY
- COLLECT
24. Which function returns the current date and time?
- CURRENT()
- NOW()
- GETDATE()
- TODAY()
25. Which constraint uniquely identifies each record in a table?
- UNIQUE
- PRIMARY KEY
- IDENTITY
- MAIN
26. Which keyword is used to change the structure of a table?
- MODIFY
- CHANGE
- ALTER TABLE
- UPDATE
28. Which function converts a value to uppercase?
- TOUPPER()
- UPPER()
- CAPITAL()
- UCASE()
29. Which join returns all records from both tables?
- INNER JOIN
- LEFT JOIN
- RIGHT JOIN
- FULL JOIN
30. Which SQL statement is used to retrieve data from a database?
- GET
- SELECT
- EXTRACT
- OPEN