CIS 3365 EXAM QUESTIONS WITH
CORRECT ANSWERS 2025 LATEST
UPDATE
What is the most important advantage of relational database management systems? a.
The use of Structured Query Language (SQL).
b. The need to focus on the physical aspects of the database.
c. The ability to hide the complexities of the relational model from the user.
d. The level of controlled redundancy. - Answer-The ability to hide the complexities of
the relational model from the user.
Which of the following is not a valid connectivity statement? a. PAINTER paints many
PAINTINGs
b. An EMPLOYEE learns many SKILLs
c. A CUSTOMER gender is MALE or FEMALE
d. An EMPLOYEE manages a STORE - Answer-A CUSTOMER gender is MALE or
FEMALE
Which of the following is a fundamental component of data modeling? - Answer-
Attribute, relationship, entity
Which of the following is not used for Big Data technology? a. Hadoop
b. NoSQL
c. SQL
d. MapReduce - Answer-SQL
Which of the following is known as a relation? a. Tuple
b. File
c. Entity
d. Table - Answer-Table
Each row in the relational table is known as an ________? a. entity set
b. entity occurrence
c. entity tuple
d. entity relation - Answer-entity occurrence
Which of the following is not a characteristic of a relational table? a. A table is perceived
as a two-dimensional structure composed of rows and columns.
,b. Each table row (tuple) represents a single entity occurrence within the entity set.
c. Each table column represents an attribute, and each column has a distinct name.
d. All values in a column may have different data format. - Answer-All values in a
column may have different data format.
Which of the following is not a valid key term in a relational model? a. Superkey
b. Composite key
c. Secondary Key
d. Integrity key - Answer-Integrity key
Inherent problems of M:N relationships cannot be avoided by creating? a. Transient
entity
b. Composite entity
c. Bridge entity
d. Associative entity - Answer-Transient entity
Which of the following is not a valid relational set operator? a. UNION operator
b. INTERSECT operator
c. DIFFERENCE operator
d. ADD operator - Answer-ADD operator
Which of the following statements best defines an index? a. An index is an orderly
arrangement used to logically access rows in a table.
b. An index is an orderly arrangement used to physically access rows in a table.
c. An index is used to logically access rows in a table.
d. An index is used to physically access rows in a table. - Answer-An index is an orderly
arrangement used to logically access rows in a table.
Why is identifying and documenting business rules essential to database design?
a. It helps to standardize the company's view of data.
b. It can be a communication tool between users and managers.
c. It allows the designer to manage business processes.
d. It allows the user understand relationship participation rules and constraints. -
Answer-It helps to standardize the company's view of data
Which of the following is not a valid Codd's Relational Database rule? a. The database
must support set-level inserts, updates, and deletes.
b. Every value in a table is guaranteed to be accessible through a combination of table
name, primary key value, and column name.
c. Any view is theoretically updatable.
d. Application programs and ad hoc facilities are logically unaffected when physical
access methods or storage structures are changed. - Answer-Any view is theoretically
updatable
, Which of the following statements best defines data dictionary? a. The data dictionary
provides a detailed description of all entities in the database created by the user and
designer.
b. The data dictionary provides a detailed description of all tables in the database
created by the user and designer.
c. The data dictionary provides a detailed description of all entities in the database
created by the developer and designer.
d. The data dictionary provides a detailed description of all tables in the database
created by the developer and designer. - Answer-The data dictionary provides a
detailed description of all tables in the database created by the user and designer.
Which of the following is not a true statement? a. The proper use of foreign keys
minimizes data redundancies.
b. The real test of redundancy is how many copies of a given attribute are stored.
c. The proper use of foreign keys minimizes the chances that destructive data
anomalies will develop.
d. The real test of redundancy is whether the elimination of an attribute will eliminate
information. - Answer-The real test of redundancy is how many copies of a given
attribute are stored.
Which of the following statements best defines entity integrity purpose? a. Each row
identifies other rows in other tables.
b. Each row will have a unique identity, and foreign key values can properly reference
primary key values.
c. Each row will have a unique identity.
d. Each row will have a value identifying foreign key values in other tables. - Answer-
Each row will have a unique identity, and foreign key values can properly reference
primary key values.
Which of the following is true of business rules? - Answer-They can serve as a
communication tool between the users and designers
Which of the following is a specialization hierarchy overlapping constraint scenario in
case of partial completeness? - Answer-Supertype has optional subtypes.
A _____ entity has a primary key that is partially or totally derived from the parent entity
in the relationship. - Answer-weak
An operational database is sometimes referred to as an enterprise database. - Answer-
False
MySQL allows multiple triggering conditions per trigger. - Answer-False
Which query is used to list a unique value for V_CODE, where the list will produce only
a list of those values that are different from one another? - Answer-SELECT ONLY
V_CODE
CORRECT ANSWERS 2025 LATEST
UPDATE
What is the most important advantage of relational database management systems? a.
The use of Structured Query Language (SQL).
b. The need to focus on the physical aspects of the database.
c. The ability to hide the complexities of the relational model from the user.
d. The level of controlled redundancy. - Answer-The ability to hide the complexities of
the relational model from the user.
Which of the following is not a valid connectivity statement? a. PAINTER paints many
PAINTINGs
b. An EMPLOYEE learns many SKILLs
c. A CUSTOMER gender is MALE or FEMALE
d. An EMPLOYEE manages a STORE - Answer-A CUSTOMER gender is MALE or
FEMALE
Which of the following is a fundamental component of data modeling? - Answer-
Attribute, relationship, entity
Which of the following is not used for Big Data technology? a. Hadoop
b. NoSQL
c. SQL
d. MapReduce - Answer-SQL
Which of the following is known as a relation? a. Tuple
b. File
c. Entity
d. Table - Answer-Table
Each row in the relational table is known as an ________? a. entity set
b. entity occurrence
c. entity tuple
d. entity relation - Answer-entity occurrence
Which of the following is not a characteristic of a relational table? a. A table is perceived
as a two-dimensional structure composed of rows and columns.
,b. Each table row (tuple) represents a single entity occurrence within the entity set.
c. Each table column represents an attribute, and each column has a distinct name.
d. All values in a column may have different data format. - Answer-All values in a
column may have different data format.
Which of the following is not a valid key term in a relational model? a. Superkey
b. Composite key
c. Secondary Key
d. Integrity key - Answer-Integrity key
Inherent problems of M:N relationships cannot be avoided by creating? a. Transient
entity
b. Composite entity
c. Bridge entity
d. Associative entity - Answer-Transient entity
Which of the following is not a valid relational set operator? a. UNION operator
b. INTERSECT operator
c. DIFFERENCE operator
d. ADD operator - Answer-ADD operator
Which of the following statements best defines an index? a. An index is an orderly
arrangement used to logically access rows in a table.
b. An index is an orderly arrangement used to physically access rows in a table.
c. An index is used to logically access rows in a table.
d. An index is used to physically access rows in a table. - Answer-An index is an orderly
arrangement used to logically access rows in a table.
Why is identifying and documenting business rules essential to database design?
a. It helps to standardize the company's view of data.
b. It can be a communication tool between users and managers.
c. It allows the designer to manage business processes.
d. It allows the user understand relationship participation rules and constraints. -
Answer-It helps to standardize the company's view of data
Which of the following is not a valid Codd's Relational Database rule? a. The database
must support set-level inserts, updates, and deletes.
b. Every value in a table is guaranteed to be accessible through a combination of table
name, primary key value, and column name.
c. Any view is theoretically updatable.
d. Application programs and ad hoc facilities are logically unaffected when physical
access methods or storage structures are changed. - Answer-Any view is theoretically
updatable
, Which of the following statements best defines data dictionary? a. The data dictionary
provides a detailed description of all entities in the database created by the user and
designer.
b. The data dictionary provides a detailed description of all tables in the database
created by the user and designer.
c. The data dictionary provides a detailed description of all entities in the database
created by the developer and designer.
d. The data dictionary provides a detailed description of all tables in the database
created by the developer and designer. - Answer-The data dictionary provides a
detailed description of all tables in the database created by the user and designer.
Which of the following is not a true statement? a. The proper use of foreign keys
minimizes data redundancies.
b. The real test of redundancy is how many copies of a given attribute are stored.
c. The proper use of foreign keys minimizes the chances that destructive data
anomalies will develop.
d. The real test of redundancy is whether the elimination of an attribute will eliminate
information. - Answer-The real test of redundancy is how many copies of a given
attribute are stored.
Which of the following statements best defines entity integrity purpose? a. Each row
identifies other rows in other tables.
b. Each row will have a unique identity, and foreign key values can properly reference
primary key values.
c. Each row will have a unique identity.
d. Each row will have a value identifying foreign key values in other tables. - Answer-
Each row will have a unique identity, and foreign key values can properly reference
primary key values.
Which of the following is true of business rules? - Answer-They can serve as a
communication tool between the users and designers
Which of the following is a specialization hierarchy overlapping constraint scenario in
case of partial completeness? - Answer-Supertype has optional subtypes.
A _____ entity has a primary key that is partially or totally derived from the parent entity
in the relationship. - Answer-weak
An operational database is sometimes referred to as an enterprise database. - Answer-
False
MySQL allows multiple triggering conditions per trigger. - Answer-False
Which query is used to list a unique value for V_CODE, where the list will produce only
a list of those values that are different from one another? - Answer-SELECT ONLY
V_CODE
