1033 + Mcqs in Database McqOptions

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

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

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

Discussion

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

Discussion

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

Discussion

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

Discussion

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

Discussion

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

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

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

Discussion

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

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

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

Discussion

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

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

Discussion

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

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

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

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

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

Discussion

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

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

Discussion

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

Discussion

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

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

Discussion

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

Discussion

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

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

Discussion

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

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

Discussion

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

Discussion

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

Discussion

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

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

Discussion

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

Discussion

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

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

Discussion

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

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

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

Discussion

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

Discussion

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

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

Discussion

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

Discussion

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

Discussion

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

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

Discussion

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

Discussion

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

Discussion

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

Discussion

Explore topic-wise MCQs in Testing Subject.

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.