08:10
Unknown
A) Define, Create
B) Drop, Comment
C) Insert, Update, Delete
D) Select, Commit
B) Drop, Comment
C) Insert, Update, Delete
D) Select, Commit
Showing posts with label sql server mcqs. Show all posts
Showing posts with label sql server mcqs. Show all posts
Which of the following statements is/are false for Extended events in sql server 2008?
A. Enhanced event handling system in SQL Server
B. Both b and c below
C. Used for problem identification or problem trouble shooting
D. An architecture that is not very scalable, highly configurable
Answer: D
B. Both b and c below
C. Used for problem identification or problem trouble shooting
D. An architecture that is not very scalable, highly configurable
Answer: D
What is the difference between the WHERE and HAVING SQL clauses?
A. The WHERE and the HAVING clauses are identical
The HAVING SQL clause condition(s) is applied to all rows in the result set before the
B. WHERE clause is applied (if parent). The WHERE clause is used only with SELECT SQL statements and specifies a search condition for an aggregate or a group.
C. HAVING clause is applied (if parent). The HAVING clause is used only with SELECT SQL statements and specifies a search condition for an aggregate or a group
The HAVING SQL clause condition(s) is applied to all rows in the result set before the
B. WHERE clause is applied (if parent). The WHERE clause is used only with SELECT SQL statements and specifies a search condition for an aggregate or a group.
C. HAVING clause is applied (if parent). The HAVING clause is used only with SELECT SQL statements and specifies a search condition for an aggregate or a group
Answer: C
Which of the following statements is/are true for SQL server?
A. SQL Server has Logical Architecture and Physical Architecture
B. Both a and c
C. SQL Server is compatible with the structured query language and has rich for XML
D. SQL Server is a DBMS, a complete database.
B. Both a and c
C. SQL Server is compatible with the structured query language and has rich for XML
D. SQL Server is a DBMS, a complete database.
Answer: B
Which of the following are features of the object-oriented approach to databases?
A. The need to split objects into their component parts.
B. The ability to represent the world in a non-geometric way.
C. The ability to develop more realistic models of the real world.
D. The ability to develop databases using natural language approaches.
E. The ability to develop database models based on location rather than state and behaviour.
B. The ability to represent the world in a non-geometric way.
C. The ability to develop more realistic models of the real world.
D. The ability to develop databases using natural language approaches.
E. The ability to develop database models based on location rather than state and behaviour.
Ans: C
Which of the following are issues to be considered by users of large corporate GIS databases?
A. The need for multiple copies of the same data and subsequent merging after separate updates.
B. The need to manage long transactions.
C. The need for manual transfer of records to paper.
D. The need for multiple views or different windows into the same databases.
E. The need for concurrent access and multi-user update.
B. The need to manage long transactions.
C. The need for manual transfer of records to paper.
D. The need for multiple views or different windows into the same databases.
E. The need for concurrent access and multi-user update.
Ans: D
What is a 'tuple'?
A. A row or record in a database table.
B. Another name for the key linking different tables in a database.
C. An attribute attached to a record.
D. Another name for a table in an RDBMS.
B. Another name for the key linking different tables in a database.
C. An attribute attached to a record.
D. Another name for a table in an RDBMS.
Ans: A
Which of the following are characteristics of an RDBMS?
A. Keys may be unique or have multiple occurrences in the database.
B. It cannot use SQL.
C. Queries are possible on individual or groups of tables.
D. Tables are linked by common data known as keys.
E. Data are organized in a series of two-dimensional tables each of which contains records for one entity.
B. It cannot use SQL.
C. Queries are possible on individual or groups of tables.
D. Tables are linked by common data known as keys.
E. Data are organized in a series of two-dimensional tables each of which contains records for one entity.
Ans: D
The advantages of Standard Query Language (SQL) include which of the following in relation to GIS databases?
A. It is good at handling geographical concepts.
B. It is widely used.
C. It is simple and easy to understand.
D. It uses a pseudo-English style of questioning.
B. It is widely used.
C. It is simple and easy to understand.
D. It uses a pseudo-English style of questioning.
Ans: A
What does the abbreviation DBMS stand for?
A. Digital Base Mapping System.
B. Data Borrowing and Movement Software.
C. Database Management System.
D. Database Manipulation Software.
B. Data Borrowing and Movement Software.
C. Database Management System.
D. Database Manipulation Software.
Ans: C