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

Edit

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

Edit

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

Edit

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

Edit

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

Edit