Database Management Systems Mcqs

Page No. 65

Which of the following is not true about B+ trees?


aB+ tree index takes the form of balanced tree


bPerformance of B+ tree degrades as the file grows


cLook-up in B+ tree is straightforward and efficient


dInsertion and deletion in B+ tree is complicated but efficient



The file organization which allows us to read records that would satisfy the join condition by using one block read is


aHeap file organization


bSequential file organization


cClustering file organization


dHash files organization



A unit of storage that can store one or more records in a hash file organization is denoted as


aBuckets


bDisk pages


cBlocks


dNodes


View Answer Buckets

_______ means that data used during the execution of a transaction cannot be used by a second transaction until the first one is completed.


aSerializability


bAtomicity


cIsolation


dTime stamping


View Answer Isolation

A condition that occurs when two transactions wait for each other to unlock data is known as a(n)


aShared lock


bExclusive lock


cBinary lock


dDeadlock


View Answer Deadlock

A lock that prevents the use of any tables in the database from one transaction while another transaction is being processed is called a


aDatabase-level lock


bTable-level lock


cPage-level lock


dRow-level lock


View Answer Database-level lock

ANSI-standard SQL allows the use of special operators in conjunction with the WHERE clause. A special operator used to check whether an attribute value is null is


aBETWEEN


bIS NULL


cLIKE


dIN


View Answer IS NULL

The most recent version of standard SQL prescribed by the American National Standards Institute is


aSQL 2016


bSQL 2002


cSQL – 4


dSQL2


View Answer SQL 2016

This validation scheme is called the _________ scheme since transactions execute optimistically, assuming they will be able to finish execution and validate at the end.


aValidation protocol


bValidation-based protocol


cTimestamp protocol


dOptimistic concurrency-control


View Answer Validation protocol

The __________ requires that each transaction Ti executes in two or three different phases in its lifetime, depending on whether it is a read-only or an update transaction.


aValidation protocol


bValidation-based protocol


cTimestamp protocol


dTimestamp-ordering protocol


View Answer Validation protocol

Goto Page No.

Page 65 of 101

Alphabetical MCQs Categories

Here below You find all kind of categories of MCQs in alphabetical order.


"Comprehensive Collection of MCQs: Alphabetically Organized by Subject"

"Discover an extensive collection of multiple-choice questions (MCQs) neatly categorized by subject from A to Z. This resource is designed for anyone eager to explore various topics in a straightforward and organized manner. Whether you're a student preparing for exams, an educator seeking supplementary materials, or simply curious about different subjects, this compilation offers a convenient way to learn and assess your knowledge. With questions arranged alphabetically, navigation is effortless, allowing you to delve into subjects of interest at your own pace. Engage, learn, and expand your understanding with this accessible and comprehensive repository of MCQs!"


BolPakistan

bolpakistan.com.pk includes Job Mcqs and Pak Mcqs is the Top Largest Mcqs Forum in World, in which you can read Mcqs of All Subjects, PPSC test preparation, FPSC, NTS and PPSC PAST PAPERS, PPSC PAST MCQS. A Collection of Repeated MCQs for JOBs seekers.

Copyright © 2024, Designed & Developed by BolPakistan