Intro to Database Development

Where is the best place for a database's metadata to be stored?

A. In the database application
B. On a thumb drive
C. In the database 
D. In a fireproof safe

What is the purpose of a database application?

A. To answer user questions about database theory
B. To make it easy for human users to communicate with a database
C. To provide steady employment for application developers
D. To avoid having to learn SQL

What language provides all the facilities you need to create, maintain, manipulate, and protect a database?

A. Visual Basic
B. SQL
C. Java
D. C++

Which of the following is a component of a database system?

A. The user
B. The operating system
C. The CD-ROM drive
D. The modem

Which database model is in the most widespread use today?

A. The relational model
B. The hierarchical model
C. The CODASYL DTBG model
D. The object-relational model

What must user documentation do?

A. Explain the underlying logic behind the application
B. Teach the user a database programming language
C. Describe all the functions the application is capable of and how to perform them
D. Describe the database structure

What are the four principal components of the E-R Model?

A. Entities, Relationships, Tables, and Keys
B. Tuples, Attributes, Entities, and Relationships
C. Relationships, Keys, Entities, and Attributes
D. Relationships, Identifiers, Attributes, and Entities

Most systems can be modeled with the E-R modeling system using relationships of how many degrees?

A. Two degrees
B. Six degrees of connection
C. Three degrees
D. One degree

What specific aspect of a database system does cardinality refer to?

A. The most important entities in a system
B. The number of attributes in an entity
C. Entities
D. Relationships

In a corporation, whose job is it to keep centralized database systems running smoothly?

A. The analysts who generate reports based on the data
B. The client who acquired the system
C. The information technology department
D. The clerks who enter data into the system

When replacing an existing system, how can you tell what parts of the old system are obsolete and should not be reimplemented?

A. Consult the old system's documentation
B. Consult the users
C. Examine existing reports
D. Examine existing data entry screens

What does the statement of requirements protect the developer from?

A. Feature creep
B. Difficult technical problems
C. Client bankruptcy
D. 12 hour workdays

What is another name for attribute?

A. A tuple
B. A column
C. A row
D. A table

Which of the following is characteristics of a table in First Normal Form?

A. Two rows may be identical
B. Each cell may contain one and only value
C. Entries in a column may be found of different kinds
D. The rows in a table must be sorted in either alphabetical or reverse alphabetical order

What is the relationship between two attributes of a relation called, when one attribute determines the value of the other attribute?

A. A functional dependency
B. A modification anomaly
C. A primary key
D. A determinant

What kind of key must uniquely identify each tuple in a relation?

A. Foreign key
B. Composite key
C. Primary key
D. Secondary key

Which kind of binary relationship is the most complex?

A. One-to-one
B. Many-to-one
C. Many-to-many
D. One-to-many

What is the intersection relation used for?

A. To join two unrelated relations
B. To decompose a many-to-many relationship
C. To simplify an E-R diagram
D. To establish the maximum cardinality of a relationship

To create a table with Microsoft Access, what must you specify?

A. Constraints
B. Number of rows
C. The Field Name and Data Type of at least one field
D. The Description of at least one field

What problem might occur if referential integrity is not enforced?

A. Individual table records may become corrupted
B. Deletion of table records will be prevented
C. Records in a table on the many side of a relationship may become orphans
D. Modification anomalies may crop up in tables

What is the main disadvantage of using the Form Wizard to create data entry forms?

A. It restricts the choice of form layouts
B. It does not provide for the entry of Currency data
C. It is harder to use that form creation from scratch
D. The Wizard was designed for creating display forms, not data entry forms

What sublanguage of SQL do you use to create the structure of a database?

A. DDL
B. DCL
C. DRL
D. DML

When you are creating a table with an SQL statement, what does PRIMARY KEY act as?

A. A table constraint
B. A value specifier
C. A determinant
D. A column constraint

What SQL statement should you use to add a new column to a table?

A. ALTER TABLE
B. UPDATE TABLE
C. INSERT COLUMN
D. CREATE TABLE

Why build a database application if you already have a fully functional database?

A. You cannot create printed reports based on the database without an application
B. You cannot ask questions of a database without an application
C. An application makes it easier for a lesser-skilled person to operate on a database
D. You cannot perform a multi-table query without an application

What tool should you use to create professional-looking forms?

A. The Application Wizard
B. The Forms Wizard
C. The Report Wizard
D. Design view

What part of an Access system is essential in order for you to create a query?

A. A form
B. A report
C. A table
D. An application

Which of the following is a database design problem?

A. A hacker scrambling your business's databases files
B. A newly-transferred employee making a procedural mistake
C. A competitor obtaining the business's customer list
D. Improperly linking the tables in a multitable database

Which of the following can a database owner grant to a grantee?

A. The ability to describe a table record
B. The ability to change a table record
C. The ability to create an index
D. The ability to delete a table lock.l

Contention among users for database access is mediated by a collection of locks. Which kind of lock has the least effect on system performance?

A. A record lock 
B. A database lock
C. A prevent read lock
D. A table lock

What language or combination of languages contain all the functionality you need to write a major database application?

A. Java
B. C++ and SQL
C. Java and Visual basic
D. SQL

What kind of driver is tailored to communicate with one specific type of data source?

A. An ODBC driver
B. A native driver
C. An OLEDB driver
D. A network driver

How is a three tier client/server system similar to a Web-based database system?

A. Both have a client system, a database server system, and a network/Web server system
B. Both use a browser such as Internet Explorer to access the database
C. Both are equally vulnerable to hacker attack
D. In both cases the application code resides on the network/Web server

What are the domain experts most knowledgeable about?

A. The function that needs to be performed by a database system
B. Computer network hardware
C. Application software
D. Database management systems

What is a good way to get early customer feedback on your development effort?

A. Ask frequent questions to confirm your understanding of what the customer wants
B. Send the customer weekly status reports
C. Demonstrate a prototype of the system to the customer
D. Show the customer your first 100 lines of code

What is scope creep?

A. A database development effort that takes much longer than originally planned
B. A project that is so large and complex that it is frightening to a developer
C. The expansion of the size of a project beyond what was originally agreed, but with no increase in budget or time to completion
D. An astronomical instrument that gradually drifts out of alignment