Ics 321 Quiz 3

Front 1

Only two tables can be queried by using a subquery.

Back 1

False

Front 2

To determine the number and type of columns in a table, use the SQL construct COUNT(*).

Back 2

False

Front 3

When examining data values as a part of assessing table structure, there is no need to try to determine candidate keys other than the table"s primary key.

Back 3

False

Front 4

Multivalued dependencies create anomalies so serious that multivalued dependencies must always be eliminated.

Back 4

True

Front 5

Read-only database are often updated

Back 5

False

Front 6

SQL provides the operator BOUNDED BY that can simplify a specific range to test in a query.

Back 6

False

Front 7

The LIKE and NOT LIKE operators can be used to search for data rows containing incomplete or partial character strings withing a data column

Back 7

True

Front 8

The SUM function can compute the total of a specified table row.

Back 8

False

Front 9

If your SELECT clause includes both column names and aggregate functions, then you must also have a GROUP BY clause in your query.

Back 9

True

Front 10

The HAVING clause can include columns or expressions that are not listed in the SELECT clause or in a GROUP BY clause.

Back 10

True

Front 11

The alias must follow a column name.

Back 11

False

Front 12

Whenever you join two or more tables and access data from one table, you should always use a JOIN clause in your select statement.

Back 12

False

Front 13

A correlated subquery is one where the outer query depends on values provided by the inner query.

Back 13

True

Front 14

Within the Database Query Engine, the Parse command will ensure the SQL statement will execute properly against the target table(s).

Back 14

True

Front 15

In a SQL query, which SQL keyword actually creates the query?
a.) EXISTS
b.) FROM
c.) SELECT
d.) SET
e.) WHERE

Back 15

c.) SELECT

Front 16

In a SQL query, which SQL keyword is used to specify the names of tables to be joined?
a.) FROM
b.) HAVING
c.) JOIN
d.) SELECT
e.) WHERE

Back 16

a.) FROM

Front 17

Which of the following descriptions is true about JOIN operation?
a.) When two tables are joined, SQL creates an inner product of the tables
b.) An ambiguous column name is qualified by using the colon (:) connector to connect the table name and the column name.
c.) Joins can be specified in either the FROM or WHERE clauses.
d.) We can assign an alias precede a table name.
e.) None of the above.

Back 17

c.) Joins can be specified in either FROM or WHERE clauses.

Front 18

During the second step of the assessing table structure, you are trying to determine__________.
a.) multivalued dependencies
b.) functional dependencies
c.) foreign keys
d.) a and b
e.) a, b and c

Back 18

e.) a, b and c

Front 19

For a number of reasons, ________ is not often an advantage for a read-only database.
a.) updating
b.) normalization
c.) denormalization
d.) a and b
e.) b and c

Back 19

b.) normalization

Front 20

A table designed to store PhoneNumber01, PhoneNumber02 and PhoneNumber03 contains _______.
a.) the multivalued, multicolumn problem
b.) the inconsistent values problem
c.) the missing values problem
d.) the general-purpose remarks column problem
e.) None of the above is correct.

Back 20

a.) the multivalued, multicolumn problem

Front 21

A null value can indicate which of the following conditions?
a.) The value is inappropriate.
b.) The value is appropriate but unknown.
c.) The value is appropriate and known, but not entered into the database.
d.) All of a, b or c are correct
e.) None of the above is correct.

Back 21

d.) All of a, b or c are correct.

Front 22

Aggregate functions can be used in the _____ and ______ clauses.
a.) SELECT
b.) HAVING
c.) WHERE
d.) a and b
e.) a, b and c

Back 22

d.) a and b

Front 23

A HAVING clause is used to filter rows _____________.
a.) after the grouping action
b.) based on order of WHERE and HAVING
c.) based on filtering action before and after
d.) before the grouping action
e.) a and d

Back 23

a.) after the grouping action

Front 24

Divide a result table into groups:
a.) Use a WHERE clause.
b.) Use a GROUP BY clause.
c.) Use an ORDER by after the HAVING clause
d.) Include one ore more aggregates in the SELECT clause listing.
e.) Use a HAVING clause.

Back 24

b.) Use a GROUP BY clause

Front 25

A LEFT OUTER JOIN
a.) Executes an inner join
b.) adds back all the rows that are dropped from the first table in the join condition
c.) adds back all the rows that are dropped from the second table in the join condition
d.) output columns from the second table are set to NULL
e.) a, b, and d

Back 25

d.) output columns from the second table are set to NULL

Front 26

Which of the following is a type of subquery?
a.) One that operate on lists by use of an unmodified comparison operator
b.) One that operate on lists by use of the IN operator or with a comparison operator modified by the ANY or ALL optional keywords.
c.) One that operate on scalar value by use of the IN operator
d.) One that uses the EXISTS operator to test the existence of data within a list.
e.) One that uses a modified comparison operator (=, <, >, <>) and returns an array of values

Back 26

b.) One that operate on lists by use of the IN operator or with a comparison operator modified by the ANY or ALL optional keywords.

Front 27

The advantages of stored procedures is/are:
a.) Shared application logic among various client applications
b.) Faster execution
c.) Reduced traffic network
d.) Improved database security
e.) All of the above

Back 27

e.) All of the above

Front 28

SQL Server user variables and parameters start with the symbol __.
a.) /*
b.) #
c.) ##
d.) @
e.) @@

Back 28

d.) @

Front 29

Which of the following is not true about stored procedures?
a.) Is a named collection of SQL statements stored in the database
b.) Can be called by name
c.) Can pass parameters
d.) Can return Values
e.) Consistent with other data access types

Back 29

e.) Consistent with other data access types

Front 30

The SQL ______ clause contains the condition that specifies which rows are to be selected.

Back 30

WHERE

Front 31

The SQL keyword _______ is used in SQL expressions to select on partial values.

Back 31

LIKE

Front 32

A join operation is achieved by specifying the equality of the respective column names as a condition in the _____ clause.

Back 32

WHERE

Front 33

________ reduces the complexity of the SQL statements needed in an application to read required data.

Back 33

Denormalization

Front 34

The SQL keyword __________ can be used to count the number of nulls in a column.

Back 34

IS NULL

Front 35

Relations are sometimes left unormalized to improve __________.

Back 35

performance

Front 36

Read-only databases are _____ updated.

Back 36

never

Front 37

When column name is specified in the COUNT function, rows containing a NULL value in the specified column are __________.

Back 37

omitted

Front 38

A _______ JOIN adds back all the rows that are dropped from the second (right) table in the join condition, and ouput columns from the first (left) table are set to NULL.

Back 38

RIGHT OUTER

Front 39

A __________ operation is used to produce a result table when the relationship of interest exists among rows that are stored within a single table.

Back 39

SELF JOIN

Front 40

When the WHERE clause of a subquery has as its object another subquery, these are termed ___________.

Back 40

nested subqueries

Front 41

A _________ is one where the inner query depends on values provided by the outer query.

Back 41

correlated subquery