Oracle__16. Oracle 1Z0-051 Exam - PL _SQL

Question 1

Do both SQL and SQL *PLUS allow manipulation of values in the database?

Answer 1

Yes

Question 2

Which of the following is a SQL *PLUS command? SELECT ALTER DESCRIBE DROP

Answer 2

DESCRIBE

Question 3

What is needed in all SQL *Plus statements but not in SQL Statements?

Answer 3

; (semicolon)

Question 4

What commands can be used to create substitution variables?

Answer 4

1. DEFINE | UNDEFINE

Question 5

What PL *SQL command will list the structure of a table?

Answer 5

DESCRIBE table1

Question 6

List some SQL *Plus command that are not supported by SQL Worksheet?

Answer 6

1. DESCRIBE2. APPEND3. ARCHIVE4. ATTRIBUTE5. BREAK