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

Question

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

A. View

B. Instance

C. Scheme

D. None of these

Share this question with your friends

Show all Advance DBMS MCQ

Comment

The left outer join takes all tuples

A. in the left relation which didnt match with any tuple in right relation

B. in the left relation which matched with a tuple in right relation

C. in the right relation which didnt match with any tuple in left relation

D. in the right relation which matched with a tuple in left relation

Discuss this answer

Tertiary storage

A. magnetic tape

B. juke box

C. optical disk

D. All of the above

Discuss this answer

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

A. i and ii only

B. ii and iii only

C. i and iii only

D. All i, ii iii

Discuss this answer

A lock that allows concurrent transactions to access different rows of the same table is known as a

A. Field-level lock

B. Row-level lock

C. Table-level lock

D. Database-level lock

Discuss this answer

The output of the Data Definition Language is stored in the

A. view table

B. schema

C. metadata

D. all of the above.

Discuss this answer

Range variables are designed using the

A. TO clause

B. FROM clause

C. RANGE clause

D. none of the above

Discuss this answer

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

A. 300MHz

B. 1GHz

C. 5GHz

D. 10 GHz

Discuss this answer

If the .................... is too much, the receiver may not be able to detect the signal at all or the signal may fall below the noise level.

A. Noise

B. Delay

C. Dispersion

D. Attenuation

Discuss this answer

Full form of CIDR

A. Classful Inter Domain Routing

B. Classless International Domain Routing

C. Classless Inter Domain Routing

D. none of these

Discuss this answer

A transaction which completes successfully is called

A. Granted

B. Committed

C. Compensated

D. Accomplished

Discuss this answer

Size of source and destination address in IP header

A. 4 bits

B. 8 bits

C. 12 bits

D. 32 bits

Discuss this answer

DECLARE is a(an)

A. executable statement.

B. declarative statement.

C. Ordered file

D. none of the above

Discuss this answer

The database environment has all of the following components except:

A. users.

B. separate files.

C. database.

D. database administrator.

Discuss this answer

Unwanted energy from source other than the transmitter.

A. Attenuation

B. Distortion

C. Delay

D. Noise

Discuss this answer

Which of the following will NOT eliminates the ambiguities of a null value?

A. Define the attribute as required

B. Define subtypes

C. Define each attribute as having an initial value that is recognized as blank

D. Define supertypes

Discuss this answer

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

A. primarykey

B. superkey

C. candidatekey

D. foreignkey

Discuss this answer

In an object oriented model, one object can access data of another object by passing?

A. Instance variable

B. Variable

C. Message

D. Function

Discuss this answer

File organization that provides fast access to any arbitrary record

A. Hashed file

B. B-tree

C. Ordered file

D. Unordered file

Discuss this answer

Electromagnetic spectrum included in radiowaves are
i) Super High Frequency (SHF)
ii) Very High Frequency (VHF)
iii) Ultra High Frequency (UHF)
iv) High Frequencies (HF)

A. i, ii and iii only

B. i, ii and iv only

C. ii, iii and iv only

D. i, iii and iv only

Discuss this answer

DBMS helps achieve

A. Data independence

B. Centralized control of data

C. Neither A) nor B)

D. both A) and B)

Discuss this answer

Database locking concept is used to solve the problem of

A. Lost Update

B. Uncommitted Dependency

C. Inconsistent Data

D. All of the above

Discuss this answer

Which of the following is also known as Offline storage ?

A. primary storage

B. secondary storage

C. tertiary storage

D. none of the above

Discuss this answer

Which of the following extracts its data from the result of an SQL SELECT statement.

A. View

B. Synonym

C. Sequence

D. Transaction

Discuss this answer

A functional dependency between two or more non-key attributes is called

A. Transitive dependency

B. Partial transitive dependency

C. Functional dependency

D. Partial functional dependency

Discuss this answer

For large networks, _______ topology is used

A. Ring

B. Bus

C. Mesh

D. none of these

Discuss this answer

Attenuation can be also expressed in decibel dB) and commonly used because.
i) Signal strengths often fall off logarithmically
ii) Cascade losses and gains can be calculated with simple additions and subtractions

A. i only

B. ii only

C. Both A and B

D. None of the above

Discuss this answer

The class based addressing is known as

A. Classless addressing

B. Classful addressing

C. Classified addressing

D. Classical addressing

Discuss this answer

A fragmentation is categorized in

A. 1 part

B. 2 part

C. 3 part

D. 4 part

Discuss this answer

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

A. check

B. unique

C. not null

D. is duplicate

Discuss this answer

The access protocol used by traditional Ethernet

A. CSMA/CA

B. CSMA/CD

C. CSMA

D. Token ring

Discuss this answer

Accepted Answer

B. Instance

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

Correct Answer :

Show all Advance DBMS MCQ

Related Questions

The left outer join takes all tuples

Tertiary storage

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

A lock that allows concurrent transactions to access different rows of the same table is known as a

The output of the Data Definition Language is stored in the

Range variables are designed using the

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

If the .................... is too much, the receiver may not be able to detect the signal at all or the signal may fall below the noise level.

Full form of CIDR

A transaction which completes successfully is called

Size of source and destination address in IP header

DECLARE is a(an)

The database environment has all of the following components except:

Unwanted energy from source other than the transmitter.

Which of the following will NOT eliminates the ambiguities of a null value?

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

In an object oriented model, one object can access data of another object by passing?

File organization that provides fast access to any arbitrary record

Electromagnetic spectrum included in radiowaves are
i) Super High Frequency (SHF)
ii) Very High Frequency (VHF)
iii) Ultra High Frequency (UHF)
iv) High Frequencies (HF)

DBMS helps achieve

Database locking concept is used to solve the problem of

Which of the following is also known as Offline storage ?

Which of the following extracts its data from the result of an SQL SELECT statement.

A functional dependency between two or more non-key attributes is called

For large networks, _______ topology is used

Attenuation can be also expressed in decibel dB) and commonly used because.
i) Signal strengths often fall off logarithmically
ii) Cascade losses and gains can be calculated with simple additions and subtractions

The class based addressing is known as

A fragmentation is categorized in

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

The access protocol used by traditional Ethernet

Also checkout

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

Correct Answer :

Show all Advance DBMS MCQ

Related Questions

The left outer join takes all tuples

Tertiary storage

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

A lock that allows concurrent transactions to access different rows of the same table is known as a

The output of the Data Definition Language is stored in the

Range variables are designed using the

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

If the .................... is too much, the receiver may not be able to detect the signal at all or the signal may fall below the noise level.

Full form of CIDR

A transaction which completes successfully is called

Size of source and destination address in IP header

DECLARE is a(an)

The database environment has all of the following components except:

Unwanted energy from source other than the transmitter.

Which of the following will NOT eliminates the ambiguities of a null value?

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

In an object oriented model, one object can access data of another object by passing?

File organization that provides fast access to any arbitrary record

Electromagnetic spectrum included in radiowaves arei) Super High Frequency (SHF)ii) Very High Frequency (VHF)iii) Ultra High Frequency (UHF)iv) High Frequencies (HF)

DBMS helps achieve

Database locking concept is used to solve the problem of

Which of the following is also known as Offline storage ?

Which of the following extracts its data from the result of an SQL SELECT statement.

A functional dependency between two or more non-key attributes is called

For large networks, _______ topology is used

Attenuation can be also expressed in decibel dB) and commonly used because.i) Signal strengths often fall off logarithmicallyii) Cascade losses and gains can be calculated with simple additions and subtractions

The class based addressing is known as

A fragmentation is categorized in

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

The access protocol used by traditional Ethernet

Also checkout

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

Electromagnetic spectrum included in radiowaves are
i) Super High Frequency (SHF)
ii) Very High Frequency (VHF)
iii) Ultra High Frequency (UHF)
iv) High Frequencies (HF)

Attenuation can be also expressed in decibel dB) and commonly used because.
i) Signal strengths often fall off logarithmically
ii) Cascade losses and gains can be calculated with simple additions and subtractions