MCQ | Database Management System (DBMS)

Database Management System (DBMS)

1 / 53

Which of the following SQL statement is used to DELETE rows from a database table? .

CLEAR

DROP

REMOVE

DELETE

2 / 53

The data type appropriate to store salary is. .

Text

Currency

Auto number

Memo

3 / 53

In a distributed Database reduction of redundancy is obtained by_____

Data fragmentation

Data Sharing

Data Replication

None of the above

4 / 53

In MS Access data are stored In . . ….

Query

Table

All of the options are correct

Form

5 / 53

The entity relationship set is represented in E-R diagram as

Dashed lines

Double diamonds

Undivided rectangles

Diamond

6 / 53

A relationship is considered a:

two-dimensional table

one-dimensional table

three-dimensional table

Column

7 / 53

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

Vertical Partitioning

Horizontal Partitioning

Vertical Partitioning

Data Replication

8 / 53

The server process that implements lock Manages functionality, is called

Lock Manager Proceses

Server Processes

Manager processes

Database Writer Process

9 / 53

An _______ is a set of entities of the same type that share the same properties, of attributes.

Entity model

Attribute set

Entity set

Relation set

10 / 53

The UPDATE SQL clause can______

delete more than one row at a time

update more than one row at a time

update only one row at a time

delete only one row at a time

11 / 53

In general, a file is basically a collection of all related_____

Database

Rows & Columns

Fields

Records

12 / 53

Which of the following gives a logical structure of the database graphically?

Entity-Relationship diagram

Entity diagram

Database diagram

Architectural representation

13 / 53

This key that uniquely identifies each record is called:

Primary Key

Unique Key

Field Name

Key Record

14 / 53

Which-one ofthe following statements about normal forms is FALSE?

Loss less, dependency – preserving decomposition into BCNF is always possible

Any relation with two attributes is BCNF

BCNF is stricter than 3 NF

Lossless, dependency –preserving decomposition into 3 NF is always possible

15 / 53

A data dictionary is repository that manages _________

Spell Checker

Memory

Data validator

Metadata

16 / 53

A........ key uniquely identifies a record.

Primary

None

Composite

Foreign

17 / 53

The primary key does not accept . . .

Text

Null Value

Number

None of above

18 / 53

Which of the following is a group of one or more attributes that uniquely identifies a row?

Tuple

Determinant

Key

Relation

19 / 53

The columns in a database table are called. ..

report

field

record

Memo

20 / 53

In the __________ normal form, a composite attribute is converted to individual attributes.

Fourth

Second

First

Third

21 / 53

The term attributes refers to a________ of a table.

Column

Tuple

Record

Key

22 / 53

The extension of the database file in MS Access is

MDB

DBM

DMB

DBF

23 / 53

Which of the following is/are the main goals of a distributed database?

All of the options are correct

Reduced communication overhead

Incremental growth

Interconnection of database

24 / 53

Which is not a type of query?

Select

Update

All the options are correct

25 / 53

Which forms simplifies and ensures that there are minimal data aggregates and repetitive groups:

1NF

2NF

3NF

All of the mentioned

26 / 53

Which of the following is generally used for performing tasks like creating the structure of the relations, deleting Relations?

Relational Schema

Query

DDL(Data Definition Language)

DML(Data Manipulation Language)

27 / 53

A Detail Management System is a type of _______ software.

It is a kind of application software

Bot A and C

Its a type of system software

It is a kind of general software

28 / 53

A relational database consists of a collection of

Keys

Tuples

Fields

Tables

29 / 53

The maximum size of the text field in MS. Access is .

255

6400

30 / 53

Which SQL keyword is used to retrieve a maximum value?

TOP

MOST

MAX

UPPER

31 / 53

The term ________ is used to refer to a row

Tuple

Field

Attribute

Instance

32 / 53

Which data type provides storage for variable length and arbitrary format data?

Hyperlink.

Memo

OLE object

Text

33 / 53

Tables in second normal form (2NF):

Have all non key fields depend on the whole primary key

Eliminate all hidden dependencies

Have a composite key

Eliminate the possibility of a insertion anomalies

34 / 53

The term "Data" refers to:

Basic information

The electronic representation of the information ( or data)

Raw Facts and figures

All of above

35 / 53

Date/Time occupies . . . bytes of memory.

36 / 53

….. query changes the value in the main table

both Select & Update

Select

None

Update

37 / 53

_____is not the data type of MS-Access.

Form

Number

Memo

Text

38 / 53

The default data type in MS-Access if . . .

Data/Time

Memo

Number

Text

39 / 53

CREATE TABLE employee (name VARCHAR, id INTEGER ) What type of statement is this?

View

DML

Integrity constrain

DDL

40 / 53

In the given query which of the keyword has to be inserted?

INSERT INTO employee ___ (4,Alok,2000);

Relation

Field

Table

Values

41 / 53

object of access is used to print formatted data.

Table

Report

Query

Form

42 / 53

A distributed database is a collection of data which belong to the same system but are spread over the of the network.

Physically, sites

Database, DBMS

Logically, sites

None of the above

43 / 53

Which of the following is not a DDL command?

None of the option

UPDATE

TRUNCATE

ALTER

44 / 53

In the __________ normal form, a composite attribute is converted to individual attributes.

Second

First

Fourth

Third

45 / 53

A field that is used to uniquely define particular record in a table is called:

Relationship

Primary Key

Entity

Constraints

46 / 53

Which of the following refers to the level of data abstraction that describes exactly how the data actually stored?

File Level

Physical Level

Logical Level

Conceptual Level

47 / 53

Functional Dependencies are the types of constraints that are based on_____

None of the mentioned

Key

Superset key

Key revisited

48 / 53

The term "SQL" stands for

Sequential query language

Standard query language

Server-side query language :

Structured query language

49 / 53

Which of the following is not a database application?

MS-Access

FoxPro

MS-Excel

Oracle

50 / 53

The report can be generated by using data from...

Query

Both Table And Query

Forms

Table

51 / 53

Which is a bottom-up approach to database design that design by examining the relationship between attributes:

Normalization

Functional dependency

Decomposition

Database modeling

52 / 53

With SQL, how do you select all the records from a table named "Persons" where the value of the column “FirstName” ends with an “a” ?

SELECT * FROM Persons WHERE FirstName LIKE '%a'

SELECT * FROM Persons WHERE FirstName='%a'

SELECT * FROM Persons WHERE FirstName LIKE 'a%'

SELECT * FROM Persons WHERE FirstName='a'

53 / 53

A table on the many side of a one to many or many to many relationship must:

Be in Second Normal Form (2NF)

Have a composite key

Have a single attribute key

Be in Third Normal Form (3NF)

Your score is

The average score is 73%