Menu

Question Discussion & Solution

MCQ

Q.

The database environment has all of the following components except:

A

users

B

separate files.

C

database

D

database administrator.

Community Discussion

No discussions yet. Be the first to start!

You must be logged in to participate in the discussion.

Login to Discuss

Similar Questions

MCQ

1.

In SQL, the ALTER TABLESPACE command is used

A

to add/rename data files

B

to change storage characteristics

C

to take a tablespace online/offline

D

to begin/end a backup

E

All of the above

Discussion

MCQ

2.

One of the reasons why OODBMSs have not been widely used for business information systems is that OOP is obsolete.

A

True

B

False

Discussion

MCQ

3.

Database applications are seldom intended for use by a single user.

A

True

B

False

Discussion

MCQ

4.

In a relational schema, each tuple is divided into fields called

A

Relations

B

Domains

C

Queries

D

All of the above

E

None of the above

Discussion

MCQ

5.

In SQL, the CREATE TABLE is used

A

to create a table, defining its columns, integrity constrains, and storage allocation

B

to add a column/integrity constraint to a table

C

to redefine a column

D

to change a table's storage characteristics

E

All of the above

Discussion

More Database Management System Topics

Miscellaneous or General

71 MCQs

Relational Algebra

3 MCQs

Database Systems

49 MCQs

Data Models

16 MCQs

The Relational Database Model

58 MCQs

Entity Relationship (ER) Modeling

59 MCQs

Advanced Data Modeling

1 MCQs

Normalization

58 MCQs

Structured Query Language (SQL)

7 MCQs

Advanced SQL

90 MCQs

Database Design

2 MCQs

Transaction and Concurrency

10 MCQs

Data Warehouses

10 MCQs

Database Administration

1 MCQs

Mixed

10 MCQs