Exam 12: Sql Views SQL/PSM and Importing Data

Explore all topics

Use the database below to answer the following question. GENERAL SALES DATABASE: SALESREP SalesRepNe RepName HireDate 654 Jones 01/02/1999 734 Smith 02/03/2000 345 Chen 01/25/1998 434 Johnson 11/23/1998 CUSTOMER $Use the database below to answer the following question. GENERAL SALES DATABASE: SALESREP \begin{array} { | l | l | l | } \hline \text { SalesRepNe } & \text { RepName } & \text { HireDate } \\ \hline 654 & \text { Jones } & 01 / 02 / 1999 \\ \hline 734 & \text { Smith } & 02 / 03 / 2000 \\ \hline 345 & \text { Chen } & 01 / 25 / 1998 \\ \hline 434 & \text { Johnson } & 11 / 23 / 1998 \\ \hline \end{array} CUSTOMER Write the SQL statement to create a view named CustomerSalesRepView that displays the customer name as CustomerName and the associated sales rep name SaleRepresentativeName from the GENERAL SALES DATABASE.$ Write the SQL statement to create a view named CustomerSalesRepView that displays the customer name as CustomerName and the associated sales rep name SaleRepresentativeName from the GENERAL SALES DATABASE.

(Essay)

4.9/5

(37)

Question 61

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

(Multiple Choice)

4.8/5

(38)

Question 62

The SQL command SELECT is used to retrieve data from view instances.

(True/False)

5.0/5

(35)

Question 63

SQL views can be used to hide complicated SQL syntax.

(True/False)

4.8/5

(31)

Question 64

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

(True/False)

4.9/5

(33)

Question 65

The SQL Server DBMS supports the SQL BEFORE trigger.

(True/False)

4.8/5

(33)

Question 66

The SQL keyword ORDER BY can be used with SELECT statements that are retrieving data from view instances to sort the results of the SELECT.

(True/False)

4.9/5

(27)

Question 67

Stored procedures have the advantage of ________.

(Multiple Choice)

4.8/5

(28)

Question 68

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

(True/False)

4.8/5

(33)

Question 69

Microsoft Access ________ can use previously stored view equivalent Access queries the same way an SQL SELECT statement uses SQL views.

(Short Answer)

4.8/5

(34)

Question 70

Showing 61 - 70 of 70

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

The SQL command SELECT is used to retrieve data from view instances.

SQL views can be used to hide complicated SQL syntax.

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

The SQL Server DBMS supports the SQL BEFORE trigger.

The SQL keyword ORDER BY can be used with SELECT statements that are retrieving data from view instances to sort the results of the SELECT.

Stored procedures have the advantage of ________.

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

Microsoft Access ________ can use previously stored view equivalent Access queries the same way an SQL SELECT statement uses SQL views.

Getting Started

The Relational Model

Structured Query Language

Data Modeling and the Entity Relationship Model

Database Design

Database Administration

Database Processing Applications

Big Data Data Warehouses and Business Intelligence Systems

Getting Started With Microsoft Sql Server 2014 Express Edition

Getting Started With Oracle Database Express Edition 11g Release 2

Getting Started With Mysql 5.6 Community Server

Getting Started in Systems Analysis and Design

Getting Started With Microsoft Visio 2013

the Access Workbench section H Microsoft Access 2013 Switchboards

Getting Started With Web Servers, Php, and the Net beans IDE

Business Intelligence Systems

Big Data

Filters