1033 + Mcqs in Database Page 21 McqOptions

1001.	One common design problem when designing a database from existing data is the use of a general-purpose remarks column in the received data.
A.	True
B.	False
Answer» B. False

Discussion

1002.	One common design problem when designing a database from existing data is the presence of missing values, called blank values, in received data.
A.	True
B.	False
Answer» C.

Discussion

1003.	Normalization requires programmers to write more complex SQL.
A.	True
B.	False
Answer» B. False

Discussion

1004.	One common design problem when designing a database from existing data is the presence of inconsistent values in the received data.
A.	True
B.	False
Answer» B. False

Discussion

1005.	When building a database from an existing set of tables, we may safely assume that there are no multivalued dependencies in the data we are given.
A.	True
B.	False
Answer» C.

Discussion

1006.	The design guidelines and priorities for read-only databases are different because read-only databases are never updated.
A.	True
B.	False
Answer» B. False

Discussion

1007.	We use the SQL construct COUNT(*) to count the number of rows in a table.
A.	True
B.	False
Answer» B. False

Discussion

1008.	When you are given a set of tables and asked to create a database to store their data, the first step is to create the new database.
A.	True
B.	False
Answer» C.

Discussion

1009.	Each index consumes extra storage space and also requires overhead maintenance time whenever indexed data change value.
A.	True
B.	False
Answer» B. False

Discussion

1010.	The phrase "SALE.CNumber must exist in CUSTOMER.CNumber" is a referential integrity constraint.
A.	True
B.	False
Answer» B. False

Discussion

1011.	Indexes can usually be created for both primary and secondary keys.
A.	True
B.	False
Answer» B. False

Discussion

1012.	The HAVING clause acts like a WHERE clause, but it identifies groups that meet a criterion, rather than rows.
A.	True
B.	False
Answer» B. False

Discussion

1013.	SQL is a data sublanguage.
A.	True
B.	False
Answer» B. False

Discussion

1014.	The qualifier DISTINCT must be used in an SQL statement when we want to eliminate duplicate rows.
A.	True
B.	False
Answer» B. False

Discussion

1015.	The result of every SQL query is a table.
A.	True
B.	False
Answer» B. False

Discussion

1016.	COUNT(field_name) tallies only those rows that contain a value; it ignores all null values.
A.	True
B.	False
Answer» B. False

Discussion

1017.	SUM, AVG, MIN, and MAX can only be used with numeric columns.
A.	True
B.	False
Answer» C.

Discussion

1018.	When building a database from an existing set of tables, we may safely assume that referential integrity constraints have been enforced on the data we are given.
A.	True
B.	False
Answer» C.

Discussion

1019.	Most of the time, modification anomalies cause problems that are severe enough that a table should be normalized into BCNF.
A.	True
B.	False
Answer» B. False

Discussion

1020.	When building a database from an existing set of tables, we still need to consider normalization principles.
A.	True
B.	False
Answer» B. False

Discussion

1021.	We have normalized a table into BCNF if all candidate keys are determinants.
A.	True
B.	False
Answer» C.

Discussion

1022.	The condition in a WHERE clause can refer to only one value.
A.	True
B.	False
Answer» C.

Discussion

1023.	We use the SQL construct COLUMNS(*) to determine the number and type of columns in a table.
A.	True
B.	False
Answer» C.

Discussion

1024.	The ADD command is used to enter one row of data or to add multiple rows as a result of a query.
A.	True
B.	False
Answer» C.

Discussion

1025.	SQL provides the AS keyword, which can be used to assign meaningful column names to the results of queries using the SQL built-in functions.
A.	True
B.	False
Answer» B. False

Discussion

1026.	The SELECT command, with its various clauses, allows users to query the data contained in the tables and ask many different questions or ad hoc queries.
A.	True
B.	False
Answer» B. False

Discussion

1027.	A SELECT statement within another SELECT statement and enclosed in square brackets ([...]) is called a subquery.
A.	True
B.	False
Answer» C.

Discussion

1028.	The SQL keyword(s) ________ is used with wildcards.
A.	LIKE only
B.	IN only
C.	NOT IN only
D.	IN and NOT IN
Answer» B. IN only

Discussion

1029.	A subquery in an SQL SELECT statement is enclosed in:
A.	braces -- {...}.
B.	CAPITAL LETTERS.
C.	parenthesis -- (...) .
D.	brackets -- [...].
Answer» D. brackets -- [...].

Discussion

1030.	To remove duplicate rows from the results of an SQL SELECT statement, the ________ qualifier specified must be included.
A.	ONLY
B.	UNIQUE
C.	DISTINCT
D.	SINGLE
Answer» D. SINGLE

Discussion

1031.	SQL query and modification commands make up a(n) ________ .
A.	DDL
B.	DML
C.	HTML
D.	XML
Answer» C. HTML

Discussion

1032.	Multivalued dependencies should ________ be eliminated.
A.	always
B.	commonly
C.	seldom
D.	never
Answer» B. commonly

Discussion

1033.	Multivalued dependencies create harmless anomalies that should be noted, but do not always need to be eliminated.
A.	True
B.	False
Answer» C.

Discussion

Explore topic-wise MCQs in Engineering.

One common design problem when designing a database from existing data is the use of a general-purpose remarks column in the received data.

One common design problem when designing a database from existing data is the presence of missing values, called blank values, in received data.

Normalization requires programmers to write more complex SQL.

One common design problem when designing a database from existing data is the presence of inconsistent values in the received data.

When building a database from an existing set of tables, we may safely assume that there are no multivalued dependencies in the data we are given.

The design guidelines and priorities for read-only databases are different because read-only databases are never updated.

We use the SQL construct COUNT(*) to count the number of rows in a table.

When you are given a set of tables and asked to create a database to store their data, the first step is to create the new database.

Each index consumes extra storage space and also requires overhead maintenance time whenever indexed data change value.

The phrase "SALE.CNumber must exist in CUSTOMER.CNumber" is a referential integrity constraint.

Indexes can usually be created for both primary and secondary keys.

The HAVING clause acts like a WHERE clause, but it identifies groups that meet a criterion, rather than rows.

SQL is a data sublanguage.

The qualifier DISTINCT must be used in an SQL statement when we want to eliminate duplicate rows.

The result of every SQL query is a table.

COUNT(field_name) tallies only those rows that contain a value; it ignores all null values.

SUM, AVG, MIN, and MAX can only be used with numeric columns.

When building a database from an existing set of tables, we may safely assume that referential integrity constraints have been enforced on the data we are given.

Most of the time, modification anomalies cause problems that are severe enough that a table should be normalized into BCNF.

When building a database from an existing set of tables, we still need to consider normalization principles.

We have normalized a table into BCNF if all candidate keys are determinants.

The condition in a WHERE clause can refer to only one value.

We use the SQL construct COLUMNS(*) to determine the number and type of columns in a table.

The ADD command is used to enter one row of data or to add multiple rows as a result of a query.

SQL provides the AS keyword, which can be used to assign meaningful column names to the results of queries using the SQL built-in functions.

The SELECT command, with its various clauses, allows users to query the data contained in the tables and ask many different questions or ad hoc queries.

A SELECT statement within another SELECT statement and enclosed in square brackets ([...]) is called a subquery.

The SQL keyword(s) ________ is used with wildcards.

A subquery in an SQL SELECT statement is enclosed in:

To remove duplicate rows from the results of an SQL SELECT statement, the ________ qualifier specified must be included.

SQL query and modification commands make up a(n) ________ .

Multivalued dependencies should ________ be eliminated.

Multivalued dependencies create harmless anomalies that should be noted, but do not always need to be eliminated.