2023 question paper

DATABASE MANAGEMENT SYSTEM

5 questions

1. Q1a. A row from a table is selected by - (i) selection operator - (ii) projection operator - (iii) union operator - (iv) none of these20232m

   Unit 2: Relational Query Languages

   A row from a table is selected by

   • (i) selection operator
   • (ii) projection operator
   • (iii) union operator
   • (iv) none of these

   View this question on its own page →

   CopySearch GoogleAsk AI
2. Q1b. A normal form in which every non-prime attribute is fully dependent on prime attribute is - (i) 1 NF - (ii) 2 NF - (iii) 3 NF - (iv) BCNF20237m

   Unit 2: Relational Query Languages

   A normal form in which every non-prime attribute is fully dependent on prime attribute is

   • (i) 1 NF
   • (ii) 2 NF
   • (iii) 3 NF
   • (iv) BCNF

   View this question on its own page →

   CopySearch GoogleAsk AI
3. Q1c. Serializability of concurrent transaction is ensured by - (i) locking - (ii) time stamping - (iii) both (a) and (b) - (iv) none of these20232m

   Unit 3: Storage and Transaction Processing

   Serializability of concurrent transaction is ensured by

   • (i) locking
   • (ii) time stamping
   • (iii) both (a) and (b)
   • (iv) none of these

   View this question on its own page →

   CopySearch GoogleAsk AI
4. Q1d. Which key cannot be null - (i) Unique key - (ii) Primary key - (iii) Super key - (iv) Foreign key20237m

   Unit 1: Database System Architecture

   Which key cannot be null

   • (i) Unique key
   • (ii) Primary key
   • (iii) Super key
   • (iv) Foreign key

   View this question on its own page →

   CopySearch GoogleAsk AI
5. Q1e. BCNF stands for - (i) Boyle Cold Normalization Form - (ii) Boyce Cold Normal Form - (iii) Boyce Codd Normal Form - (iv) None of these20232m

   Unit 2: Relational Query Languages

   BCNF stands for

   • (i) Boyle Cold Normalization Form
   • (ii) Boyce Cold Normal Form
   • (iii) Boyce Codd Normal Form
   • (iv) None of these

   View this question on its own page →

   CopySearch GoogleAsk AI