Filters
Question type

Study Flashcards

Character data can contain any character or symbol intended for mathematical manipulation.

A) True
B) False

Correct Answer

verifed

verified

If the attribute (B)is functionally dependent on a composite key (A)but not on any subset of that composite key,the attribute (B)is fully functionally dependent on (A).

A) True
B) False

Correct Answer

verifed

verified

The order of the rows and columns is important to the DBMS.

A) True
B) False

Correct Answer

verifed

verified

In a natural join,the column on which the join was made occurs twice in the new table.

A) True
B) False

Correct Answer

verifed

verified

A data dictionary is sometimes described as "the database designer's database" because it records the design decisions about tables and their structures.

A) True
B) False

Correct Answer

verifed

verified

When two or more tables share the same number of columns,and when their corresponding columns share the same or compatible domains,they are said to be .


A) intersect-compatible
B) union-compatible
C) difference-compatible
D) select-compatible

E) A) and B)
F) A) and C)

Correct Answer

verifed

verified

B

A(n)index is an index in which the index key can have only one pointer value (row)associated with it.

Correct Answer

verifed

verified

The proper use of keys is crucial to controlling data redundancy.

Correct Answer

verifed

verified

__ returns only the attributes requested,in the order in which they are requested.


A) PROJECT
B) SELECT
C) UNION
D) DIFFERENCE

E) C) and D)
F) B) and C)

Correct Answer

verifed

verified

Depending on the sophistication of the application development software,nulls can create problems when functions such as COUNT,AVERAGE,and SUM are used.

A) True
B) False

Correct Answer

verifed

verified

Define entity integrity.What are the two requirements to ensure entity integrity?

Correct Answer

verifed

verified

Entity integrity is the condition in whi...

View Answer

A(n) join links tables by selecting only the rows with common values in their common attribute(s) .


A) attribute
B) unique
C) foreign
D) natural

E) B) and D)
F) None of the above

Correct Answer

verifed

verified

A(n) only returns matched records from the tables that are being joined.


A) outer join
B) inner join
C) equijoin
D) theta join

E) A) and C)
F) All of the above

Correct Answer

verifed

verified

You can think of a table as a persistent representation of a logical relation.

A) True
B) False

Correct Answer

verifed

verified

______relationships cannot be implemented as such in the relational model.

Correct Answer

verifed

verified

In a database context,the word indicates the use of the same attribute name to label different attributes.


A) redundancy
B) homonym
C) duplicate
D) synonym

E) A) and C)
F) A) and B)

Correct Answer

verifed

verified

Date attributes contain calendar dates stored in a special format known as the date format.


A) Epoch
B) calendar
C) Julian
D) logical

E) None of the above
F) B) and C)

Correct Answer

verifed

verified

The constraint can be placed on a column to ensure that every row in the table has a value for that column.


A) UNIQUE
B) NOT NULL
C) VALUE
D) EMPTY

E) A) and D)
F) B) and C)

Correct Answer

verifed

verified

PRODUCT yields all possible pairs of rows from two tables,also known as the product.

Correct Answer

verifed

verified

Cartesian

Each table represents an attribute.


A) column
B) row
C) dimension
D) value

E) A) and D)
F) A) and B)

Correct Answer

verifed

verified

A

Showing 1 - 20 of 74

Related Exams

Show Answer