Question 1

When the correct SQL command is used to delete a table's structure,what happens to the data in the table?

Accepted Answer

A) If the deleted table was a parent table,the data is added to the appropriate rows of the child table. 
B) If the deleted table was a child table,the data is added to the appropriate rows of the parent table. 
C) The data in the table is also deleted. 
D) Nothing because there was no data in the table since only an empty table can be deleted. 
E) A and B 
A) If the deleted table was a parent table,the data is added to the appropriate rows of the child table. 
B) If the deleted table was a child table,the data is added to the appropriate rows of the parent table. 
C) The data in the table is also deleted. 
D) Nothing because there was no data in the table since only an empty table can be deleted. 
E) A and B

Question 2

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

Accepted Answer

A) True 
 B)False

Question 3

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 4

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 5

Because SQL stored procedures allow and encourage code sharing among developers,stored procedures give database application developers the advantages of ________.

Accepted Answer

A) less work 
B) standardized processing 
C) specialization among developers 
D) A and B 
E) A,B and C 
A) less work 
B) standardized processing 
C) specialization among developers 
D) A and B 
E) A,B and C

When the correct SQL command is used to delete a table's structure,what happens to the data in the table?

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

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

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

Because SQL stored procedures allow and encourage code sharing among developers,stored procedures give database application developers the advantages of ________.

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

Managing Databases With SQL Server 2008 R2

Managing Databases With Oracle Database 11g

Managing Databases With MySQL 55

The Web Server Environment

Database Processing With XML

Database Processing for Business Intelligence Systems

Microsoft Access 2010

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 2010

the Semantic Object Model

Data Structures for Database Processing

Getting Started With Web Servers php and the Eclipse PDT

Filters

Exam 7: SQL for Database Construction and Application Processing

When the correct SQL command is used to delete a table's structure,what happens to the data in the table?

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

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

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

Because SQL stored procedures allow and encourage code sharing among developers,stored procedures give database application developers the advantages of ________.

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

Managing Databases With SQL Server 2008 R2

Managing Databases With Oracle Database 11g

Managing Databases With MySQL 55

The Web Server Environment

Database Processing With XML

Database Processing for Business Intelligence Systems

Microsoft Access 2010

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 2010

the Semantic Object Model

Data Structures for Database Processing

Getting Started With Web Servers php and the Eclipse PDT

Filters