Question 1

What is a view? What is the command used to create a view?

Accepted Answer

A view is a virtual table based on a SEL

Question 2

All SQL commands must be issued on a single line.

Accepted Answer

A) True 
 B)False

Question 3

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

Accepted Answer

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

Question 4

String comparisons are made from left to right.

Accepted Answer

A) True 
 B)False

Question 5

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

Accepted Answer

A) True 
 B)False

Question 6

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

Accepted Answer

The answer of In an INSERT command,you can indicate just...

Question 7

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.

Accepted Answer

The answer of A(n)____________________ order sequence is a multilevel ordered...

Question 8

A(n)____________________ is performed when data is retrieved from more than one table at a time.

Accepted Answer

The answer of A(n)____________________ is performed when data is retrieved...

Question 9

Since computers identify all characters by their numeric codes,mathematical operators cannot be used to place restrictions on character-based attributes.

Accepted Answer

A) True 
 B)False

Question 10

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

Accepted Answer

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

Question 11

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

Accepted Answer

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

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

Accepted Answer

The answer of In a 1:M relationship,you must always create...

Question 13

The most recent fully approved version of standard SQL prescribed by the ANSI is ____.

Accepted Answer

A)  SQL-99 
B)  SQL-2003 
C)  SQL-4 
D)  SQL-07 
A)  SQL-99 
B)  SQL-2003 
C)  SQL-4 
D)  SQL-07

Question 14

What is a schema? How many schemas can be used in one database?

Accepted Answer

In the SQL environment,a schema is a gro

Question 15

When you issue the DELETE FROM tablename command without specifying a WHERE condition,____.

Accepted Answer

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

The ____ special operator is used to check whether an attribute value is null.

Accepted Answer

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

Question 17

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 18

The SQL aggregate function that gives the average for the specific column is ____.

Accepted Answer

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

Question 19

The SQL command that modifies an attribute's values in one or more table's rows is ____.

Accepted Answer

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

Question 20

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

What is a view? What is the command used to create a view?

All SQL commands must be issued on a single line.

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

String comparisons are made from left to right.

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

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

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.

A(n)____________________ is performed when data is retrieved from more than one table at a time.

Since computers identify all characters by their numeric codes,mathematical operators cannot be used to place restrictions on character-based attributes.

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

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

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

The most recent fully approved version of standard SQL prescribed by the ANSI is ____.

What is a schema? How many schemas can be used in one database?

When you issue the DELETE FROM tablename command without specifying a WHERE condition,____.

The ____ special operator is used to check whether an attribute value is null.

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

The SQL aggregate function that gives the average for the specific column is ____.

The SQL command that modifies an attribute's values in one or more table's rows is ____.

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.

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)

What is a view? What is the command used to create a view?

All SQL commands must be issued on a single line.

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

String comparisons are made from left to right.

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

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

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.

A(n)____________________ is performed when data is retrieved from more than one table at a time.

Since computers identify all characters by their numeric codes,mathematical operators cannot be used to place restrictions on character-based attributes.

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

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

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

The most recent fully approved version of standard SQL prescribed by the ANSI is ____.

What is a schema? How many schemas can be used in one database?

When you issue the DELETE FROM tablename command without specifying a WHERE condition,____.

The ____ special operator is used to check whether an attribute value is null.

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

The SQL aggregate function that gives the average for the specific column is ____.

The SQL command that modifies an attribute's values in one or more table's rows is ____.

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.

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

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