Rdbms Archives - Page 2 of 37

Sign Up

Sign In

Forgot Password

Lost your password? Please enter your email address. You will receive a link and will create a new password via email.

You must login to ask a question.

You must login to add post.

Please briefly explain why you feel this question should be reported.

Please briefly explain why you feel this answer should be reported.

Please briefly explain why you feel this user should be reported.

Ask A Question

Pinky Saurabh Rattan

Asked: 3 years agoIn: Rdbms

State true or false: Snapshot isolation has low overhead

(a) True

(b) False

This question was addressed to me in a national level competition.

My question is based upon Multiversion Schemes, Snapshot Isolation in portion Concurrency Control of RDBMS

Shanti Rajesh Lad

Asked: 3 years agoIn: Rdbms

RAID level 5 refers to?

(a) Disk arrays with striping at the level of blocks

(b) Disk mirroring with block striping

(c) Memory style error correcting code

(d) Block interleaved distributed parity

Manish Borra

Asked: 3 years agoIn: Rdbms

What is a subquery?

(a) A subquery is a select-from-where expression that is nested within another query

(b) A subquery is any query that is nested within another query

(c) A subquery is a relation that is externally specified which can be used to handle data in queries

(d) A subquery is a condition that excludes all the invalid tuples from the database

Abhinav Kulkarni

Asked: 3 years agoIn: Rdbms

If a transaction has obtained a ________ lock, it can both read and write on the item

(a) Shared mode

(b) Exclusive mode

(c) Read only mode

(d) Write only mode

Dhiraj Kumar Suresh

Asked: 3 years agoIn: Rdbms

The _________ of the entity set is an actual collection of entities belonging to that entity set.

(a) Extension

(b) Intention

(c) Description

(d) Availability

Nawab, Bijoy Balakrishnan

Asked: 3 years agoIn: Rdbms

What is an NVRAM?

(a) RAM which is non-volatile in nature

(b) RAM whose data is not lost during power failures

(c) RAM that significantly speeds up data transfers

(d) All of the mentioned

Arun Loke

Asked: 3 years agoIn: Rdbms

Which of the following is the specialization that permits multiple sets

(a) Superclass specialization

(b) Disjoint specialization

(c) Overlapping specialization

(d) None of the mentioned

Sai Mody

Asked: 3 years agoIn: Rdbms

________ deletes a data item from a database

(a) Delete(Q)

(b) Insert(Q)

(c) Drop(Q)

(d) None of the mentioned

Prabha Pirzada Ghose

Asked: 3 years agoIn: Rdbms

In a __________ , we obtain the address of the disk block containing a desired record directly by computing a function on the search key value of the record

(a) Hash file organization

(b) Hash index organization

(c) Hashing address

(d) None of the mentioned

Kasturba Albert Palan

Asked: 3 years agoIn: Rdbms

What is the difference between a join and an outer join operation?

(a) There is no difference

(b) Join preserves a few tuples that are otherwise lost in the outer join

(c) Outer join preserves a few tuples that are otherwise lost in the join

(d) An outer join can be used only on outer queries whereas a join operation can be used in Subqueries

Load More Questions

Rdbms

State true or false: Snapshot isolation has low overhead

(a) True

(b) False

This question was addressed to me in a national level competition.

My question is based upon Multiversion Schemes, Snapshot Isolation in portion Concurrency Control of RDBMS

RAID level 5 refers to?

(a) Disk arrays with striping at the level of blocks

(b) Disk mirroring with block striping

(c) Memory style error correcting code

(d) Block interleaved distributed parity

If a transaction has obtained a ________ lock, it can both read and write on the item

(a) Shared mode

(b) Exclusive mode

(c) Read only mode

(d) Write only mode

The _________ of the entity set is an actual collection of entities belonging to that entity set.

(a) Extension

(b) Intention

(c) Description

(d) Availability

What is an NVRAM?

(a) RAM which is non-volatile in nature

(b) RAM whose data is not lost during power failures

(c) RAM that significantly speeds up data transfers

(d) All of the mentioned

Which of the following is the specialization that permits multiple sets

(a) Superclass specialization

(b) Disjoint specialization

(c) Overlapping specialization

(d) None of the mentioned

________ deletes a data item from a database

(a) Delete(Q)

(b) Insert(Q)

(c) Drop(Q)

(d) None of the mentioned

In a __________ , we obtain the address of the disk block containing a desired record directly by computing a function on the search key value of the record

(a) Hash file organization

(b) Hash index organization

(c) Hashing address

(d) None of the mentioned

How to approach applying for a job at a company ...

How to handle personal stress caused by utterly incompetent and ...

What is a programmer’s life like?

Sign Up

Sign In

Forgot Password

Rdbms

mcqoptions.com Latest Questions