Question 1

Which SQL keyword is used to name a new table and describe the table's columns?

Accepted Answer

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

Question 2

Referential integrity constraints are implemented in SQL using the ________ syntax.

Accepted Answer

A) PRIMARY KEY 
B) FOREIGN KEY 
C) DEFAULT 
D) UNIQUE 
A) PRIMARY KEY 
B) FOREIGN KEY 
C) DEFAULT 
D) UNIQUE

Question 3

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

Accepted Answer

A) True 
 B)False

Question 4

If the table PRODUCT has a column PRICE that has the data type Numeric (8,2),the value 12345 will be displayed by the DBMS as ________.

Accepted Answer

A) 123.45 
B) 12345 
C) 12345.00 
D) 123450.00 
A) 123.45 
B) 12345 
C) 12345.00 
D) 123450.00

Question 5

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

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) Both A and B are correct 
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) Both A and B are correct

Question 7

Based on the table below,a function to compute a 10% late penalty on a customer's balance would have how many input parameters? CUSTOMER

Accepted Answer

A) 0 
B) 1 
C) 2 
D) it doesn't matter 
A) 0 
B) 1 
C) 2 
D) it doesn't matter

Question 8

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

Accepted Answer

A) True 
 B)False

Question 9

If you have a foreign key in a CUSTOMER table that references the primary key in a SALESREP table,the ON DELETE CASCADE syntax means that ________.

Accepted Answer

A) when a CUSTOMER is deleted,that CUSTOMER's SALESREP is also deleted 
B) when a CUSTOMER is deleted,all SALESREPS are also deleted 
C) when a SALESREP is deleted,all CUSTOMERs of that SALESREP are also deleted 
D) when the SALESREP table is dropped,all CUSTOMERs must be deleted 
A) when a CUSTOMER is deleted,that CUSTOMER's SALESREP is also deleted 
B) when a CUSTOMER is deleted,all SALESREPS are also deleted 
C) when a SALESREP is deleted,all CUSTOMERs of that SALESREP are also deleted 
D) when the SALESREP table is dropped,all CUSTOMERs must be deleted

Question 10

SQL views are not used ________.

Accepted Answer

A) to hide columns 
B) to show results of computed columns 
C) to hide complicated SQL statements 
D) to enforce primary key constraints 
A) to hide columns 
B) to show results of computed columns 
C) to hide complicated SQL statements 
D) to enforce primary key constraints

Question 11

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 an INSTEAD OF trigger.

Accepted Answer

A) True 
 B)False

Question 12

What is embedded SQL,and what considerations are necessary when using it in an application?

Accepted Answer

Embedded SQL are SQL statements used,or

Question 13

Discuss what is meant by a data type of "Numeric (10,3)." Include at least one example.

Accepted Answer

Numeric indicates a non-integer,decimal

Question 14

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 
A) the SQL interpreter 
B) the application code 
C) the embedded SQL code 
D) the trigger code

Question 15

The SQL keyword PRIMARY KEY is used to designate the column(s)that are the primary key for the table.

Accepted Answer

A) True 
 B)False

Question 16

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

Accepted Answer

A) True 
 B)False

Question 17

Which of the following is not an SQL trigger Oracle supports?

Accepted Answer

A) BEFORE 
B) INSTEAD OF 
C) AFTER 
D) DURING 
A) BEFORE 
B) INSTEAD OF 
C) AFTER 
D) DURING

Question 18

Which SQL keyword is used to impose restrictions on a table,data or relationship?

Accepted Answer

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

Question 19

If the table ITEM has a column WEIGHT,and WEIGHT has the data type Numeric (4,2),the value 4321 will be displayed by the DBMS as 43.21.

Accepted Answer

A) True 
 B)False

Question 20

Unlike application code,stored procedures are never distributed to the client computers.

Accepted Answer

A) True 
 B)False

Exam 7: SQL for Database Construction and Application Processing

Which SQL keyword is used to name a new table and describe the table's columns?

Referential integrity constraints are implemented in SQL using the ________ syntax.

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

If the table PRODUCT has a column PRICE that has the data type Numeric (8,2),the value 12345 will be displayed by the DBMS as ________.

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

SQL views are always updatable when ________.

Based on the table below,a function to compute a 10% late penalty on a customer's balance would have how many input parameters? CUSTOMER

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

If you have a foreign key in a CUSTOMER table that references the primary key in a SALESREP table,the ON DELETE CASCADE syntax means that ________.

SQL views are not used ________.

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 an INSTEAD OF trigger.

What is embedded SQL,and what considerations are necessary when using it in an application?

Discuss what is meant by a data type of "Numeric (10,3)." Include at least one example.

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

The SQL keyword PRIMARY KEY is used to designate the column(s)that are the primary key for the table.

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

Which of the following is not an SQL trigger Oracle supports?

Which SQL keyword is used to impose restrictions on a table,data or relationship?

If the table ITEM has a column WEIGHT,and WEIGHT has the data type Numeric (4,2),the value 4321 will be displayed by the DBMS as 43.21.

Unlike application code,stored procedures are never distributed to the client computers.

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