SQL Server Mock Test 2

10%

Question 1 of 10

1. Syntax for viewing the methods and properties we can pipe our output to Get-Member by ______________

Get-Member

Get-Process | Get-Member

All of the mentioned

Get-Process

Question 1 of 10

Question 2 of 10

2. Point out the wrong statement.

Get-Command retrieve basic information about a command

Trace-Command trace an expression or command

Get-Content delete content from a file

None of the mentioned

Question 2 of 10

Question 3 of 10

3. Point out the correct statement.

In a UNIQUE constraint, no two rows in the table can have the same value for the columns

UNIQUE constraints enforce the uniqueness of the values in a set of columns

CHECK constraints enforce domain integrity

All of the mentioned

Question 3 of 10

Question 4 of 10

4. Which of the following is not a foreign key constraint?

All of the mentioned

SET NULL

NO ACTION

CASCADE

Question 4 of 10

Question 5 of 10

5. The UNION SQL clause can be used with ____________

UPDATE clause only

SELECT clause only

All of the mentioned

DELETE and UPDATE clauses

Question 5 of 10

Question 6 of 10

6. Which of the code deletes node H using hierarchical data type?

DROP FROM H WHERE Name = 'Steve'

DELETE FROM H WHERE Name = 'Steve'

All of the mentioned

DELETE H WHERE Name = 'Steve'

Question 6 of 10

Question 7 of 10

7. Which of the following is not a ranking function?

ROW_NUMBER

RANK

NTILE

All of the mentioned

Question 7 of 10

Question 8 of 10

8. Which of the following error message will be displayed if ORDER CLAUSE is not mentioned in ROW NUMBER function?

"The ranking function "ROW_NUMBER" must have an OVER BY clause."

All of the mentioned

"The ranking function "ROW_NUMBER" must have an PARTITION BY clause."

"The ranking function "ROW_NUMBER" must have an ORDER BY clause."

Question 8 of 10

Question 9 of 10

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

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

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

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

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

Question 9 of 10

Question 10 of 10

10. The command ________________ such tables are available only within the transaction executing the query, and are dropped when the transaction finishes.

Create temporary table

Create label view

Create view

Create table

Question 10 of 10