Practice Database Questions Multiple Choice Questions with Answers Quiz-2

Q.1.

Of the three ways to create an Oracle database, which one is the easiest and most recommended?

Using the Oracle Database Configuration Assistant.
Using the Oracle-supplied database creation procedures.
Using the SQL CREATE DATABASE command.
None of the above is correct.

Explanation

Q.2.

Which of the following occurs when a transaction rereads data it has previously read and finds modification or deletions caused by a committed transaction?

Nonrepeatable read
Phantom read
Dirty read
Consistent read

Explanation

Q.3.

To eliminate definition duplication, XML Schemas define:

an intersection table.
global elements.
a normalized definition table.
None of the above is correct.

Explanation

Q.4.

Which of the following is not true about cloud computing?

which_of_the_following_is_not_true_about_cloud_computing1539240737.jpg image

Cloud-based management platforms cannot support internally hosted server platforms
Cloud-based management platforms can support multiple cloud-virtual server vendors
Cloud-based management platforms can support multiple cloud-virtual server operating systems
Cloud-based management platforms can support change management methodologies

Explanation

Q.5.

We Can still delete a row from primary table if there are related rows in secondary table once a refferential integrity is enforced

TRUE
FALSE

Explanation

Q.6.

Physical data models describe the details of how data is stored in the computers

TRUE
FALSE

Explanation

Q.7.

Cloud computing is not suited for situations

where complex legacy systems have to be ported
characterized by limited-time tasks
involving offloading of expensive computing tasks
with no existing regulatory compliance issues

Explanation

Q.8.

The no of entities participating in a relation is called

Relation
Degree of relationship
Recursive relationship
None of the above

Explanation

Q.9.

Which among the following is the disadvantage of circular list?

An info field that contains the information stored in the node
Can’t traverse the list backward
A pointer to the node is given we cannot delete the node
Both 2 and 3

Explanation

Q.10.

In enterprise data modeling, which is incorrect?

You review current systems.
You implement the new database.
You describe the data needed at a very high level of abstraction.
You plan one or more database development projects.

Explanation

Q.11.

Which among the following is the relationship constraints

Cardinality ratio
Participation constraints
Both A and B
None of the above

Explanation

Q.12.

Which type of entity is related to two or more associated entities that each contain specialized attributes that apply to some but not all of the instances of the entity?

Supertype entity
Subtype entity
Archetype entity
Instance entity

Explanation

Q.13.

A reason for using an SQL view to hide columns is:

to simplify a result only.
to prevent the display of sensitive data only.
to accomplish both of the above.
None of the above are reasons for using an SQL view.

Explanation

Q.14.

Which of the following indicates the maximum number of entities that can be involved in a relationship?

Minimum cardinality
Maximum cardinality
ERD
Greater Entity Count (GEC)

Explanation

Q.15.

A transitive dependency is which of the following?

A functional dependency between two or more key attributes.
A functional dependency between two or more nonkey attributes.
A relation that is in first normal form.
A relation that is in second normal form.

Explanation

Q.16.

A ternary relationship involves how many entities?

3 or less
3
More than 3
3 or more

Explanation

Q.17.

The capacity to change the conceptual schema without having to change external schemas or application programs is called

Physical Data Independence
Logical Data Independence
Both A and B
None

Explanation

Q.18.

The benefits of object-oriented modeling are which of the following?

The ability to tackle more challenging problems
Reusability of analysis, design, and programming results
Improved communication between users, analysts, etc.
All of the above.

Explanation

Q.19.

The ODBC core API consists of which of the following functions?

Commit or rollback transactions only
Connect to data sources only
Connect to data sources with driver-specific information only
Both 1 and 2 above are in the OBDC core API.

Explanation

Q.20.

The command to eliminate a table from a database is

REMOVE TABLE CUSTOMER;
UPDATE TABLE CUSTOMER;
DELETE TABLE CUSTOMER;
DROP TABLE CUSTOMER;

Explanation

Support mcqgeeks.com by disabling your adblocker.