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

Question

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

A. Foreign key

B. Secondary key

C. Primary key

D. Alternate key

Share this question with your friends

Show all Advance DBMS MCQ

Comment

Multivalued dependency is removed in

A. 4 NF

B. 3 NF

C. 2 NF

D. 1 NF

Discuss this answer

Unwanted energy from source other than the transmitter.

A. Attenuation

B. Distortion

C. Delay

D. Noise

Discuss this answer

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

A. DBMS, same site

B. OS ,same site

C. DBMS ,different site

D. OS ,different site

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

A. i, ii only

B. ii and iv only

C. ii and iv only

D. i, iv only

Discuss this answer

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

A. 300MHz

B. 1GHz

C. 5GHz

D. 10 GHz

Discuss this answer

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

A. Conceptual and view

B. Only physical

C. Physical and conceptual

D. Only conceptual

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

In client/server computing data are

A. sent only upon the client's request

B. sent in complete copies for the client to filter and sort

C. never sent to the client machine

D. sent in very large sections to save processing time

Discuss this answer

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

A. System View

B. User View

C. Logical View

D. Data View

Discuss this answer

The transaction consists of all statements executed between

A. the begin transaction and end transaction

B. the start transaction and end transaction

C. the begin transaction and finish transaction

D. none of the above.

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

For large networks, _______ topology is used

A. Ring

B. Bus

C. Mesh

D. none of these

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

What is the max data capacity of STP?

A. 1 Gbps

B. 56 Mbps

C. 100 Mbps

D. 256 Mbps

Discuss this answer

Transaction access data using two operations

A. read(), print()

B. read(), write()

C. scan(), write()

D. none of the above

Discuss this answer

Transaction processing is associated with everything below except

A. producing detail, summary, or exception reports.

B. recording a business activity.

C. confirming an action or triggering a response.

D. maintaining data.

Discuss this answer

The mode in which data item may be locked

A. Partner

B. Mutual

C. Exclusive

D. Atomic

Discuss this answer

Tertiary storage

A. magnetic tape

B. juke box

C. optical disk

D. All of the above

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

An entity set that does not have sufficient attributes to form a primary key is a

A. strong entity set.

B. weak entity set.

C. simple entity set.

D. primary entity set.

Discuss this answer

Which of the following operator preserves unmatched rows of the relations being joined?

A. Inner join

B. Outer join

C. union

D. Intersect

Discuss this answer

Which of the following is true statement ?

A. SQL permits attribute names to be repeated in the same relation.

B. a SQL query automatically eliminates duplicates.

C. a SQL query will not work if there are no indexes on the relations

D. None of these

Discuss this answer

A transaction is said to have terminated if it has

A. either committed or aborted

B. either partially committed or aborted

C. either committed or failed

D. none of these

Discuss this answer

Which of the following produces the relation that has attributes of R1 and R2

A. Cartesian product

B. Difference

C. Intersection

D. Product

Discuss this answer

In which of the following SET concept is used ?

A. Network Model

B. Hierarchical Model

C. Relational Model

D. None of these

Discuss this answer

Mail services are available to network users through the

A. Session layer

B. Presentation layer

C. Application layer

D. Transport layer

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

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

Secondary storage

A. magnetic disk

B. magnetic tape

C. juke box

D. cache

Discuss this answer

Which topology requires a central controller or hub?

A. Ring

B. Tree

C. Switch

D. Graph

Discuss this answer

Accepted Answer

C. Primary key

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

Correct Answer :

Show all Advance DBMS MCQ

Related Questions

Multivalued dependency is removed in

Unwanted energy from source other than the transmitter.

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

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

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

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

DBMS helps achieve

In client/server computing data are

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

The transaction consists of all statements executed between

Size of source and destination address in IP header

For large networks, _______ topology is used

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

What is the max data capacity of STP?

Transaction access data using two operations

Transaction processing is associated with everything below except

The mode in which data item may be locked

Tertiary storage

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)

An entity set that does not have sufficient attributes to form a primary key is a

Which of the following operator preserves unmatched rows of the relations being joined?

Which of the following is true statement ?

A transaction is said to have terminated if it has

Which of the following produces the relation that has attributes of R1 and R2

In which of the following SET concept is used ?

Mail services are available to network users through the

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

Which of the following is also known as Offline storage ?

Secondary storage

Which topology requires a central controller or hub?

Also checkout

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

Correct Answer :

Show all Advance DBMS MCQ

Related Questions

Multivalued dependency is removed in

Unwanted energy from source other than the transmitter.

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

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

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

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

DBMS helps achieve

In client/server computing data are

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

The transaction consists of all statements executed between

Size of source and destination address in IP header

For large networks, _______ topology is used

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

What is the max data capacity of STP?

Transaction access data using two operations

Transaction processing is associated with everything below except

The mode in which data item may be locked

Tertiary storage

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

An entity set that does not have sufficient attributes to form a primary key is a

Which of the following operator preserves unmatched rows of the relations being joined?

Which of the following is true statement ?

A transaction is said to have terminated if it has

Which of the following produces the relation that has attributes of R1 and R2

In which of the following SET concept is used ?

Mail services are available to network users through the

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

Which of the following is also known as Offline storage ?

Secondary storage

Which topology requires a central controller or hub?

Also checkout

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

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)