What is the primary goal of BCNF in database normalization? - Question not attempted

Asked in Analyst Cum Programmer (Deputy Director) 2024 · Topic: Basics of Computers and Information Technology (Database Management Systems (DBMS) Basics: Concepts, Types of Databases)

1. To eliminate redundancy caused by functional dependencies.
2. To reduce the size of the database.
3. To remove multivalued dependencies.
4. To improve query speed.

More Information and Communication Technology questions

• Which SQL query retrieves all employees whose address contains the substring ‘AJMER’ from EMPLOYEE table? - SELECT * FROM EMPLOYEE WHERE Address = ‘AJMER’; - SELECT * FROM EMPLOYEE WHERE Address LIKE ‘%AJMER’; - SELECT * FROM EMPLOYEE LIKE Address = ‘AJMER’; - SE‐ LECT * FROM EMPLOYEE WHERE Address LIKE ‘AJMER’;
• Suppose we have two relations: R(A, B, C) and S(B, C, D). Consider the natural join operation: R ⋈ S Which of the following could be the resulting schema of this operation?
• Which relational algebra expression selects all employees from the emp table whose salary is greater than 40000 and who work in the Delhi location?
• What is the primary purpose of the embedded SQL?
• Which statement best describes the goal of data abstraction in a DBMS?
• A serializable schedule has 5 transactions, each with 2 operations. How many possible serial schedules exist?
• Consider the following Query SELECT Course FROM STUDENT GROUP BY Course HAVING Count(*) > 10; where STUDENT is a relation with one of its attributes as ‘Course’. What will be the result of the Query?
• Which collision resolution technique in hashing handles collisions by storing all keys that hash to the same index in a linked list? - Question not attempted

All 1,360 Information and Communication Technology questions →