1033 + Mcqs in Database Page 14 McqOptions

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

Discussion

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

Discussion

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

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

Discussion

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

Discussion

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

Discussion

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

Discussion

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

Discussion

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

Discussion

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

Discussion

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

Discussion

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

Discussion

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

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

Discussion

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

Discussion

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

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

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

Discussion

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

Discussion

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

Discussion

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

Discussion

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

Discussion

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

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

Discussion

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

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

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

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

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

Discussion

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

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

Discussion

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

Discussion

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

Discussion

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

Discussion

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

Discussion

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

Discussion

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

Discussion

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

Discussion

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

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

Discussion

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

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

Discussion

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

Discussion

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

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

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

Discussion

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

Discussion

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

Discussion

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

Discussion

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

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.