DBMS QUIZ

What is the full form of DBMS?
a)

• Data of Binary Management System
  

• Database Management System

• Database Management Service
  

• Data Backup Management System

Which of the following formats data is stored in the database management system?

• Image

• Text

• Table

• Graph

Which of the following is not a type of database

• Hierarchical

• Network

• Distributed

• Decentralized

Which of the following is a function of the DBMS

• Storing data

• Providing multi-users access control

• Data Integrity

• All of the above

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

______________ is a set of one or more attributes taken collectively to uniquely identify a record.

• Primary Key

• Foreign key

• Super key

• Candidate key

Which of the following establishes a top-to-bottom relationship among the items?

• Relational schema

• Network schema

• Hierarchical schema

• All of the mentioned

SELECT * FROM employee WHERE salary>10000 AND dept_id=101;

Which of the following fields are displayed as output?

• Salary, dept_id

• Employee

• Salary

• All the field of employee relation

INSERT INTO employee _____ (1002,'Joey',2000);

• Table

• Values

• Relation

• Field

Using the ______ clause retains only one copy of such identical tuples.

• GROUP BY
• JOIN
• UNIQUE
• DISTINCT