Which is an /SQL*Plus command?

The correct answer is D. DESCRIBE. There is only one SQLPlus command in this list: DESCRIBE. It cannot be used as SQL command. This command returns a description of tablename, including all columns in that table, the datatype for each column, and an indication of whether the column permits storage of NULL…

Basic SQL SELECT Statements

Question

Options

AINSERT
BUPDATE
CSELECT
DDESCRIBE
EDELETE
FRENAME

How the community answered

(40 responses)

A
15% (6)
B
5% (2)
C
3% (1)
D
75% (30)
F
3% (1)

Explanation

There is only one SQLPlus command in this list: DESCRIBE. It cannot be used as SQL command. This command returns a description of tablename, including all columns in that table, the datatype for each column, and an indication of whether the column permits storage of NULL Incorrect Answers A: INSERT is not a SQLPlus command. It's data-manipulation language (DML) command. B: UPDATE is not a SQLPlus command. It's data-manipulation language (DML) command. C: SELECT is not a SQLPlus command. E: DELETE is not a SQLPlus command. It's data-manipulation language (DML) command. F: RENAME is not a SQLPlus command.

Topics

#SQL*Plus#DESCRIBE command#iSQL*Plus commands#DML vs DDL

Community Discussion

No community discussion yet for this question.

Full 1Z0-007 Practice