Question 1

Which SQL keyword is used to change the structure,properties or constraints of a table?

Accepted Answer

A) SET 
B) CREATE 
C) SELECT 
D) ALTER 
A) SET 
B) CREATE 
C) SELECT 
D) ALTER

Question 2

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

Accepted Answer

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

Question 3

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

Accepted Answer

A) True 
 B)False

Question 4

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 5

Discuss SQL data types.

Accepted Answer

Common examples of standard SQL data typ

Question 6

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

Accepted Answer

A) True 
 B)False

Question 7

Unless it is being used to copy data from one table to another,the SQL INSERT statement can be used to insert only a single row into a table.

Accepted Answer

A) True 
 B)False

Question 8

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

Accepted Answer

A) True 
 B)False

Question 9

Which SQL statement is used to retrieve view instances?

Accepted Answer

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

Question 10

Which of the following does not describe a user-defined function?

Accepted Answer

A) It computes a numeric value 
B) It can be called by name from within an SQL statement 
C) It may have input parameters passed to it 
D) It returns an output value to the calling statement 
A) It computes a numeric value 
B) It can be called by name from within an SQL statement 
C) It may have input parameters passed to it 
D) It returns an output value to the calling statement

Question 11

Because SQL statements are table-oriented,whereas programs are element-oriented,the results of SQL statements used in programs are accessed using ________.

Accepted Answer

A) standard programming tools 
B) custom written programming tools 
C) an SQL cursor 
D) an SQL trigger 
A) standard programming tools 
B) custom written programming tools 
C) an SQL cursor 
D) an SQL trigger

Question 12

When the correct SQL command is used to delete a table's structure,the command can only be used with a table that has already had its data removed.

Accepted Answer

A) True 
 B)False

Question 13

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

Accepted Answer

A) True 
 B)False

Question 14

Distinguish between Char and VarChar data types.Include examples and tradeoffs.

Accepted Answer

Char data type is fixed-length,so that n

Question 15

If the values in an SQL view are not changeable through the view itself,you may still be able to update the view by using unique application logic.In this case,the specific logic is placed in ________.

Accepted Answer

A) a BEFORE trigger 
B) an INSTEAD OF trigger 
C) an AFTER trigger 
D) Depending on the specific logic,either A or B can be used. 
A) a BEFORE trigger 
B) an INSTEAD OF trigger 
C) an AFTER trigger 
D) Depending on the specific logic,either A or B can be used.

Question 16

The SQL SET keyword is used to specify a new value when changing a column value.

Accepted Answer

A) True 
 B)False

Question 17

SQL triggers are created using the SQL ADD TRIGGER statement.

Accepted Answer

A) True 
 B)False

Question 18

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

Accepted Answer

A) True 
 B)False

Question 19

The SQL command SELECT is used to retrieve view instances.

Accepted Answer

A) True 
 B)False

Question 20

The following database will be used in this question:
GENERAL SALES DATABASE:
SALESREP
   CUSTOMER
   What is an SQL view,and what is it used for? Include an example based on the CUSTOMER table of the General Sales Database.

Accepted Answer

An SQL view is a virtual table construct

Exam 7: SQL for Database Construction and Application Processing

Which SQL keyword is used to change the structure,properties or constraints of a table?

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

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

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

Discuss SQL data types.

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

Unless it is being used to copy data from one table to another,the SQL INSERT statement can be used to insert only a single row into a table.

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

Which SQL statement is used to retrieve view instances?

Which of the following does not describe a user-defined function?

Because SQL statements are table-oriented,whereas programs are element-oriented,the results of SQL statements used in programs are accessed using ________.

When the correct SQL command is used to delete a table's structure,the command can only be used with a table that has already had its data removed.

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

Distinguish between Char and VarChar data types.Include examples and tradeoffs.

If the values in an SQL view are not changeable through the view itself,you may still be able to update the view by using unique application logic.In this case,the specific logic is placed in ________.

The SQL SET keyword is used to specify a new value when changing a column value.

SQL triggers are created using the SQL ADD TRIGGER statement.

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

The SQL command SELECT is used to retrieve view instances.

The following database will be used in this question: GENERAL SALES DATABASE: SALESREP CUSTOMER What is an SQL view,and what is it used for? Include an example based on the CUSTOMER table of the General Sales Database.

Introduction

Introduction to Structured Query Language

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 2014

Managing Databases With Oracle Database

Managing Databases With Mysql 5.6

The Web Server Environment

Big Data, Data-Warehouses, and Business Intelligence Systems

Getting Started With 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 Netbeans IDE

Business Intelligence Systems

Big Data

Filters