Search Header Logo

Database concepts and the Structured Query Language

Authored by KALPANA CHODAVARAPU

Computers

11th Grade

Used 25+ times

Database concepts and the Structured Query Language
AI

AI Actions

Add similar questions

Adjust reading levels

Convert to real-world scenario

Translate activity

More...

20 questions

Show all answers

1.

MULTIPLE CHOICE QUESTION

30 sec • 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

2.

MULTIPLE CHOICE QUESTION

30 sec • 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

3.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which of the following operations requires the relations to be union compatible?

A.UNION

B.INTERSECTION

C.DIFFERENCE

D.ALL OF THESE

4.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

The database language that allows us to access data in a database is called :

A.DCL

B.DML

C.DDL

D.None Of Above

5.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which data manipulation command is used to combines the records from one or more tables?

A.SELECT

B.PROJECT

C.JOIN

D.PRODUCT

6.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which of the following is a legal expression in SQL?

A.SELECT NULL FROM SALES;

B.SELECT NAME FROM SALES;

C.SELECT * FROM SALES WHEN PRICE = NULL;

D.SELECT # FROM SALES;

7.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

DCL provides commands to perform actions like

A.Change the structure of Tables

B.Insert, Update or Delete Records and Values

C.Authorizing Access and other control over Database

D.None of Above

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

Microsoft

Continue with Microsoft

or continue with

Facebook

Facebook

Apple

Apple

Others

Others

By signing up, you agree to our Terms of Service & Privacy Policy

Already have an account?