|
I know that you guys can help me with this. I have 3 hours to finish it but
I`m not that good with this like you. I`ll appreciate your help. PLSSSSS
1.Where is the best place for a database's metadata to be stored?
a. In the database application.
b. In the database.
c. On a floppy disk.
d. In a fireproof safe.
2.What is the purpose of a database application?
a.To avoid having to learn SQL.
b.To make it easy for human users to communicate with a database.
c. To provide steady employment for application developers.
d. To answer user questions about database theory.
3.What language provides all the facilities you need to create, maintain, manipulate, and protect a database?
a. C++.
b. Visual Basic.
c. Java.
d. SQL.
4.Which of the following is a component of a database system?
a.The user.
b. The modem.
c. The operating system.
d. The CD-ROM drive.
5.Which database model is in the most widespread use today?
a. The CODASYL DBTG model.
b. The relational model.
c. The hierarchical model.
d. The object-relational model.
6.What must user documentation do?
a. Explain the underlying logic behind the application.
b.Describe the database structure.
c. Teach the user a database programming language.
d. Describe all the functions the application is capable of and how to perform them.
7.What are the four principal components of the E-R Model?
a.Relationships, Keys, Entities, and Attributes.
b.Relationships, Identifiers, Attributes, and Entities.
c.Tuples, Attributes, Entities, and Relationships.
d. Entities, Relationships, Tables, and Keys.
8.Most systems can be modeled with the E-R modeling system using relationships of how many degrees?
a.Six degrees of connection.
b. Three degrees.
c. Two degrees.
d. One degree.
9.What specific aspect of a database system does cardinality refer to?
a.Entities.
b. Relationships.
c. The number of attributes in an entity.
d. The most important entities in a system.
10.In a corporation, whose job is it to keep centralized database systems running smoothly?
a.The client who acquired the system.
b. The clerks who enter data into the system.
c. The information technology department.
c. The analysts who generate reports based on the data.
11.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 data entry screens.
d. Examine existing reports.
--------------------------------------------------------------------------------
12.What does the statement of requirements protect the developer from?
12 hour workdays.
Feature creep.
Difficult technical problems.
Client bankruptcy.
--------------------------------------------------------------------------------
13.What is another name for attribute?
A table.
A tuple.
A row.
A column.
--------------------------------------------------------------------------------
14.Which of the following is characteristic of a table in First Normal Form?
Two rows may be identical.
Entries in a column may be of different kinds.
Each cell may contain one and only one value.
The rows in a table must be sorted in either alphabetical or reverse alphabetical order.
--------------------------------------------------------------------------------
15.What is the relationship between two attributes of a relation called, when one attribute determines the value of the other attribute?
A determinant.
A functional dependency.
A primary key.
A modification anomaly.
--------------------------------------------------------------------------------
16.What kind of key must uniquely identify each tuple in a relation?
Composite key.
Foreign key.
Primary key.
Secondary key.
--------------------------------------------------------------------------------
17.Which kind of binary relationship is the most complex?
Many-to-one.
One-to-one.
One-to-many.
Many-to-many.
--------------------------------------------------------------------------------
18.What is an intersection relation used for?
To decompose a many-to-many relationship.
To establish the maximum cardinality of a relationship.
To join two unrelated relations.
To simplify an E-R diagram.
--------------------------------------------------------------------------------
19.To create a table with Microsoft Access, what must you specify?
The Description of at least one field.
The Field Name and Data Type of at least one field.
Number of rows.
Constraints.
--------------------------------------------------------------------------------
20.What problem might occur if referential integrity is not enforced?
Records in a table on the many side of a relationship may become orphans.
Modification anomalies may crop up in tables.
Deletion of table records will be prevented.
Individual table records may become corrupted.
--------------------------------------------------------------------------------
21.What is the main disadvantage of using the Form Wizard to create data entry forms?
It does not provide for the entry of Currency data.
It restricts the choice of form layouts.
It is harder to use than form creation from scratch.
The Wizard was designed for creating display forms, not data entry forms.
--------------------------------------------------------------------------------
22.Which sublanguage of SQL do you use to create the structure of a database?
DML.
DCL.
DDL.
DRL.
--------------------------------------------------------------------------------
23.When you are creating a table with an SQL statement, what does PRIMARY KEY act as?
A value specifier.
A table constraint.
A column constraint.
A determinant.
--------------------------------------------------------------------------------
24.What SQL statement should you use to add a new column to a table?
CREATE TABLE.
INSERT COLUMN.
UPDATE TABLE.
ALTER TABLE.
--------------------------------------------------------------------------------
25.Why build a database application if you already have a fully functional database?
You cannot ask questions of a database without an application.
You cannot create printed reports based on the database without an application.
An application makes it easier for a lesser-skilled person to operate on a database.
You cannot perform a multi-table query without an application.
--------------------------------------------------------------------------------
26.What tool should you use to create professional-looking forms?
Design view.
The Forms Wizard.
The Application Wizard.
The Report Wizard.
--------------------------------------------------------------------------------
27.What part of an Access system is essential in order for you to create a query?
A form.
An application.
A report.
A table.
--------------------------------------------------------------------------------
28.Which of the following is a database design problem?
A competitor obtaining the business's customer list.
A hacker scrambling your business's database files.
A newly-transferred employee making a procedural mistake.
Improperly linking the tables in a multitable database.
--------------------------------------------------------------------------------
29.Which of the following can a database owner grant to a grantee?
The ability to create an index.
The ability to change a table record.
The ability to delete a table lock.I
The ability to describe a table record.
--------------------------------------------------------------------------------
30.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 record lock.
A table lock.
A database lock.
A prevent read lock.
--------------------------------------------------------------------------------
31.What language(s) might you use to write a major database application?
C++.
SQL.
C++ and SQL.
Java and Visual Basic.
--------------------------------------------------------------------------------
32.What kind of driver is tailored to communicate with one specific type of data source?
An ODBC driver.
An OLEDB driver.
A native driver.
A network driver.
--------------------------------------------------------------------------------
33.How is a three tier client/server system similar to a Web-based database system?
Both have a client system, a database server system, and a network/Web server system.
Both use a browser such as Internet Explorer to access the database.
Both are equally vulnerable to hacker attack.
In both cases the application code resides on the network/Web server.
--------------------------------------------------------------------------------
34.What are domain experts most knowledgeable about?
Computer network hardware.
The function that needs to be performed by a database system.
Database management systems.
Application software.
--------------------------------------------------------------------------------
35.What is a good way to get early customer feedback on your development effort?
Show the customer your first 100 lines of code.
Demonstrate a prototype of the system to the customer.
Send the customer weekly status reports.
Ask frequent questions to confirm your understanding of what the customer wants.
--------------------------------------------------------------------------------
36.What is scope creep?
An astronomical instrument that gradually drifts out of alignment.
A project that is so large and complex that it is frightening to a developer.
The expansion of the size of a project beyond what was originally agreed, but with no increase in budget or time to completion.
A database development effort that takes much longer than originally planned
|
