Relational Database Design and SQL-Object Oriented Database Management Systems [NTA-NET (UGC-NET) Computer Science & Applications (87)]: Questions 1 - 5 of 11
Choose Programs:
⏳ 🎯 Online Tests (4 Tests [100 questions each]): NTA Pattern, Analytics & Explanations
Rs. 800.00 -OR-
3 Year Validity (Multiple Devices)
Sample TestsDetailsSee Demo
🎓 Study Material (2083 Notes): 2024-2025 Syllabus
Rs. 1250.00 -OR-
3 Year Validity (Multiple Devices)
Topic-wise Notes & SampleDetails
🎯 2699 MCQs (& PYQs) with Full Explanations (2024-2025 Exam)
Rs. 600.00 -OR-
3 Year Validity (Multiple Devices)
CoverageDetailsSample Explanation
Help me Choose & Register (Watch Video) Already Subscribed?
Question 1
Appeared in Year: 2016
Question MCQ▾
In RDBMS, the constraint that no key attribute (column) may be NULL is referred to as:
Choices
Choice (4) | Response | |
---|---|---|
a. | Multi-valued dependency | |
b. | Entity Integrity | |
c. | Functional dependency | |
d. | Referential integrity |
Question 2
Appeared in Year: 2013
Question MCQ▾
A Network Schema (June Paper II)
Choices
Choice (4) | Response | |
---|---|---|
a. | restricts to one to many relationship | |
b. | permits many to many relationship | |
c. | stores Data in a Database | |
d. | stores Data in a Relation |
Question 3
Appeared in Year: 2017
Question MCQ▾
An attribute A of data type Var char (20) has value ‘Ram’ and the attribute B of datatype char (20) has value ‘Sita’ in oracle. The attribute A has ________ memory spaces and B has ________ memory spaces. (January paper II)
Choices
Choice (4) | Response | |
---|---|---|
a. | 20,20 | |
b. | 3,4 | |
c. | 20,4 | |
d. | 3,20 |
Question 4
Question MCQ▾
What is the output of the following Oracle SQL statement?
Choices
Choice (4) | Response | |
---|---|---|
a. | All records of the employee table | |
b. | 2 records of the employee table | |
c. | 1 record of the employee table | |
d. | 0 records of the employee table |
Question 5
Question MCQ▾
For what purpose are the Codd՚s rules used for in the Relational database management system (RDBMS) ?
Choices
Choice (4) | Response | |
---|---|---|
a. | To check for functional dependency | |
b. | For a Relational DBMS to be consistent | |
c. | For a Relational DBMS to be perfect | |
d. | All of the above |