In RDBMS, Data is presented as a collection of

Question

In RDBMS, Data is presented as a collection of

A. Relation

B. Table

C. Attribute

D. Entity

Share this question with your friends

Show all Advance DBMS MCQ

Comment

In two-phase locking protocol the two phases are

A. growing phase and shrinking phase

B. execution phase and blocking phase.

C. running phase and sleeping phase.

D. none of the above

Discuss this answer

A logical schema

A. is the entire database.

B. is a standard way of organizing information into accessible parts.

C. describes how data is actually stored on disk.

D. both A) and C)

Discuss this answer

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

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.

A. i and ii only

B. ii and iii only

C. i and iii only

D. i only

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

A data dictionary contains:
i) The name of all fields in all files.
ii) The data type of all fields in all files.
iii) The width of all fields in all files.

A. only i)

B. only i) and ii)

C. only ii) and iii)

D. i) ii) iii)

Discuss this answer

In which of the following transmissions, we can send data by grouping n bits at a time instead of a single bit?

A. parallel

B. serial

C. analog

D. digital

Discuss this answer

Aggregate functions are also called

A. serial functions

B. non-serial functions

C. row functions

D. column functions

Discuss this answer

A relation which is in 3NF is

A. in 1NF also

B. in 2NF also

C. free from transitive dependencies

D. All of these

Discuss this answer

Select the incorrect statement

A. BCNF is stronger than 3NF

B. Relational algebra is a non-procedural language

C. Every conflict serializable schedule is view serializable.

D. none of the above

Discuss this answer

The degree of the table with 500 rows and 7 columns is

A. 500

B. 7

C. 3500

D. none of these

Discuss this answer

In mesh topology, if the number of devices is n , then the number of ports present in each device is

A. n

B. n+1

C. n-1

D. n/2

Discuss this answer

The ________ states that a foreign key must either match a primary key value in another relation or it must be null.

A. entity integrity rule

B. referential integrity constraint

C. composite attribute

D. action assertion

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

Select the incorrect statement

A. View is derived from other tables.

B. Once a transaction has executed commit work its effect cant be undone by rollback work .

C. The input to the aggregate function avg can be non numeric data types

D. A primary key can never be null.

Discuss this answer

In ………… paging we make copy of the current page table.

A. physical

B. logical

C. shadow

D. duplicate

Discuss this answer

Functional dependencies are generalization of

A. Relation dependencies

B. Data dependencies

C. key dependencies

D. none of the above

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

The physical location of a record is determined by a mathematical formula that transforms
a file key into a record location is :

A. B-Tree File

B. Hashed File

C. Indexed File

D. Sequential file.

Discuss this answer

Which of the following file organization provides very fast access to any arbitrary record of a file?

A. Ordered file

B. Unordered file

C. Hashed file

D. B-tree

Discuss this answer

The index table has …… Columns.

A. 1

B. 2

C. 3

D. 4

Discuss this answer

In the architecture of a database system external level is the

A. physical level.

B. logical level.

C. conceptual level

D. view level.

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

Which of the following is not proper state of transaction ?

A. Partially aborted

B. Partially committed

C. Aborted

D. Committed

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

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

A. Physical data independence

B. Logical data independence

C. External data independence

D. Static data

Discuss this answer

What does the number of attributes in a relation is called?

A. Cardinality

B. Degree

C. Tuple

D. Order

Discuss this answer

Which topology requires a central controller or hub?

A. Ring

B. Tree

C. Switch

D. Graph

Discuss this answer

The privilege lists include
i) select
ii) insert
iii) update
iv) delete

A. only i)

B. only i) ii)

C. only i) ii) iii)

D. i) ii) iii) iv)

Discuss this answer

Accepted Answer

A. Relation

In RDBMS, Data is presented as a collection of

Correct Answer :

Show all Advance DBMS MCQ

Related Questions

In two-phase locking protocol the two phases are

A logical schema

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

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.

Size of source and destination address in IP header

A data dictionary contains:
i) The name of all fields in all files.
ii) The data type of all fields in all files.
iii) The width of all fields in all files.

In which of the following transmissions, we can send data by grouping n bits at a time instead of a single bit?

Aggregate functions are also called

A relation which is in 3NF is

Select the incorrect statement

The degree of the table with 500 rows and 7 columns is

In mesh topology, if the number of devices is n , then the number of ports present in each device is

The ________ states that a foreign key must either match a primary key value in another relation or it must be null.

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

Select the incorrect statement

In ………… paging we make copy of the current page table.

Functional dependencies are generalization of

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

The physical location of a record is determined by a mathematical formula that transforms
a file key into a record location is :

Which of the following file organization provides very fast access to any arbitrary record of a file?

The index table has …… Columns.

In the architecture of a database system external level is the

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

Which of the following is not proper state of transaction ?

The class based addressing is known as

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

What does the number of attributes in a relation is called?

Which topology requires a central controller or hub?

The privilege lists include
i) select
ii) insert
iii) update
iv) delete

Also checkout

In RDBMS, Data is presented as a collection of

Correct Answer :

Show all Advance DBMS MCQ

Related Questions

In two-phase locking protocol the two phases are

A logical schema

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

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.

Size of source and destination address in IP header

A data dictionary contains:i) The name of all fields in all files.ii) The data type of all fields in all files.iii) The width of all fields in all files.

In which of the following transmissions, we can send data by grouping n bits at a time instead of a single bit?

Aggregate functions are also called

A relation which is in 3NF is

Select the incorrect statement

The degree of the table with 500 rows and 7 columns is

In mesh topology, if the number of devices is n , then the number of ports present in each device is

The ________ states that a foreign key must either match a primary key value in another relation or it must be null.

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

Select the incorrect statement

In ………… paging we make copy of the current page table.

Functional dependencies are generalization of

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

The physical location of a record is determined by a mathematical formula that transformsa file key into a record location is :

Which of the following file organization provides very fast access to any arbitrary record of a file?

The index table has …… Columns.

In the architecture of a database system external level is the

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

Which of the following is not proper state of transaction ?

The class based addressing is known as

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

What does the number of attributes in a relation is called?

Which topology requires a central controller or hub?

The privilege lists includei) selectii) insertiii) updateiv) delete

Also checkout

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.

A data dictionary contains:
i) The name of all fields in all files.
ii) The data type of all fields in all files.
iii) The width of all fields in all files.

The physical location of a record is determined by a mathematical formula that transforms
a file key into a record location is :

The privilege lists include
i) select
ii) insert
iii) update
iv) delete