1033 + Mcqs in Database McqOptions

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

Discussion

2.	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

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

Discussion

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

Discussion

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

Discussion

6.	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

7.	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

8.	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

9.	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

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

Discussion

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

Discussion

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

Discussion

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

Discussion

14.	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

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

Discussion

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

Discussion

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

Discussion

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

Discussion

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

Discussion

20.	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

21.	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

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

Discussion

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

Discussion

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

Discussion

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

Discussion

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

Discussion

27.	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

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

Discussion

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

Discussion

30.	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

31.	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

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

Discussion

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

Discussion

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

Discussion

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

Discussion

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

Discussion

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

Discussion

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

Discussion

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

Discussion

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

Discussion

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

Discussion

42.	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

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

Discussion

44.	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

45.	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

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

Discussion

47.	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

48.	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

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

Discussion

50.	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 Testing Subject.

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.