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