Exam 7: Sql for Database Construction and Application Processing

Explore all topics

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.

(Essay)

4.7/5

(27)

Question 21

Rows in a table can be changed by using the SQL UPDATE statement.

(True/False)

4.8/5

(26)

Question 22

The SQL command SELECT is used to retrieve view instances.

(True/False)

4.9/5

(32)

Question 23

Based on the tables below,which of the following SQL statements would increase the balance of the Gonzales account by $100 to a total of $450? GENERAL SALES DATABASE: SALESREP CUSTOMER

(Multiple Choice)

4.9/5

(33)

Question 24

Given the SQL statement CREATE TABLE SALESREP ( SalesRepNo int NOT NULL, RepName char(35)NOT NULL, HireDate date NOT NULL, CONSTRAINT SalesRepPK PRIMARY KEY (SalesRepNo), CONSTRAINT SalesRepAK1 UNIQUE (RepName) ); We know that ________.

(Multiple Choice)

4.8/5

(38)

Question 25

Which of the following is an SQL trigger Oracle supports?

(Multiple Choice)

4.9/5

(34)

Question 26

The SQL Server DBMS supports the SQL BEFORE trigger.

(True/False)

4.8/5

(30)

Question 27

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

(Multiple Choice)

4.9/5

(32)

Question 28

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

(Multiple Choice)

4.8/5

(37)

Question 29

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

(True/False)

4.8/5

(34)

Question 30

SQL views are constructed from SELECT statements.

(True/False)

4.9/5

(37)

Question 31

SQL triggers use the ANSI SQL keywords BEFORE,INSTEAD OF,and AFTER.

(True/False)

4.8/5

(38)

Question 32

The Oracle DBMS supports the SQL BEFORE trigger.

(True/False)

4.9/5

(30)

Question 33

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

(True/False)

4.8/5

(30)

Question 34

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.

(True/False)

4.9/5

(27)

Question 35

Which SQL keyword is used to change one or more rows in a table?

(Multiple Choice)

4.9/5

(40)

Question 36

Which SQL keyword is used to delete a table's structure?

(Multiple Choice)

4.9/5

(31)

Question 37

One or more rows can be added to a table by using the SQL INSERT statement.

(True/False)

4.8/5

(34)

Question 38

To set a column value to an initial value that is selected according to some business logic,you would use:

(Multiple Choice)

4.9/5

(35)

Question 39

The SQL keyword UNIQUE is used to define alternative keys.

(True/False)

4.9/5

(34)

Question 40

Showing 21 - 40 of 100

Exam 7: Sql for Database Construction and Application Processing

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.

Rows in a table can be changed by using the SQL UPDATE statement.

The SQL command SELECT is used to retrieve view instances.

Based on the tables below,which of the following SQL statements would increase the balance of the Gonzales account by $100 to a total of $450? GENERAL SALES DATABASE: SALESREP CUSTOMER

Given the SQL statement CREATE TABLE SALESREP ( SalesRepNo int NOT NULL, RepName char(35)NOT NULL, HireDate date NOT NULL, CONSTRAINT SalesRepPK PRIMARY KEY (SalesRepNo), CONSTRAINT SalesRepAK1 UNIQUE (RepName) ); We know that ________.

Which of the following is an SQL trigger Oracle supports?

The SQL Server DBMS supports the SQL BEFORE trigger.

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

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

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

SQL views are constructed from SELECT statements.

SQL triggers use the ANSI SQL keywords BEFORE,INSTEAD OF,and AFTER.

The Oracle DBMS supports the SQL BEFORE trigger.

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

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.

Which SQL keyword is used to change one or more rows in a table?

Which SQL keyword is used to delete a table's structure?

One or more rows can be added to a table by using the SQL INSERT statement.

To set a column value to an initial value that is selected according to some business logic,you would use:

The SQL keyword UNIQUE is used to define alternative keys.

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