Which of the following is also known as Offline storage ?

Question

Which of the following is also known as Offline storage ?

A. primary storage

B. secondary storage

C. tertiary storage

D. none of the above

Share this question with your friends

Show all Advance DBMS MCQ

Comment

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

The attribute that can be divided into other attributes is called

A. Simple Attribute

B. Composite Attribute

C. Multi-valued Attribute

D. Derived Attribute

Discuss this answer

Select the incorrect statement(s)
i) Shared locks are compatible with each other.
ii) A relation which is in 3NF may have redundancy due to composite keys.
iii) A table in a database can have multiple indexes.

A. i only

B. ii, only

C. ii, iii only

D. none of the above

Discuss this answer

.................. means sending a digital signal over a channel without changing the digital signal to an analog signal.

A. Baseband transmission

B. Broadband transmission

C. Digital transmission

D. Analog transmission

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

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 statement in SQL which allows to change the definition of a table is

A. Select

B. Update

C. Create

D. Alter

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

Which of the following submit and execute query at run time?

A. Static SQL

B. Dynamic SQL

C. both

D. none of these

Discuss this answer

A relation that has no partial dependencies is in which normal form

A. First

B. Second

C. Third

D. BCNF

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 aggregate function doesnt ignore NULLs in its results?

A. COUNT

B. COUNT(*)

C. MAX

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

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

A. first

B. Second

C. third

D. fourth

Discuss this answer

An advantage of the database management approach is

A. data is dependent on programs.

B. data redundancy increases.

C. data is integrated and can be accessed by multiple programs.

D. none of the above.

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

Natural mask for a Class A network

A. 255.0.0.0

B. 255.255.0.0

C. 255.255.255.0

D. none of these

Discuss this answer

In defining the notion of the tuple variable, which one of the clause is useful?

A. as

B. by

C. from

D. none 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 table that displays data redundancies yields ____________ anomalies

A. Insertion

B. Deletion

C. Update

D. All of the above

Discuss this answer

Data integrity refers to

A. the uniqueness of the data in a database

B. the correctness and completeness of the data in a database

C. the un redundancies of the data in a database

D. Data independence of the database

Discuss this answer

The command used to delete a particular column in a relation

A. UPDATE

B. DROP

C. ALTER

D. DELETE

Discuss this answer

Datalog is

A. procedural query language

B. nonprocedural query language

C. scan(), write()

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

What is the max data capacity of STP?

A. 1 Gbps

B. 56 Mbps

C. 100 Mbps

D. 256 Mbps

Discuss this answer

Query processing is

A. converting data to insert in a database

B. translation of query to lower form

C. range of activities involved in extracting data from a database

D. none of the above

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

The control of concurrent execution is left with the

A. operating system

B. controller unit of the kernel

C. concurrency control component of the database system

D. none

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

Accepted Answer

C. tertiary storage

Which of the following is also known as Offline storage ?

Correct Answer :

Show all Advance DBMS MCQ

Related Questions

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

The attribute that can be divided into other attributes is called

Select the incorrect statement(s)
i) Shared locks are compatible with each other.
ii) A relation which is in 3NF may have redundancy due to composite keys.
iii) A table in a database can have multiple indexes.

.................. means sending a digital signal over a channel without changing the digital signal to an analog signal.

In which of the following SET concept is used ?

Transaction processing is associated with everything below except

The statement in SQL which allows to change the definition of a table is

Full form of CIDR

A transaction which completes successfully is called

Which of the following submit and execute query at run time?

A relation that has no partial dependencies is in which normal form

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

Which of the following aggregate function doesnt ignore NULLs in its results?

Select the incorrect statement

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

An advantage of the database management approach is

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.

Natural mask for a Class A network

In defining the notion of the tuple variable, which one of the clause is useful?

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

A table that displays data redundancies yields ____________ anomalies

Data integrity refers to

The command used to delete a particular column in a relation

Datalog is

Mail services are available to network users through the

What is the max data capacity of STP?

Query processing is

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

The control of concurrent execution is left with the

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

Also checkout

Which of the following is also known as Offline storage ?

Correct Answer :

Show all Advance DBMS MCQ

Related Questions

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

The attribute that can be divided into other attributes is called

Select the incorrect statement(s)i) Shared locks are compatible with each other.ii) A relation which is in 3NF may have redundancy due to composite keys.iii) A table in a database can have multiple indexes.

.................. means sending a digital signal over a channel without changing the digital signal to an analog signal.

In which of the following SET concept is used ?

Transaction processing is associated with everything below except

The statement in SQL which allows to change the definition of a table is

Full form of CIDR

A transaction which completes successfully is called

Which of the following submit and execute query at run time?

A relation that has no partial dependencies is in which normal form

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

Which of the following aggregate function doesnt ignore NULLs in its results?

Select the incorrect statement

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

An advantage of the database management approach is

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.

Natural mask for a Class A network

In defining the notion of the tuple variable, which one of the clause is useful?

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

A table that displays data redundancies yields ____________ anomalies

Data integrity refers to

The command used to delete a particular column in a relation

Datalog is

Mail services are available to network users through the

What is the max data capacity of STP?

Query processing is

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

The control of concurrent execution is left with the

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

Also checkout

Select the incorrect statement(s)
i) Shared locks are compatible with each other.
ii) A relation which is in 3NF may have redundancy due to composite keys.
iii) A table in a database can have multiple indexes.

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

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