14. Which of the following are types of SQL statements? a. Data Definition Langu

Question

14. Which of the following are types of SQL statements? a. Data Definition Language (DDL) b. Data Manipulation Language (DML) c. Data Control Language (DCL) d. All of the above 15. If a field named PAGE has data type NUMBER, which of the following WHERE clause conditions will return pages 1-3? a. PAGE between 1 and 3 b. PAGE in (1, 2, 3) c. PAGE1 and PAGE d. All of the above 3 16. In order to see output from the DBMS OUTPUT.PUT_LINE you must use which SET command? a. VERIFY b. TERMOUT c. SERVEROUTPUT d. DISPLAY 17. The only section of an anonymous block that is required is? a. Declaration b. Execution c. Exception d. None of the above

Explanation / Answer

14)d

DML,DCL and DDL

15)d

Between checks inclusive of both boundary conditions

In checks all the values present in parenthesis

>= and <= gets the 3 pages

16)c

SET SERVEROUTPUT ON

17)b

Execution section is the only mandatory one for a anonymous block.

Related Questions

Navigate

• Browse (All)
• Browse 1
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.