Database Management Systems Mcqs

Page No. 48

_______________ is a procedural extension of Oracle – SQL that offers language constructs similar to those in imperative programming languages.


aSQL


bPL/SQL


cAdvanced SQL


dPQL


View Answer PL/SQL

Which one of the following statements is FALSE?


aAny relation with two attributes is in BCNF


bA relation in which every key has only one attribute is in 2NF


cA prime attribute can be transitively dependent on a key in a 3 NF relation


dA prime attribute can be transitively dependent on a key in a BCNF relation



The relation EMPDT1 is defined with attributes empcode(unique), name, street, city, state, and pincode. For any pincode, there is only one city and state. Also, for any given street, city and state, there is just one pincode. In normalization terms EMPDT1 is a relation in


a1NF only


b2NF and hence also in 1NF


c3NF and hence also in 2NF and 1NF


dBCNF and hence also in 3NF, 2NF and 1NF



Which of the following is TRUE?


aEvery relation in 2NF is also in BCNF


bA relation R is in 3NF if every non-prime attribute of R is fully functionally dependent on every key of R


cEvery relation in BCNF is also in 3NF


dNo relation can be in both BCNF and 3NF



Which one of the following statements about normal forms is FALSE?


aBCNF is stricter than 3NF


bLossless, dependency-preserving decomposition into 3NF is always possible


cLossless, dependency-preserving decomposition into BCNF is always possible


dAny relation with two attributes is in BCNF



Relation R with an associated set of functional dependencies, F, is decomposed into BCNF. The redundancy (arising out of functional dependencies) in the resulting set of relations is


aZero


bMore than zero but less than that of an equivalent 3NF decomposition


cProportional to the size of F+


dIndeterminate



Consider a schema R(A, B, C, D) and functional dependencies A -> B and C -> D. Then the decomposition of R into R1 (A, B) and R2(C, D) is


adependency preserving and lossless join


blossless join but not dependency preserving


cdependency preserving but not lossless join


dnot dependency preserving and not lossless join



Which normal form is considered adequate for normal relational database design?


a2NF


b5NF


c4NF


d3NF


View Answer 3NF

Cursor that reflects the changes made to the database table even after the result set is returned


aStatic


bDynamic


cFORWARD_ONLY


dKeyset


View Answer Dynamic

Which of the following connection type supports application role permissions and password encryption?


aOLE DB


bDBLib


cODBC


dOLE DB and ODBC


View Answer OLE DB and ODBC

Goto Page No.

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