DBMS Practical Quiz

Which of the following is a property of database

• Represents some aspect of the real world

• Logically related collection of data

• Built, and populated with data for a specific purpose

• All the above

A database management system (DBMS) is a collection of programs that enables users to

• create a database

• manipulate a database

• both create and manipulate a database

• for storing data only

Which one of the following is used to define the structure of the relation, deleting relations and relating schemas?

• DML(Data Manipulation Langauge)

• DDL(Data Definition Langauge)

• Query

• Relational Schema

Which one of the following is used to define the structure of the relation, deleting relations and relating schemas?

• DML(Data Manipulation Langauge)

• DDL(Data Definition Langauge)

• Query

• Relational Schema

CREATE TABLE employee (name VARCHAR, id INTEGER)

What type of statement is this?

• DML

• DDL

• View

• Integrity constraint

The SQL used by front-end application programs to request data from the DBMS is called _______

• A. DML

• B .DDL

• C .VDL

• D. SDL

The command used to delete a particular column in a relation is ____________

• A.UPDATE TABLE

• B.TRUNCATE COLUMN

• C.ALTER , DROP

• D.DELETE COLUMN

What is the full form of DDL ?

• A.Dynamic Data Language

• B.Detailed Data Language

• C.Data Definition Language

• D.Data Derivation Language

In SQL, which command is used to SELECT only one copy of each set of duplicable rows

• A. SELECT DISTINCT

• B. SELECT UNIQUE

• C. SELECT DIFFERENT

• D. All of the above

In SQL, which command is used to SELECT only one copy of each set of duplicable rows

• A. SELECT DISTINCT

• B. SELECT UNIQUE

• C. SELECT DIFFERENT

• D. All of the above