Filters
Question type

Study Flashcards

In a database context,a(n) ____ indicates the use of different names to describe the same attribute.


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

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

Correct Answer

verifed

verified

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 ____ key,the attribute (B) is fully functionally dependent on (A) .


A) foreign
B) unique
C) composite
D) complete

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

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

Fortunately,the problems inherent in the ____________________ relationship can easily be avoided by creating a composite entity.

Correct Answer

verifed

verified

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

Correct Answer

verifed

verified

As rare as 1:1 relationships should be,certain conditions absolutely require their use.

A) True
B) False

Correct Answer

verifed

verified

A left outer join on tables CUSTOMER and AGENT yields all of the rows in the CUSTOMER table,including those that do not have a matching value in the AGENT table

A) True
B) False

Correct Answer

verifed

verified

The logical view of the relational database is facilitated by the creation of data relationships based on a logical construct known as a(n)____________________.

Correct Answer

verifed

verified

____ yields only the rows that appear in both tables.


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

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

Correct Answer

verifed

verified

No data entry at all is known as a(n) ____.


A) nil
B) null
C) empty
D) zero

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

Correct Answer

verifed

verified

A proper understanding of the concept and use of keys in a relational database model is very important.

A) True
B) False

Correct Answer

verifed

verified

____________________ joins are especially useful when you are trying to determine what value(s)in related tables cause(s)referential integrity problems.

Correct Answer

verifed

verified

All primary key entries are unique,and no part of a primary key may be ____.


A) zero
B) a foreign key
C) null
D) a candidate key

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

Correct Answer

verifed

verified

The following example exhibits ____________________ integrity: The CUSTOMER table's primary key is CUS_CODE.The CUSTOMER primary key column has no null entries,and all entries are unique.Similarly,the AGENT table's primary key is AGENT_CODE,and this primary key column also is free of null entries.

Correct Answer

verifed

verified

The DIFFERENCE operator subtracts one table from the other.

A) True
B) False

Correct Answer

verifed

verified

The one-to-many (1:M)relationship is easily implemented in the relational model by putting the foreign key of the "1" side in the table of the "many" side as a primary key.

A) True
B) False

Correct Answer

verifed

verified

____,also known as RESTRICT,yields values for all rows found in a table that satisfy a given condition.


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

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

Correct Answer

verifed

verified

A null is created when you press the Enter key or the Tab key to move to the next entry without making a prior entry of any kind.

A) True
B) False

Correct Answer

verifed

verified

A(n) ____ is an ordered arrangement of keys and pointers.


A) table
B) superkey
C) relationship
D) index

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

Correct Answer

verifed

verified

Showing 61 - 80 of 100

Related Exams

Show Answer