SQL Server Quiz | SQL Server Objective Type Questions and Answers

Questions
21 To remove duplicate rows from the results of an SQL SELECT statement, the ________ qualifier specified must be included.
A DISTINCT
B SINGLE
C ONLY
D UNIQUE

Answer: DISTINCT
22 The HAVING clause does which of the following?
A It is good at handling geographical concepts.
B Acts EXACTLY like a WHERE clause.
C Acts like a WHERE clause but is used for rows rather than columns.
D Acts like a WHERE clause but is used for columns rather than groups.

Answer: Acts like a WHERE clause but is used for groups rather than rows.
23 The result of a SQL SELECT statement is a(n) ________ .
A table
B file
C report
D form

Answer: table
24 Which of the following is the correct order of keywords for SQL SELECT statements?
A SELECT, FROM, WHERE
B SELECT,WHERE,FROM
C FROM, WHERE, SELECT
D WHERE, FROM,SELECT

Answer: SELECT, FROM, WHERE
25 The SQL keyword(s) ________ is used with wildcards.
A LIKE only
B IN only
C NOT IN only
D IN and NOT IN

Answer: LIKE only
26 Which of the following is valid SQL for an Index?
A CHANGE INDEX ID;
B REMOVE INDEX ID;
C CREATE INDEX ID;
D ADD INDEX ID;

Answer: CREATE INDEX ID;
27 SQL data definition commands make up a(n) ________ .
A XML
B DDL
C DML
D HTML

Answer: DDL
28 The command to eliminate a table from a database is:
A DROP TABLE CUSTOMER;
B UPDATE TABLE CUSTOMER;
C REMOVE TABLE CUSTOMER;
D DELETE TABLE CUSTOMER;

Answer: DROP TABLE CUSTOMER;
29 A view is which of the following?
A A virtual table that can be accessed via SQL commands
B A base table that cannot be accessed via SQL commands
C A virtual table that cannot be accessed via SQL commands
D A base table that can be accessed via SQL commands

Answer: A virtual table that can be accessed via SQL commands
30 The wildcard in a WHERE clause is useful when?
A An exact match is not possible in a SELECT statement.
B An exact match is not possible in a CREATE statement.
C An exact match is necessary in a CREATE statement.
D An exact match is necessary in a SELECT statement.

Answer: An exact match is not possible in a SELECT statement.
31 Which of the following is the original purpose of SQL?
A To define the data structures
B To specify the syntax and semantics of SQL manipulation language
C To specify the syntax and semantics of SQL data definition language
D All of the above

Answer: All of the above
32 The SQL WHERE clause:
A limits the column data that are returned.
B limits the row data are returned.
C Both A and B are correct.
D Neither A nor B are correct.

Answer: limits the row data are returned.
33 The command to remove rows from a table 'CUSTOMER' is:
A DELETE FROM CUSTOMER WHERE ...
B UPDATE FROM CUSTOMER ...
C DROP FROM CUSTOMER ...
D REMOVE FROM CUSTOMER ...

Answer: DELETE FROM CUSTOMER WHERE ...
34 You can add a row using SQL in a database with which of the following?
A INSERT
B MAKE
C ADD
D CREATE

Answer: INSERT
35 Which of the following are features of the object-oriented approach to databases?
A The ability to develop more realistic models of the real world.
B The ability to develop databases using natural language approaches.
C The ability to develop database models based on location rather than state and behaviour.
D The ability to represent the world in a non-geometric way.

Answer: The ability to develop more realistic models of the real world.
36 Which of the following are issues to be considered by users of large corporate GIS databases?
A The need for multiple views or different windows into the same databases.
B The need for concurrent access and multi-user update.
C The need for manual transfer of records to paper.
D The need for multiple copies of the same data and subsequent merging after separate updates.

Answer: The need for multiple views or different windows into the same databases.
37 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.

Answer: A row or record in a database table.
junior administrative assistant jaa test series