DBMS-Microsoft SQL Server Questions and Answers

Practice Mode
Showing 10 of 49 questions
Q41
Which function combines two or more strings into one?
  • A MERGE()
  • B COMBINE()
  • C JOIN()
  • D CONCAT()
Answer: Option D
Explanation: CONCAT() function joins two or more string values together.
Q42
Which transaction control language command saves transactions?
  • A SAVE
  • B COMMIT
  • C KEEP
  • D STORE
Answer: Option B
Explanation: COMMIT permanently saves all transactions to the database.
Q43
Which constraint uniquely identifies each record in a table?
  • A FOREIGN KEY
  • B PRIMARY KEY
  • C UNIQUE
  • D IDENTITY
Answer: Option B
Explanation: PRIMARY KEY constraint uniquely identifies each record in a table.
Q44
Which clause groups rows that have the same values?
  • A GROUP BY
  • B PARTITION BY
  • C COLLECT
  • D CATEGORIZE
Answer: Option A
Explanation: GROUP BY clause groups rows that have same values into summary rows.
Q45
Which function returns the current date and time?
  • A CURRENT_DATE()
  • B NOW()
  • C GETDATE()
  • D TODAY()
Answer: Option C
Explanation: GETDATE() returns current database system timestamp in SQL Server.
Q46
Which statement is used to remove privileges from a user?
  • A REMOVE
  • B DENY
  • C REVOKE
  • D DELETE PERMISSION
Answer: Option C
Explanation: REVOKE statement removes previously granted privileges from users.
Q47
Which type of index reorders the physical storage of data?
  • A Non-Clustered
  • B Clustered
  • C Unique
  • D Bitmap
Answer: Option B
Explanation: Clustered index determines the physical order of data in a table.
Q48
Which operator returns TRUE if all subquery values meet the condition?
  • A ANY
  • B SOME
  • C ALL
  • D EVERY
Answer: Option C
Explanation: ALL operator returns TRUE if all values in subquery meet the condition.
Q49
Which statement is used to create a stored procedure?
  • A CREATE PROC
  • B CREATE PROCEDURE
  • C MAKE PROCEDURE
  • D DEFINE PROC
Answer: Option B
Explanation: CREATE PROCEDURE statement creates a stored procedure in database.

📚 More from Database

← All Topics 🎯 Practice ⏱️ Take Test 🔍 Search
Database
Back to Database
Other Subjects
Questions and Answers for Competitive Exams Various Entrance Test