SQL SERVER

Questions

1. Which grant table scope columns are case insensitive?
2. Output generated by the boolean expression not unknown is
3. Aggregate functions are said to take a set or multiset of values as input and return
4. An aggregate function of SQL that demands the input to be a collection of numbers is known to be
5. Clause when is used in a query, demands elimination of duplicate tuples, is called
6. Built-in aggregate functions introduced by SQL can be classified into
7. Reasons for consideration of the stored procedure can be?
8. Point out the correct statement.
9. __________ takes no parameters and returns all kinds of interesting information.
10. Which of the following has support for transaction?
11. Point out the wrong statement.
12. __________create the removable database.
13. Which of the following stored procedure is used for error messages?
14. _____________ sets procedure options in SQL Server.
15. __________ is used to build the code dynamically and execute it.
16. Stored procedure used to remember the exact number of bytes is _____________
17. What SQL Command Can Be Used To Delete Columns From A Table?
18. Which is the subset of sql commands used to manipulate database structures, including tables?
19. Which Operator Performs Pattern Matching?
20. In SQL, which command is used to change a table's storage characteristics?
21. In SQL, which command is used to select only one copy of each set of duplicable rows
22. Which of the SQL statements is correct?
23. Which SQL keyword is used to retrieve only unique values?
24. Which of the following is a SQL aggregate function?
25. The SQL statement SELECT SUBSTR('123456789', INSTR('abcabcabc', 'b'), 4) FROM DUAL;
26. Which of the following must be enclosed in double-quotes?
27. Which of the following command makes the updates performed by the transaction permanent in the database?
28. Which command will undo all the updates performed by the SQL in the transaction?
29. Which of the following is illegal?
30. Which of the following is not a type of SQL constraint?
31. The SQL where clause:
32. A subquery in an SQL select statement is enclosed in:
33. What does the abbreviation DBMS stand for?
34. The advantages of Standard Query Language (SQL) include which of the following in relation to GIS databases?
35. Which of the following are characteristics of an RDBMS?
36. What is a Tuple?
37. Which of the following are issues to be considered by users of large corporate GIS databases?
38. Which of the following are features of the object-oriented approach to databases?
39. You can add a row using SQL in a database with which of the following?
40. The command to remove rows from a table 'CUSTOMER' is:
41. Which of the following is the original purpose of SQL?
42. The wildcard in a WHERE clause is useful when?
43. A view is which of the following?
44. The command to eliminate a table from a database is:
45. SQL data definition commands make up a(n) ________ .
46. Which of the following is valid SQL for an Index?
47. The SQL keyword(s) ________ is used with wildcards.
48. Which of the following is the correct order of keywords for SQL SELECT statements?
49. The HAVING clause does which of the following?
50. Which of the following do you need to consider when you make a table in SQL?
51. SQL query and modification commands make up a(n) ________ .
52. Which one of the following sorts rows in SQL?
53. To sort the results of a query use:
54. SQL can be used to:
55. The SQL statement that queries or reads data from a table is ________ .
56. What is the correct SQL syntax for returning all the columns from a table named “Persons” sorted REVERSE alphabetically by “FirstName”?
57. What will be the query to display the courses in which the number of students enrolled is more than 5?
58. Consider the query: SELECT name FROM Students WHERE name LIKE ‘_a%’; Which names will be displayed?
59. SELECT employee_id FROM employees WHERE commission_pct=.5 OR salary > 23000; Which of the following statements is correct with regard to this code?
60. Which of the following statement will results in 0 (false)?
61. What will happen if you query the emp table as shown below: select empno, DISTINCT ename, Salary from emp;
62. Examine the data in the employees table given below: last_name department_id salary ALLEN 10 3000 MILLER 20 1500 King 20 2200 Davis 30 5000 Which of the following Subqueries will execute well?