Question 1

Discuss what is meant by a data type of "Numeric (10,3)."

Accepted Answer

Numeric indicates a non-integer,decimal

Question 2

Data values to be added to a table are specified by using the SQL VALUES clause.

Accepted Answer

A) True 
 B)False

Question 3

When a trigger is fired,the DBMS makes the appropriate data available to ________.

Accepted Answer

A) the SQL interpreter 
B) the application code 
C) the embedded SQL code 
D) the trigger code 
E) the stored procedure code 
A) the SQL interpreter 
B) the application code 
C) the embedded SQL code 
D) the trigger code 
E) the stored procedure code

Question 4

SQL triggers can be used when the DBMS receives an insert request.

Accepted Answer

A) True 
 B)False

Question 5

If the values in an SQL view are changeable through the view itself,the SQL command UPDATE is used to change the values.

Accepted Answer

A) True 
 B)False

Question 6

Rows can be removed from a table by using the SQL DELETE statement.

Accepted Answer

A) True 
 B)False

Question 7

According to the SQL-92,statements used to construct views cannot contain ________.

Accepted Answer

A) the SELECT clause 
B) the FROM clause 
C) the WHERE clause 
D) the ORDER BY clause 
E) SQL view statements can use all of the listed clauses. 
A) the SELECT clause 
B) the FROM clause 
C) the WHERE clause 
D) the ORDER BY clause 
E) SQL view statements can use all of the listed clauses.

Question 8

A stored program that is attached to the database is called ________.

Accepted Answer

A) a CHECK constraint 
B) a view 
C) embedded SQL 
D) a trigger 
E) a stored procedure 
A) a CHECK constraint 
B) a view 
C) embedded SQL 
D) a trigger 
E) a stored procedure

Question 9

Stored procedures have the advantage of greater security,decreased network traffic,SQL optimized by the DBMS compiler,and code sharing.

Accepted Answer

A) True 
 B)False

Question 10

Explain the essential format of the CREATE TABLE statement.

Accepted Answer

The essential format for the CREATE TABL

Question 11

The SQL command used to create a virtual table is ________.

Accepted Answer

A) CREATE VTABLE 
B) CREATE VIEW 
C) VTABLE 
D) VIEW 
E) NEWLOOK 
A) CREATE VTABLE 
B) CREATE VIEW 
C) VTABLE 
D) VIEW 
E) NEWLOOK

Question 12

The values in an SQL view are not always changeable through the view itself.

Accepted Answer

A) True 
 B)False

Question 13

Because SQL statements are set-oriented,whereas programs are element-oriented,the results of SQL statements used in programs are treated as ________.

Accepted Answer

A) tables 
B) columns 
C) rows 
D) files 
E) pseudofiles 
A) tables 
B) columns 
C) rows 
D) files 
E) pseudofiles

Question 14

SQL triggers are created using ________.

Accepted Answer

A) the SQL CREATE TRIGGER statement 
B) the SQL ADD TRIGGER statement 
C) the SQL TRIGGER statement 
D) the SQL ADD CONSTRAINT TRIGGER statement 
E) the SQL CONSTRAINT TRIGGER statement 
A) the SQL CREATE TRIGGER statement 
B) the SQL ADD TRIGGER statement 
C) the SQL TRIGGER statement 
D) the SQL ADD CONSTRAINT TRIGGER statement 
E) the SQL CONSTRAINT TRIGGER statement

Question 15

If the values in an SQL view are changeable through the view itself,which SQL statement is used to change the values?

Accepted Answer

A) CREATE 
B) DELETE 
C) INSERT 
D) SELECT 
E) UPDATE 
A) CREATE 
B) DELETE 
C) INSERT 
D) SELECT 
E) UPDATE

Question 16

The SQL keyword MODIFY is used to change a column value.

Accepted Answer

A) True 
 B)False

Question 17

The SQL keyword DELETE is used to delete a table's structure.

Accepted Answer

A) True 
 B)False

Question 18

Which SQL keyword is used to change the values of an entire column?

Accepted Answer

A) CHANGE 
B) INSERT 
C) SELECT 
D) SET 
E) MODIFY 
A) CHANGE 
B) INSERT 
C) SELECT 
D) SET 
E) MODIFY

Question 19

What are SQL triggers and how are they used?

Accepted Answer

An SQL trigger is a stored program that

Question 20

When a trigger is fired,the DBMS makes the appropriate data available to the trigger code.

Accepted Answer

A) True 
 B)False

Exam 7: Sql for Database Construction and Application Processing

Discuss what is meant by a data type of "Numeric (10,3)."

Data values to be added to a table are specified by using the SQL VALUES clause.

When a trigger is fired,the DBMS makes the appropriate data available to ________.

SQL triggers can be used when the DBMS receives an insert request.

If the values in an SQL view are changeable through the view itself,the SQL command UPDATE is used to change the values.

Rows can be removed from a table by using the SQL DELETE statement.

According to the SQL-92,statements used to construct views cannot contain ________.

A stored program that is attached to the database is called ________.

Stored procedures have the advantage of greater security,decreased network traffic,SQL optimized by the DBMS compiler,and code sharing.

Explain the essential format of the CREATE TABLE statement.

The SQL command used to create a virtual table is ________.

The values in an SQL view are not always changeable through the view itself.

Because SQL statements are set-oriented,whereas programs are element-oriented,the results of SQL statements used in programs are treated as ________.

SQL triggers are created using ________.

If the values in an SQL view are changeable through the view itself,which SQL statement is used to change the values?

The SQL keyword MODIFY is used to change a column value.

The SQL keyword DELETE is used to delete a table's structure.

Which SQL keyword is used to change the values of an entire column?

What are SQL triggers and how are they used?

When a trigger is fired,the DBMS makes the appropriate data available to the trigger code.

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