Question 1

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

Accepted Answer

A) True 
 B)False

Question 2

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

Accepted Answer

A) True 
 B)False

Question 3

If you add a new column to a table that already has rows, the existing rows will default to a value of ____________________ for the new column.

Accepted Answer

The answer of If you add a new column to...

Question 4

The SQL aggregate function that gives the total of all values for a selected attribute in a given column is ____.

Accepted Answer

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

Question 5

The basic SQL vocabulary has fewer than ____________________ words.

Accepted Answer

100
one hu

Question 6

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

Accepted Answer

The answer of U.S. state abbreviations are always two characters,...

Question 7

All SQL commands must be issued on a single line.

Accepted Answer

A) True 
 B)False

Question 8

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

Accepted Answer

A) True 
 B)False

Question 9

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

Accepted Answer

A) True 
 B)False

Question 10

What command is used to save changes to the database? What is the syntax for this command?

Accepted Answer

Any changes made to the table contents a

Question 11

Most SQL implementations yield case-insensitive searches.

Accepted Answer

A) True 
 B)False

Question 12

Using the ____________________ command, SQL indexes can be created on the basis of any selected attribute.

Accepted Answer

The answer of Using the ____________________ command, SQL indexes can...

Question 13

If your integer values are relatively small, use ____________________ instead of INT.

Accepted Answer

The answer of If your integer values are relatively small,...

Question 14

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

Accepted Answer

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} 
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 15

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

Accepted Answer

A) True 
 B)False

Question 16

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 ____.

Accepted Answer

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

Question 17

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

Accepted Answer

A) True 
 B)False

Question 18

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

Accepted Answer

% means any and all following or precedi

Question 19

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

Accepted Answer

A) True 
 B)False

Question 20

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

Accepted Answer

The answer of A table can be deleted from the...

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

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

If you add a new column to a table that already has rows, the existing rows will default to a value of ____________________ for the new column.

The SQL aggregate function that gives the total of all values for a selected attribute in a given column is ____.

The basic SQL vocabulary has fewer than ____________________ words.

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

All SQL commands must be issued on a single line.

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

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

What command is used to save changes to the database? What is the syntax for this command?

Most SQL implementations yield case-insensitive searches.

Using the ____________________ command, SQL indexes can be created on the basis of any selected attribute.

If your integer values are relatively small, use ____________________ instead of INT.

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

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

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 ____.

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

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

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

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

The Database Approach

Database Development Process

Data Models

Relational Model Characteristics

Procedural Language Sql and Advanced Sql

Data Modeling With Entity Relationship Diagrams

Data Modeling Advanced Concepts

Normalizing Database Designs

Distributed Databases

Interacting With Databases Through the Web

Database Administration and Security

Managing Transactions and Concurrency

Managing Database and Sql Performance

Databases for Decision Support

Filters

Exam 5: Beginning Structured Query Language Sql

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

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

If you add a new column to a table that already has rows, the existing rows will default to a value of ____________________ for the new column.

The SQL aggregate function that gives the total of all values for a selected attribute in a given column is ____.

The basic SQL vocabulary has fewer than ____________________ words.

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

All SQL commands must be issued on a single line.

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

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

What command is used to save changes to the database? What is the syntax for this command?

Most SQL implementations yield case-insensitive searches.

Using the ____________________ command, SQL indexes can be created on the basis of any selected attribute.

If your integer values are relatively small, use ____________________ instead of INT.

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

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

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 ____.

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

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

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

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

The Database Approach

Database Development Process

Data Models

Relational Model Characteristics

Procedural Language Sql and Advanced Sql

Data Modeling With Entity Relationship Diagrams

Data Modeling Advanced Concepts

Normalizing Database Designs

Distributed Databases

Interacting With Databases Through the Web

Database Administration and Security

Managing Transactions and Concurrency

Managing Database and Sql Performance

Databases for Decision Support

Filters