............... noise is caused by the random motion of the electrons in a wire and is avoidable.

Question

............... noise is caused by the random motion of the electrons in a wire and is avoidable.

A. Thermal

B. Intermodulation

C. Cross talk

D. Impulse

Share this question with your friends

Show all Advance DBMS MCQ

Comment

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

A. Backup

B. Recovery

C. Grant

D. Troubleshooting

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 collection of information stored in a database at a particular moment is?

A. View

B. Instance

C. Scheme

D. None of these

Discuss this answer

Which of the following is/are error-free channel(s)
i) Noisy channel
ii) Noiseless channel

A. i only

B. ii only

C. Both

D. None of these

Discuss this answer

Data independence means

A. data is defined separately and not included in programs.

B. programs are not dependent on the physical attributes of data.

C. programs are not dependent on the logical attributes of data.

D. both B) and C).

Discuss this answer

In an E-R diagram attributes are represented by

A. rectangle.

B. square.

C. ellipse.

D. triangle.

Discuss this answer

A type of query that is placed within a WHERE or HAVING clause of another query is called

A. Super query

B. Sub query

C. Master query

D. Multi-query

Discuss this answer

Select the incorrect statement(s)
i) Foreign key values can be left blank
ii) In SQL duplicates may be present
iii) Theta join operation doesnt remove duplicate columns.
iv) NULL value means string of blank characters.

A. i ,iii only

B. ii, iv only

C. iii, iv only

D. ii, iii, iv

Discuss this answer

The number of cursors depend on the

A. number of queries

B. number of attributes

C. size of memory area

D. none of these

Discuss this answer

Secondary storage

A. magnetic disk

B. magnetic tape

C. juke box

D. cache

Discuss this answer

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

A. parallel

B. serial

C. analog

D. digital

Discuss this answer

FDDI protocol operates in
i) Transport layer
ii) Network layer
iii) Datalink layer
iv) Physical layer

A. i and ii only

B. ii and iii only

C. i and iii only

D. iii and iv only

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

A transaction which completes successfully is called

A. Granted

B. Committed

C. Compensated

D. Accomplished

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

It is possible to define a schema completely using

A. VDL and DDL.

B. DDL and DML.

C. SDL and DDL.

D. VDL and DML.

Discuss this answer

In E-R Diagram weak entity set are represented by

A. Ellipse

B. Dashed ellipse

C. Dashed Rectangle

D. Doubled Rectangle

Discuss this answer

Consider the join of a relation R with relation S. If R has m tuples and S has n tuples,
then the maximum size of join is:

A. mn

B. m+n

C. m+n)/2

D. 2 m+n)

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

Specialization is a

A. top-down approach.

B. bottom-up approach.

C. left-right approach.

D. none of the above

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

The maximum number of children in a B-tree of order m is

A. m+1

B. m

C. m-1

D. m/2

Discuss this answer

Benefit of database normalization is

A. smaller number of tables

B. higher query processing efficiency

C. reduced I/O for most queries

D. reduced data redundancy

Discuss this answer

Three SQL, DDL, CREATE commands are

A. Schema, Base and Table

B. Schema, Table and View

C. Base, Table and Schema

D. Key, Base and Table

Discuss this answer

An operation that will increase the length of a list is

A. insert

B. modify

C. lookup

D. none of the above

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

Which of the following Key is used to represent relationship between the tables?

A. Primary key

B. Secondary Key

C. Foreign Key

D. None of these

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

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

Select the correct statement
i) Aggregate functions work on a group of data and return a single value.
ii) ODBC connects the frontend with the database without considering its compatibility
iii) View definition cant be used at multiple places through with clause .

A. i and ii only

B. ii and iii only

C. i and iii only

D. i only

Discuss this answer

Accepted Answer

A. Thermal

............... noise is caused by the random motion of the electrons in a wire and is avoidable.

Correct Answer :

Show all Advance DBMS MCQ

Related Questions

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

Select the incorrect statement

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

Which of the following is/are error-free channel(s)
i) Noisy channel
ii) Noiseless channel

Data independence means

In an E-R diagram attributes are represented by

A type of query that is placed within a WHERE or HAVING clause of another query is called

Select the incorrect statement(s)
i) Foreign key values can be left blank
ii) In SQL duplicates may be present
iii) Theta join operation doesnt remove duplicate columns.
iv) NULL value means string of blank characters.

The number of cursors depend on the

Secondary storage

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

FDDI protocol operates in
i) Transport layer
ii) Network layer
iii) Datalink layer
iv) Physical layer

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

A transaction which completes successfully is called

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

It is possible to define a schema completely using

In E-R Diagram weak entity set are represented by

Consider the join of a relation R with relation S. If R has m tuples and S has n tuples,
then the maximum size of join is:

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

Specialization is a

Mail services are available to network users through the

The maximum number of children in a B-tree of order m is

Benefit of database normalization is

Three SQL, DDL, CREATE commands are

An operation that will increase the length of a list is

What is the max data capacity of STP?

Which of the following Key is used to represent relationship between the tables?

The output of the Data Definition Language is stored in the

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

Select the correct statement
i) Aggregate functions work on a group of data and return a single value.
ii) ODBC connects the frontend with the database without considering its compatibility
iii) View definition cant be used at multiple places through with clause .

Also checkout

............... noise is caused by the random motion of the electrons in a wire and is avoidable.

Correct Answer :

Show all Advance DBMS MCQ

Related Questions

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

Select the incorrect statement

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

Which of the following is/are error-free channel(s)i) Noisy channelii) Noiseless channel

Data independence means

In an E-R diagram attributes are represented by

A type of query that is placed within a WHERE or HAVING clause of another query is called

Select the incorrect statement(s)i) Foreign key values can be left blankii) In SQL duplicates may be presentiii) Theta join operation doesnt remove duplicate columns.iv) NULL value means string of blank characters.

The number of cursors depend on the

Secondary storage

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

FDDI protocol operates ini) Transport layerii) Network layeriii) Datalink layeriv) Physical layer

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

A transaction which completes successfully is called

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

It is possible to define a schema completely using

In E-R Diagram weak entity set are represented by

Consider the join of a relation R with relation S. If R has m tuples and S has n tuples,then the maximum size of join is:

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

Specialization is a

Mail services are available to network users through the

The maximum number of children in a B-tree of order m is

Benefit of database normalization is

Three SQL, DDL, CREATE commands are

An operation that will increase the length of a list is

What is the max data capacity of STP?

Which of the following Key is used to represent relationship between the tables?

The output of the Data Definition Language is stored in the

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

Select the correct statementi) Aggregate functions work on a group of data and return a single value.ii) ODBC connects the frontend with the database without considering its compatibilityiii) View definition cant be used at multiple places through with clause .

Also checkout

Which of the following is/are error-free channel(s)
i) Noisy channel
ii) Noiseless channel

Select the incorrect statement(s)
i) Foreign key values can be left blank
ii) In SQL duplicates may be present
iii) Theta join operation doesnt remove duplicate columns.
iv) NULL value means string of blank characters.

FDDI protocol operates in
i) Transport layer
ii) Network layer
iii) Datalink layer
iv) Physical layer

Consider the join of a relation R with relation S. If R has m tuples and S has n tuples,
then the maximum size of join is:

Select the correct statement
i) Aggregate functions work on a group of data and return a single value.
ii) ODBC connects the frontend with the database without considering its compatibility
iii) View definition cant be used at multiple places through with clause .