Dba 110 Final Study Guide 2d5d63

• A DBMS lets you assign s to ____. Answer Selected Answer: Correct Answer: •

attribut es

groups Question 2

2.5 out of 2.5 points

A(n) ____ frees programmers who write database access programs from having to engage in mundane data manipulation activities, such as adding new data and deleting existing data. Answer Selected Answer:

Correct Answer:

•

DBM S

DBM S

Question 3

2.5 out of 2.5 points

A(n) ____ is a person, place, object, event, or idea for which you want to store and process data. Answer Selected Answer:

Correct Answer:

entit y

entit

y •

Question 4

2.5 out of 2.5 points

A visual way to represent a database is with a(n) ____. Answer Selected Answer:

Correct Answer:

•

entity-relationship diagram

entity-relationship diagram

Question 5

2.5 out of 2.5 points

During the ____ process, a database expert determines the structure of the required database. Answer Selected Answer:

Correct Answer:

•

database design

database design

Question 6

2.5 out of 2.5 points

One disadvantage of a database system is ____. Answer Selected Answer:

a larger file

size Correct Answer:

•

a larger file size

Question 7

2.5 out of 2.5 points

The ____ of an entity become the columns in the database table. Answer Selected Answer:

Correct Answer:

•

attribut es

attribut es

Question 8

2.5 out of 2.5 points

An association between entities is known as a(n) ____. Answer Selected Answer:

Correct Answer:

•

relations hip

relations hip

Question 9

2.5 out of 2.5 points

Popular ____ include Access, Oracle, DB2, MySQL, and SQL Server. Answer

Selected Answer:

Correct Answer:

•

DBM Ss

DBM Ss

Question 10

2.5 out of 2.5 points

Storing the same data in more than one place is called ____. Answer Selected Answer:

Correct Answer:

redundan cy

redundan cy

Tuesday, September 6, 2011 2:28:42 PM EDT OK false

•

Question 1

2.5 out of 2.5 points

Two tables are considered to be ____ compatible if they have the same number of columns and their corresponding columns represent the same type of data. Answer Selected Answer:

Correct Answer:

unio n

unio

n •

Question 2

2.5 out of 2.5 points

The product of two tables is also called the ____ product. Answer Selected Answer:

Correct Answer:

•

Cartesi an

Cartesi an

Question 3

2.5 out of 2.5 points

Using the product operator, if table A has 4 rows and table B has 4 rows, the number of rows in the product of these two tables is ____. Answer Selected Answer:

Correct Answer:

•

1 6

1 6

Question 4

2.5 out of 2.5 points

Rows are also called ____. Answer Selected Answer:

tupl es

Correct Answer:

•

tupl es

Question 5

2.5 out of 2.5 points

You can restrict the output from a to include only certain columns by using the ____ command. Answer Selected Answer:

Correct Answer:

•

PROJE CT

PROJE CT

Question 6

0 out of 2.5 points

A query that changes data is a(n) ____ query. Answer Selected Answer: Correct Answer:

•

upda te

upda te

Question 7

2.5 out of 2.5 points

When duplicate column names exist in a database and you need to indicate the column to which you are referring, ____. Answer

Selected Answer:

Correct Answer:

•

write both the table name and the column name, separated by a period

write both the table name and the column name, separated by a period

Question 8

2.5 out of 2.5 points

The ____ key of a table is the column or collection of columns that uniquely identifies a given row in that table. Answer Selected Answer:

Correct Answer:

•

prima ry

prima ry

Question 9

2.5 out of 2.5 points

The compound criteria (conditions) are created by using ____. Answer Selected Answer:

Correct Answer:

•

AND or OR

AND or OR

Question 10

2.5 out of 2.5 points

Count, Sum, Avg, Max, and Min are a few of the built-in statistics or ____ functions that can be used in a query. Answer Selected Answer:

Correct Answer:

aggreg ate

aggreg ate

Tuesday, September 6, 2011 2:15:29 PM EDT OK •

2.5 out of 2.5 points

Storing the same data in more than one place is called ____. Answer Selected Answer:

Correct Answer:

•

redundan cy

redundan cy

Question 2

2.5 out of 2.5 points

Popular ____ include Access, Oracle, DB2, MySQL, and SQL Server. Answer Selected Answer:

Correct Answer:

DBM Ss

DBM Ss

•

Question 3

2.5 out of 2.5 points

A(n) ____ frees programmers who write database access programs from having to engage in mundane data manipulation activities, such as adding new data and deleting existing data. Answer Selected Answer:

Correct Answer:

•

DBM S

DBM S

Question 4

2.5 out of 2.5 points

A(n) ____ is the computer counterpart to an ordinary paper file you might keep in a file cabinet or an ing ledger. Answer Selected Answer:

Correct Answer:

•

data file

data file

Question 5

2.5 out of 2.5 points

A good ____ should provide an opportunity for s to incorporate integrity constraints when they design the database. Answer Selected Answer:

DBM S Correct Answer:

•

DBM S

Question 6

2.5 out of 2.5 points

A database has ____ if the data in it satisfies all established integrity constraints. Answer Selected Answer:

Correct Answer:

•

integri ty

integri ty

Question 7

2.5 out of 2.5 points

Which of the following statements is correct? Answer Selected Answer:

Correct Answer:

•

In a nondatabase, file-oriented environment, data is often partitioned into several disted systems with each system having its own collection of files.

In a nondatabase, file-oriented environment, data is often partitioned into several disted systems with each system having its own collection of files.

Question 8

2.5 out of 2.5 points

An association between entities is known as a(n) ____. Answer Selected Answer:

Correct Answer:

•

relations hip

relations hip

Question 9

2.5 out of 2.5 points

____ are screen objects used to maintain, view, and print data from a database. Answer Selected Answer:

Correct Answer:

•

For ms

For ms

Question 10

2.5 out of 2.5 points

During the ____ process, a database expert determines the structure of the required database. Answer Selected Answer:

Correct Answer:

database design

database design

Wednesday, September 7, 2011 2:00:08 PM EDT

OK •

Question 1

2.5 out of 2.5 points

Two tables are considered to be ____ compatible if they have the same number of columns and their corresponding columns represent the same type of data. Answer Selected Answer:

Correct Answer:

•

unio n

unio n

Question 2

2.5 out of 2.5 points

If you are sorting records by more than one field, the more important field is called the ____. Answer Selected Answer:

Correct Answer:

•

primary sort key

primary sort key

Question 3

2.5 out of 2.5 points

Based on the Customer table below, which command lists all information from the table concerning customer 524? CustomerNum CustomerName Street City State Zip 462 Bargains Galore 3829 Central Grove FL 33321

524 Kline’s 838 Ridgeland Filmore FL 33336 Answer Selected Answer:

Correct Answer:

•

SELECT Customer WHERE CustomerNum=524 GIVING Answer

SELECT Customer WHERE CustomerNum=524 GIVING Answer

Question 4

2.5 out of 2.5 points

You can restrict the output from a to include only certain columns by using the ____ command. Answer Selected Answer:

Correct Answer:

•

PROJE CT

PROJE CT

Question 5

2.5 out of 2.5 points

The product of two tables is also called the ____ product. Answer Selected Answer:

Correct Answer:

•

Cartesi an

Cartesi an

Question 6

0 out of 2.5 points

The ____ command within relational algebra takes a vertical subset of a table. Answer Selected Answer: Correct Answer:

•

SELEC T

PROJE CT

Question 7

2.5 out of 2.5 points

The ____ key of a table is the column or collection of columns that uniquely identifies a given row in that table. Answer Selected Answer:

Correct Answer:

•

prima ry

prima ry

Question 8

2.5 out of 2.5 points

The ____ operator is performed by the SUBTRACT command in relational algebra. Answer Selected Answer:

Correct

differen ce

Answer:

•

differen ce

Question 9

2.5 out of 2.5 points

A ____ query creates a new table using the query results. Answer Selected Answer:

Correct Answer:

•

maketable

maketable

Question 10

0 out of 2.5 points

The ____ operator is used to concatenate every row in the first table with every row in the second table. Answer Selected Answer: Correct Answer:

union

produ ct

Wednesday, September 7, 2011 2:40:15 PM EDT OK •

Question 1

2.5 out of 2.5 points

When you use a name containing a space in Access SQL, you must ____. Answer

Selected Answer:

Correct Answer:

•

enclose it in square brackets

enclose it in square brackets

Question 2

2.5 out of 2.5 points

When rows are grouped, ____. Answer Selected Answer:

Correct Answer:

•

one line of output is produced for each group

one line of output is produced for each group

Question 3

0 out of 2.5 points

Customer ( CustomerNum, CustomerName, Street, City, State, Zip, Balance, CreditLimit, RepNum ) Based on the code above, list the number, name, and balance of all customers with balances greater than or equal to $1,000 and less than or equal to $5,000. Answer Selected Answer: Correct Answer:

SELECT CustomerName, Balance FROM Customer WHERE Balance BETWEEN 1000 AND 5000 ;

SELECT CustomerNum, CustomerName, Balance FROM Customer WHERE Balance BETWEEN 1000 AND 5000 ;

•

Question 4

2.5 out of 2.5 points

Customer ( CustomerNum, CustomerName, Street, City, State, Zip, Balance, CreditLimit, RepNum ) Based on the code above, list the number, name, street, and credit limit of all customers. Order the customers by name within descending credit limit. Answer Selected Answer:

Correct Answer:

•

SELECT CustomerNum, CustomerName, Street, CreditLimit FROM Customer ORDER BY CreditLimit DESC, CustomerName ;

SELECT CustomerNum, CustomerName, Street, CreditLimit FROM Customer ORDER BY CreditLimit DESC, CustomerName ;

Question 5

2.5 out of 2.5 points

The basic form of an SQL retrieval command is ____. Answer Selected Answer:

Correct Answer:

•

SELECT-FROMWHERE

SELECT-FROMWHERE

Question 6

0 out of 2.5 points

You can save the results of a query as a table by including the ____ clause in the query. Answer

Selected Answer: Correct Answer: •

UPDA TE

INTO

Question 7

2.5 out of 2.5 points

Student (StudentID, FirstName, LastName, Street, City, State, Zip) Based on the code above, list the complete student table. Answer Selected Answer:

Correct Answer:

•

SELECT * FROM Student ;

SELECT * FROM Student ;

Question 8

2.5 out of 2.5 points

Customer ( CustomerNum, CustomerName, Street, City, State, Zip, Balance, CreditLimit, RepNum ) Based on the code above, list the number, name, and available credit for all customers with credit limits that exceed their balances. Answer Selected Answer:

Correct Answer:

SELECT CustomerNum, CustomerName, CreditLimit-Balance AS AvailableCredit FROM Customer WHERE CreditLimit>Balance ;

SELECT CustomerNum, CustomerName, CreditLimit-Balance AS AvailableCredit FROM Customer WHERE CreditLimit>Balance ;

•

Question 9

2.5 out of 2.5 points

When used after the word SELECT, the ____ symbol indicates that you want to include all fields in the query results in the order in which you described them to the DBMS when you created the table. Answer Selected Answer: Correct Answer: •

*

*

Question 10

2.5 out of 2.5 points

In MySQL, the ____ is used as a wildcard to represent any collection of characters. Answer Selected Answer:

Correct Answer:

percent sign (%)

percent sign (%)

Tuesday, September 13, 2011 6:06:14 PM EDT OK •

Question 1

2.5 out of 2.5 points

When used after the word SELECT, the ____ symbol indicates that you want to include all fields in the query results in the order in which you described them to the DBMS when you created the table. Answer

Selected Answer: Correct Answer: •

*

*

Question 2

2.5 out of 2.5 points

Part (PartNum, Description, OnHand, Class, Warehouse, Price ) Based on the code above, list the descriptions of all parts that are not in Warehouse 3. Answer Selected Answer:

Correct Answer:

•

SELECT Description FROM Part WHERE NOT Warehouse=’3’ ;

SELECT Description FROM Part WHERE NOT Warehouse=’3’ ;

Question 3

2.5 out of 2.5 points

Many versions of SQL require you to end a command with a ____. Answer Selected Answer:

Correct Answer:

•

semicolon (;)

semicolon (;)

Question 4

2.5 out of 2.5 points

Customer ( CustomerNum, CustomerName, Street, City, State, Zip, Balance, CreditLimit, RepNum ) Based on the code above, list the number, name, and complete address of every customer located on a street that contains the letters “Oxford”. Answer Selected Answer:

Correct Answer:

•

SELECT CustomerNum, CustomerName, Street, City, State, Zip FROM Customer WHERE Street LIKE “%Oxford%” ;

SELECT CustomerNum, CustomerName, Street, City, State, Zip FROM Customer WHERE Street LIKE “%Oxford%” ;

Question 5

2.5 out of 2.5 points

Part (PartNum, Description, OnHand, Class, Warehouse, Price ) Based on the code above, find how many parts are in item class HW. Answer Selected Answer:

Correct Answer:

•

SELECT COUNT(*) FROM Part WHERE Class=’HW’ ;

SELECT COUNT(*) FROM Part WHERE Class=’HW’ ;

Question 6

2.5 out of 2.5 points

You can save the results of a query as a table by including the ____ clause in the query. Answer Selected Answer:

INT

O Correct Answer:

•

INT O

Question 7

2.5 out of 2.5 points

To add new data to a table, use the ____ command. Answer Selected Answer:

Correct Answer:

•

INSE RT

INSE RT

Question 8

2.5 out of 2.5 points

Customer ( CustomerNum, CustomerName, Street, City, State, Zip, Balance, CreditLimit, RepNum ) Based on the code above, list the number, name, street, and credit limit of all customers. Order the customers by name within descending credit limit. Answer Selected Answer:

Correct Answer:

•

SELECT CustomerNum, CustomerName, Street, CreditLimit FROM Customer ORDER BY CreditLimit DESC, CustomerName ;

SELECT CustomerNum, CustomerName, Street, CreditLimit FROM Customer ORDER BY CreditLimit DESC, CustomerName ;

Question 9

2.5 out of 2.5 points

To use a wildcard, include the ____ operator in the WHERE clause. Answer Selected Answer:

Correct Answer:

•

LIK E

LIK E

Question 10

2.5 out of 2.5 points

Student (StudentID, FirstName, LastName, Street, City, State, Zip) Based on the code above, find the name of the student whose ID is 1167. Answer Selected Answer:

Correct Answer:

SELECT FirstName, LastName FROM Student WHERE StudentID=’1167’ ;

SELECT FirstName, LastName FROM Student WHERE StudentID=’1167’ ;

Tuesday, September 13, 2011 11:45:24 PM EDT OK •

0 out of 2.5 points

The statement, ____, removes the table LargeCust from a DBMS. Answer Selected Answer: Correct Answer:

DELETE TABLE LargeCust ;

DROP TABLE LargeCust ;

•

Question 2

2.5 out of 2.5 points

The CHECK clause can be included in the ____ command. Answer Selected Answer:

Correct Answer:

•

CREATE TABLE

CREATE TABLE

Question 3

2.5 out of 2.5 points

In SQL, you use the CHECK clause to enforce ____ integrity. Answer Selected Answer:

Correct Answer:

•

legalvalues

legalvalues

Question 4

2.5 out of 2.5 points

A(n) ____ is an action that occurs automatically in response to an associated database operation such as an INSERT, UPDATE, or DELETE command. Answer Selected Answer:

trigg er

Correct Answer:

•

trigg er

Question 5

0 out of 2.5 points

To create the primary key clause for the Orders table on the OrderNum and PartNum fields, the correct statement is ____. Answer Selected Answer: Correct Answer: •

PRIMARY KEY (Orders, OrderNum, PartNum)

PRIMARY KEY (OrderNum, PartNum)

Question 6

2.5 out of 2.5 points

To create an index for the Customer table named RepBal with the keys RepNum and Balance and with the balances listed in descending order, the command is ____. Answer Selected Answer:

Correct Answer:

•

CREATE INDEX RepBal ON Customer (RepNum, Balance DESC) ;

CREATE INDEX RepBal ON Customer (RepNum, Balance DESC) ;

Question 7

2.5 out of 2.5 points

The ____ statement will take away privileges to the database. Answer

Selected Answer:

Correct Answer:

•

REVO KE

REVO KE

Question 8

2.5 out of 2.5 points

To use a stored procedure in MySQL, a enters the word _____ followed by the procedure name. Answer Selected Answer:

Correct Answer:

•

CAL L

CAL L

Question 9

2.5 out of 2.5 points

Essentially, setting the value in a given field to ____ is similar to not entering a value in it at all. Answer Selected Answer:

Correct Answer:

•

nu ll

nu ll

Question 10

2.5 out of 2.5 points

A trigger is stored and compiled on the ____. Answer Selected Answer:

Correct Answer:

serv er

serv er

Friday, September 23, 2011 5:29:48 AM EDT OK •

2.5 out of 2.5 points

To create an index for the Customer table named RepBal with the keys RepNum and Balance and with the balances listed in descending order, the command is ____. Answer Selected Answer:

Correct Answer:

•

CREATE INDEX RepBal ON Customer (RepNum, Balance DESC) ;

CREATE INDEX RepBal ON Customer (RepNum, Balance DESC) ;

Question 2

2.5 out of 2.5 points

The statement, ____, removes the table LargeCust from a DBMS. Answer Selected Answer:

Correct Answer:

DROP TABLE LargeCust ;

DROP TABLE LargeCust ;

•

Question 3

2.5 out of 2.5 points

If you anticipate running a particular query often, you can improve overall performance by saving the query in a special file called a(n) ____. Answer Selected Answer:

Correct Answer:

•

stored procedure

stored procedure

Question 4

2.5 out of 2.5 points

In Access, many macro actions require additional information, called _____ to complete the action. Answer Selected Answer:

Correct Answer:

•

argume nts

argume nts

Question 5

2.5 out of 2.5 points

In SQL, you use the CHECK clause to enforce ____ integrity. Answer Selected Answer:

legalvalues

Correct Answer:

•

legalvalues

Question 6

2.5 out of 2.5 points

To use a stored procedure in MySQL, a enters the word _____ followed by the procedure name. Answer Selected Answer:

Correct Answer:

•

CAL L

CAL L

Question 7

2.5 out of 2.5 points

The CHECK clause can be included in the ____ command. Answer Selected Answer:

Correct Answer:

•

CREATE TABLE

CREATE TABLE

Question 8

2.5 out of 2.5 points

The SQL command for deleting the Warehouse field from the Part table is ____. Answer

Selected Answer:

Correct Answer:

•

ALTER TABLE Part DROP COLUMN Warehouse ;

ALTER TABLE Part DROP COLUMN Warehouse ;

Question 9

2.5 out of 2.5 points

In MySQL, you use the _____ command to produce a list of tables. Answer Selected Answer:

Correct Answer:

•

SHOW TABLES

SHOW TABLES

Question 10

2.5 out of 2.5 points

To insert a new field in a table, the ____ keyword should be used with the ALTER TABLE command. Answer Selected Answer:

Correct Answer:

AD D

AD D

Friday, September 23, 2011 6:02:12 AM EDT OK •

2.5 out of 2.5 points

From all the ____ keys, one is chosen to be the primary key. Answer Selected Answer:

Correct Answer:

•

candida te

candida te

Question 2

0 out of 2.5 points

Second normal form can be defined as a table that is in first normal form but that contains no ____. Answer Selected Answer: Correct Answer:

•

nonkey columns

partial dependencies

Question 3

2.5 out of 2.5 points

A table is in first normal form if it does not contain ____. Answer Selected Answer:

Correct Answer:

•

repeating groups

repeating groups

Question 4

2.5 out of 2.5 points

An alternate key is a ____. Answer Selected Answer:

Correct Answer:

•

column that could be a primary key but was not chosen

column that could be a primary key but was not chosen

Question 5

2.5 out of 2.5 points

A(n) ____ is a column or collection of columns on which all columns in the table are functionally dependent. Answer Selected Answer:

Correct Answer:

•

candidate key

candidate key

Question 6

2.5 out of 2.5 points

Potential problems in the design of a relational database are known as ____. Answer Selected Answer:

Correct Answer:

update anomalies

update anomalies

•

Question 7

2.5 out of 2.5 points

If there is more than one possible choice for the primary key, and one of the possibilities is chosen to be the primary key, the other choices are referred to as ____. Answer Selected Answer:

Correct Answer:

•

alternate keys

alternate keys

Question 8

2.5 out of 2.5 points

The fact that column B is functionally dependent on column A can be written as ____. Answer Selected Answer:

Correct Answer:

•

A® B

A® B

Question 9

2.5 out of 2.5 points

If B (an attribute) is functionally dependent on A, we can also say that ____. Answer Selected Answer:

A functionally

determines B Correct Answer:

•

A functionally determines B

Question 10

2.5 out of 2.5 points

A column is a nonkey column if it is ____. Answer Selected Answer:

Correct Answer:

not a part of the primary key

not a part of the primary key

Friday, October 7, 2011 3:32:10 AM EDT OK

You will only be allowed 2 attempts to take this Quiz. false

•

Question 1

2.5 out of 2.5 points

A table is in fourth normal form when it is in third normal form and there are no ____. Answer Selected Answer:

multivalued dependencies

Correct Answer:

•

multivalued dependencies

Question 2

2.5 out of 2.5 points

If there is more than one possible choice for the primary key, and one of the possibilities is chosen to be the primary key, the other choices are referred to as ____. Answer Selected Answer:

Correct Answer:

•

alternate keys

alternate keys

Question 3

2.5 out of 2.5 points

Another name for a nonkey column is a ____. Answer Selected Answer:

Correct Answer:

•

nonkey attribute

nonkey attribute

Question 4

2.5 out of 2.5 points

From all the ____ keys, one is chosen to be the primary key. Answer

Selected Answer:

Correct Answer:

•

candida te

candida te

Question 5

2.5 out of 2.5 points

____ contains a repeating group. Answer Selected Answer:

Correct Answer:

•

Orders (OrderNum, OrderDate, (PartNum, NumOrdered) )

Orders (OrderNum, OrderDate, (PartNum, NumOrdered) )

Question 6

2.5 out of 2.5 points

Potential problems in the design of a relational database are known as ____. Answer Selected Answer:

Correct Answer:

•

update anomalies

update anomalies

Question 7

2.5 out of 2.5 points

If B (an attribute) is functionally dependent on A, we can also say that ____. Answer Selected Answer:

Correct Answer:

•

A functionally determines B

A functionally determines B

Question 8

2.5 out of 2.5 points

____ normal form has an additional condition that the only determinants the table contains are candidate keys. Answer Selected Answer:

Correct Answer:

•

Thir d

Thir d

Question 9

2.5 out of 2.5 points

A table that contains a repeating group is called a(n) ____. Answer Selected Answer:

Correct Answer:

•

unnormalized relation

unnormalized relation

Question 10

2.5 out of 2.5 points

A(n) ____ is a column or collection of columns on which all columns in the table are functionally dependent. Answer Selected Answer:

Correct Answer:

candidate key

candidate key

Friday, October 7, 2011 3:49:28 AM EDT OK •

0 out of 2.5 points

When deg a database, you might find it helpful to design a(n) ____ to obtain the required information from s. Answer Selected Answer: Correct Answer:

•

E-R diagram

survey form

Question 2

2.5 out of 2.5 points

Independent entities have ____ in an E-R diagram. Answer Selected Answer:

Correct

square corners

Answer:

•

square corners

Question 3

0 out of 2.5 points

In IDEF1X, the ____ is the symbol for category. Answer Selected Answer: Correct Answer: •

rectan gle

circle

Question 4

2.5 out of 2.5 points

A subtype is also called a(n) ____ in IDEF1X terminology. Answer Selected Answer:

Correct Answer:

•

catego ry

catego ry

Question 5

2.5 out of 2.5 points

A(n) ____ is a primary key that consists of a column that uniquely identifies an entity, such as a person’s Social Security number. Answer Selected Answer:

natural key

Correct Answer:

•

natural key

Question 6

2.5 out of 2.5 points

When a DBMS creates a(n) ____ key, it is usually an automatic numbering data type, such as the Access AutoNumber data type. Answer Selected Answer:

Correct Answer:

•

surroga te

surroga te

Question 7

2.5 out of 2.5 points

The properties of the entities you choose as you design the view will become the ____ in the appropriate tables. Answer Selected Answer:

Correct Answer:

•

colum ns

colum ns

Question 8

0 out of 2.5 points

The crucial issue in making the determination between a single many-tomany-to-many relationship and two (or three) many-to-many relationships is the ____. Answer Selected Answer: Correct Answer:

•

data dependence

independenc e

Question 9

2.5 out of 2.5 points

On an E-R diagram, the number closest to the rectangle represents ____ cardinality. Answer Selected Answer:

Correct Answer:

•

maximu m

maximu m

Question 10

0 out of 2.5 points

A(n) ____ is a system-generated primary key that is usually hidden from s. Answer Selected Answer: Correct Answer:

artificial key

surrogate key

Friday, October 21, 2011 12:35:01 AM EDT OK • In IDEF1X, the ____ is the symbol for category. Answer Selected Answer:

Correct Answer:

•

circl e

circl e Question 2

2.5 out of 2.5 points

____ means that an entity has a minimum cardinality of one. Answer Selected Answer:

Correct Answer:

•

The entity is required in the relationship

The entity is required in the relationship

Question 3

2.5 out of 2.5 points

The properties of the entities you choose as you design the view will become the ____ in the appropriate tables. Answer Selected Answer:

colum ns

Correct Answer:

•

colum ns

Question 4

0 out of 2.5 points

On an E-R diagram, the number closest to the relationship represents ____ cardinality. Answer Selected Answer: Correct Answer:

•

maximu m

minimu m

Question 5

2.5 out of 2.5 points

A set of requirements that is necessary to the operations of a particular database is known as a(n) ____. Answer Selected Answer:

Correct Answer:

•

view

view

Question 6

0 out of 2.5 points

A(n) ____ is a system-generated primary key that is usually hidden from s. Answer Selected Answer: Correct Answer:

•

artificial key

surrogate key

Question 7

2.5 out of 2.5 points

After the information-level design is completed, the ____ is the next step. Answer Selected Answer:

Correct Answer:

•

physical-level design

physical-level design

Question 8

2.5 out of 2.5 points

An entity that exists to implement a many-to-many relationship is called a(n) ____. Answer Selected Answer:

Correct Answer:

•

composite entity

composite entity

Question 9

2.5 out of 2.5 points

If each employee works in a single department and each department has only one employee, the relationship between employees and departments is ____. Answer Selected Answer:

Correct Answer:

•

one-toone

one-toone

Question 10

2.5 out of 2.5 points

Independent entities have ____ in an E-R diagram. Answer Selected Answer:

Correct Answer:

square corners

square corners

Friday, October 21, 2011 12:53:06 AM EDT OK •

0 out of 2.5 points

____ integrity implies that the value entered for any field should be consistent with the data type for that field. Answer Selected Answer: Correct

Format

Answer:

•

Data type

Question 2

2.5 out of 2.5 points

____ contain information about table relationships, views, indexes, s, privileges, and replicated data. Answer Selected Answer:

Correct Answer:

•

Catalo gs

Catalo gs

Question 3

2.5 out of 2.5 points

The technique for identifying the person who is attempting to access the DBMS is known as ____. Answer Selected Answer:

Correct Answer:

•

authenticat ion

authenticat ion

Question 4

2.5 out of 2.5 points

A string of characters assigned by the DBA to a database that the must enter to access the database is known as a database ____. Answer

Selected Answer:

Correct Answer:

•

wo rd

wo rd

Question 5

2.5 out of 2.5 points

Data about the data in a database is known as ____. Answer Selected Answer:

Correct Answer:

•

metada ta

metada ta

Question 6

2.5 out of 2.5 points

____ denies access by other s to data while the DBMS processes one 's updates to the database. Answer Selected Answer:

Correct Answer:

•

Locki ng

Locki ng

Question 7

2.5 out of 2.5 points

The DBMS accomplishes ____ by reading the log for the problem transactions and applying the before images to undo their updates. Answer Selected Answer:

Correct Answer:

•

backward recovery

backward recovery

Question 8

2.5 out of 2.5 points

After a DBMS detects a deadlock, the ____ should break the deadlock. Answer Selected Answer:

Correct Answer:

•

DBM S

DBM S

Question 9

2.5 out of 2.5 points

To break a deadlock, the DBMS chooses one deadlocked to be the ____. Answer Selected Answer:

Correct Answer:

•

victi m

victi m

Question 10

2.5 out of 2.5 points

A(n) ____ is a snapshot of certain data in a database at a given moment in time. Answer Selected Answer:

Correct Answer:

vie w

vie w

Sunday, November 6, 2011 2:10:40 AM EST OK

You will only be allowed 2 attempts to take this Quiz. false

•

Question 1

2.5 out of 2.5 points

To break a deadlock, the DBMS chooses one deadlocked to be the ____. Answer Selected Answer:

Correct Answer:

•

victi m

victi m

Question 2

2.5 out of 2.5 points

Data about the data in a database is known as ____. Answer Selected Answer:

Correct Answer:

•

metada ta

metada ta

Question 3

2.5 out of 2.5 points

____ a database reverses encryption. Answer Selected Answer:

Correct Answer:

•

Decrypti ng

Decrypti ng

Question 4

2.5 out of 2.5 points

The DBA usually creates groups of s called ____. Answer Selected Answer:

Correct Answer:

•

workgrou ps

workgrou ps

Question 5

2.5 out of 2.5 points

A(n) ____ is a snapshot of certain data in a database at a given moment in time. Answer Selected Answer:

Correct Answer:

•

vie w

vie w

Question 6

2.5 out of 2.5 points

If two or more s are waiting for the other to release a lock before they can proceed, this is known as a ____. Answer Selected Answer:

Correct Answer:

•

deadlo ck

deadlo ck

Question 7

2.5 out of 2.5 points

____ integrity implies that the value entered for any field should be consistent with the data type for that field. Answer Selected Answer:

Correct Answer:

Data type

Data

type •

Question 8

2.5 out of 2.5 points

In order to accomplish serial processing of updates, many DBMSs use ____. Answer Selected Answer:

Correct Answer:

•

locki ng

locki ng

Question 9

2.5 out of 2.5 points

The technique for identifying the person who is attempting to access the DBMS is known as ____. Answer Selected Answer:

Correct Answer:

•

authenticat ion

authenticat ion

Question 10

2.5 out of 2.5 points

After a DBMS detects a deadlock, the ____ should break the deadlock. Answer Selected Answer:

DBM S

Correct Answer:

DBM S

Sunday, November 6, 2011 2:22:59 AM EST OK •

2.5 out of 2.5 points

After the database designers complete the information-level design, the DBA does the ____-level design. Answer Selected Answer:

Correct Answer:

•

physic al

physic al

Question 2

2.5 out of 2.5 points

Which of the following DBMS evaluation categories does the following question relate to: Is it a simple catalog or can it contain more content, such as information about programs and the various data items these programs access? Answer Selected Answer:

Correct Answer:

•

Data dictionary

Data dictionary

Question 3

2.5 out of 2.5 points

____ integrity is the constraint that says that the values in foreign keys must match values already in the database. Answer Selected Answer:

Correct Answer:

•

Referent ial

Referent ial

Question 4

2.5 out of 2.5 points

After the DBMS is purchased, the ____ has primary responsibility for installation and maintenance. Answer Selected Answer:

Correct Answer:

•

DB A

DB A

Question 5

2.5 out of 2.5 points

Which of the following DBMS evaluation categories does the following question relate to: Does the vendor of the DBMS supply printed or online training manuals and how good are the manuals? Answer Selected Answer:

Correct Answer:

Documentation and training

Documentation and training •

Question 6

2.5 out of 2.5 points

Which of the following DBMS evaluation categories does the following question relate to: How many files can you open at the same time? Answer Selected Answer:

Correct Answer:

•

Limitatio ns

Limitatio ns

Question 7

2.5 out of 2.5 points

Tables with indexes allow faster searches, but slower performance on ____. Answer Selected Answer:

Correct Answer:

•

updat es

updat es

Question 8

2.5 out of 2.5 points

The ____ is responsible for providing training in the use of the DBMS. Answer Selected Answer:

DB

A Correct Answer:

•

DB A

Question 9

2.5 out of 2.5 points

Which of the following DBMS evaluation categories does the following question relate to: Does the DBMS allow partial copies and how does the DBMS handle updates to the same data from two or more replicas? Answer Selected Answer:

Correct Answer:

•

Replication and distributed databases

Replication and distributed databases

Question 10

2.5 out of 2.5 points

The ____ determines the access privileges for all s and enters the appropriate authorization rules in the DBMS catalog to ensure that s access the database only in ways in which they are entitled to do so. Answer Selected Answer:

Correct Answer:

DB A

DB A

Tuesday, November 22, 2011 1:08:21 AM EST OK •

Question 1

2.5 out of 2.5 points

The ____ determines the access privileges for all s and enters the appropriate authorization rules in the DBMS catalog to ensure that s access the database only in ways in which they are entitled to do so. Answer Selected Answer:

Correct Answer:

•

DB A

DB A

Question 2

2.5 out of 2.5 points

Which of the following DBMS evaluation categories does the following question relate to: Is it a simple catalog or can it contain more content, such as information about programs and the various data items these programs access? Answer Selected Answer:

Correct Answer:

•

Data dictionary

Data dictionary

Question 3

2.5 out of 2.5 points

____ converts a table that is in third normal form to a table no longer in third normal form. Answer Selected Answer:

Denormalizat

ion Correct Answer:

•

Denormalizat ion

Question 4

2.5 out of 2.5 points

Which of the following DBMS evaluation categories does the following question relate to: Does the DBMS allow partial copies and how does the DBMS handle updates to the same data from two or more replicas? Answer Selected Answer:

Correct Answer:

•

Replication and distributed databases

Replication and distributed databases

Question 5

2.5 out of 2.5 points

Changing the database design to improve the performance is called ____ the design. Answer Selected Answer:

Correct Answer:

•

tunin g

tunin g

Question 6

2.5 out of 2.5 points

A ____ is a place where a record of certain corporate data is kept. Answer Selected Answer:

Correct Answer:

•

data archive

data archive

Question 7

2.5 out of 2.5 points

Which of the following DBMS evaluation categories does the following question relate to: On what operating system and hardware is the DBMS ed? Answer Selected Answer:

Correct Answer:

•

Limitatio ns

Limitatio ns

Question 8

2.5 out of 2.5 points

The ____ is responsible for providing training in the use of the DBMS. Answer Selected Answer:

Correct Answer:

•

DB A

DB A

Question 9

2.5 out of 2.5 points

Tables with indexes allow faster searches, but slower performance on ____. Answer Selected Answer:

Correct Answer:

•

updat es

updat es

Question 10

2.5 out of 2.5 points

Which of the following DBMS evaluation categories does the following question relate to: What types of files can you import or export? Answer Selected Answer:

Correct Answer:

Portabili ty

Portabili ty

Tuesday, November 22, 2011 1:23:21 AM EST OK •

Question 1

2.5 out of 2.5 points

With respect to the definition of data warehouse, ____ means that data in a data warehouse represents snapshots of data at various points in time in the past. Answer Selected Answer:

time-

variant Correct Answer:

•

timevariant

Question 2

2.5 out of 2.5 points

When a centralized database becomes unavailable for any reason, no s can continue processing. In contrast, if a local database in a distributed database becomes unavailable, only s who need that data are affected. Because of this, distributed databases have a(n) ____ advantage over a centralized database. Answer Selected Answer:

Correct Answer:

•

system availability

system availability

Question 3

2.5 out of 2.5 points

____ refers to the association of an operation to actual program code. Answer Selected Answer:

Correct Answer:

•

Bindi ng

Bindi ng

Question 4

0 out of 2.5 points

In ____ systems, data and actions are encapsulated. Answer Selected Answer: Correct Answer:

•

relational

objectoriented

Question 5

2.5 out of 2.5 points

_____ is a standard interface that provides the capability necessary for Web browsers to communicate with server-side extensions. Answer Selected Answer:

Correct Answer:

•

Common Gateway Interface

Common Gateway Interface

Question 6

2.5 out of 2.5 points

____ is the data communication method used by Web clients and Web servers to exchange data on the Internet. Answer Selected Answer:

Correct Answer:

•

HTT P

HTT P

Question 7

2.5 out of 2.5 points

When s interact with an RDBMS, they use transactions. These types of systems are called ____ systems. Answer Selected Answer:

Correct Answer:

•

OLT P

OLT P

Question 8

2.5 out of 2.5 points

With respect to the definition of data warehouse, ____ means that the data is read-only. Answer Selected Answer:

Correct Answer:

•

nonvolat ile

nonvolat ile

Question 9

0 out of 2.5 points

____ is a metalanguage derived from a restricted subset of SGML, and designed for the exchange of data on the Web. Answer Selected Answer: Correct

HTT P

Answer: •

XML

Question 10

0 out of 2.5 points

Because the clients and the server perform different functions and can run two different operating systems, there is an arrangement of client/server architecture known as ____. Answer Selected Answer: Correct Answer:

three-tier architecture

two-tier architecture

Saturday, November 26, 2011 3:17:00 AM EST OK •

2.5 out of 2.5 points

A(n) ____ consists of rows that contain consolidated and summarized data. Answer Selected Answer:

Correct Answer:

•

fact table

fact table

Question 2

2.5 out of 2.5 points

____ is the ability of a computer system to continue to function well as utilization of the system increases. Answer

Selected Answer:

Correct Answer:

•

Scalabil ity

Scalabil ity

Question 3

2.5 out of 2.5 points

Uncovering new knowledge, patterns, trends, and rules from the data stored in a data warehouse is known as ____. Answer Selected Answer:

Correct Answer:

•

data mining

data mining

Question 4

2.5 out of 2.5 points

The formula for message transmission time is: communication time = access delay + (data volume / X), where X represents ____. Answer Selected Answer:

Correct Answer:

•

transmission rate

transmission rate

Question 5

0 out of 2.5 points

_____ is a standard interface that provides the capability necessary for Web browsers to communicate with server-side extensions. Answer Selected Answer: Correct Answer:

•

Web Server Interface

Common Gateway Interface

Question 6

2.5 out of 2.5 points

When a centralized database becomes unavailable for any reason, no s can continue processing. In contrast, if a local database in a distributed database becomes unavailable, only s who need that data are affected. Because of this, distributed databases have a(n) ____ advantage over a centralized database. Answer Selected Answer:

Correct Answer:

•

system availability

system availability

Question 7

2.5 out of 2.5 points

With respect to the definition of data warehouse, ____ means that data is stored in one place, even though it originates from everywhere in the organization and from a variety of external sources. Answer Selected Answer:

integrat ed

Correct Answer:

•

integrat ed

Question 8

2.5 out of 2.5 points

When the data is organized by entity rather than by the application that uses the data, it is called ____. Answer Selected Answer:

Correct Answer:

•

subjectoriented

subjectoriented

Question 9

2.5 out of 2.5 points

____ implies that the performance of functions such as adding sites, changing versions of DBMSs, creating backups, and modifying hardware should not require planned shutdowns of the entire distributed database. Answer Selected Answer:

Correct Answer:

•

Continuous operation

Continuous operation

Question 10

2.5 out of 2.5 points

A DDBMS that has at least two sites at which the local DBMSs are different is known as a ____. Answer Selected Answer:

Correct Answer:

heterogeneous DDBMS

heterogeneous DDBMS