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