READ Free Dumps For Oracle- 1z0-001
| Question ID 8118 | Which is not an SQL Plus command?
|
| Option A | List.
|
| Option B | Accept.
|
| Option C | Change.
|
| Option D | Update.
|
| Option E | Describe.
|
| Correct Answer | D |
Explanation Explanation/Reference: Explanation: Answer D is correct because UPDATE is SQL Data Manipulation Language (DML) command, all others answers represent SQL * Plus commands. Incorrect Answers: A: LIST is an SQL * Plus command. B: ACCEPT is an SQL * Plus command. Used to set value for a variable. C: CHANGE is an SQL * Plus command. Used to correct typing errors. E: DESCRIBE is an SQL * Plus command. Used to show the table definition. Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 6-10 Chapter 1: Selecting Data from Oracle
| Question ID 8119 | When selecting data which statement is valid about projection?
|
| Option A | Projection allows due to choose rows.
|
| Option B | Projection allows due to choose columns.
|
| Option C | Projection allows due to joined tables together.
|
| Option D | Projection allows due to add columns to a table.
|
| Correct Answer | B |
Explanation Explanation/Reference: Explanation: Answer B is correct because projection is used to choose columns for data selecting. Incorrect Answers: A: Not projection, but the WHERE clause is used to choose rows. C: Projection does not allow to join tables together. D: Projection does not allow to add columns to a table. Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 4-8 Chapter 1: Selecting Data from Oracle