SQL Server Interview Questions - 18 | Snaprecruit.com

SQL Server Interview Questions - 18 | Snaprecruit.com

SQL Server interview questions part 18

SQL Server interview questions part 18

Take as many assements as you can to improve your validate your skill rating

Total Questions: 20

1. Select * from employee where salary>10000 and dept_id=101; Which of the following fields are displayed as output?

Correct Answer is : All the field of employee relation

2. Insert into employee _________ (1002,Joey,2000); In the given query which of the keyword has to be inserted ?

Correct Answer is : Values

3. To delete a database ___________ command is used

Correct Answer is : drop database database_name

4. The ________________ is essentially used to search for patterns in target string.

Correct Answer is : Like Predicate

5. Which is a duplicate copy of a file program that is stored on a different storage media than the original location:

Correct Answer is : Backup

6. _______________ joins are SQL server default

Correct Answer is : Inner

7. To alter a database ___________ command is used

Correct Answer is : ALTER database database_name

8. The EXISTS keyword will be true if:

Correct Answer is : Any row in the subquery meets the condition only

9. Which of the following is a aggregate function ?

Correct Answer is : Sum

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

Correct Answer is : Create temporary table

11. 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;

Correct Answer is : Max_budget

12. 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.

Correct Answer is : Having, where

13. Which is duplication of computer operations and routine backups to combat any unforeseen problems:

Correct Answer is : Recovery

14. The UNION SQL clause can be used with

Correct Answer is : SELECT clause only

15. Which of the following statement is true ?

Correct Answer is : DELETE does not free the space containing the table and TRUNCATE free the space containing the table

16. SQL Server 2014 supports up to ________ partitions by default.

Correct Answer is : 15000

17. Point out the correct statement :

Correct Answer is : On x86-based systems, creating a table or index with more than 1000 partitions is possible

18. __________ is a database object that defines how the rows of a table or index are mapped to a set of partitions based on the values of certain column

Correct Answer is : Partition function

19. Designing an nonaligned partitioned index can be useful in the following case :

Correct Answer is : All of the mentioned

20. Point out the wrong statement :

Correct Answer is : Partitioning column is the process by which the query optimizer accesses only the relevant partitions to satisfy the filter criteria of the query

Similar Interview Questions

    Search for latest jobs

    Icon
    Icon