UGC NET · PAPER 2
UGC NET Paper 2 Computer Science – Unit 4: Database Management Systems PYQ (December 2024)
Q10. What will be the right sequence of the phases of database design?
A. Physical Design
B. Conceptual Design
C. Logical Design
D. Requirement collection and analysis
Choose the correct answer from the options given below:
A. Physical Design
B. Conceptual Design
C. Logical Design
D. Requirement collection and analysis
Choose the correct answer from the options given below:
- D, A, B, C
- D, B, C, A
- D, B, A, C
- D, A, C, B
Q11. An alternate key in a database table is also called
- Primary key
- Candidate key
- Super key
- Foreign key
Q25. In concurrency control, the phantom problem may occur when
- records are inserted
- records are deleted
- records are modified
- records are indexed
Q34. Which of the following is/are FALSE statement(s)?
A. An all-key relation is always in BCNF since it has no FDs.
B. A relation that is not in 4NF due to a nontrivial MVD must be decomposed to convert it into a set of relations in 4NF.
C. The decomposition removes the redundancy caused by the MVD.
D. 3NF is stronger than BCNF.
Choose the correct answer from the options given below:
A. An all-key relation is always in BCNF since it has no FDs.
B. A relation that is not in 4NF due to a nontrivial MVD must be decomposed to convert it into a set of relations in 4NF.
C. The decomposition removes the redundancy caused by the MVD.
D. 3NF is stronger than BCNF.
Choose the correct answer from the options given below:
- A only
- A, B only
- D only
- C only
Q35. Which of the following commands can be used to modify data in an SQL table?
A. INSERT
B. DELETE
C. UPDATE
D. SELECT
Choose the correct answer from the options given below:
A. INSERT
B. DELETE
C. UPDATE
D. SELECT
Choose the correct answer from the options given below:
- A, B, D only
- A, C, D only
- B, C, D only
- A, B, C only
Q54. Which of the following tables contains the primary information in a data warehouse?
- Dimension table
- Fact table
- Lookup table
- Primary table
Q55. The INSERT command is used to
A. add a single tuple to a relation
B. add multiple tuples to a relation
C. add values to specific attributes
D. insert a new table
Choose the correct answer from the options given below:
A. add a single tuple to a relation
B. add multiple tuples to a relation
C. add values to specific attributes
D. insert a new table
Choose the correct answer from the options given below:
- A only
- A, B only
- A, B, C only
- B, C, D only
Q61. Match List I with List II
| List I | List II |
|---|---|
| A. Hadoop Distributed File System | I. Trust |
| B. Veracity | II. Facebook |
| C. Apache Pig | III. Name-Node |
| D. Apache Hive | IV. Yahoo |
- A-IV, B-III, C-I, D-II
- A-III, B-I, C-II, D-IV
- A-III, B-I, C-IV, D-II
- A-II, B-III, C-I, D-IV
Q65. The degree of a relation in a database is
- the number of tuples in the relation
- the number of attributes in the relation
- the number of values in the domain
- the number of keys in a relation
Q78. Match List I with List II
| List I | List II |
|---|---|
| A. Project Join Normal Form | I. Concurrency |
| B. The lost update problem | II. Fifth Normal Form |
| C. Discretionary Access Control | III. SQL |
| D. Data Manipulation Language | IV. Security |
- A-II, B-I, C-IV, D-III
- A-I, B-II, C-IV, D-III
- A-I, B-II, C-III, D-IV
- A-IV, B-II, C-III, D-I