MCQ IN COMPUTER SCIENCE & ENGINEERING

COMPUTER SCIENCE AND ENGINEERING

SQL

Please wait while the activity loads.
If this activity does not load, try refreshing your browser. Also, this page requires javascript. Please visit using a browser with javascript enabled.

If loading fails, click here to try again

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]

Which of the following is not a DDL command?

A	UPDATE
B	TRUNCATE
C	ALTER
D	None of the Mentioned

Explanation:

Detailed explanation-1: -In SQL, which of the following is not a data definition language commands? Explanation: With RENAME statement you can rename a table.RENAME, REVOKE and GRANT are DDL commands and UPDATE is DML command.

Detailed explanation-2: -It is a Data Definition Language (DDL). It is a Data Manipulation Language (DML). This command operates on the structure level.

Detailed explanation-3: -Answer: UPDATE is not a DDL command.

Detailed explanation-4: -Following are the five DDL commands in SQL: DROP Command. ALTER Command. TRUNCATE Command. RENAME Command.

There is 1 question to complete.