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
