1033 + Mcqs in Database Page 20 McqOptions

951.	Some advantages of the database approach include all, but:
A.	minimal data redundancy.
B.	improved data consistency.
C.	improved data sharing.
D.	program-data dependency.
Answer» E.

Discussion

952.	User views are included as part of which schema?
A.	Internal
B.	Conceptual
C.	External
D.	None of the above.
Answer» D. None of the above.

Discussion

953.	A conceptual schema is usually depicted in graphical format using E-R or object-modeling notations.
A.	True
B.	False
Answer» B. False

Discussion

954.	A fact is a word or phrase that has a specific meaning for the business.
A.	True
B.	False
Answer» C.

Discussion

955.	A candidate key must uniquely identify each row.
A.	True
B.	False
Answer» B. False

Discussion

956.	A pointer is a detailed coding scheme recognized by system software for representing organizational data.
A.	True
B.	False
Answer» C.

Discussion

957.	Mirrored databases are almost always provided in high-availability systems.
A.	True
B.	False
Answer» B. False

Discussion

958.	A constructor operation does which of the following?
A.	Creates a new instance of a class
B.	Updates an existing instance of a class
C.	Deletes and existing instance of a class
D.	All of the above.
Answer» B. Updates an existing instance of a class

Discussion

959.	Composition is a stronger form of which of the following?
A.	Aggregation
B.	Encapsulation
C.	Inheritance
D.	All of the above.
Answer» B. Encapsulation

Discussion

960.	Database objects are almost always transient.
A.	True
B.	False
Answer» C.

Discussion

961.	Which type of entity has its relationship to another entity determined by an attribute in that other entity called a discriminator?
A.	Supertype entity
B.	Subtype entity
C.	Archetype entity
D.	Instance entity
Answer» C. Archetype entity

Discussion

962.	Which of the following is an SQL trigger supported by Oracle?
A.	BEFORE
B.	INSTEAD OF
C.	AFTER
D.	All of the above.
Answer» E.

Discussion

963.	The SQL statement used to create a view is CREATE VIEW.
A.	True
B.	False
Answer» B. False

Discussion

964.	A tool that can help designers understand the dependencies of database structures is a:
A.	dependency graph.
B.	data model.
C.	graphical display.
D.	None of the above is correct.
Answer» B. data model.

Discussion

965.	Money is defined in Oracle with the Currency data type.
A.	True
B.	False
Answer» C.

Discussion

966.	Legacy data is which of the following?
A.	Data contained in a newly-installed system
B.	Data rejected during the installation of a new system
C.	Data contained in a file system
D.	Data contained by a system used prior to the installation of a new system
Answer» E.

Discussion

967.	Oracle, the world's most popular DBMS, is powerful and robust, running on many different operating systems.
A.	True
B.	False
Answer» B. False

Discussion

968.	Which of the following is true for a relational database?
A.	Data is represented by tables.
B.	It is difficult to access data.
C.	Complex programs have to be written for simple queries.
D.	All of the above.
Answer» B. It is difficult to access data.

Discussion

969.	If an entity adheres to the disjoint rule, then an entity instance can be a member of more than one entity for a given supertype.
A.	True
B.	False
Answer» C.

Discussion

970.	Hashing algorithm converts a primary key value into a record address.
A.	True
B.	False
Answer» B. False

Discussion

971.	It is usually not very important to design the physical database to minimize the time required by users to interact with the information systems.
A.	True
B.	False
Answer» C.

Discussion

972.	ROLLBACK WORK asks SQL to empty the log file.
A.	True
B.	False
Answer» B. False

Discussion

973.	Activities of a DBMS occur in the processing component logic.
A.	True
B.	False
Answer» C.

Discussion

974.	The extract process is which of the following?
A.	Capturing all of the data contained in various operational systems
B.	Capturing a subset of the data contained in various operational systems
C.	Capturing all of the data contained in various decision support systems
D.	Capturing a subset of the data contained in various decision support systems
Answer» C. Capturing all of the data contained in various decision support systems

Discussion

975.	The format SELECT-FROM-WHERE is the fundamental framework of SQL SELECT statements.
A.	True
B.	False
Answer» B. False

Discussion

976.	Indexes may be created or dropped at any time.
A.	True
B.	False
Answer» B. False

Discussion

977.	The SQL statement: SELECT Number1 + Number 2 AS Total FROM NUMBER_TABLE; adds two numbers from each row together and lists the results in a column named Total.
A.	True
B.	False
Answer» B. False

Discussion

978.	ORDER BY can be combined with the SELECT statements.
A.	True
B.	False
Answer» B. False

Discussion

979.	Data manipulation language (DML) commands are used to define a database, including creating, altering, and dropping tables and establishing constraints.
A.	True
B.	False
Answer» C.

Discussion

980.	DISTINCT and its counterpart, ALL, can be used more than once in a SELECT statement.
A.	True
B.	False
Answer» C.

Discussion

981.	Most companies keep at least two versions of any database they are using.
A.	True
B.	False
Answer» B. False

Discussion

982.	Microsoft Access has become ubiquitous, and being able to program in Access is a critical skill.
A.	True
B.	False
Answer» C.

Discussion

983.	The keyword BETWEEN can be used in a WHERE clause to refer to a range of values.
A.	True
B.	False
Answer» B. False

Discussion

984.	SQL provides five built-in functions: COUNT, SUM, AVG, MAX, MIN.
A.	True
B.	False
Answer» B. False

Discussion

985.	To establish a range of values, < and > can be used.
A.	True
B.	False
Answer» B. False

Discussion

986.	If you are going to use a combination of three or more AND and OR conditions, it is often easier to use the NOT and NOT IN operators.
A.	True
B.	False
Answer» B. False

Discussion

987.	The keyword LIKE can be used in a WHERE clause to refer to a range of values.
A.	True
B.	False
Answer» C.

Discussion

988.	The SQL statement: SELECT Name, COUNT(*) FROM NAME_TABLE; counts the number of name rows and displays this total in a table with a single row and a single column.
A.	True
B.	False
Answer» C.

Discussion

989.	The SQL keyword GROUP BY instructs the DBMS to group together those rows that have the same value in a column.
A.	True
B.	False
Answer» B. False

Discussion

990.	The wildcard asterisk (*) is the SQL-92 standard for indicating "any sequence of characters."
A.	True
B.	False
Answer» C.

Discussion

991.	There is an equivalent join expression that can be substituted for all subquery expressions.
A.	True
B.	False
Answer» C.

Discussion

992.	The rows of the result relation produced by a SELECT statement can be sorted, but only by one column.
A.	True
B.	False
Answer» C.

Discussion

993.	A dynamic view is one whose contents materialize when referenced.
A.	True
B.	False
Answer» B. False

Discussion

994.	SQL is a programming language.
A.	True
B.	False
Answer» C.

Discussion

995.	SELECT DISTINCT is used if a user wishes to see duplicate columns in a query.
A.	True
B.	False
Answer» C.

Discussion

996.	One common design problem when designing a database from existing data is the use of a single cell in one column to store multiple values of an attribute.
A.	True
B.	False
Answer» C.

Discussion

997.	In all cases, normalization into BCNF is desirable.
A.	True
B.	False
Answer» C.

Discussion

998.	Denormalized tables are in BCNF.
A.	True
B.	False
Answer» C.

Discussion

999.	We can eliminate modification anomalies with proper normalization that results in tables in BCNF.
A.	True
B.	False
Answer» B. False

Discussion

1000.	Proper normalization eliminates duplicated data.
A.	True
B.	False
Answer» C.

Discussion

Explore topic-wise MCQs in Engineering.

Some advantages of the database approach include all, but:

User views are included as part of which schema?

A conceptual schema is usually depicted in graphical format using E-R or object-modeling notations.

A fact is a word or phrase that has a specific meaning for the business.

A candidate key must uniquely identify each row.

A pointer is a detailed coding scheme recognized by system software for representing organizational data.

Mirrored databases are almost always provided in high-availability systems.

A constructor operation does which of the following?

Composition is a stronger form of which of the following?

Database objects are almost always transient.

Which type of entity has its relationship to another entity determined by an attribute in that other entity called a discriminator?

Which of the following is an SQL trigger supported by Oracle?

The SQL statement used to create a view is CREATE VIEW.

A tool that can help designers understand the dependencies of database structures is a:

Money is defined in Oracle with the Currency data type.

Legacy data is which of the following?

Oracle, the world's most popular DBMS, is powerful and robust, running on many different operating systems.

Which of the following is true for a relational database?

If an entity adheres to the disjoint rule, then an entity instance can be a member of more than one entity for a given supertype.

Hashing algorithm converts a primary key value into a record address.

It is usually not very important to design the physical database to minimize the time required by users to interact with the information systems.

ROLLBACK WORK asks SQL to empty the log file.

Activities of a DBMS occur in the processing component logic.

The extract process is which of the following?

The format SELECT-FROM-WHERE is the fundamental framework of SQL SELECT statements.

Indexes may be created or dropped at any time.

The SQL statement: SELECT Number1 + Number 2 AS Total FROM NUMBER_TABLE; adds two numbers from each row together and lists the results in a column named Total.

ORDER BY can be combined with the SELECT statements.

Data manipulation language (DML) commands are used to define a database, including creating, altering, and dropping tables and establishing constraints.

DISTINCT and its counterpart, ALL, can be used more than once in a SELECT statement.

Most companies keep at least two versions of any database they are using.

Microsoft Access has become ubiquitous, and being able to program in Access is a critical skill.

The keyword BETWEEN can be used in a WHERE clause to refer to a range of values.

SQL provides five built-in functions: COUNT, SUM, AVG, MAX, MIN.

To establish a range of values, &lt; and &gt; can be used.

If you are going to use a combination of three or more AND and OR conditions, it is often easier to use the NOT and NOT IN operators.

The keyword LIKE can be used in a WHERE clause to refer to a range of values.

The SQL statement: SELECT Name, COUNT(*) FROM NAME_TABLE; counts the number of name rows and displays this total in a table with a single row and a single column.

The SQL keyword GROUP BY instructs the DBMS to group together those rows that have the same value in a column.

The wildcard asterisk (*) is the SQL-92 standard for indicating "any sequence of characters."

There is an equivalent join expression that can be substituted for all subquery expressions.

The rows of the result relation produced by a SELECT statement can be sorted, but only by one column.

A dynamic view is one whose contents materialize when referenced.

SQL is a programming language.

SELECT DISTINCT is used if a user wishes to see duplicate columns in a query.

One common design problem when designing a database from existing data is the use of a single cell in one column to store multiple values of an attribute.

In all cases, normalization into BCNF is desirable.

Denormalized tables are in BCNF.

We can eliminate modification anomalies with proper normalization that results in tables in BCNF.

Proper normalization eliminates duplicated data.

To establish a range of values, < and > can be used.