Deck 7: Introduction to Structured Query Language Sql

Question 1

You can select partial table contents by naming the desired fields and by placing restrictions on the rows to be included in the output.

Answer 1

True

Question 2

Some RDBMSs, such as Microsoft Access, automatically make the necessary conversions to eliminate case sensitivity.

Answer 2

True

Question 3

The COMMIT command does not permanently save all changes. In order to do that, you must use SAVE.

Answer 3

False

Question 4

All SQL commands must be issued on a single line.

Question 5

Date procedures are often more software-specific than other SQL procedures.

Question 6

Most SQL implementations yield case-insensitive searches.

Question 7

Numeric functions take one numeric parameter and return one value.

Question 8

SQL allows the use of logical restrictions on its inquiries such as OR, AND, and NOT.

Question 9

Comparison operators cannot be used to place restrictions on character-based attributes.

Question 10

An alias cannot be used when a table is required to be joined to itself in a recursive query.

Question 11

The COUNT function is designed to tally the number of non-null "values" of an attribute, and is often used in conjunction with the DISTINCT clause.

Question 12

You cannot insert a row containing a null attribute value using SQL.

Question 13

Oracle users can use the Access QBE (query by example) query generator.

Question 14

The conditional LIKE must be used in conjunction with wildcard characters.

Question 15

String comparisons are made from left to right.

Question 16

The ANSI SQL standards are also accepted by the ISO.

Question 17

A database language enables the user to perform complex queries designed to transform the raw data into useful information.

Question 18

ANSI-standard SQL allows the use of special operators in conjunction with the WHERE clause.

Question 19

Although SQL commands can be grouped together on a single line, complex command sequences are best shown on separate lines, with space between the SQL command and the command's components.

Question 20

SQL is considered difficult to learn; its command set has a vocabulary of more than 300 words.

Question 21

A(n) _____ join performs a relational product (also known as the Cartesian product) of two tables.

A) full
B) cross
C) natural
D) equi-

Question 22

The special operator used to check whether an attribute value is within a range of values is _____.

A) BETWEEN
B) NULL
C) LIKE
D) IN

Question 23

Which comparison operator indicates a value isnot equal?

A) <
B) <=
C) >=
D) <>

Question 24

What type of command does this SQL statement use?

A) set operator
B) natural join
C) "old-style" join
D) procedural statement

Question 25

The SQL data manipulation command HAVING:

A) restricts the selection of rows based on a conditional expression.
B) restricts the selection of grouped rows based on a condition.
C) modifies an attribute's values in one or more table's rows.
D) groups the selected rows based on one or more attributes.

Question 26

The _____ command defines a default value for a column when no value is given.

A) CHECK
B) UNIQUE
C) NOT NULL
D) DEFAULT

Question 27

A(n) _____ join returns not only the rows matching the join condition (that is, rows with matching values in the common columns) but also the rows with unmatched values.

A) outer
B) inner
C) equi-
D) cross

Question 28

Which query is used to list a unique value for V_CODE, where the list will produce only a list of those values that are different from one another?

A) SELECT ONLY V_CODE
FROM PRODUCT;
B) SELECT UNIQUE V_CODE
FROM PRODUCT;
C) SELECT DIFFERENT V_CODE
FROM PRODUCT;
D) SELECT DISTINCT V_CODE
FROM PRODUCT;

Question 29

A(n) _____ join will select only the rows with matching values in the common attribute(s).

A) natural
B) outer
C) full
D) cross

Question 30

How many rows would be returned from a cross join of tables A and B, if A contains 8 rows and B contains 18?

A) 8
B) 18
C) 26
D) 144

Question 31

When using a(n) _____ join, only rows from the tables that match on a common value are returned.

A) full
B) outer
C) inner
D) set

Question 32

A(n) _____ query specifies which data should be retrieved and how it should be filtered, aggregated, and displayed.

A) INSERT
B) SELECT
C) COMMIT
D) UPDATE

Question 33

The special operator used to check whether an attribute value matches a given string pattern is _____.

A) BETWEEN
B) IS NULL
C) LIKE
D) IN

Question 34

If a designer wishes to create an inner join, but the two tables do not have a commonly named attribute, he can use a(n) _____ clause.

A) OF
B) USING
C) HAS
D) JOIN ON

Question 35

The syntax for a left outer join is _____.

A) SELECT     column-list
FROM        table1 OUTER JOIN table2 LEFT
WHERE     join-condition
B) SELECT     column-list
FROM table1 LEFT [OUTER] JOIN table2
ON join-condition
C) SELECT     column-list
WHERE     LEFT table1 = table
D) SELECT    column-list
FROM       table1 LEFT table2 [JOIN]
WHERE     join-condition

Question 36

The SQL command that allows a user to permanently save data changes is _____.

A) INSERT
B) SELECT
C) COMMIT
D) UPDATE

Question 37

The SQL aggregate function that gives the number of rows containing non-null values for a given column is _____.

A) COUNT
B) MIN
C) MAX
D) SUM

Question 38

According to the rules of precedence, which of the following computations should be completed first?

A) Additions and subtractions
B) Multiplications and divisions
C) Operations within parentheses
D) Power operations

Question 39

The _____ command restricts the selection of grouped rows based on a condition.

A) DISPLAY
B) HAVING
C) FROM
D) CONVERT

Question 40

A(n) _____ is an alternate name given to a column or table in any SQL statement.

A) alias
B) data type
C) stored function
D) trigger

Question 41

A(n) _____ order sequence is a multilevel ordered sequence that can be created easily by listing several attributes, separated by commas, after the ORDER BY clause.

Question 42

The Oracle _____ function compares an attribute or expression with a series of values and returns an associated value or a default value if no match is found.

A) NVL
B) TO_CHAR
C) DECODE
D) CONVERT

Question 43

When using the Oracle TO_DATE function, the code _____ represents a three-letter month name.

A) MON
B) MM3
C) MONTH
D) MM

Question 44

A(n) _____ character is a symbol that can be used as a general substitute for other characters or commands.

Question 45

An alias is especially useful when a table must be joined to itself in a(n) _____ query.

Question 46

In Oracle, the _____ function converts a date to a character string.

A) CONVERT()
B) TO_DATE
C) TO_CHAR()
D) TO_STRING()

Question 47

_____ is a relational set operator.

A) EXCEPT
B) PLUS
C) ALL
D) EXISTS

Question 48

_____ is a string function that returns the number of characters in a string value.

A) LENGTH
B) SUBSTRING
C) CONCAT
D) UCASE

Question 49

A(n) _____ is a query that is embedded (or nested) inside another query.

A) alias
B) operator
C) subquery
D) view

Question 50

The _____ function returns the current system date in MS Access.

A) TO_DATE()
B) SYSDATE()
C) DATE()
D) TODAY()

Question 51

Which is a feature of a correlated subquery?

A) The inner subquery executes first.
B) The outer subquery initiates the process of execution in a subquery.
C) The inner subquery initiates the process of execution in a subquery.
D) The outer subquery executes independent of the inner subquery.

Question 52

In the SQL environment, the word _____ covers both questions and actions.

Question 53

The _____ specification is used to avoid having duplicated values in a column.

Question 54

A specialty field in mathematics, known as _____ algebra, is dedicated to the use of logical operators.

Question 55

In SQL, all _____ expressions evaluate to true or false.

Question 56

The _____ command, coupled with appropriate search conditions, is an incredibly powerful tool that enables a user to transform data into information.

Question 57

The _____ condition is generally composed of an equality comparison between the foreign key and the primary key of related tables.

Question 58

The special operator used to check whether a subquery returns any rows is _____.

A) BETWEEN
B) EXISTS
C) LIKE
D) IN

Question 59

In subquery terminology, the first query in the SQL statement is known as the _____ query.

A) outer
B) left
C) inner
D) base

Question 60

The basic SQL vocabulary has fewer than _____words.

Question 61

What is a subquery? What is always executed first?

Question 62

The _____statement in SQL combines rows from two queries and returns only the rows that appear in the first set but not in the second.

Question 63

_____ functions allow you to take a value of a given data type and convert it to the equivalent value in another data type.

Question 64

The _____ operator could be used in place of INTERSECT if the DBMS does not support it.

Question 65

"_____" means that the names of the relation attributes must be the same and their data types must be alike.

Question 66

The syntax of theEXCEPT statement in Oracle is _____.

Question 67

What are the wildcard characters that are used with the LIKE command? Provide one or more examples of each.

Question 68

A(n) _____, also known as a nested query or an inner query, is a query that is embedded (or nested) inside another query.

Question 69

Describe the important features and applications of SQL functions.

Question 70

The _____ clause of the GROUP BY statement operates very much like the WHERE clause in the SELECT statement.

Question 71

Rows can be grouped into smaller collections quickly and easily using the _____ clause within the SELECT statement.

Question 72

The _____ operator could be used in place of EXCEPT (MINUS) if the DBMS does not support it.

Question 73

DATE() and SYSDATE are special functions that return today's date in MS Access and _____, respectively.

Question 74

Explain the SQL function categories.

Question 75

What are the four different types of results that can be returned from a subquery?