Which forms have a relation that contains information about a single entity?
a) 4NF
b) 2NF
c) 5NF
d) 3NF
Which forms have a relation that contains information about a single entity?Read More »
Data Base MCQS
Here’s the comprehensive list of top DBMS MCQ Questions with Answers to brush up your skills. These MCQs range from basic to advanced for Lecturer Computer, Computer Instructor, Computer Teacher
_____ operations do not preserve non-matched tuples.
a) Left outer join
b) Inner join
c) Natural join
d) Right outer join
_____ operations do not preserve non-matched tuples.Read More »
Procedural language among the following is __
a) Domain relational calculus
b) Tuple relational calculus
c) Relational algebra
d) Query language
Which of the following command is correct to delete the values in the relation teaches?
a) Delete from teaches;
b) Delete from teaches where Id =’Null’;
c) Remove table teaches;
d) Drop table teaches;
Which of the following command is correct to delete the values in the relation teaches?Read More »
Which of the following set should be associated with weak entity set for weak entity to be meaningful?
a) Neighbour set
b) Strong entity set
c) Owner set
d) Identifying set
Which command is used to remove a relation from an SQL?
a) Drop table
b) Delete
c) Purge
d) Remove
Which command is used to remove a relation from an SQL?Read More »
__ is a set of one or more attributes taken collectively to uniquely identify a record.
a) Primary Key
b) Foreign key
c) Super key
d) Candidate key
__ is a set of one or more attributes taken collectively to uniquely identify a record.Read More »
The ability to query data, as well as insert, delete, and alter tuples, is offered by __
a) TCL (Transaction Control Language)
b) DCL (Data Control Language)
c) DDL (Data Definition Langauge)
d) DML (Data Manipulation Langauge)
The ability to query data, as well as insert, delete, and alter tuples, is offered by __Read More »
The DBMS acts as an interface between ____ and ____ of an enterprise-class system.
a) Data and the DBMS
b) Application and SQL
c) Database application and the database
d) The user and the software
The DBMS acts as an interface between ____ and ____ of an enterprise-class system.Read More »
__ is a hardware component that is most important for the operation of a database management system.
a) Microphone
b) High speed, large capacity disk to store data
c) High-resolution video display
d) Printer