Question 1

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.&#10;A) select&#10;B) union&#10;C) project&#10;D) intersection

Accepted Answer

The intersection operation is used to create a new relation that contains only the tuples that are present in both relation A and relation B.

Question 2

Each column in a relation is called _______.&#10;A) an attribute&#10;B) a tuple&#10;C) a union&#10;D) an attitude

Accepted Answer

Each column in a relation is called an attribute.

Question 3

If you want to change the value of an attribute of a tuple, you use the _______ operation.&#10;A) project&#10;B) join&#10;C) update&#10;D) select

Accepted Answer

To change the value of an attribute of a tuple, the update operation is used. The project operation is used to retrieve specific attributes from a relation, the join operation is used to combine tuples from two or more relations based on a common attribute, and the select operation is used to retrieve tuples that satisfy a particular condition.

Question 4

In a three-level DBMS architecture, the layer that interacts directly with the hardware is the _______ level.&#10;A) external&#10;B) conceptual&#10;C) internal&#10;D) physical

Accepted Answer

The layer that interacts directly with the hardware is known as the internal level. This level is responsible for managing the physical storage and retrieval of data from physical storage devices like hard drives and memory. It converts logical data structures from the conceptual level into physical data structures that can be stored in the database.

Question 5

_______ is a declarative language used on relational databases.&#10;A) PDQ&#10;B) SQL&#10;C) LES&#10;D) PBJ

Accepted Answer

SQL (Structured Query Language) is a declarative language used to manage and manipulate data stored in relational databases. PDQ, LES, and PBJ are not related to relational database management.

Question 6

Of the various database models, the _______ model is the most prevalent today.&#10;A) hierarchical&#10;B) network&#10;C) relational&#10;D) linked list

Accepted Answer

The relational database model is currently the most popular and widely used among database management systems. It allows for easy data access, manipulation, and management through the use of tables with predefined relationships between them. Hierarchical and network models were popular during the early days of computing, but have since been largely replaced by the more flexible and scalable relational model. Linked lists are a data structure used in programming and not a database model.

Question 7

Which of the following is a unary operator?&#10;A) intersection&#10;B) union&#10;C) join&#10;D) project

Accepted Answer

A unary operator is an operator that takes a single operand, and in relational algebra, the project operator is a unary operator that selects a subset of attributes from a relation. The other operators listed (intersection, union, and join) are all binary operators that take two operands.

Question 8

The _______ level of a three-level DBMS architecture defines the logical view of the data.&#10;A) external&#10;B) conceptual&#10;C) internal&#10;D) physical

Accepted Answer

The conceptual level of a three-level DBMS architecture defines the overall logical view of the database. It provides an abstraction of the data that is independent of any specific application or user. It defines the relationships between the different data elements and the rules that govern their interactions. The external level defines how specific users or applications view the data, while the internal level defines how the data is physically stored and accessed by the computer system.

Question 9

The operation that takes two relations and combines them based on common attributes is the _________ operation.&#10;A) join&#10;B) project&#10;C) union&#10;D) intersection

Accepted Answer

The join operation is used to combine two relations based on common attributes. This operation matches tuples from each relation where the values of the common attributes match, and creates a new relation with the combined attributes from both original relations. Project, union, and intersection operations do not merge two relations based on common attributes.

Question 10

A binary operator is applied to _______ relations&#8197;(s) and creates an output of ________ relation(s).&#10;A) one, one&#10;B) one, two&#10;C) two, one&#10;D) two, two

Accepted Answer

A binary operator requires two input relations and creates one output relation. Therefore, the only option that meets these criteria is C, in which there are two input relations and one output relation.

Question 11

In a three-level DBMS architecture, the _______ level determines where data is actually stored on the storage devices.&#10;A) external&#10;B) conceptual&#10;C) internal&#10;D) physical

Accepted Answer

The answer of In a three-level DBMS architecture, the _______...

Question 12

Which of the following is a binary operator?&#10;A) select&#10;B) update&#10;C) difference&#10;D) all of the above

Accepted Answer

The answer of Which of the following is a binary...

Question 13

If you need to delete an attribute in a relation, you can use the _______ operation.&#10;A) join&#10;B) project&#10;C) union&#10;D) intersection

Accepted Answer

The answer of If you need to delete an attribute...

Question 14

In a three-level DBMS architecture, the _______ level interacts directly with the users.&#10;A) external&#10;B) conceptual&#10;C) internal&#10;D) physical

Accepted Answer

The answer of In a three-level DBMS architecture, the _______...

Question 15

A unary operator is applied to _______ relation(s) and creates an output of ________ relation(s).&#10;A) one, one&#10;B) one, two&#10;C) two, one&#10;D) two, two

Accepted Answer

The answer of A unary operator is applied to _______...

Question 16

The unary _______ operation always results in a relation that has exactly one more row than the original relation.&#10;A) insert&#10;B) delete&#10;C) update&#10;D) select

Accepted Answer

The answer of The unary _______ operation always results in...

Question 17

Each row in a relation is called _______.&#10;A) an attribute&#10;B) a tuple&#10;C) a union&#10;D) an attitude

Accepted Answer

The answer of Each row in a relation is called...

Question 18

The data model and the schema of a DBMS are often defined at the _______ level.&#10;A) external&#10;B) conceptual&#10;C) internal&#10;D) physical

Accepted Answer

The answer of The data model and the schema of...

Deck 14: Databases