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
41. Which function combines two or more strings into one?
- MERGE()
- COMBINE()
- JOIN()
- CONCAT()
42. Which transaction control language command saves transactions?
- SAVE
- COMMIT
- KEEP
- STORE
43. Which constraint uniquely identifies each record in a table?
- FOREIGN KEY
- PRIMARY KEY
- UNIQUE
- IDENTITY
44. Which clause groups rows that have the same values?
- GROUP BY
- PARTITION BY
- COLLECT
- CATEGORIZE
45. Which function returns the current date and time?
- CURRENT_DATE()
- NOW()
- GETDATE()
- TODAY()
46. Which statement is used to remove privileges from a user?
- REMOVE
- DENY
- REVOKE
- DELETE PERMISSION
47. Which type of index reorders the physical storage of data?
- Non-Clustered
- Clustered
- Unique
- Bitmap
48. Which operator returns TRUE if all subquery values meet the condition?
- ANY
- SOME
- ALL
- EVERY
49. Which statement is used to create a stored procedure?
- CREATE PROC
- CREATE PROCEDURE
- MAKE PROCEDURE
- DEFINE PROC