SQL Server Multiple Choice Questions and Answers for freshers and experienced pdf free download

SQL Server 2008 multiple choice questions, SQL Server 2012 multiple choice questions, SQL Server objective questions, SQL Server mcq questions with answers, SQL Server objective questions and answers
1.  What does the abbreviation DBMS stand for?
2.  The advantages of Standard Query Language (SQL) include which of the following in relation to GIS databases?
3.  Which of the following are characteristics of an RDBMS?
4.  What is a 'tuple'?
5.  Which of the following are issues to be considered by users of large corporate GIS databases?
6.  Which of the following are features of the object-oriented approach to databases?
7.  Redundancy is minimised with a computer based database approach.
8.  The relational database model is based on concepts proposed in the 1960s and 1970s.
9.  A row in a database can also be called a domain.
10. A first step in database creation should be needs analysis.
11. In entity attribute modelling a many to many relationship is represented by M:M.
12. In a networked web based GIS all communications must go through an internet map server.
13. In an OO database approach 'object = attributes + behaviour'.
14. In an OO database objects may inherit some or all of the characteristics of other objects.
15. You can add a row using SQL in a database with which of the following?
16. The command to remove rows from a table 'CUSTOMER' is:
17. The SQL WHERE clause:
18. Which of the following is the original purpose of SQL?
19. The wildcard in a WHERE clause is useful when?
20. A view is which of the following?
21. The command to eliminate a table from a database is:
22. SQL data definition commands make up a(n) ________ .
23. Which of the following is valid SQL for an Index?
24. The SQL keyword(s) ________ is used with wildcards.
25. Which of the following is the correct order of keywords for SQL SELECT statements?
26. The result of a SQL SELECT statement is a(n) ________ .
27. The HAVING clause does which of the following?
28. To remove duplicate rows from the results of an SQL SELECT statement, the ________ qualifier specified must be included.
29. The benefits of a standard relational language include which of the following?
30. Which of the following do you need to consider when you make a table in SQL?
31. SQL query and modification commands make up a(n) ________ .
32. Which one of the following sorts rows in SQL?
33. To sort the results of a query use:
34. SQL can be used to:
35. The SQL statement that queries or reads data from a table is ________ .

0 comments: