Question 1

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

Accepted Answer

The answer of A(n)____________________ character is a symbol that can...

Question 2

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?

Accepted Answer

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; 
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 3

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

Question 4

The SQL command that lets you insert rows into a table is ____.

Accepted Answer

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

Question 5

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

Accepted Answer

A) True 
 B)False

Question 6

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

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; 
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; 
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;

Question 7

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

Accepted Answer

The answer of The ____________________ clause of the GROUP BY...

Question 8

The ANSI SQL standards are also accepted by the ISO.

Accepted Answer

A) True 
 B)False

Question 9

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

Accepted Answer

A) True 
 B)False

Question 10

SQL character data format(s)is(are)____.

Accepted Answer

A)  CHAR and VARCHAR 
B)  VARCHAR only 
C)  Alphanumeric 
D)  CHAR only 
A)  CHAR and VARCHAR 
B)  VARCHAR only 
C)  Alphanumeric 
D)  CHAR only

Question 11

The SQL query to output the contents of the EMPLOYEE table sorted by last name,first name,and initial is ____.

Accepted Answer

A)  SELECT EMP_LNAME,EMP_FNAME,EMP_INITIAL,EMP_AREACODE,EMP_PHONE
FROM EMPLOYEE
LIST BY EMP_LNAME,EMP_FNAME,EMP_INITIAL; 
B)  SELECT EMP_LNAME,EMP_FNAME,EMP_INITIAL,EMP_AREACODE,EMP_PHONE
FROM EMPLOYEE
ORDER BY EMP_LNAME,EMP_FNAME,EMP_INITIAL; 
C)  SELECT EMP_LNAME,EMP_FNAME,EMP_INITIAL,EMP_AREACODE,EMP_PHONE
FROM EMPLOYEE
DISPLAY BY EMP_LNAME,EMP_FNAME,EMP_INITIAL; 
D)  SELECT EMP_LNAME,EMP_FNAME,EMP_INITIAL,EMP_AREACODE,EMP_PHONE
FROM EMPLOYEE
SEQUENCE BY EMP_LNAME,EMP_FNAME,EMP_INITIAL; 
A)  SELECT EMP_LNAME,EMP_FNAME,EMP_INITIAL,EMP_AREACODE,EMP_PHONE
FROM EMPLOYEE
LIST BY EMP_LNAME,EMP_FNAME,EMP_INITIAL; 
B)  SELECT EMP_LNAME,EMP_FNAME,EMP_INITIAL,EMP_AREACODE,EMP_PHONE
FROM EMPLOYEE
ORDER BY EMP_LNAME,EMP_FNAME,EMP_INITIAL; 
C)  SELECT EMP_LNAME,EMP_FNAME,EMP_INITIAL,EMP_AREACODE,EMP_PHONE
FROM EMPLOYEE
DISPLAY BY EMP_LNAME,EMP_FNAME,EMP_INITIAL; 
D)  SELECT EMP_LNAME,EMP_FNAME,EMP_INITIAL,EMP_AREACODE,EMP_PHONE
FROM EMPLOYEE
SEQUENCE BY EMP_LNAME,EMP_FNAME,EMP_INITIAL;

Question 12

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

Accepted Answer

A) True 
 B)False

Question 13

The special operator used to check for similar character strings is ____.

Accepted Answer

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

Question 14

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

Accepted Answer

A) True 
 B)False

Question 15

The SQL command that lets you permanently save data changes is ____.

Accepted Answer

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

Question 16

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

Accepted Answer

A)  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 
A)  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 17

Frequency distributions can be created quickly and easily using the SQL ____________________ clause.

Accepted Answer

The answer of Frequency distributions can be created quickly and...

Question 18

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

Accepted Answer

The answer of A(n)____________________,also known as a nested query or...

Question 19

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

Accepted Answer

A) True 
 B)False

Question 20

You can create a logical (virtual)table by using the MAKE VIEW command.

Accepted Answer

A) True 
 B)False

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

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?

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

The SQL command that lets you insert rows into a table is ____.

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

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

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

The ANSI SQL standards are also accepted by the ISO.

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

SQL character data format(s)is(are)____.

The SQL query to output the contents of the EMPLOYEE table sorted by last name,first name,and initial is ____.

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

The special operator used to check for similar character strings is ____.

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

The SQL command that lets you permanently save data changes is ____.

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

Frequency distributions can be created quickly and easily using the SQL ____________________ clause.

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

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

You can create a logical (virtual)table by using the MAKE VIEW command.

Database Systems

Data Models

The Relational Database Model

Entity Relationship (ER)Modeling

Advanced Data Modeling

Normalization of Database Tables

Advanced SQL

Database Design

Transaction Management and Concurrency Control

Database Performance Tuning and Query Optimization

Distributed Database Management Systems

Business Intelligence and Data Warehouses

Database Connectivity and Web Technologies

Database Administration and Security

Filters

Exam 7: Introduction to Structured Query Language (SQL)

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

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?

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

The SQL command that lets you insert rows into a table is ____.

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

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

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

The ANSI SQL standards are also accepted by the ISO.

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

SQL character data format(s)is(are)____.

The SQL query to output the contents of the EMPLOYEE table sorted by last name,first name,and initial is ____.

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

The special operator used to check for similar character strings is ____.

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

The SQL command that lets you permanently save data changes is ____.

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

Frequency distributions can be created quickly and easily using the SQL ____________________ clause.

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

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

You can create a logical (virtual)table by using the MAKE VIEW command.

Database Systems

Data Models

The Relational Database Model

Entity Relationship (ER)Modeling

Advanced Data Modeling

Normalization of Database Tables

Advanced SQL

Database Design

Transaction Management and Concurrency Control

Database Performance Tuning and Query Optimization

Distributed Database Management Systems

Business Intelligence and Data Warehouses

Database Connectivity and Web Technologies

Database Administration and Security

Filters