Deck 1: Clientserver Databases and the Oracle10g Relational Database

Question 1

NULL is a valid value for a primary key.

Answer 1

False

Question 2

Relationships between entities in database tables are maintained using key fields.

Answer 2

True

Question 3

A student can take many different classes in the same term,and each class can be composed of many different students;this is an example of a many-to-many relationship.

Answer 3

True

Question 4

A shorthand method of identifying a table and its contents is to give the name of the table followed by a list of the column names and data types,separated by commas,within a set of square brackets.

Question 5

A DBMS is usually administered by several programmers.

Question 6

A composite key usually comprises fields that are foreign keys in other tables.

Question 7

In an ER diagram a 1:M relationship shows a simple straight line between two entities.

Question 8

A candidate key for a database table can change often as long as it is unique.

Question 9

First normal form means that the data has been organized in such a manner that it has a primary key and no repeating groups.

Question 10

A foreign key value must exist in the table where it is a primary key.

Question 11

Redundant data is a big problem because it can become inconsistent.

Question 12

The purpose of normalization is to store data efficiently in the least possible amount of space.

Question 13

A customer database table with columns first_name,last_name,and phone_number would probably need to use a surrogate key.

Question 14

During the design of the actual database tables,the N:M relationship is broken down into a series of two or more 1:M relationships through the use of a linking table in the process of normalization.

Question 15

In a data file,a record contains one piece of information such as a person's last name.

Question 16

There are two main tasks involved with the design of a database: developing an entity-relationship (ER)model and regulating the database tables.

Question 17

Oracle can automatically generate surrogate keys.

Question 18

Database design is usually a very simple task since it is always obvious what tables should be created and how they are related.

Question 19

A relational database was the earlier type of database,but is no longer used in modern computing.

Question 20

Data is considered to be normalized as long as a primary key has been designated.

Question 21

Why is an address a bad choice for a primary key?

A)it can change
B)it is too long
C)it contains letters and numbers
D)not everyone has an address

Question 22

It is not necessary to specify a data type for all database columns - only the ones that you want the database to perform error checking on.

Question 23

A personal database should only be used for non-mission-critical applications.

Question 24

A terminal is a program that requests and uses server resources.

Question 25

If your database table has a lot of redundant data,how can you fix it?

A)delete the redundant data
B)eliminate the table
C)split the table into two and use a foreign key
D)split the table into two and use a composite key

Question 26

During the normalization process,it is common to decrease the number of tables in the database design.

Question 27

The final step in the normalization process is to convert the tables to fourth normal form (4NF).

Question 28

Who typically installs and maintains a database?

A)the project leader
B)a manager
C)a dba
D)any programmer

Question 29

Which data type do surrogate keys have?

A)numeric
B)boolean
C)character
D)text

Question 30

MS Access is an example of a client/server database.

Question 31

Personal databases are preferred for database applications that retrieve and manipulate small amounts of data from databases containing large numbers of records.

Question 32

What type of key may be helpful in eliminating redundant data from a table?

A)link
B)foreign
C)duplicate
D)composite

Question 33

In a data file,fields are also called ____.

A)columns
B)records
C)rows
D)entities

Question 34

It is possible to use a personal database in a multiuser environment.

Question 35

What is the preferred data type for primary key fields?

A)text
B)date
C)numeric
D)character

Question 36

A transitive dependency means that the fields within the table are dependent only on part of the primary key.

Question 37

When two fields are combined to form a unique value,this is known as a ____ key.

A)double
B)composite
C)surrogate
D)foreign

Question 38

Most modern databases are ____ databases.

A)hierarchical
B)relational
C)object-oriented
D)structured

Question 39

Client/server databases create a lot of network traffic because the entire database is sent between the client and server for every request.

Question 40

If no candidate keys exist in a table,which of the following is used?

A)surrogate key
B)dummy key
C)primary key
D)index key

Question 41

A ____ does not perform any processing - it sends keyboard input and displays output from a central computer.

A)workstation
B)server
C)terminal
D)laptop

Question 42

What is meant by the term "transaction processing"?

A)processing over a network
B)processing by a bank or other financial institution
C)grouping database changes into one unit of work that must succeed or fail together
D)pre-processing data with a separate program before it is saved in the database

Question 43

A ____ key is any column that could be used as the primary key.

A)surrogate
B)foreign
C)possible
D)candidate

Question 44

Which normal form is the highest level usually achieved by database designers?

A)unnormalized
B)first normal form
C)second normal form
D)third normal form

Question 45

How many users typically use a personal database?

A)1
B)5
C)20
D)4000

Question 46

Which of the following characterizes unnormalized data?

A)does not have a foreign key identified
B)does not have a primary key identified and/or contains repeating groups
C)has transitive dependencies
D)has partial dependencies

Question 47

When a personal database is shared by more than one user,where do the database files typically reside?

A)on one user's workstation
B)on the Internet
C)on a file server
D)on a cd

Question 48

A field is also called a(n)____.

A)row
B)column
C)table
D)item

Question 49

The name of the utility which handles all client and server communication in Oracle is ____.

A)Oracle Server
B)Oracle Net
C)Oracle Socket
D)Oracle Protocol

Question 50

Which of the following is used to represent entities in ER models?

A)squares
B)lines
C)circles
D)diamonds

Question 51

In a relational database which of the following allows a user to interact with the database?

A)database applications
B)dba
C)database server process
D)database server

Question 52

A ____ key is a field in a relational database table whose value must be unique for each row.

A)foreign
B)primary
C)secondary
D)link

Question 53

What is the term for reversing changes to a database?

A)undo
B)roll back
C)delete
D)backup

Question 54

A(n)____ stores all organizational data in a central location.

A)database administrator
B)record
C)database
D)index

Question 55

Which of the following is the utility used for creating and testing queries in Oracle 10g?

A)Forms Builder
B)Reports Builder
C)SQL*Plus
D)EnterpriseManager

Question 56

What is the definition of a server?

A)an expensive computer
B)a computer with more than one processor
C)a computer that shares resources with other computers
D)a computer that is used by many people

Question 57

What is a disadvantage of using a personal database over a network?

A)slow
B)creates a lot of network traffic
C)hard to save data
D)not secure

Question 58

In database terminology,a(n)____ is an object about which you want to store data.

A)component
B)record
C)file
D)entity

Question 59

Which relationship type cannot be physically represented in the database and requires the use of a link table?

A)one-to-one
B)many-to-one
C)one-to-many
D)many-to-many

Question 60

A ____ dependency means that a field is dependent on another field within the table that is not the primary key field.

A)indirect
B)direct
C)transitive
D)partial

Question 61

In a data file,a(n)____________________ is a collection of related fields that contain related information.

Question 62

A ____ key is a column that you create to be the record's primary key identifier.

A)foreign
B)secondary
C)surrogate
D)composite

Question 63

It is best to use ____________________ values for primary keys rather than text values.

Question 64

In a relational database,relationships among entities are established through ____________________ fields.

Question 65

A(n)____________________ database stores data in tabular format.

Question 66

In a database,a(n)____________________ is an object about which you want to store data.

Question 67

A ____ key is a unique key that you create by combining two or more columns.

A)composite
B)primary
C)foreign
D)secondary

Question 68

____ relationships are rare in a relational database;usually you work with ____ relationships.

A)One-to-many,one-to-one
B)One-to-one,one-to-many
C)One-to-one,many-to-one
D)Many-to-one,many-to-many

Question 69

A(n)____________________ key has no real relationship to the row to which it is assigned,other than to identify the row uniquely.

Question 70

A(n)____________________ is a sequential list of numbers that the database automatically generates and that guarantee that each primary key value will be unique.

Question 71

____ data takes up extra storage space.

A)Inconsistent
B)Redundant
C)Overused
D)Foreign

Question 72

The Microsoft Access personal database stores all data for a database in a single file with a(n)____ extension.

A)doc
B)xls
C)mdb
D)odb

Question 73

To connect information about different entities,you must create ____,which are links that show how different records are related.

A)relationships
B)records
C)rows
D)foreign keys

Question 74

As a general rule,database developers should use a personal database only for ____ applications.

A)business
B)experimental
C)mission-critical
D)non-mission-critical

Question 75

A ____ is a computer that shares its resources with other computers.

A)client
B)server
C)parallel
D)user

Question 76

In Oracle,you can use a(n)____ to automatically generate surrogate keys.

A)algorithm
B)generating key
C)link
D)sequence

Question 77

In a data file describing a student,each characteristic of the student such as first name,last name,telephone number is known as a(n)____________________.

Question 78

A(n)____________________ stores all organizational data in a central location.

Question 79

In a database,the ______________________________ performs all routine data handling operations.

Question 80

A table is in 2NF if it fulfills these two conditions: it is in 1NF,and it has ____ dependencies.

A)no partial
B)no total
C)all partial
D)all total