Type
Quiz
Book Title
Database Concepts 7th Edition
ISBN 13
978-0133544626

COMP 62433

August 22, 2017
A(n) ________ is a set of one or more computer programs that serves as an
intermediary between the user and the DBMS.
Compare and contrast subqueries and joins.
NetBeans is a(n) ________.
What are the basic steps of the normalization process?
Oracle Database Express Edition 11g Release 2 uses ________ to generate surrogate
keys.
When using Microsoft Access and IIS with an ODBC data source, the ODBC data
source should be a(n) ________.
What are Business Intelligence (BI) systems?
Distinguish between an entity class and an entity instance.
When using Microsoft Visio 2013, how do we create a blank diagram for use with a
data model?
Users log into SQL Server 2014 Express using the ________ dialog box.
SQL statements can be run individually or as part of a related group of SQL statements
known as a(n) ________.
Use the database below to answer the following question.
GENERAL SALES DATABASE:
SALESREP
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.
When using Microsoft Access 2013, how do we create a switchboard?
What is a reporting system?
Why do computers fail?