Question 1

The SQL CREATE TABLE statement is used to name a new table and describe the table's columns.

Accepted Answer

A) True 
 B)False  True

Question 2

The SQL keyword CONSTRAINT is used to limit column values to specific values.

Accepted Answer

A) True 
 B)False  True

Question 3

Because SQL statements are table-oriented,whereas programs are variable-oriented,the results of SQL statements used in programs are accessed using an SQL cursor.

Accepted Answer

A) True 
 B)False  True

Question 4

To set a column value to an initial value that is selected according to some business logic,you would use the SQL DEFAULT constraint with the CREATE TABLE command.

Accepted Answer

A) True 
 B)False

Question 5

SQL triggers are used for providing default values,validity checking,updating views,and performing referential integrity actions.

Accepted Answer

A) True 
 B)False

Question 6

SQL views are always updatable when ________.

Accepted Answer

A) the view is based on a single table with no computed columns,and all non-null columns are present in the view 
B) the view is based on any number of tables,with or without computed columns,and the INSTEAD OF trigger is defined for the view 
C) the view is based on multiple tables,the update is being done on the most subordinate table,and the rows of that table can be uniquely identified 
D) A and B 
E) A,B,and C 
A) the view is based on a single table with no computed columns,and all non-null columns are present in the view 
B) the view is based on any number of tables,with or without computed columns,and the INSTEAD OF trigger is defined for the view 
C) the view is based on multiple tables,the update is being done on the most subordinate table,and the rows of that table can be uniquely identified 
D) A and B 
E) A,B,and C

Question 7

If a trigger is being written to enforce referential integrity actions,you cannot use an INSTEAD OF trigger.

Accepted Answer

A) True 
 B)False

Question 8

The SQL keyword CONSTRAINT is used to define one of five types of constraints.

Accepted Answer

A) True 
 B)False

Question 9

The following database will be used in this question:
GENERAL SALES DATABASE:
SALESREP
   
CUSTOMER
   
Explain the use of the SQL statement CREATE TABLE.Do NOT discuss the ALTER statement in your answer,but DO include an example based on the SALESREP table in the General Sales database.

Accepted Answer

The SQL statement CREATE TABLE forms tha

Question 10

The SQL keyword CHECK is used to limit column values to specific values.

Accepted Answer

A) True 
 B)False

Question 11

Because SQL statements are table-oriented,whereas programs are variable-oriented,the results of SQL statements used in programs are treated as pseudofiles.

Accepted Answer

A) True 
 B)False

Question 12

Discuss SQL data types.

Accepted Answer

Common examples of standard SQL data typ

Question 13

A set of SQL statements stored in an application written in a standard programming language is called embedded SQL.

Accepted Answer

A) True 
 B)False

Question 14

SQL views are updatable when the view is based on a single table with no computed columns,and all non-null columns are present in the view.

Accepted Answer

A) True 
 B)False

Question 15

Explain how relationships are created using SQL.

Accepted Answer

In SQL,relationships are created using a

Question 16

Distinguish between Char and VarChar data types.

Accepted Answer

Char data type is fixed-length,so that n

Question 17

The SQL command CREATE USER VIEW is used to create a virtual table.

Accepted Answer

A) True 
 B)False

Question 18

SQL views are constructed from ________.

Accepted Answer

A) CREATE statements 
B) INSERT statements 
C) UPDATE statements 
D) SELECT statements 
E) VIEW statements 
A) CREATE statements 
B) INSERT statements 
C) UPDATE statements 
D) SELECT statements 
E) VIEW statements

Question 19

A stored program that is stored within the database and compiled when used is called a trigger.

Accepted Answer

A) True 
 B)False

Question 20

SQL triggers are used for ________.

Accepted Answer

A) validity checking 
B) providing default values 
C) updating views 
D) A and B 
E) A,B,and C 
A) validity checking 
B) providing default values 
C) updating views 
D) A and B 
E) A,B,and C

Exam 7: Sql for Database Construction and Application Processing

The SQL CREATE TABLE statement is used to name a new table and describe the table's columns.

The SQL keyword CONSTRAINT is used to limit column values to specific values.

Because SQL statements are table-oriented,whereas programs are variable-oriented,the results of SQL statements used in programs are accessed using an SQL cursor.

To set a column value to an initial value that is selected according to some business logic,you would use the SQL DEFAULT constraint with the CREATE TABLE command.

SQL triggers are used for providing default values,validity checking,updating views,and performing referential integrity actions.

SQL views are always updatable when ________.

If a trigger is being written to enforce referential integrity actions,you cannot use an INSTEAD OF trigger.

The SQL keyword CONSTRAINT is used to define one of five types of constraints.

The following database will be used in this question: GENERAL SALES DATABASE: SALESREP CUSTOMER Explain the use of the SQL statement CREATE TABLE.Do NOT discuss the ALTER statement in your answer,but DO include an example based on the SALESREP table in the General Sales database.

The SQL keyword CHECK is used to limit column values to specific values.

Because SQL statements are table-oriented,whereas programs are variable-oriented,the results of SQL statements used in programs are treated as pseudofiles.

Discuss SQL data types.

A set of SQL statements stored in an application written in a standard programming language is called embedded SQL.

SQL views are updatable when the view is based on a single table with no computed columns,and all non-null columns are present in the view.

Explain how relationships are created using SQL.

Distinguish between Char and VarChar data types.

The SQL command CREATE USER VIEW is used to create a virtual table.

SQL views are constructed from ________.

A stored program that is stored within the database and compiled when used is called a trigger.

SQL triggers are used for ________.

Introduction

Introduction to Structured Query Language SQL

The Relational Model and Normalization

Database Design Using Normalization

Data Modeling With the Entity-Relationship Model

Transforming Data Models Into Database Designs

Database Redesign

Managing Multiuser Databases

A: Managing Databases With SQL Server 20012

B: Managing Databases With Oracle Database 11g Release 2

C: Managing Databases With MySQL

The Web Server Environment

Big Data datawarehouse and Business Intelligence Systems

Microsoft Access 2013

Getting Started With Systems Analysis and Design

E-R Diagrams and the Idef1x Standard

E-R Diagrams and the UML Standard

Getting Started With MySQL Workbench Data Modeling Tools

Getting Started With Microsoft Visio 2013

Data Structures for Database Processing

the Semantic Object Model

Getting Started With Web Servers php and the Eclipse PDT

Business Intelligence Systems

Filters