Question 1

If you want to change the value of an attribute of a tuple, you use the _______ operation.

Accepted Answer

A)   project
B)   join
C)   update
D)   selectE) None of the above
F) C) and D)

Question 2

The unary _______ operation always results in a relation that has exactly one more row than the original relation.

Accepted Answer

A)   insert
B)   delete
C)   update
D)   selectE) A) and D)
F) A) and B)

Question 3

If you need to delete an attribute in a relation, you can use the _______ operation.

Accepted Answer

A)   join
B)   project
C)   union
D)   intersectionE) A) and D)
F) None of the above

Question 4

A unary operator is applied to _______ relation(s)  and creates an output of ________ relation(s) .

Accepted Answer

A)   one, one
B)   one, two
C)   two, one
D)   two, twoE) B) and D)
F) All of the above A

Question 5

The _______ level of a three-level DBMS architecture defines the logical view of the data.

Accepted Answer

A)   external
B)   conceptual
C)   internal
D)   physicalE) All of the above
F) A) and D)

Question 6

In a three-level DBMS architecture, the _______ level interacts directly with the users.

Accepted Answer

A)   external
B)   conceptual
C)   internal
D)   physicalE) All of the above
F) B) and C)

Question 7

_______ is a declarative language used on relational databases.

Accepted Answer

A)   PDQ
B)   SQL
C)   LES
D)   PBJE) B) and C)
F) None of the above

Question 8

Of the various database models, the _______ model is the most prevalent today.

Accepted Answer

A)   hierarchical
B)   network
C)   relational
D)   linked listE) B) and C)
F) All of the above

Question 9

The operation that takes two relations and combines them based on common attributes is the _________ operation.

Accepted Answer

A)   join
B)   project
C)   union
D)   intersectionE) A) and D)
F) A) and C)

Question 10

You want to create a relation called New that contains tuples that belong to both relation A and relation B. For this, you can use the _______ operation.

Accepted Answer

A)   select
B)   union
C)   project
D)   intersectionE) All of the above
F) B) and C)

Question 11

Each row in a relation is called _______.

Accepted Answer

A)   an attribute
B)   a tuple
C)   a union
D)   an attitudeE) A) and C)
F) A) and B)

Question 12

In a three-level DBMS architecture, the _______ level determines where data is actually stored on the storage devices.

Accepted Answer

A)   external
B)   conceptual
C)   internal
D)   physicalE) A) and B)
F) C) and D)

Question 13

Which of the following is a binary operator?

Accepted Answer

A)   select
B)   update
C)   difference
D)   all of the aboveE) None of the above
F) All of the above C

Question 14

A binary operator is applied to _______ relations (s)  and creates an output of ________ relation(s) .

Accepted Answer

A)   one, one
B)   one, two
C)   two, one
D)   two, twoE) B) and C)
F) A) and C)

Question 15

Which of the following is a unary operator?

Accepted Answer

A)   intersection
B)   union
C)   join
D)   projectE) A) and B)
F) B) and C) D

Question 16

In a three-level DBMS architecture, the layer that interacts directly with the hardware is the _______ level.

Accepted Answer

A)   external
B)   conceptual
C)   internal
D)   physicalE) C) and D)
F) All of the above

Question 17

The data model and the schema of a DBMS are often defined at the _______ level.

Accepted Answer

A)   external
B)   conceptual
C)   internal
D)   physicalE) A) and D)
F) A) and B)

Question 18

Each column in a relation is called _______.

Accepted Answer

A)   an attribute
B)   a tuple
C)   a union
D)   an attitudeE) None of the above
F) All of the above

Exam 14: Databases

If you want to change the value of an attribute of a tuple, you use the _______ operation.

Correct Answer
verified

The unary _______ operation always results in a relation that has exactly one more row than the original relation.

Correct Answer
verified

If you need to delete an attribute in a relation, you can use the _______ operation.

Correct Answer
verified

A unary operator is applied to _ relation(s) and creates an output of __ relation(s) .

Correct Answer
verified
A

The _______ level of a three-level DBMS architecture defines the logical view of the data.

Correct Answer
verified

In a three-level DBMS architecture, the _______ level interacts directly with the users.

Correct Answer
verified

_______ is a declarative language used on relational databases.

Correct Answer
verified

Of the various database models, the _______ model is the most prevalent today.

Correct Answer
verified

The operation that takes two relations and combines them based on common attributes is the _________ operation.

Correct Answer
verified

You want to create a relation called New that contains tuples that belong to both relation A and relation B. For this, you can use the _______ operation.

Correct Answer
verified

Each row in a relation is called _______.

Correct Answer
verified

In a three-level DBMS architecture, the _______ level determines where data is actually stored on the storage devices.

Correct Answer
verified

Which of the following is a binary operator?

Correct Answer
verified
C

A binary operator is applied to _ relations (s) and creates an output of __ relation(s) .

Correct Answer
verified

Which of the following is a unary operator?

Correct Answer
verified
D

In a three-level DBMS architecture, the layer that interacts directly with the hardware is the _______ level.

Correct Answer
verified

The data model and the schema of a DBMS are often defined at the _______ level.

Correct Answer
verified

Each column in a relation is called _______.

Correct Answer
verified

Exam 14: Databases

If you want to change the value of an attribute of a tuple, you use the _______ operation.

Correct AnswerverifiedShow Answer

The unary _______ operation always results in a relation that has exactly one more row than the original relation.

Correct AnswerverifiedShow Answer

If you need to delete an attribute in a relation, you can use the _______ operation.

Correct AnswerverifiedShow Answer

A unary operator is applied to _______ relation(s) and creates an output of ________ relation(s) .

Correct AnswerverifiedA

The _______ level of a three-level DBMS architecture defines the logical view of the data.

Correct AnswerverifiedShow Answer

In a three-level DBMS architecture, the _______ level interacts directly with the users.

Correct AnswerverifiedShow Answer

_______ is a declarative language used on relational databases.

Correct AnswerverifiedShow Answer

Of the various database models, the _______ model is the most prevalent today.

Correct AnswerverifiedShow Answer

The operation that takes two relations and combines them based on common attributes is the _________ operation.

Correct AnswerverifiedShow Answer

You want to create a relation called New that contains tuples that belong to both relation A and relation B. For this, you can use the _______ operation.

Correct AnswerverifiedShow Answer

Each row in a relation is called _______.

Correct AnswerverifiedShow Answer

In a three-level DBMS architecture, the _______ level determines where data is actually stored on the storage devices.

Correct AnswerverifiedShow Answer

Which of the following is a binary operator?

Correct AnswerverifiedC

A binary operator is applied to _______ relations (s) and creates an output of ________ relation(s) .

Correct AnswerverifiedShow Answer

Which of the following is a unary operator?

Correct AnswerverifiedD

In a three-level DBMS architecture, the layer that interacts directly with the hardware is the _______ level.

Correct AnswerverifiedShow Answer

The data model and the schema of a DBMS are often defined at the _______ level.

Correct AnswerverifiedShow Answer

Each column in a relation is called _______.

Correct AnswerverifiedShow Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

A unary operator is applied to _ relation(s) and creates an output of __ relation(s) .

Correct Answer
verified
A

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
C

A binary operator is applied to _ relations (s) and creates an output of __ relation(s) .

Correct Answer
verified

Correct Answer
verified
D

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified