NEW
Font size
WorksheetsDBMS Quizzz....!
Total questions: 15
Worksheet time: 15mins
What is the Full form of DBMS?
Data of Binary Management System
Database Management System
Database Management Service
Data Backup Management System
Which type of data can be stored in the database?
Image oriented data
Text, files containing data
Data in the form of audio or video
All of the above
Which of the following is not an example of DBMS?
MySQL
Microsoft Acess
IBM DB2
Which of the following is known as a set of entities of the same type that share same properties, or attributes?
Relation set
Tuples
Entity set
Entity Relation model
What does an RDBMS consist of?
Collection of Records
Collection of Keys
Collection of Tables
Collection of Fields
The values appearing in given attributes of any tuple in the referencing relation must likewise occur in specified attributes of at least one tuple in the referenced relation, according to _____________________ integrity constraint.
Referential
Primary
Referencing
Specific
______________ is a set of one or more attributes taken collectively to uniquely identify a record.
Primary Key
Foreign key
Super key
Candidate key
Which command is used to remove a relation from an SQL?
Drop table
Delete
Purge
Remove
Which of the following command is correct to delete the values in the relation teaches?
Delete from teaches;
Delete from teaches where Id =’Null’;
Remove table teaches;
Drop table teaches;
Which forms have a relation that contains information about a single entity?
4NF
2NF
5NF
3NF
Why the following statement is erroneous?
SELECT dept_name, ID, avg (salary)
FROM instructor
GROUP BY dept_name;
Dept_id should not be used in group by clause
Group by clause is not valid in this query
Avg(salary) should not be selected
None
In which of the following formats data is stored in the database management system?
Image
Text
Table
Graph
Which of the following is not a feature of DBMS?
Minimum Duplication and Redundancy of Data
High Level of Security
Single-user Access only
Support ACID Property
The DBMS acts as an interface between ________________ and ________________ of an enterprise-class system.
Data and the DBMS
Application and SQL
Database application and the database
The user and the software
What does a foreign key combined with a primary key create?
Network model between the tables that connect them
Parent-Child relationship between the tables that connects them
One to many relationship between the tables that connects them
All of the mentioned
