Database Management Systems Mcqs

Page No. 63

If needed to split a node or coalesce it with its siblings, or redistribute key values between siblings, the crabbing protocol locks the parent of the node in ____________ mode.


aShared


bExclusive


cRead only


dNone of the mentioned


View Answer Exclusive

In crabbing protocol, the lock obtained on the root node is in _________ mode.


aShared


bExclusive


cRead only


dNone of the mentioned


View Answer Shared

The deadlock can be handled by


aRemoving the nodes that are deadlocked


bRestarting the search after releasing the lock


cRestarting the search without releasing the lock


dResuming the search



In crabbing protocol locking


aGoes down the tree and back up


bGoes up the tree and back down


cGoes down the tree and releases


dGoes up the tree and releases



How many techniques are available to control concurrency on B+ trees?


aOne


bThree


cFour


dNone of the mentioned


View Answer None of the mentioned

Why do we need concurrency control on B+ trees ?


aTo remove the unwanted data


bTo easily add the index elements


cTo maintain accuracy of index


dAll of the mentioned



The method of access that uses key transformation is called as


aDirect


bHash


cRandom


dSequential


View Answer Hash

Which statement is true regarding synonyms?


aSynonyms can be created for tables but not views


bSynonyms are used to reference only those tables that are owned by another user


cA public synonym and a private synonym can exist with the same name for the same table


dThe DROP SYNONYM statement removes the synonym, and the status of the table on which the synonym has been created becomes invalid



Which statements are correct regarding indexes?


aWhen a table is dropped, the corresponding indexes are automatically dropped


bFor each DML operation performed, the corresponding indexes are automatically updated


cA non-deferrable PRIMARY KEY or UNIQUE KEY constraint in a table automatically creates a unique index


dAll of the mentioned


View Answer All of the mentioned

In which scenario would you use the ROLLUP operator for expression or columns within a GROUP BY clause?


aTo find the groups forming the subtotal in a row


bTo create group-wise grand totals for the groups specified within a GROUP BY clause


cTo create a grouping for expressions or columns specified within a GROUP BY clause in one direction, from right to left for calculating the subtotals


dTo create a grouping for expressions or columns specified within a GROUP BY clause in all possible directions, which is cross-tabular report for calculating the subtotals



Goto Page No.

Page 63 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