1033 + Mcqs in Database McqOptions

1.	The only reason for the existence of relations is to store instances of functional dependencies.
A.	True
B.	False
Answer» B. False

Discussion

2.	A relation is in 5NF when multivalued dependencies are isolated in their own relation.
A.	True
B.	False
Answer» C.

Discussion

3.	The functional dependency R S means that the value of S can be determined when we are given a value of R.
A.	True
B.	False
Answer» B. False

Discussion

4.	In a relation, the columns are sometimes called "attributes."
A.	True
B.	False
Answer» B. False

Discussion

5.	In a relation, the order of the columns does not matter.
A.	True
B.	False
Answer» B. False

Discussion

6.	A functional dependency is a relationship between or among attributes.
A.	True
B.	False
Answer» B. False

Discussion

7.	A key is a group of one or more attributes that uniquely identifies a row.
A.	True
B.	False
Answer» B. False

Discussion

8.	Keys made up of two or more attributes are called composite keys.
A.	True
B.	False
Answer» B. False

Discussion

9.	Given the functional dependency R S , R is called the determinant.
A.	True
B.	False
Answer» B. False

Discussion

10.	Relations are categorized into normal forms according to the referential integrity constraints that they have.
A.	True
B.	False
Answer» C.

Discussion

11.	A relation is in Boyce-Codd Normal Form (BCNF) if every determinant is a composite key.
A.	True
B.	False
Answer» C.

Discussion

12.	In a relation, the rows are sometimes called "records."
A.	True
B.	False
Answer» B. False

Discussion

13.	Any table that meets the definition of a relation is said to be in first normal form.
A.	True
B.	False
Answer» B. False

Discussion

14.	Given the functional dependency R (S,T) , then it is also true that R S.
A.	True
B.	False
Answer» B. False

Discussion

15.	Data-volume and frequency-of-use statistics are not critical inputs to the physical database design process.
A.	True
B.	False
Answer» C.

Discussion

16.	In general, larger block sizes are used for online transaction processing applications and smaller block sizes are used for databases with a decision support or data warehousing system.
A.	True
B.	False
Answer» C.

Discussion

17.	When storage space is scarce and physical records cannot span pages, creating multiple physical records from one logical relation will minimize wasted storage space.
A.	True
B.	False
Answer» B. False

Discussion

18.	A field represents each component of a composite attribute.
A.	True
B.	False
Answer» B. False

Discussion

19.	Some advantages of partitioning include: efficiency, security, and load balancing.
A.	True
B.	False
Answer» B. False

Discussion

20.	Distributing the columns of a table into several separate physical records is known as horizontal partitioning.
A.	True
B.	False
Answer» C.

Discussion

21.	An extent is a contiguous section of disk storage space.
A.	True
B.	False
Answer» B. False

Discussion

22.	The three newest database architectures in use today are relational, multidimensional and hierarchical.
A.	True
B.	False
Answer» C.

Discussion

23.	Outer join is the same as equi-join, except one of the duplicate columns is eliminated in the result table.
A.	True
B.	False
Answer» C.

Discussion

24.	A function returns one value and has only output parameters.
A.	True
B.	False
Answer» C.

Discussion

25.	With the UNION clause, each query involved must output the same number of columns, and they must be UNION compatible.
A.	True
B.	False
Answer» B. False

Discussion

26.	When AUTOCOMMIT is set on, changes will be made automatically at the end of each SQL statement.
A.	True
B.	False
Answer» B. False

Discussion

27.	The UNION clause is used to combine the output from multiple queries together into a single result table.
A.	True
B.	False
Answer» B. False

Discussion

28.	The most frequently used relational operation, which brings together data from two or more related tables into one resultant table, is called an equi-join.
A.	True
B.	False
Answer» C.

Discussion

29.	A correlated subquery is where the outer query depends on data from the inner query.
A.	True
B.	False
Answer» C.

Discussion

30.	A transaction is the complete set of closely related update commands that must all be done, or none of them done, for the database to remain valid.
A.	True
B.	False
Answer» B. False

Discussion

31.	Centralized systems are more susceptible to security threats than client/server architectures.
A.	True
B.	False
Answer» C.

Discussion

32.	Writing stored procedures takes less time than using Visual Basic or PowerBuilder to create an application.
A.	True
B.	False
Answer» C.

Discussion

33.	Data processing logic includes such activities as data validation and identification of processing errors.
A.	True
B.	False
Answer» B. False

Discussion

34.	ODBC requires the specific driver.
A.	True
B.	False
Answer» B. False

Discussion

35.	The first client/server architectures developed were file servers.
A.	True
B.	False
Answer» B. False

Discussion

36.	A data mart is designed to optimize the performance for well-defined and predicable uses.
A.	True
B.	False
Answer» B. False

Discussion

37.	Successful data warehousing requires that a formal program in total quality management (TQM) be implemented.
A.	True
B.	False
Answer» B. False

Discussion

38.	The primary goal of physical database design is data processing efficiency.
A.	True
B.	False
Answer» B. False

Discussion

39.	A bitmap index is an index on columns from two or more tables that come from the same domain of values.
A.	True
B.	False
Answer» C.

Discussion

40.	Triggers are stored blocks of code that have to be called in order to operate.
A.	True
B.	False
Answer» C.

Discussion

41.	The joining technique is useful when data from several relations are to be retrieved and displayed and the relationships are not necessarily nested.
A.	True
B.	False
Answer» B. False

Discussion

42.	There should be one condition within the WHERE clause for each pair of tables being joined.
A.	True
B.	False
Answer» B. False

Discussion

43.	Subqueries can be nested multiple times.
A.	True
B.	False
Answer» B. False

Discussion

44.	The code to create triggers and routines is stored in only one location and is administered centrally.
A.	True
B.	False
Answer» B. False

Discussion

45.	All enterprise resource planning (ERP) systems are heavily dependent on databases to store the data required by the ERP applications.
A.	True
B.	False
Answer» B. False

Discussion

46.	Database management systems were first introduced in the 1950s.
A.	True
B.	False
Answer» C.

Discussion

47.	Databases that contain historical and summarized information are usually called data warehouses.
A.	True
B.	False
Answer» B. False

Discussion

48.	Packaged data models are meant to be exactly right straight out of the box.
A.	True
B.	False
Answer» C.

Discussion

49.	An action assertion is a statement that expresses some aspect of the static structure of the organization.
A.	True
B.	False
Answer» C.

Discussion

50.	Massively parallel processing (MPP) systems require a complete copy of the operating system to be resident in each dedicated memory.
A.	True
B.	False
Answer» B. False

Discussion

Explore topic-wise MCQs in Testing Subject.

The only reason for the existence of relations is to store instances of functional dependencies.

A relation is in 5NF when multivalued dependencies are isolated in their own relation.

The functional dependency R S means that the value of S can be determined when we are given a value of R.

In a relation, the columns are sometimes called "attributes."

In a relation, the order of the columns does not matter.

A functional dependency is a relationship between or among attributes.

A key is a group of one or more attributes that uniquely identifies a row.

Keys made up of two or more attributes are called composite keys.

Given the functional dependency R S , R is called the determinant.

Relations are categorized into normal forms according to the referential integrity constraints that they have.

A relation is in Boyce-Codd Normal Form (BCNF) if every determinant is a composite key.

In a relation, the rows are sometimes called "records."

Any table that meets the definition of a relation is said to be in first normal form.

Given the functional dependency R (S,T) , then it is also true that R S.

Data-volume and frequency-of-use statistics are not critical inputs to the physical database design process.

In general, larger block sizes are used for online transaction processing applications and smaller block sizes are used for databases with a decision support or data warehousing system.

When storage space is scarce and physical records cannot span pages, creating multiple physical records from one logical relation will minimize wasted storage space.

A field represents each component of a composite attribute.

Some advantages of partitioning include: efficiency, security, and load balancing.

Distributing the columns of a table into several separate physical records is known as horizontal partitioning.

An extent is a contiguous section of disk storage space.

The three newest database architectures in use today are relational, multidimensional and hierarchical.

Outer join is the same as equi-join, except one of the duplicate columns is eliminated in the result table.

A function returns one value and has only output parameters.

With the UNION clause, each query involved must output the same number of columns, and they must be UNION compatible.

When AUTOCOMMIT is set on, changes will be made automatically at the end of each SQL statement.

The UNION clause is used to combine the output from multiple queries together into a single result table.

The most frequently used relational operation, which brings together data from two or more related tables into one resultant table, is called an equi-join.

A correlated subquery is where the outer query depends on data from the inner query.

A transaction is the complete set of closely related update commands that must all be done, or none of them done, for the database to remain valid.

Centralized systems are more susceptible to security threats than client/server architectures.

Writing stored procedures takes less time than using Visual Basic or PowerBuilder to create an application.

Data processing logic includes such activities as data validation and identification of processing errors.

ODBC requires the specific driver.

The first client/server architectures developed were file servers.

A data mart is designed to optimize the performance for well-defined and predicable uses.

Successful data warehousing requires that a formal program in total quality management (TQM) be implemented.

The primary goal of physical database design is data processing efficiency.

A bitmap index is an index on columns from two or more tables that come from the same domain of values.

Triggers are stored blocks of code that have to be called in order to operate.

The joining technique is useful when data from several relations are to be retrieved and displayed and the relationships are not necessarily nested.

There should be one condition within the WHERE clause for each pair of tables being joined.

Subqueries can be nested multiple times.

The code to create triggers and routines is stored in only one location and is administered centrally.

All enterprise resource planning (ERP) systems are heavily dependent on databases to store the data required by the ERP applications.

Database management systems were first introduced in the 1950s.

Databases that contain historical and summarized information are usually called data warehouses.

Packaged data models are meant to be exactly right straight out of the box.

An action assertion is a statement that expresses some aspect of the static structure of the organization.

Massively parallel processing (MPP) systems require a complete copy of the operating system to be resident in each dedicated memory.