Search Header Logo

QUIZ 1 BASIC SQL BCA 3rd Year

Authored by KRITI BANSAL

Engineering

University

Used 4+ times

QUIZ 1 BASIC SQL BCA 3rd Year
AI

AI Actions

Add similar questions

Adjust reading levels

Convert to real-world scenario

Translate activity

More...

    Content View

    Student View

36 questions

Show all answers

1.

MULTIPLE CHOICE QUESTION

2 mins • 1 pt

The language used application programs to request data from the DBMS is referred to as __________

DDL

DML

Query Language

All of the mentioned

2.

MULTIPLE CHOICE QUESTION

2 mins • 1 pt

Match SQL language with SQL commands

1)DDL i)Revok, Grant

2)DML ii)rename a table

3)TCL iii)insert, update

4)DCL iv)rollback , commit

1-iii,2-i,3-ii,4-iv

1-iii,2-ii,3-iv,4-i

1-ii,2-iii,3-iv,4-i

1-i,2-iii,3-ii,4-iv

3.

MULTIPLE CHOICE QUESTION

2 mins • 1 pt

Which of the following is not a type of SQL statement?

Data Manipulation Language (DML)

Data Definition Language (DDL)

Data Control Language (DCL)

Data Communication Language (DCL)

4.

MULTIPLE CHOICE QUESTION

2 mins • 1 pt

SQL Query to delete all rows in a table without deleting the table (structure, attributes, and indexes)

DELETE FROM table_name;

DELETE TABLE table_name;

DROP TABLE table_name;

None

5.

MULTIPLE CHOICE QUESTION

2 mins • 1 pt

Correct syntax query syntax to drop a column from a table is

DELETE COLUMN column_name;

DROP COLUMN column_name;

ALTER TABLE table_name DROP COLUMN column_name;

None is correct.

6.

MULTIPLE CHOICE QUESTION

2 mins • 1 pt

Which command is used for removing a table and all its data from the database:

Create command

Drop table command

Alter table command

All of the mentioned

7.

MULTIPLE CHOICE QUESTION

2 mins • 1 pt

Which of the following language is used to specify database Schema ?

DDL

DML

DCL

None

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?