Search Header Logo

DBMS LAB

Authored by AKILA A

Computers

University

CCSS covered

Used 217+ times

DBMS LAB
AI

AI Actions

Add similar questions

Adjust reading levels

Convert to real-world scenario

Translate activity

More...

    Content View

    Student View

20 questions

Show all answers

1.

MULTIPLE CHOICE QUESTION

1 min • 1 pt

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

2.

MULTIPLE CHOICE QUESTION

1 min • 1 pt

CREATE TABLE employee (name VARCHAR, id INTEGER)

What type of statement is this?

DML

DDL

View

Integrity constraint

3.

MULTIPLE CHOICE QUESTION

1 min • 1 pt

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

A. DML

B .DDL

C .VDL

D. SDL

4.

MULTIPLE CHOICE QUESTION

1 min • 1 pt

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

A.UPDATE TABLE

B.TRUNCATE COLUMN

C.ALTER , DROP

D.DELETE COLUMN

5.

MULTIPLE CHOICE QUESTION

1 min • 1 pt

What is the full form of DDL ?

A.Dynamic Data Language

B.Detailed Data Language

C.Data Definition Language

D.Data Derivation Language

6.

MULTIPLE CHOICE QUESTION

1 min • 1 pt

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

7.

MULTIPLE CHOICE QUESTION

1 min • 1 pt

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

Access all questions and much more by creating a free account

Create resources

Host any resource

Get auto-graded reports

Google

Continue with Google

Email

Continue with Email

Classlink

Continue with Classlink

Clever

Continue with Clever

or continue with

Microsoft

Microsoft

Apple

Apple

Others

Others

Already have an account?

Discover more resources for Computers