A fragmentation is categorized in

Question

A fragmentation is categorized in

A. 1 part

B. 2 part

C. 3 part

D. 4 part

Correct Answer :

C. 3 part

Share this question with your friends

Show all Advance DBMS MCQ

Comment

Tape storage is referred to as

Discuss this answer

Data integrity refers to

Discuss this answer

What is the max data capacity of STP?

A. 1 Gbps

Discuss this answer

Extended Entity Relationship model consists of which of the following
i) Specialization
ii) Generalization
iii) Categorization

Discuss this answer

What does a field or a combination of fields that has a unique value called ?

Discuss this answer

Specialization is a

Discuss this answer

The mode in which data item may be locked

B. Mutual

D. Atomic

Discuss this answer

Only one communication channel is needed rather than n channels to transmit data between two communicating devices

B. serial

C. analog

Discuss this answer

The union of primary keys of a related entity becomes …………. Of a relation.

Discuss this answer

A logical description of some portion of database that is required by a user to perform task is called as

Discuss this answer

A relation is said to be in ………. If it doesnt contain partial dependency

A. 1NF

B. 2NF

C. 3NF

D. BCNF

Discuss this answer

Select the incorrect statement

Discuss this answer

Select the correct
i) A timestamp-based scheduler cant produce live lock
ii) Aggregate functions cant appear with HAVING clause.
iii) Isolation is a property of database transaction.

D. i only

Discuss this answer

For large networks, _______ topology is used

A. Ring

B. Bus

C. Mesh

Discuss this answer

The types of noiseless channels are
i) Selective Reject ARQ
ii) simplest protocol
iii) Go-Back-N ARQ
iv) Stop-and-Wait Protocol

Discuss this answer

Technique used in log based recovery

Discuss this answer

An operation that will increase the length of a list is

A. insert

B. modify

C. lookup

Discuss this answer

In E-R diagram Generalization is represented by

A. Circle

Discuss this answer

Range variables are designed using the

Discuss this answer

Volatile storage

D. none

Discuss this answer

The command used to delete a particular column in a relation

A. UPDATE

B. DROP

C. ALTER

D. DELETE

Discuss this answer

An association of several structure of a data base can be expressed graphically by?

A. Tuple

B. Record

D. Field

Discuss this answer

Symbol to represent weak entity set in ER Model

B. Square

Discuss this answer

Select the incorrect statement(s)
i) Shared locks are compatible with each other.
ii) A relation which is in 3NF may have redundancy due to composite keys.
iii) A table in a database can have multiple indexes.

A. i only

Discuss this answer

Which one of the following statements is false?

Discuss this answer

Which of the following is not a constraint on a single relation?

A. check

B. unique

Discuss this answer

Radio frequencies below ............. are more suitable for omnidirectional applications.

A. 300MHz

B. 1GHz

C. 5GHz

D. 10 GHz

Discuss this answer

Which of the following is also known as Offline storage ?

Discuss this answer

Tertiary storage

Discuss this answer

The ability to modify the conceptual schema without causing any change to the application program is known as

Discuss this answer

Answer 1

A. sequential access storage

Answer 2

B. direct access storage

Answer 3

C. random access storage

Answer 4

D. none of the above

Answer 5

A. the uniqueness of the data in a database

Answer 6

B. the correctness and completeness of the data in a database

Answer 7

C. the un redundancies of the data in a database

Answer 8

D. Data independence of the database

Answer 9

B. 56 Mbps

Answer 10

C. 100 Mbps

Answer 11

D. 256 Mbps

Answer 12

A. i and ii only

Answer 13

B. ii and iii only

Answer 14

C. i and iii only

Answer 15

D. All i, ii iii

Answer 16

A. Foreign key

Answer 17

B. Secondary key

Answer 18

C. Primary key

Answer 19

D. Alternate key

Answer 20

A. top-down approach.

Answer 21

B. bottom-up approach.

Answer 22

C. left-right approach.

Answer 23

D. none of the above

Answer 24

A. Partner

Answer 25

C. Exclusive

Answer 26

A. parallel

Answer 27

D. digital

Answer 28

A. primarykey

Answer 29

B. superkey

Answer 30

C. candidatekey

Answer 31

D. foreignkey

Answer 32

A. System View

Answer 33

B. User View

Answer 34

C. Logical View

Answer 35

D. Data View

Answer 36

A. BCNF is stronger than 3NF

Answer 37

B. Relational algebra is a non-procedural language

Answer 38

C. Every conflict serializable schedule is view serializable.

Answer 39

D. none of the above

Answer 40

A. i and ii only

Answer 41

B. ii and iii only

Answer 42

C. i and iii only

Answer 43

D. none of these

Answer 44

A. i, ii only

Answer 45

B. ii and iv only

Answer 46

C. ii and iv only

Answer 47

D. i, iv only

Answer 48

A. Immediate database modification

Answer 49

B. Graph-based recovery

Answer 50

C. key dependencies

Answer 51

D. none of the above

Answer 52

D. none of the above

Answer 53

B. Rectangle

Answer 54

C. Hyperbola

Answer 55

D. Triangle

Answer 56

A. TO clause

Answer 57

B. FROM clause

Answer 58

C. RANGE clause

Answer 59

D. none of the above

Answer 60

A. loses its contents when power is switched off.

Answer 61

B. doesnt loses its contents when power is switched off.

Answer 62

C. creates backup when power is switched off.

Answer 63

C. Relationship

Answer 64

A. Dotted rectangle

Answer 65

C. Doubly outlined rectangle

Answer 66

D. Diamond

Answer 67

B. ii, only

Answer 68

C. ii, iii only

Answer 69

D. none of the above

Answer 70

A. The data dictionary is normally maintained by the database administrator.

Answer 71

B. Data elements in the database can be modified by changing the data dictionary.

Answer 72

C. The data dictionary contains the name and description of each data element.

Answer 73

D. The data dictionary is a tool used exclusively by the database administrator.

Answer 74

C. not null

Answer 75

D. is duplicate

Answer 76

A. primary storage

Answer 77

B. secondary storage

Answer 78

C. tertiary storage

Answer 79

D. none of the above

Answer 80

A. magnetic tape

Answer 81

B. juke box

Answer 82

C. optical disk

Answer 83

D. All of the above

Answer 84

A. Physical data independence

Answer 85

B. Logical data independence

Answer 86

C. External data independence

Answer 87

D. Static data

A fragmentation is categorized in

Correct Answer :

Show all Advance DBMS MCQ

Related Questions

Tape storage is referred to as

Data integrity refers to

What is the max data capacity of STP?

Extended Entity Relationship model consists of which of the following
i) Specialization
ii) Generalization
iii) Categorization

What does a field or a combination of fields that has a unique value called ?

Specialization is a

The mode in which data item may be locked

Only one communication channel is needed rather than n channels to transmit data between two communicating devices

The union of primary keys of a related entity becomes …………. Of a relation.

A logical description of some portion of database that is required by a user to perform task is called as

A relation is said to be in ………. If it doesnt contain partial dependency

Select the incorrect statement

Select the correct
i) A timestamp-based scheduler cant produce live lock
ii) Aggregate functions cant appear with HAVING clause.
iii) Isolation is a property of database transaction.

For large networks, _______ topology is used

The types of noiseless channels are
i) Selective Reject ARQ
ii) simplest protocol
iii) Go-Back-N ARQ
iv) Stop-and-Wait Protocol

Technique used in log based recovery

An operation that will increase the length of a list is

In E-R diagram Generalization is represented by

Range variables are designed using the

Volatile storage

The command used to delete a particular column in a relation

An association of several structure of a data base can be expressed graphically by?

Symbol to represent weak entity set in ER Model

Select the incorrect statement(s)
i) Shared locks are compatible with each other.
ii) A relation which is in 3NF may have redundancy due to composite keys.
iii) A table in a database can have multiple indexes.

Which one of the following statements is false?

Which of the following is not a constraint on a single relation?

Radio frequencies below ............. are more suitable for omnidirectional applications.

Which of the following is also known as Offline storage ?

Tertiary storage

The ability to modify the conceptual schema without causing any change to the application program is known as

Also checkout

A fragmentation is categorized in

Correct Answer :

Show all Advance DBMS MCQ

Related Questions

Tape storage is referred to as

Data integrity refers to

What is the max data capacity of STP?

Extended Entity Relationship model consists of which of the followingi) Specializationii) Generalizationiii) Categorization

What does a field or a combination of fields that has a unique value called ?

Specialization is a

The mode in which data item may be locked

Only one communication channel is needed rather than n channels to transmit data between two communicating devices

The union of primary keys of a related entity becomes …………. Of a relation.

A logical description of some portion of database that is required by a user to perform task is called as

A relation is said to be in ………. If it doesnt contain partial dependency

Select the incorrect statement

Select the correcti) A timestamp-based scheduler cant produce live lockii) Aggregate functions cant appear with HAVING clause.iii) Isolation is a property of database transaction.

For large networks, _______ topology is used

The types of noiseless channels arei) Selective Reject ARQii) simplest protocoliii) Go-Back-N ARQiv) Stop-and-Wait Protocol

Technique used in log based recovery

An operation that will increase the length of a list is

In E-R diagram Generalization is represented by

Range variables are designed using the

Volatile storage

The command used to delete a particular column in a relation

An association of several structure of a data base can be expressed graphically by?

Symbol to represent weak entity set in ER Model

Select the incorrect statement(s)i) Shared locks are compatible with each other.ii) A relation which is in 3NF may have redundancy due to composite keys.iii) A table in a database can have multiple indexes.

Which one of the following statements is false?

Which of the following is not a constraint on a single relation?

Radio frequencies below ............. are more suitable for omnidirectional applications.

Which of the following is also known as Offline storage ?

Tertiary storage

The ability to modify the conceptual schema without causing any change to the application program is known as

Also checkout

Extended Entity Relationship model consists of which of the following
i) Specialization
ii) Generalization
iii) Categorization

Select the correct
i) A timestamp-based scheduler cant produce live lock
ii) Aggregate functions cant appear with HAVING clause.
iii) Isolation is a property of database transaction.

The types of noiseless channels are
i) Selective Reject ARQ
ii) simplest protocol
iii) Go-Back-N ARQ
iv) Stop-and-Wait Protocol

Select the incorrect statement(s)
i) Shared locks are compatible with each other.
ii) A relation which is in 3NF may have redundancy due to composite keys.
iii) A table in a database can have multiple indexes.