Practice Introduction To SQL Multiple Choice Questions Quiz-2 - MCQGeeks.com

Q.1

To define what columns should be displayed in an SQL SELECT statement:

use FROM to name the source table(s) and list the columns to be shown after SELECT.
use USING to name the source table(s) and list the columns to be shown after SELECT.
use SELECT to name the source table(s) and list the columns to be shown after USING.
use USING to name the source table(s) and list the columns to be shown after WHERE.

Q.2

SQL can be used to:

create database structures only.
query database data only.
modify database data only.
All of the above can be done by SQL.

Q.3

The SQL statement that queries or reads data from a table is ________ .

SELECT
READ
QUERY
None of the above is correct

Q.4

In an SQL SELECT statement querying a single table, according to the SQL-92 standard the asterisk (*) means that:

all columns of the table are to be returned.
all records meeting the full criteria are to be returned.
all records with even partial criteria met are to be returned.
None of the above is correct.

Q.5

The HAVING clause does which of the following?

Acts like a WHERE clause but is used for groups rather than rows.
Acts like a WHERE clause but is used for rows rather than columns.
Acts like a WHERE clause but is used for columns rather than groups.
Acts EXACTLY like a WHERE clause.

Q.6

The SQL -92 wildcards are and .

asterisk (*); percent sign (%)
percent sign (%); underscore (_)
underscore(_); question mark (?)
question mark (?); asterisk (*)

Q.7

To remove duplicate rows from the results of an SQL SELECT statement, the ________ qualifier specified must be included.

ONLY
UNIQUE
DISTINCT
SINGLE

Q.8

The benefits of a standard relational language include which of the following?

Reduced training costs
Increased dependence on a single vendor
Applications are not needed
All of the above

Q.9

Which of the following do you need to consider when you make a table in SQL?

Data types
Primary keys
Default values
All of the above

Q.10

SQL query and modification commands make up a(n) ________ .

DDL
DML
HTML
XML

Q.11

The SQL keyword(s) ________ is used with wildcards.

LIKE only
IN only
NOT IN only
IN and NOT IN

Q.12

Which of the following is the correct order of keywords for SQL SELECT statements?

SELECT, FROM, WHERE
FROM, WHERE, SELECT
WHERE, FROM,SELECT
SELECT,WHERE,FROM

Q.13

When three or more AND and OR conditions are combined, it is easier to use the SQL keyword(s):

LIKE only.
IN only.
NOT IN only.
Both IN and NOT IN.

Q.14

The Microsoft Access wildcards are and .

asterisk (*); percent sign (%)
percent sign (%); underscore (_)
underscore(_); question mark (?)
question mark (?); asterisk (*)

Q.15

A subquery in an SQL SELECT statement is enclosed in:

braces -- {...}.
CAPITAL LETTERS.
parenthesis -- (...) .
brackets -- [...].

Q.16

The result of a SQL SELECT statement is a(n) ________ .

report
form
file
table

Q.17

Find the SQL statement below that is equal to the following: SELECT NAME FROM CUSTOMER WHERE STATE = 'VA';

SELECT NAME IN CUSTOMER WHERE STATE IN ('VA');
SELECT NAME IN CUSTOMER WHERE STATE = 'VA';
SELECT NAME IN CUSTOMER WHERE STATE = 'V';
SELECT NAME FROM CUSTOMER WHERE STATE IN ('VA');

Q.18

A view is which of the following?

A virtual table that can be accessed via SQL commands
A virtual table that cannot be accessed via SQL commands
A base table that can be accessed via SQL commands
A base table that cannot be accessed via SQL commands

Q.19

The command to eliminate a table from a database is:

REMOVE TABLE CUSTOMER;
DROP TABLE CUSTOMER;
DELETE TABLE CUSTOMER;
UPDATE TABLE CUSTOMER;

Q.20

ON UPDATE CASCADE ensures which of the following?

Normalization
Data Integrity
Materialized Views
All of the above

0 h : 0 m : 1 s