Welcome to

CrackIT
DBMS imp MCQs
Which of the following products was an early implementation of the relational model developed by E.F. Codd of IBM?

A. IDMS
B. DB2
C. dBase-II
D. R:base

Every time attribute A appears, it is matched with the same value of attribute B, but not the same value of attribute C.
Therefore, it is true that:

A. A → B.
B. A → C.
C. A → (B,C).
D. (B,C) → A.

A relation is in this form if it is in BCNF and has no multivalued dependencies:

A. second normal form.

B. third normal form.
C. fourth normal form.
D. domain/key normal form.

Row is synonymous with the term:

A. record.
B. relation.
C. column.
D. field.
Which of the following is a group of one or more attributes that uniquely identifies a row?

A. Key
B. Determinant
C. Tuple
D. Relation

When the values in one or more attributes being used as a foreign key must exist in another set of one or more attributes in
another table, we have created a(n):

A. transitive dependency.
B. insertion anomaly.
C. referential integrity constraint.
D. normal form.

A relation in this form is free of all modification anomalies.

A. First normal form

B. Second normal form
C. Third normal form
D. Domain/key normal form

Which type of entity cannot exist in the database unless another type of entity also exists in the database, but does not require
that the identifier of that other entity be included as part of its own identifier?

A. Weak entity
B. Strong entity
C. ID-dependent entity
D. ID- independent entity
In a one-to-many relationship, the entity that is on the one side of the relationship is called a(n) ________ entity.

A. parent
B. child
C. instance
D. subtype

In a one-to-many relationship, the entity that is on the many side of the relationship is called a(n) ________ entity.

A. parent
B. child
C. instance
D. subtype

The SQL command to create a table is:

A. MAKE TABLE.
B. ALTER TABLE.
C. DEFINE TABLE.
D. CREATE TABLE.
The DROP TABLE statement:

A. deletes the table structure only.

B. deletes the table structure along with the table data.
C. works whether or not referential integrity constraints would be violated.
D. is not an SQL statement.

What SQL structure is used to limit column values of a table?

A. The LIMIT constraint

B. The CHECK constraint
C. The VALUE constraint
D. None of the above is correct.
Views constructed from SQL SELECT statements that conform to the SQL-92 standard may not contain:

A. GROUP BY.
B. WHERE.
C. ORDER BY.
D. FROM.

Locks placed by command are called ________ .

A. implicit locks
B. explicit locks
C. exclusive locks
D. shared locks

Which of the following occurs when a transaction rereads data and finds new rows that were inserted by a command
transaction since the prior read?

A. Nonrepeatable read
B. Phantom read
C. Dirty read
D. Consistent read
In this instance, dirty reads are disallowed, while nonrepeatable reads and phantom reads are allowed.

A. Read committed
B. Read uncommitted
C. Repeatable read
D. Serializable

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

A. Nonrepeatable read
B. Phantom read
C. Dirty read
D. Consistent read

Which of the following disallows both dirty reads and nonrepeatable reads, but allows phantom reads?

A. Read committed
B. Read uncommitted
C. Repeatable read
D. Serializable

Dirty read, nonrepeatable, and phantom reads are not possible in this instance.

A. Read committed
B. Read uncommitted
C. Repeatable read
D. Serializable
A transaction in which either all of the database actions occur or none of them do is called:

A. atomic.
B. consistent.
C. isolated.
D. durable.

Which of the following occurs when one transaction reads a changed record that has not been committed to the database?

A. Nonrepeatable read
B. Phantom read
C. Dirty read
D. Consistent read

Which of the following allows dirty reads, nonrepeatable reads and phantom reads to occur?

A. Read committed
B. Read uncommitted
C. Repeatable read
D. Serializable

The size of a lock is called:

A. implicit lock.
B. lock granularity.
C. exclusive lock.
D. shared lock.
Which of the following database activities determines the entities, attributes, and relationships of data?

A. Conceptual data modeling

B. Logical database design
C. Physical database design and definition
D. Database implementation

User views are included as part of which schema?

A. Internal
B. Conceptual
C. External
D. None of the above.

An oval represents which of the following in an EER?

A. Attribute
B. Entity
C. Optional One
D. Relationship

The fastest read/write time and most efficient data storage of any disk array type is:

A. RAID-0.
B. RAID-1.
C. RAID-2.
D. RAID-3.
A snowflake schema is which of the following types of tables?

A. Fact
B. Dimension
C. Helper
D. All of the above

Fact tables are which of the following?

A. Completely denoralized
B. Partially denoralized
C. Completely normalized
D. Partially normalized

Data transformation includes which of the following?

A. A process to change data from a detailed level to a summary level

B. A process to change data from a summary level to a detailed level
C. Joining data from one source into various sources of data
D. Separating data from one source into various sources of data

Reconciled data is which of the following?

A. Data stored in the various operational systems throughout the organization.

B. Current data intended to be the single source for all decision support systems.
C. Data stored in one operational system in the organization.
D. Data that has been selected and formatted for end-user support applications.
A star schema has what type of relationship between a dimension and fact table?

A. Many-to-many
B. One-to-one
C. One-to-many
D. All of the above.

Storing a separate copy of the database at multiple locations is which of the following?

A. Data Replication
B. Horizontal Partitioning
C. Vertical Partitioning
D. Horizontal and Vertical Partitioning

You can add a row using SQL in a database with which of the following?

A. ADD
B. CREATE
C. INSERT
D. MAKE

The command to remove rows from a table 'CUSTOMER' is:

A. REMOVE FROM CUSTOMER ...

B. DROP FROM CUSTOMER ...
C. DELETE FROM CUSTOMER WHERE ...
D. UPDATE FROM CUSTOMER ...
The SQL WHERE clause:

A. limits the column data that are returned.

B. limits the row data are returned.
C. Both A and B are correct.
D. Neither A nor B are correct.

Where clause is used to limit the row. If I want to display only those student name who achieve greater than 80
then we limit the row.

The wildcard in a WHERE clause is useful when?

A. An exact match is necessary in a SELECT statement.

B. An exact match is not possible in a SELECT statement.
C. An exact match is necessary in a CREATE statement.
D. An exact match is not possible in a CREATE statement.

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

A. LIKE only
B. IN only
C. NOT IN only
D. IN and NOT IN
Which of the following is the correct order of keywords for SQL SELECT statements?

A. SELECT, FROM, WHERE

B. FROM, WHERE, SELECT
C. WHERE, FROM,SELECT
D. SELECT,WHERE,FROM

A subquery in an SQL SELECT statement is enclosed in:

A. braces -- {...}.
B. CAPITAL LETTERS.
C. parenthesis -- (...) .
D. brackets -- [...].

The HAVING clause does which of the following?

A. Acts like a WHERE clause but is used for groups rather than rows.
B. Acts like a WHERE clause but is used for rows rather than columns.
C. Acts like a WHERE clause but is used for columns rather than groups.
D. Acts EXACTLY like a WHERE clause.
Which one of the following sorts rows in SQL?

A. SORT BY
B. ALIGN BY
C. ORDER BY
D. GROUP BY

To define what columns should be displayed in an SQL SELECT statement:

A. use FROM to name the source table(s) and list the columns to be shown after SELECT.
B. use USING to name the source table(s) and list the columns to be shown after SELECT.
C. use SELECT to name the source table(s) and list the columns to be shown after USING.
D. use USING to name the source table(s) and list the columns to be shown after WHERE.
 The SQL keyword BETWEEN is used:

A. for ranges.
B. to limit the columns displayed.
C. as a wildcard.
D. None of the above is correct.

Using the SQL GROUP BY phrase with a SELECT statement can help detect which of the following problems?

A. The multivalue, multicolumn problem

B. The inconsistent values problem
C. The missing values problem
D. The general-purpose remarks column problem

Most of the time, modification anomalies are serious enough that tables should be normalized into:

A. 1NF.
B. 2NF.
C. 3NF.
D. BCNF.

If a table has been normalized so that all determinants are candidate keys, then that table is in:

A. 1NF.
B. 2NF.
C. 3NF.
D. BCNF.
In a 1:N relationship, the foreign key is placed in:

A. either table without specifying parent and child tables.

B. the parent table.
C. the child table.
D. either the parent table or the child table.

A unique, DBMS-supplied identifier used as the primary key of a relation is called a(n):

A. primary key.
B. foreign key.
C. composite key.
D. surrogate key.

After a table has been created, its structure can be modified using the SQL command:

A. UPDATE TABLE [TableName].

B. MODIFY TABLE [TableName].
C. ALTER TABLE [TableName].
D. CHANGE TABLE [TableName].
When using ODBC, which of the following processes ODBC requests and submits specific SQL statements to a
given type of data source?

A. Data source
B. Driver
C. Driver manager
D. DBMS

How many JDBC driver types does Sun define?

[A]. One
[B]. Two
[C]. Three
[D]. Four

Which JDBC driver Type(s) can be used in either applet or servlet code?

A. Both Type 1 and Type 2

B. Both Type 1 and Type 3
C. Both Type 3 and Type 4
D. Type 4 only
What MySQL property is used to create a surrogate key in MySQL?

A. UNIQUE
B. SEQUENCE
C. AUTO_INCREMENT
D. None of the above -- Surrogate keys are not implemented in MySQL.

Which JDBC driver Type(s) can you use in a three-tier architecture and if the Web server and the DBMS are
running on the same machine?

A. Type 1 only
B. Type 2 only
C. Both Type 3 and Type 4
D. All of Type 1, Type 2, Type 3 and Type 4

What is invoked via HTTP on the Web server computer when it responds to requests from a user's Web
browser?

A. A Java application
B. A Java applet
C. A Java servlet
D. None of the above is correct.
The entity integrity rule states that:

A. no primary key attribute may be null.

B. no primary key can be composite.
C. no primary key may be unique.
D. no primary key may be equal to a value in a foreign key.

If no multivalued attributes exist and no partial dependencies exist in a relation, then the relation is in what
normal form?

A. First normal form

B. Second normal form
C. Third normal form
D. Fourth normal form

A transitive dependency is which of the following?

A. A functional dependency between two or more key attributes.

B. A functional dependency between two or more nonkey attributes.
C. A relation that is in first normal form.
D. A relation that is in second normal form.
What type of join is needed when you wish to include rows that do not have matching values?

A. Equi-join
B. Natural join
C. Outer join
D. All of the above.

What type of join is needed when you wish to return rows that do have matching values?

A. Equi-join
B. Natural join
C. Outer join
D. All of the above.

Which of the following is true concerning triggers?

A. You do not create them with SQL.

B. They execute against only some applications that access a database.
C. They have an event, condition, and action.
D. They cannot cascade (cause another trigger to fire).
 ultiplicity is the same as what concept for an ERD?

A. Relationship
B. Attribute
C. Entity
D. Cardinality

Composition is a stronger form of which of the following?

A. Aggregation
B. Encapsulation
C. Inheritance
D. All of the above.

Aggregation is which of the following?

A. Expresses a part-of relationship and is a stronger form of an association relationship.

B. Expresses a part-of relationship and is a weaker form of an association relationship.
C. Expresses an is-a relationship and is a stronger form of an association relationship.
D. Expresses an is-a relationship and is a weaker form of an association relationship.