Intro to SQL

Question 1

SQL can be used to:

Answer 1

create database structures and modify & query database data

Question 2

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

Answer 2

SELECT NAME FROM CUSTOMER WHERE STATE IN (‘VA’);

Question 3

A subquery in an SQL SELECT statement is enclosed in:

Answer 3

parenthesis – (…)

Question 4

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

Answer 4

LIKE only

Question 5

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

Answer 5

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

Question 6

What does the HAVING clause do?

Answer 6

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

Question 7

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

Answer 7

All columns of the table are to be returned

Question 8

A subquery in an SQL SELECT statement:

Answer 8

has a distinct form that cannot be duplicated by a join

Question 9

Which of the following is valid SQL for an Index?

Answer 9

CREATE INDEX ID;

Question 10

SQL is:

Answer 10

a data sublanguage

Question 11

What is a view?

Answer 11

A virtual table that can be accessed via SQL commands

Question 12

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

Answer 12

SELECT

Question 13

The result of a SQL SELECT statment is a(n) _____.

Answer 13

table

Question 14

The SELECT command, with its various clauses, allows users to query the data contained in the tables and ask many different questions or ad hoc queries. T/F

Answer 14

True

Question 15

To establish a range of values, can be used. T/F

Answer 15

True

Question 16

Most companies keep at least two versions of any database they are using. T/F

Answer 16

True

Question 17

If you are going to use a combination of of three or more AND and OR conditions, it is often easier to use the NOT and NOT IN operators.

Answer 17

True

Question 18

SQL is a data sublanguage. T/F

Answer 18

True

Question 19

The HAVING clause acts like a WHERE clause, but it identifies groups that meet a criterion, rather than rows. T/F

Answer 19

True

Question 20

Indexes may be created or dropped at any t ime. T/F

Answer 20

True

Question 21

SQL provides five built-in functions: COUNT, SUM, AVG, MAX, MIN. T/F

Answer 21

True

Question 22

The keyword BETWEEN can be used in a WHERE clause to refer to a range of values. T/F

Answer 22

True

Question 23

The qualifier DISTINCT must be used in an SQL statement when we want to eliminate duplicate rows. T/F

Answer 23

True

Question 24

The format SELECT-FROM-WHERE is the fundamental framework of SQL SELECT statements. T/F

Answer 24

True

Question 25

The result of every SQL query is a table. T/F

Answer 25

True

Question 26

The SQL keyword GROUP BY instructs the DBMS to group together those rows that have the same value in a column. T/F

Answer 26

True

Question 27

A dynamic view is one whose contents materialize when referenced. T/F

Answer 27

True

Question 28

What is the correct order of keywords for SQL SELECT statements?

Answer 28

SELECT, FROM, WHERE

Question 29

SQL data definition commands make up a(n) _______.

Answer 29

DDL

Question 30

What is DDL?

Answer 30

Data Definition Language; deals with database schemas and descriptions of how the data should resides in the database

Question 31

What are examples of DDL commands?

Answer 31

CREATE, ALTER, DROP, TRUNCATE, COMMENT, and RENAME

Question 32

What is DML?

Answer 32

Data Manipulation Language; deals with data manipulation used to story, modify, retrieve, delete, and update data in database

Question 33

What are examples of DML commands?

Answer 33

SELECT, INSERT, UPDATE, DELETE, MERGE, LOCK TABLE

Question 35

What is the original purpose of SQL?

Answer 35

To specify the syntax and semantics of SQL manipulation language, to define the data structures, and to specify the syntax and semantics of SQL data definition language