XII COMPUTER SCIENCE EM-12

JavaScript isn't enabled in your browser, so this file can't be opened. Enable and reload.

12.STRUCTURED QUERY LANGUAGE (SQL)one mark questions :

Prepared by S. Saminathan , GHSS - MUKHASAPARUR, cuddalore dt

https://sites.google.com/view/tn-computer-science/home

NAME: *

SCHOOL : *

1. Which commands provide definitions for creating table structure, deleting relations, and modifying relation schemas. *

1 point

DDL

DML

DQL

DCL

2. Which command lets to change the structure of the table? *

1 point

ORDER BY

MODIFY

ALTER

SELECT

3. The command to delete a table including the structure is *

1 point

DROP

DELETE

DELETES ALL

ALTER TABLE

4. Queries can be generated using *

1 point

ORDER BY

SELECT

ALTER

MODIFY

5. The clause used to sort data in a database *

1 point

SELECT

SORT BY

ORDER BY

GROUP BY

6 RDBMS example ....
*

1 point

3. Informix,postgres

2. IBMDMB2, Micro soft access,

1. Oracle, mysql, MS SQL sever,

1,2 AND 3

7. ........Remove all records from a table, also release the space occupied by those records. *

1 point

TRUNCATE

COMMIT

GRANT

ROLL BACK

8. DDL Expand ....... *

1 point

Data Definition Level

Date Definition Language

Data Defi Language

Data Definition Language

9. DCL Expand........ *

1 point

Data Control Level

Data Control Language

Date Control Language

Data Conform Language

10. TCL Expand......... *

1 point

Transactional Control Language

Transfer Control Language

Transmit Control Language

Transmision Control Language

Submit

Clear form

Never submit passwords through Google Forms.

This content is neither created nor endorsed by Google. Report Abuse - Terms of Service - Privacy Policy

Forms