List of top Computer Science Questions on DBMS asked in CUET (UG)

Given two relations:

Employee with structure as (ID, Name, Address, Phone, Deptno)
Department with structure as (Deptno, Dname)
__________ is used to represent the relationship between two relations Employee and Department.
Match List-I with List-II.
List-IList-II
(A) Primary key(III) Attribute used to uniquely identify a tuple.
(B) Degree(I) Total number of attributes in a table.
(C) Foreign key(II) Attribute used to relate two tables.
(D) Constraint(IV) A restriction on the type of data that can be inserted in a column.
In SQL table, the set of values which a column can take in each row is called __________.
Which of the following is the limitation of DBMS ?
Which of the following are true about DBMS ?
(A) Each attribute should have unique name 
(B) Order of attribute is immaterial 
(C) Each tuple should be unique 
(D) The values of attributes do not belong to same domain 
(E) An attribute can have multiple values in tuple 
Choose the correct answer from the options given below :