Deck 7: Introduction to Structured Query Language SQL

Question 1

Entity integrity is enforced automatically when the primary key is specified in the CREATE TABLE command sequence.

Answer 1

True

Question 2

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

Answer 2

False

Question 3

Only numeric data types can be added and subtracted in SQL.

Answer 3

False

Question 4

The ANSI SQL standards are also accepted by the ISO.

Question 5

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

Question 6

The CHECK constraint is used to define a condition for the values that the attribute domain cannot have.

Question 7

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 8

Any changes made to the contents of a table are not physically saved on disk until you use the SAVE command.

Question 9

Data type selection is usually dictated by the nature of the data and by the intended use.

Question 10

To list the contents of a table,you must use the DISPLAY command.

Question 11

All SQL commands must be issued on a single line.

Question 12

SQL requires the use of the ADD command to enter data into a table.

Question 13

The ANSI prescribes a standard SQL-the current fully approved version is known as SQL­07.

Question 14

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

Question 15

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

Question 16

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

Question 17

String comparisons are made from left to right.

Question 18

If you have not yet used the COMMIT command to store the changes permanently in the database,you can restore the database to its previous condition with the ROLLBACK command.

Question 19

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

Question 20

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

Question 21

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

Question 22

When a user issues the DELETE FROM tablename command without specifying a WHERE condition,.

A)no rows will be deleted
B)the first row will be deleted
C)the last row will be deleted
D)all rows will be deleted

Question 23

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

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

Question 24

Some RDBMSs,such as Oracle,automatically data changes when issuing data definition commands.

A)COMMIT
B)ROLLBACK
C)UNSAVE
D)UPDATE

Question 25

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

Question 26

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

Question 27

UPDATE tablename *****
[WHERE conditionlist];
The command replaces the ***** in the syntax of the UPDATE command,shown above.

A)SET columnname = expression
B)columnname = expression
C)expression = columnname
D)LET columnname = expression

Question 28

An example of a command a user would use when making changes to a PRODUCT table is .

A)CHANGE PRODUCT SET P_INDATE = '18-JAN-2004' WHERE P_CODE = '13-Q2/P2';
B)ROLLBACK PRODUCT SET P_INDATE = '18-JAN-2004' WHERE P_CODE = '13-Q2/P2';
C)EDIT PRODUCT SET P_INDATE = '18-JAN-2004' WHERE P_CODE = '13-Q2/P2';
D)UPDATE PRODUCT SET P_INDATE = '18-JAN-2004' WHERE P_CODE = '13-Q2/P2';

Question 29

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 30

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

Question 31

When joining three or more tables,you need to specify a join condition for one pair of tables.

Question 32

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

Question 33

In Oracle,the command is used to change the display for a column,for example,to place a $ in front of a numeric value.

A)DISPLAY
B)FORMAT
C)CHAR
D)CONVERT

Question 34

The SQL command that allows a user to list the contents of a table is .

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

Question 35

Most SQL implementations yield case-insensitive searches.

Question 36

The constraint assigns a value to an attribute when a new row is added to a table.

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

Question 37

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 38

The constraint assigns a value to an attribute when a new row is added to a table.

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

Question 39

The command is used to restore the database to its previous condition.

A)COMMIT; RESTORE;
B)COMMIT; BACKUP;
C)COMMIT; ROLLBACK;
D)ROLLBACK;

Question 40

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

Question 41

A table can be deleted from the database by using the command.

A)DROP TABLE
B)DELETE TABLE
C)MODIFY TABLE
D)ERASE TABLE

Question 42

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 43

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

A)performing additions and subtractions
B)performing multiplications and divisions
C)performing operations within parentheses
D)performing power operations

Question 44

Which of the following queries will output the table contents when the value of the character field P_CODE is alphabetically less than 1558-QW1?

A)SELECT P_CODE,P_DESCRIPT,P_QOH,P_MIN,P_PRICE FROM PRODUCT WHERE P_CODE <'1558-QW1';
B)SELECT P_CODE,P_DESCRIPT,P_QOH,P_MIN,P_PRICE FROM PRODUCT WHERE P_CODE = [1558-QW1];
C)SELECT P_CODE,P_DESCRIPT,P_QOH,P_MIN,P_PRICE FROM PRODUCT WHERE P_CODE = (1558-QW1);
D)SELECT P_CODE,P_DESCRIPT,P_QOH,P_MIN,P_PRICE FROM PRODUCT WHERE P_CODE = {1558-QW1};

Question 45

The command would be used to delete the table row where the P_CODE is 'BRT-345'.

A)DELETE FROM PRODUCT WHERE P_CODE = 'BRT-345';
B)REMOVE FROM PRODUCT WHERE P_CODE = 'BRT-345';
C)ERASE FROM PRODUCT WHERE P_CODE = 'BRT-345';
D)ROLLBACK FROM PRODUCT WHERE P_CODE = 'BRT-345';

Question 46

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 47

The query to join the P_DESCRIPT and P_PRICE fields from the PRODUCT table and the V_NAME,V_AREACODE,V_PHONE and V_CONTACT fields from the VENDOR table,where the values of V_CODE match and the output is ordered by the price is .

A)SELECT PRODUCT.P_DESCRIPT,PRODUCT.P_PRICE,VENDOR.V_NAME,VENDOR.V_CONTACT,VENDOR.V_AREACODE,VENDOR.V_PHONE FROM PRODUCT,VENDOR
WHERE PRODUCT.V_CODE <> VENDOR.V_CODE; ORDER BY PRODUCT.P_PRICE;
B)SELECT PRODUCT.P_DESCRIPT,PRODUCT.P_PRICE,VENDOR.V_NAME,VENDOR.V_CONTACT,VENDOR.V_AREACODE,VENDOR.V_PHONE FROM PRODUCT,VENDOR
WHERE PRODUCT.V_CODE => VENDOR.V_CODE; ORDER BY PRODUCT.P_PRICE;
C)SELECT PRODUCT.P_DESCRIPT,PRODUCT.P_PRICE,VENDOR.V_NAME,VENDOR.V_CONTACT,VENDOR.V_AREACODE,VENDOR.V_PHONE FROM PRODUCT,VENDOR
WHERE PRODUCT.V_CODE <= VENDOR.V_CODE; ORDER BY PRODUCT.P_PRICE;
D)SELECT PRODUCT.P_DESCRIPT,PRODUCT.P_PRICE,VENDOR.V_NAME,VENDOR.V_CONTACT, VENDOR.V_AREACODE,VENDOR.V_PHONE FROM PRODUCT,VENDOR
WHERE PRODUCT.V_CODE = VENDOR.V_CODE; ORDER BY PRODUCT.P_PRICE;

Question 48

Which of the following queries 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 49

Which of the following queries will output the table contents when the value of V_CODE is not equal to 21344?

A)SELECT P_DESCRIPT,P_INDATE,P_PRICE,V_CODE FROM PRODUCT WHERE V_CODE <> 21344;
B)SELECT P_DESCRIPT,P_INDATE,P_PRICE,V_CODE FROM PRODUCT WHERE V_CODE <= 21344;
C)SELECT P_DESCRIPT,P_INDATE,P_PRICE,V_CODE FROM PRODUCT WHERE V_CODE = 21344;
D)SELECT P_DESCRIPT,P_INDATE,P_PRICE,V_CODE FROM PRODUCT WHERE V_CODE => 21344;

Question 50

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

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

Question 51

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

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

Question 52

Which of the following queries will list all the rows in which the inventory stock dates occur on or after January 20,2016?

A)SELECT P_DESCRIPT,P_QOH,P_MIN,P_PRICE,P_INDATE FROM PRODUCT WHERE P_INDATE >= '20-JAN-2016';
B)SELECT P_DESCRIPT,P_QOH,P_MIN,P_PRICE,P_INDATE FROM PRODUCT WHERE P_INDATE >= $20-JAN-2010$;
C)SELECT P_DESCRIPT,P_QOH,P_MIN,P_PRICE,P_INDATE FROM PRODUCT WHERE P_INDATE <= '20-JAN-2010';
D)SELECT P_DESCRIPT,P_QOH,P_MIN,P_PRICE,P_INDATE FROM PRODUCT WHERE P_INDATE >= {20-JAN-2010};

Question 53

Which of the following is used to select partial table contents?

A)SELECT FROM
BY ;
B)LIST FROM
BY ;
C)SELECT FROM
WHERE ;
D)LIST FROM
WHERE ;

Question 54

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 55

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 56

Which of the following queries will output the table contents when the value of V_CODE is equal to 21344?

A)SELECT P_DESCRIPT,P_INDATE,P_PRICE,V_CODE FROM PRODUCT WHERE V_CODE <> 21344;
B)SELECT P_DESCRIPT,P_INDATE,P_PRICE,V_CODE FROM PRODUCT WHERE V_CODE <= 21344;
C)SELECT P_DESCRIPT,P_INDATE,P_PRICE,V_CODE FROM PRODUCT WHERE V_CODE = 21344;
D)SELECT P_DESCRIPT,P_INDATE,P_PRICE,V_CODE FROM PRODUCT WHERE V_CODE => 21344;

Question 57

Which of the following queries will use the given columns and column aliases from the PRODUCT table to determine the total value of inventory held on hand?

A)SELECT P_DESCRIPT,P_QOH,P_PRICE,P_QOH/P_PRICE FROM PRODUCT;
B)SELECT P_DESCRIPT,P_QOH,P_PRICE,P_QOH=P_PRICE FROM PRODUCT;
C)SELECT P_DESCRIPT,P_QOH,P_PRICE,P_QOH*P_PRICE FROM PRODUCT;
D)SELECT P_DESCRIPT,P_QOH,P_PRICE,P_QOH-P_PRICE FROM PRODUCT;

Question 58

Which of the following queries uses the correct SQL syntax to list the table contents for either V_CODE = 21344 or V_CODE = 24288?

A)SELECT P_DESCRIPT,P_INDATE,P_PRICE,V_CODE FROM PRODUCT WHERE V_CODE = 21344 OR V_CODE <= 24288;
B)SELECT P_DESCRIPT,P_INDATE,P_PRICE,V_CODE FROM PRODUCT WHERE V_CODE = 21344 OR V_CODE => 24288;
C)SELECT P_DESCRIPT,P_INDATE,P_PRICE,V_CODE FROM PRODUCT WHERE V_CODE = 21344 OR V_CODE > 24288;
D)SELECT P_DESCRIPT,P_INDATE,P_PRICE,V_CODE FROM PRODUCT WHERE V_CODE = 21344 OR V_CODE = 24288;

Question 59

The query to join the P_DESCRIPT and P_PRICE fields from the PRODUCT table and the V_NAME,V_AREACODE,V_PHONE,and V_CONTACT fields from the VENDOR table where the values of V_CODE match is .

A)SELECT P_DESCRIPT,P_PRICE,V_NAME,V_CONTACT,V_AREACODE,V_PHONE FROM PRODUCT,VENDOR WHERE PRODUCT.V_CODE <> VENDOR.V_CODE;
B)SELECT P_DESCRIPT,P_PRICE,V_NAME,V_CONTACT,V_AREACODE,V_PHONE FROM PRODUCT,VENDOR WHERE PRODUCT.V_CODE = VENDOR.V_CODE;
C)SELECT P_DESCRIPT,P_PRICE,V_NAME,V_CONTACT,V_AREACODE,V_PHONE FROM PRODUCT,VENDOR WHERE PRODUCT.V_CODE <= VENDOR.V_CODE;
D)SELECT P_DESCRIPT,P_PRICE,V_NAME,V_CONTACT,V_AREACODE,V_PHONE FROM PRODUCT,VENDOR WHERE PRODUCT.V_CODE => VENDOR.V_CODE;

Question 60

All changes in a table structure are made using the command,followed by a keyword that produces the specific changes a user wants to make.

A)ALTER TABLE
B)UPDATE TABLE
C)COOMIT TABLE
D)ROLLBACK TABLE

Question 61

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

Question 62

In an INSERT command,a user can indicate just the attributes that have required values by listing the inside parentheses after the table name.

Question 63

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

Question 64

In a 1:M relationship,a user must always create the table for the side first.

Question 65

___ __.is the process the DBMS uses to verify that only registered users access the database.

Question 66

__ words are words used by SQL to perform specific functions.

Question 67

The SQL data type DATE stores date in the date format.

Question 68

With the exception of the database process,most RDBMS vendors use SQL that deviates little from the ANSI standard SQL.

Question 69

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

Question 70

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

Question 71

A common practice is to create a(n)on any field that is used as a search key,in comparison operations in a conditional expression,or when a user wants to list rows in a specific order.

Question 72

The basic SQL vocabulary has fewer than words.

Question 73

A(n)is a logical group of database objects,such as tables and indexes,that are related to each other.

Question 74

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

Question 75

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

Question 76

To delete an index,one must use the command.

Question 77

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

Question 78

To make SQL code more _______,most SQL programmers use one line per column (attribute)definition.

Question 79

In SQL,all expressions evaluate to true or false.

Question 80

U.S.state abbreviations are always two characters,so (2)is a logical choice for the data type representing a state column.