SQL Server Questions and Answers – Modifying Data – 2

This set of SQL Server Multiple Choice Questions & Answers (MCQs) focuses on “Modifying Data – 2”.

1. The EXISTS keyword will be true if ____________
a) Any row in the subquery meets the condition only
b) All rows in the subquery fail the condition only
c) Both of these two conditions are met
d) Neither of these two conditions is met
View Answer

2. Which of the following is an aggregate function?
a) Average
b) Sum
c) With
d) Minimum
View Answer

3. The command ________________ such tables are available only within the transaction executing the query, and are dropped when the transaction finishes.
a) Create table
b) Create temporary table
c) Create view
d) Create label view
View Answer

4. In the query given above which one of the following is a temporary relation?

WITH max_budget (VALUE) AS
(SELECT MAX(budget)
FROM department)
SELECT budget
FROM department, max_budget
WHERE department.budget = MAX budget.value;

a) Budget
b) Department
c) Value
d) Max_budget
View Answer

5. Aggregate functions can be used in the select list or the_______clause of a select statement or subquery. They cannot be used in a ______ clause.
a) Where, having
b) Having, where
c) Group by, having
d) Group by, where
View Answer

6. Which is the duplication of computer operations and routine backups to combat any unforeseen problems?
a) Concurrency
b) Deadlock
c) Backup
d) Recovery
View Answer

7. The UNION SQL clause can be used with ____________
a) SELECT clause only
b) DELETE and UPDATE clauses
c) UPDATE clause only
d) All of the mentioned
View Answer

8. Find all the tuples having temperature greater than ‘Paris’.
a)

SELECT * FROM weather
WHERE temperature > (SELECT temperature FROM weather WHERE city = ‘Paris’

b)

SELECT * FROM weather 
WHERE temperature > (SELECT * FROM weather WHERE city = ‘Paris’)

c)

SELECT * FROM weather 
WHERE temperature > (SELECT city FROM weather WHERE city = ‘Paris’)

d)

SELECT * FROM weather 
WHERE temperature > ‘Paris’ temperature

9. Which of the following statement is true?
a) DELETE does not free the space containing the table and TRUNCATE free the space containing the table
b) Both DELETE and TRUNCATE free the space containing the table
c) Both DELETE and TRUNCATE does not free the space containing the table
d) DELETE free the space containing the table and TRUNCATE does not free the space containing the table
View Answer

10. How can you change “Hansen” into “Nilsen” in the “LastName” column in the Persons table?
a)

UPDATE Persons 
SET LastName=’Hansen’ INTO LastName=’Nilsen’

b)

MODIFY Persons 
SET LastName=’Nilsen’ WHERE LastName=’Hansen’

c)

MODIFY Persons 
SET LastName=’Hansen’ INTO LastName=’Nilsen’

d)

UPDATE Persons 
SET LastName=’Nilsen’ WHERE LastName=’Hansen’

Sanfoundry Global Education & Learning Series – SQL Server.

To practice all areas of SQL Server, here is complete set of 1000+ Multiple Choice Questions and Answers.