Question 1

What improvement can be made to file-based databases to overcome their limitations?

Accepted Answer

Implementing a tabular structure, as seen in relational databases, allows for better organization, querying, and management of data compared to traditional file-based systems.

Question 2

Consider the table for an employee database shown in the exhibit. What is the cardinality of the table?

Accepted Answer

C

Question 3

Consider the table for an employee database shown in the exhibit. What is the degree of the table?

Accepted Answer

B

Question 4

What is the most important service provided by a database management system?

Accepted Answer

A database management system (DBMS) primarily provides support for a data manipulation language, which allows users to perform operations such as querying, updating, inserting, and deleting data within the database.

Question 5

You enterprise must decide whether to use a database management system. Which of the following lists four advantages of using a DBMS?

Accepted Answer

The answer of You enterprise must decide whether to use...

Question 6

Consider the following database information: domain s_id: integer domain grd: fixed length character string length 1 STUDENT_GRADE( Student_Number: s_id NOT NULL Grade: grd ) Primary Key Student_Number During which phase of the database design process would this information be developed?

Accepted Answer

This information would be developed during the logical phase of the database design process, where the logical structure of the database is defined, including tables, columns, data types, and constraints like primary keys.

Question 7

Consider the Information Engineering diagram in the exhibit showing the relations BUILDING and RESIDENT. What is the relationship between BUILDING and RESIDENT?

Accepted Answer

The answer of Consider the Information Engineering diagram in the...

Question 8

Which pair of relational algebraic operations requires union compatibility?

Accepted Answer

Union compatibility is required for operations like intersection and difference, where the relations must have the same set of attributes.

Question 9

Which of the following best describes a composite key?

Accepted Answer

A composite key is a key that consists of two or more attributes that together uniquely identify a record in a table.

Question 10

The creation of intermediate entities occurs during the logical database design phase for an enterprise. It is used to resolve which types of relationships?

Accepted Answer

Intermediate entities, also known as associative or junction tables, are used to resolve complex, recursive, and many-to-many relationships in database design.

Question 11

Consider the Recreation relation in the exhibit. A data operation that changes one of the tuples for Student_ID 1003 must be performed. It is necessary to change one of the activities from swimming to tennis. The Student_ID and Activity attributes make up the primary key for the Recreation relation. All related information must be altered, as well. Which SQL statement or statements would best accomplish this?

Accepted Answer

The answer of Consider the Recreation relation in the exhibit....

Question 12

NULL) Primary Key Class_Num Consider the Information Engineering diagram shown in the exhibit. Which DBDL definition best describes this diagram?

Accepted Answer

The answer of NULL) Primary Key Class_Num Consider the Information...

Question 13

Which of the following occurs in a relation when records are added or removed?

Accepted Answer

The degree of a relation (number of attributes) remains fixed, while the cardinality (number of records) changes when records are added or removed.

Question 14

Your enterprise is developing a database system that will contain highly sensitive data. Security of the data will take priority over database processing speed. Which database protection technique should be employed?

Accepted Answer

Encryption is the most effective technique for protecting highly sensitive data, as it ensures that even if data is accessed by unauthorized users, it remains unreadable without the decryption key.

Question 15

The exhibit shows a table called Housing Relation that relates a unique student identification number with a dormitory building and a room fee for that building. Each building charges only one fee and a student can live in only one building. The key for the Housing Relation is Student_ID. This table is in which normal form?

Accepted Answer

The answer of The exhibit shows a table called Housing...

Question 16

What is a relational database domain?

Accepted Answer

A relational database domain is a set of permissible attribute values, defining the possible values that an attribute can take.

Question 17

Your enterprise is creating a relation (shown in the exhibit) that tracks parts and suppliers. Which situation would occur if new supplier information were entered in the relation before any information about specific parts?

Accepted Answer

The answer of Your enterprise is creating a relation (shown...

Question 18

Consider the following table as well as the Dept1_Parts and Dept2_Parts relations shown in the exhibit: Which of the following relational algebraic expressions would result in the given table?

Accepted Answer

The answer of Consider the following table as well as...

Question 19

Which process is used to prevent the current database operation from reading or writing a data item while that data item is being accessed by another operation?

Accepted Answer

Locks are used in databases to prevent concurrent operations from accessing the same data item simultaneously, ensuring data integrity and consistency.

Question 20

The exhibit shows a relation for a company projects. Which candidate key(s) would best serve as the primary key for this relation?

Accepted Answer

The answer of The exhibit shows a relation for a...

Exam 3: CIW v5 Database Design Specialist