Database Design(Normal Forms)

Question 61

Consider the following table < img src = "https://www.cdn.geeksforgeeks.org/wp-content/uploads/ISRO64.png "> The table is in which normal form?

• First Normal Form
• Second Normal Form
• Third Normal Form but not BCNF
• Third Normal Form but not BCNF

Question 62

In RDBMS, the constraint that no key attribute (column) may be NULL is referred to as:

• Referential integrity
• Multi-valued dependency
• Entity Integrity
• Functional dependency

Question 63

Which of the following statements is TRUE? D₁ : The decomposition of the schema R(A, B, C) into R₁(A, B) and R₂ (A, C) is always lossless. D₂ : The decomposition of the schema R(A, B, C, D, E) having AD → B, C → DE, B → AE and AE → C, into R₁ (A, B, D) and R₂ (A, C, D, E) is lossless.

• Both D₁ and D₂
• Neither D₁ nor D₂
• Only D₁
• Only D₂

Question 64

Consider the following dependencies and the BOOK table in a relational database design. Determine the normal form of the given relation.

ISBN → Title
 ISBN → Publisher
 Publisher → Address 

• First Normal Form
• Second Normal Form
• Third Normal Form
• BCNF

Question 65

Consider a “CUSTOMERS” database table having a column “CITY” filled with all the names of Indian cities (in capital letters). The SQL statement that finds all cities that have “GAR” somewhere in its name, is:

• Select * from customers where city = ‘%GAR%’;
• Select * from customers where city = ‘$GAR$’;
• Select * from customers where city like ‘%GAR%’;
• Select * from customers where city as ‘%GAR’;

Question 66

match the following datbase terms to their function:

• (1)

• (2)

• (3)

• (4)

Question 67

Data which improves the performance and accessibility of the database are called:

• Indexes
• User Data
• Application Metadata
• Data Dictionary

Question 68

Which type of DBMS provides support for maintaining several versions of the same entity?

• Relational Database Management System
• Hierarchical
• Object Oriented Database Management System
• Network

Question 69

Which normal form is based on the concept of \'full functional dependency\'?

• First Normal Form
• Second Normal Form
• Third Normal Form
• Fourth Normal Form

Question 70

Consider the following database table: Create table test( one integer, two integer, primary key(one), unique(two), check(one >= 1 and <= 10), check(two >= 1 and <= 5) ); How many data records/tuples atmost can this table containt?

• 5
• 10
• 15
• 50