1033 + Mcqs in Database Page 15 McqOptions

701.	A supertype can only have only one subtype.
A.	True
B.	False
Answer» C.

Discussion

702.	Symmetric multiprocessing (SMP) architectures are useful for situations where data must remain in memory during processing to achieve the desired performance level.
A.	True
B.	False
Answer» B. False

Discussion

703.	There is cardinality on an EER between the supertype and subtype.
A.	True
B.	False
Answer» C.

Discussion

704.	A subtype discriminator of the supertype is an attribute whose values determine the target subtype(s).
A.	True
B.	False
Answer» B. False

Discussion

705.	The Windows operating system and Windows applications are event driven.
A.	True
B.	False
Answer» B. False

Discussion

706.	The SQL MAKE TABLE command is used to construct tables, define columns, define column constraints and create relationships.
A.	True
B.	False
Answer» C.

Discussion

707.	SQL has a JOIN ON syntax that can be used to create inner joins and outer joins.
A.	True
B.	False
Answer» B. False

Discussion

708.	Standard SQL-92 views are constructed from SQL SELECT statements that do not contain the GROUP BY clause.
A.	True
B.	False
Answer» C.

Discussion

709.	The SQL CHECK constraint is fully defined by the SQL-92 standard, and is consistently implemented by all DBMS vendors.
A.	True
B.	False
Answer» C.

Discussion

710.	A regular subquery is processed from the bottom up.
A.	True
B.	False
Answer» B. False

Discussion

711.	Correlated subqueries are similar to a regular subquery.
A.	True
B.	False
Answer» C.

Discussion

712.	Database redesign is especially difficult if the database has no data.
A.	True
B.	False
Answer» C.

Discussion

713.	A correlated subquery is processed as a nested subquery.
A.	True
B.	False
Answer» B. False

Discussion

714.	Some organizations take the stand that no application should ever employ the true name of a table.
A.	True
B.	False
Answer» B. False

Discussion

715.	A method defines the form or protocol of the operation, but not its implementation.
A.	True
B.	False
Answer» C.

Discussion

716.	A class is a concept, abstraction, or thing that makes sense in an application context.
A.	True
B.	False
Answer» B. False

Discussion

717.	ODL supports the abstract keyword for classes and operations.
A.	True
B.	False
Answer» C.

Discussion

718.	The ODMG Object Model requires that a relationship be specified in both directions.
A.	True
B.	False
Answer» B. False

Discussion

719.	Before specifying a key for a class, you must specify its extent.
A.	True
B.	False
Answer» B. False

Discussion

720.	The Object Model supports different literal types, but does not support atomic literals, collection literals, and structured literals.
A.	True
B.	False
Answer» C.

Discussion

721.	An ID-dependent entity is an entity whose identifier is a composite identifier where no portion of the composite identifier is an identifier of another entity.
A.	True
B.	False
Answer» C.

Discussion

722.	All instances of an entity class have the same attributes.
A.	True
B.	False
Answer» B. False

Discussion

723.	A ternary relationship is so called because in contains two entities and one association between them.
A.	True
B.	False
Answer» C.

Discussion

724.	A minimum cardinality is the minimum number of entity instances that may participate in a relationship instance.
A.	True
B.	False
Answer» C.

Discussion

725.	An attribute describes the entity's characteristics.
A.	True
B.	False
Answer» B. False

Discussion

726.	Indexes are created to enforce uniqueness on columns and to enable fast retrieval by column values.
A.	True
B.	False
Answer» B. False

Discussion

727.	An entity is something that can be identified in the user's work environment; something that the users want to track.
A.	True
B.	False
Answer» B. False

Discussion

728.	Entity instances are associated by relationship classes.
A.	True
B.	False
Answer» C.

Discussion

729.	1:1, 1:N and N:M relationships are also known as HAS-A relationships.
A.	True
B.	False
Answer» B. False

Discussion

730.	In a 1:N relationship, the parent is the entity on the one side of the relationship and the child is the entity on the N side of the relationship.
A.	True
B.	False
Answer» B. False

Discussion

731.	A maximum cardinality is the maximum number of entity instances that can participate in a relationship instance.
A.	True
B.	False
Answer» B. False

Discussion

732.	Composite identifiers consist of two or more attributes.
A.	True
B.	False
Answer» B. False

Discussion

733.	When designing a database, first identify the entities, then determine the attributes, and finally establish the relationships.
A.	True
B.	False
Answer» C.

Discussion

734.	A subtype entity is a special case of another entity called a supertype entity.
A.	True
B.	False
Answer» B. False

Discussion

735.	The reasons for overriding include extension, restriction, and optimization.
A.	True
B.	False
Answer» B. False

Discussion

736.	An object's state is determined by its attribute values and links to other objects.
A.	True
B.	False
Answer» B. False

Discussion

737.	Composition does not allow an object to be part of more than one aggregate object.
A.	True
B.	False
Answer» B. False

Discussion

738.	In an object diagram, an object is represented as a rectangle with two compartments.
A.	True
B.	False
Answer» B. False

Discussion

739.	An operation that alters the state of an object is known as a constructor operation.
A.	True
B.	False
Answer» C.

Discussion

740.	Each association has two or more roles.
A.	True
B.	False
Answer» B. False

Discussion

741.	The data model produced from the reverse engineering process is a true logical model.
A.	True
B.	False
Answer» C.

Discussion

742.	Reverse engineering is the process of reading a database schema and producing a data model from that schema.
A.	True
B.	False
Answer» B. False

Discussion

743.	It is not easy to build a database correctly the first time.
A.	True
B.	False
Answer» B. False

Discussion

744.	Typically, there should be at least two different copies of the database schema used in the redesign process.
A.	True
B.	False
Answer» C.

Discussion

745.	Dependency graphs are diagrams that consist of nodes and arcs that show the dependencies of a database.
A.	True
B.	False
Answer» B. False

Discussion

746.	The EXISTS keyword will be true if any row in the subquery meets the condition.
A.	True
B.	False
Answer» B. False

Discussion

747.	Although creating test databases is a critical and necessary job, there are few career opportunities in this area.
A.	True
B.	False
Answer» C.

Discussion

748.	Because of the need for extensive knowledge of SQL, many database developers choose to automate the redesign process.
A.	True
B.	False
Answer» C.

Discussion

749.	You can use the DROP statement to remove structures from the database.
A.	True
B.	False
Answer» B. False

Discussion

750.	Oracle commands, column names, table names, view names and all other database elements are case sensitive.
A.	True
B.	False
Answer» C.

Discussion

Explore topic-wise MCQs in Engineering.

A supertype can only have only one subtype.

Symmetric multiprocessing (SMP) architectures are useful for situations where data must remain in memory during processing to achieve the desired performance level.

There is cardinality on an EER between the supertype and subtype.

A subtype discriminator of the supertype is an attribute whose values determine the target subtype(s).

The Windows operating system and Windows applications are event driven.

The SQL MAKE TABLE command is used to construct tables, define columns, define column constraints and create relationships.

SQL has a JOIN ON syntax that can be used to create inner joins and outer joins.

Standard SQL-92 views are constructed from SQL SELECT statements that do not contain the GROUP BY clause.

The SQL CHECK constraint is fully defined by the SQL-92 standard, and is consistently implemented by all DBMS vendors.

A regular subquery is processed from the bottom up.

Correlated subqueries are similar to a regular subquery.

Database redesign is especially difficult if the database has no data.

A correlated subquery is processed as a nested subquery.

Some organizations take the stand that no application should ever employ the true name of a table.

A method defines the form or protocol of the operation, but not its implementation.

A class is a concept, abstraction, or thing that makes sense in an application context.

ODL supports the abstract keyword for classes and operations.

The ODMG Object Model requires that a relationship be specified in both directions.

Before specifying a key for a class, you must specify its extent.

The Object Model supports different literal types, but does not support atomic literals, collection literals, and structured literals.

An ID-dependent entity is an entity whose identifier is a composite identifier where no portion of the composite identifier is an identifier of another entity.

All instances of an entity class have the same attributes.

A ternary relationship is so called because in contains two entities and one association between them.

A minimum cardinality is the minimum number of entity instances that may participate in a relationship instance.

An attribute describes the entity's characteristics.

Indexes are created to enforce uniqueness on columns and to enable fast retrieval by column values.

An entity is something that can be identified in the user's work environment; something that the users want to track.

Entity instances are associated by relationship classes.

1:1, 1:N and N:M relationships are also known as HAS-A relationships.

In a 1:N relationship, the parent is the entity on the one side of the relationship and the child is the entity on the N side of the relationship.

A maximum cardinality is the maximum number of entity instances that can participate in a relationship instance.

Composite identifiers consist of two or more attributes.

When designing a database, first identify the entities, then determine the attributes, and finally establish the relationships.

A subtype entity is a special case of another entity called a supertype entity.

The reasons for overriding include extension, restriction, and optimization.

An object's state is determined by its attribute values and links to other objects.

Composition does not allow an object to be part of more than one aggregate object.

In an object diagram, an object is represented as a rectangle with two compartments.

An operation that alters the state of an object is known as a constructor operation.

Each association has two or more roles.

The data model produced from the reverse engineering process is a true logical model.

Reverse engineering is the process of reading a database schema and producing a data model from that schema.

It is not easy to build a database correctly the first time.

Typically, there should be at least two different copies of the database schema used in the redesign process.

Dependency graphs are diagrams that consist of nodes and arcs that show the dependencies of a database.

The EXISTS keyword will be true if any row in the subquery meets the condition.

Although creating test databases is a critical and necessary job, there are few career opportunities in this area.

Because of the need for extensive knowledge of SQL, many database developers choose to automate the redesign process.

You can use the DROP statement to remove structures from the database.

Oracle commands, column names, table names, view names and all other database elements are case sensitive.