A composite attribute is converted to individual attributes in which of the following normal form ?

Question

A composite attribute is converted to individual attributes in which of the following normal form ?

A. first

B. Second

C. third

D. fourth

Correct Answer :

A. first

Share this question with your friends

Show all Advance DBMS MCQ

Comment

Thermal noise is often referred to as ............... noise, because it affects uniformly the different frequencies.

A. Gray

B. White

C. Blue

D. Black

Discuss this answer

Functional dependencies are generalization of

Discuss this answer

Data fragmentation is performed by the …… and each fragment is stored at…………..

Discuss this answer

The transaction consists of all statements executed between

Discuss this answer

A subschema expresses

Discuss this answer

What is ACID properties of Transactions?

Discuss this answer

Primary storage

D. cache

Discuss this answer

Commit operation …………… writes the changes made to the database.

Discuss this answer

Range variables are designed using the

Discuss this answer

The database environment has all of the following components except:

A. users.

Discuss this answer

When all attributes in a relation tuple are not functionally dependent only on the key attribute. Which of the following normalization is needed?

A. first

B. second

C. third

D. fourth

Discuss this answer

A DBMS query language is designed to

Discuss this answer

Which command is used to cancel privileges granted through the GRANT command ?

A. CANCEL

B. OVER

C. STOP

D. REVOKE

Discuss this answer

RAID

Discuss this answer

Size of source and destination address in IP header

A. 4 bits

B. 8 bits

Discuss this answer

.................. occurs due to velocity of propagation the frequency varies. Thus various frequency components of a signal arrive at the receiver at different times.

A. Noise

Discuss this answer

A transaction which completes successfully is called

Discuss this answer

Transaction processing is associated with everything below except

Discuss this answer

An operation that will increase the length of a list is

A. insert

B. modify

C. lookup

Discuss this answer

Specialization is a

Discuss this answer

DBMS utility which allows to reconstruct the correct state of database from the backup and history of transactions

A. Backup

C. Grant

Discuss this answer

Secondary storage

D. cache

Discuss this answer

A transaction is said to have terminated if it has

Discuss this answer

The language used in application programs to request data from the DBMS is referred to as the

A. DML

B. DDL

C. VDL

D. SDL

Discuss this answer

Object based data models are used in describing the abstraction of the following levels?

Discuss this answer

Tape storage is referred to as

Discuss this answer

Aggregate functions are also called

Discuss this answer

The collection of information stored in a database at a particular moment is?

A. View

C. Scheme

Discuss this answer

Which of the following is the unit of signaling speed or modulation rate or the rate of symbol transmission?

Discuss this answer

State which of the following statements are True
i) TCP is connection oriented but unreliable
ii) UDP is connection oriented but unreliable
iii) TCP is connectionless but reliable
iv) UDP is connectionless but reliable

Discuss this answer

Answer 1

A. Relation dependencies

Answer 2

B. Data dependencies

Answer 3

C. key dependencies

Answer 4

D. none of the above

Answer 5

A. DBMS, same site

Answer 6

B. OS ,same site

Answer 7

C. DBMS ,different site

Answer 8

D. OS ,different site

Answer 9

A. the begin transaction and end transaction

Answer 10

B. the start transaction and end transaction

Answer 11

C. the begin transaction and finish transaction

Answer 12

D. none of the above.

Answer 13

A. the logical view.

Answer 14

B. the physical view.

Answer 15

C. the external view.

Answer 16

D. all of the above.

Answer 17

A. Atomicity, Consistency, Isolation, Database

Answer 18

B. Atomicity, Consistency, Isolation, Durability

Answer 19

C. Atomicity, Consistency, Inconsistent, Durability

Answer 20

D. Automatically, Concurrency, Isolation, Durability

Answer 21

A. magnetic disk

Answer 22

B. magnetic tape

Answer 23

C. juke box

Answer 24

A. temporarily

Answer 25

B. permanently

Answer 26

C. none of these

Answer 27

D. all of the above

Answer 28

A. TO clause

Answer 29

B. FROM clause

Answer 30

C. RANGE clause

Answer 31

D. none of the above

Answer 32

B. separate files.

Answer 33

C. database.

Answer 34

D. database administrator.

Answer 35

A. support end users who use English-like commands.

Answer 36

B. support in the development of complex applications software.

Answer 37

C. specify the structure of a database.

Answer 38

D. all of the above.

Answer 39

A. Redundant Arrays of Independent Disks

Answer 40

B. Redundant Arrays of Independent Drives

Answer 41

C. Redundant Arrays of Interconnected Drives

Answer 42

D. Redundant Arrays of Interconnected Disks

Answer 43

C. 12 bits

Answer 44

D. 32 bits

Answer 45

B. Delay distortion

Answer 46

C. Attenuation distortion

Answer 47

D. Dispersion

Answer 48

A. Granted

Answer 49

B. Committed

Answer 50

C. Compensated

Answer 51

D. Accomplished

Answer 52

A. producing detail, summary, or exception reports.

Answer 53

B. recording a business activity.

Answer 54

C. confirming an action or triggering a response.

Answer 55

D. maintaining data.

Answer 56

D. none of the above

Answer 57

A. top-down approach.

Answer 58

B. bottom-up approach.

Answer 59

C. left-right approach.

Answer 60

D. none of the above

Answer 61

B. Recovery

Answer 62

D. Troubleshooting

Answer 63

A. magnetic disk

Answer 64

B. magnetic tape

Answer 65

C. juke box

Answer 66

A. either committed or aborted

Answer 67

B. either partially committed or aborted

Answer 68

C. either committed or failed

Answer 69

D. none of these

Answer 70

A. Conceptual and view

Answer 71

B. Only physical

Answer 72

C. Physical and conceptual

Answer 73

D. Only conceptual

Answer 74

A. sequential access storage

Answer 75

B. direct access storage

Answer 76

C. random access storage

Answer 77

D. none of the above

Answer 78

A. serial functions

Answer 79

B. non-serial functions

Answer 80

C. row functions

Answer 81

D. column functions

Answer 82

B. Instance

Answer 83

D. None of these

Answer 84

A. Data rate

Answer 85

B. Bit rate

Answer 86

C. Signal to Noise Ratio

Answer 87

D. Baud rate

Answer 88

A. i and ii only

Answer 89

B. ii and iii only

Answer 90

C. i and iii only

Answer 91

D. None of these

A composite attribute is converted to individual attributes in which of the following normal form ?

Correct Answer :

Show all Advance DBMS MCQ

Related Questions

Thermal noise is often referred to as ............... noise, because it affects uniformly the different frequencies.

Functional dependencies are generalization of

Data fragmentation is performed by the …… and each fragment is stored at…………..

The transaction consists of all statements executed between

A subschema expresses

What is ACID properties of Transactions?

Primary storage

Commit operation …………… writes the changes made to the database.

Range variables are designed using the

The database environment has all of the following components except:

When all attributes in a relation tuple are not functionally dependent only on the key attribute. Which of the following normalization is needed?

A DBMS query language is designed to

Which command is used to cancel privileges granted through the GRANT command ?

RAID

Size of source and destination address in IP header

.................. occurs due to velocity of propagation the frequency varies. Thus various frequency components of a signal arrive at the receiver at different times.

A transaction which completes successfully is called

Transaction processing is associated with everything below except

An operation that will increase the length of a list is

Specialization is a

DBMS utility which allows to reconstruct the correct state of database from the backup and history of transactions

Secondary storage

A transaction is said to have terminated if it has

The language used in application programs to request data from the DBMS is referred to as the

Object based data models are used in describing the abstraction of the following levels?

Tape storage is referred to as

Aggregate functions are also called

The collection of information stored in a database at a particular moment is?

Which of the following is the unit of signaling speed or modulation rate or the rate of symbol transmission?

State which of the following statements are True
i) TCP is connection oriented but unreliable
ii) UDP is connection oriented but unreliable
iii) TCP is connectionless but reliable
iv) UDP is connectionless but reliable

Also checkout

A composite attribute is converted to individual attributes in which of the following normal form ?

Correct Answer :

Show all Advance DBMS MCQ

Related Questions

Thermal noise is often referred to as ............... noise, because it affects uniformly the different frequencies.

Functional dependencies are generalization of

Data fragmentation is performed by the …… and each fragment is stored at…………..

The transaction consists of all statements executed between

A subschema expresses

What is ACID properties of Transactions?

Primary storage

Commit operation …………… writes the changes made to the database.

Range variables are designed using the

The database environment has all of the following components except:

When all attributes in a relation tuple are not functionally dependent only on the key attribute. Which of the following normalization is needed?

A DBMS query language is designed to

Which command is used to cancel privileges granted through the GRANT command ?

RAID

Size of source and destination address in IP header

.................. occurs due to velocity of propagation the frequency varies. Thus various frequency components of a signal arrive at the receiver at different times.

A transaction which completes successfully is called

Transaction processing is associated with everything below except

An operation that will increase the length of a list is

Specialization is a

DBMS utility which allows to reconstruct the correct state of database from the backup and history of transactions

Secondary storage

A transaction is said to have terminated if it has

The language used in application programs to request data from the DBMS is referred to as the

Object based data models are used in describing the abstraction of the following levels?

Tape storage is referred to as

Aggregate functions are also called

The collection of information stored in a database at a particular moment is?

Which of the following is the unit of signaling speed or modulation rate or the rate of symbol transmission?

State which of the following statements are Truei) TCP is connection oriented but unreliableii) UDP is connection oriented but unreliableiii) TCP is connectionless but reliableiv) UDP is connectionless but reliable

Also checkout

State which of the following statements are True
i) TCP is connection oriented but unreliable
ii) UDP is connection oriented but unreliable
iii) TCP is connectionless but reliable
iv) UDP is connectionless but reliable