DBMS LAB

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

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

The database definition or descriptive information is also stored by the DBMS in the form of a _______________

• Data catalog

• excel file

• document file

• pdf file

The database and DBMS software together is called a ________________

• Database system

• Data Model

• Application Program

• System software

A database entity is also known as:

• a table
• a field
• a row
• a report