20 TOP SQL Server Multiple choice Questions and Answers pdf free download

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. Which of the following statements is/are true for SQL server?
16. What is the difference between the WHERE and HAVING SQL clauses?
17. When SQL server is installed, which of the following database are created by default?
18. Which of the following statements is/are false for Extended events in sql server 2008?
19. ______ provides option for entering SQL queries as execution time, rather than at the development stage.
20. What are the different events in Triggers?

0 comments:

Post a Comment

Blogger news