Practice Database Questions Multiple Choice Questions with Answers Quiz-4

Q.1.

A composite attribute is which of the following?

An attribute that can be broken into components
An attribute that cannot be broken into components
Multiple attributes
An identifier

Explanation

Q.2.

Legacy data is which of the following?

Data contained in a newly-installed system
Data rejected during the installation of a new system
Data contained in a file system
Data contained by a system used prior to the installation of a new system

Explanation

Q.3.

Cloud computing uses Server virtualization.

TRUE
FALSE

Explanation

Q.4.

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

1NF
2NF
3NF
BCNF

Explanation

Q.5.

In the relational model, relationships between relations or tables are created by using:

composite keys.
determinants.
candidate keys.
foreign keys.

Explanation

Q.6.

An entity is a thing in the real world with an independent existence.

TRUE
FALSE

Explanation

Q.7.

A proxy server is used for which of the following?

To provide security against unauthorized users
To process client requests for Web pages
To process client requests for database access
To provide TCP/IP

Explanation

Q.8.

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

ONLY
DISTINCT
UNIQUE
SINGLE

Explanation

Q.9.

What SQL command will allow you to change the table STUDENT to add the constraint named GradeCheck that states that the values of the Grade column must be greater than 0?

ALTER TABLE STUDENT ALTER CONSTRAINT GradeCheck (Grade > 0);
ALTER TABLE STUDENT ADD CONSTRAINT GradeCheck (Grade > 0);
ALTER TABLE STUDENT ADD CONSTRAINT GradeCheck CHECK (Grade > 0);
None of the above is correct.

Explanation

Q.10.

A supertype/subtype hierarchy has which of the following features?

Subtypes at the lower lever in the hierarchy inherit attributes only from their immediate supertype.
Subtypes at the higher lever in the hierarchy inherit attributes only from their immediate subtype.
Attributes are assigned at the highest logical level.
Attributes are assigned at the lowest logical level.

Explanation

Q.11.

When an entity instance may be a member of multiple subtypes or it does not have to be a member of a subtype, it is which of the following?

Disjoint with total specialization
Disjoint with partial specialization
Overlap with total specialization
Overlap with partial specialization

Explanation

Q.12.

The HAVING clause does which of the following?

Acts like a WHERE clause but is used for groups rather than rows.
Acts like a WHERE clause but is used for rows rather than columns.
Acts like a WHERE clause but is used for columns rather than groups.
Acts EXACTLY like a WHERE clause.

Explanation

Q.13.

The following SQL is which type of join: SELECT CUSTOMER_T. CUSTOMER_ID, ORDER_T. CUSTOMER_ID, NAME, ORDER_ID FROM CUSTOMER_T,ORDER_T ;

Equi-join
Natural join
Outer join
Cartesian join

Explanation

Q.14.

It is necessary to sort a file before searching a particular item

True
False
May or may not be true
None of the above

Explanation

Q.15.

When three or more AND and OR conditions are combined, it is easier to use the SQL keyword(s):

LIKE only.
IN only.
NOT IN only.
Both IN and NOT IN.

Explanation

Q.16.

A data dictionary is a special file that contains

The width of all fields in all files
The data type of all fields in all file
The name of all fields in all files
All of the above

Explanation

Q.17.

A benefit of the three-tier architecture is which of the following?

New modules can be built to support specific business needs
Performance improves for compiled SQL statements
Results in a thinner client and database server
All of the above.

Explanation

Q.18.

When assessing the table structure of an acquired set of tables with data, accessing the validity of possible referential integrity constraints on foreign keys is (part of) the:

first step.
second step.
third step.
fourth step.

Explanation

Q.19.

For what purposes are views used?

To hide rows only
To hide columns only
To hide complicated SQL statements only
All of the above are uses for SQL views.

Explanation

Q.20.

Which of the following is true about cloud computing?

Cloud computing has brought about a drop in hardware and software sales, while augmenting service revenues
You can access your data from any computer in the world, as long as you have an Internet connection.
Both A & B
It's always going to be less expensive and more secure than local computing.

Explanation

Support mcqgeeks.com by disabling your adblocker.