READ Free Dumps For Oracle- 1z0-007
| Question ID 7957 | Which statement describes the ROWID data type?
|
| Option A | Binary data up to 4 gigabytes.
|
| Option B | Character data up to 4 gigabytes.
|
| Option C | Raw binary data of variable length up to 2 gigabytes.
|
| Option D | Binary data stored in an external file, up to 4 gigabytes.
|
| Option E | A hexadecimal string representing the unique address of a row in its table.
|
| Correct Answer | E |
Explanation Explanation/Reference: Explanation: The ROWID datatype stores information related to the disk location of table rows. They also uniquely identify the rows in your table. The ROWID datatype is stored as a hexadecimal string. Incorrect Answers A: It is not a binary data. The ROWID datatype is a hexadecimal string. B: It is not a character data. The ROWID datatype is a hexadecimal string. C: It is not a raw binary data. The ROWID datatype is a hexadecimal string. D: It is not binary data stored in an external file. The ROWID datatype is a hexadecimal string. OCP Introduction to Oracle 9i: SQL Exam Guide, Jason Couchman, p. 216 Chapter 5: Creating Oracle Database Objects
| Question ID 7958 | Evaluate the SQL statement DROP TABLE DEPT: Which four statements are true of the SQL statement? (Choose four)
|
| Option A | You cannot roll back this statement.
|
| Option B | All pending transactions are committed.
|
| Option C | All views based on the DEPT table are deleted.
|
| Option D | All indexes based on the DEPT table are dropped.
|
| Option E | All data in the table is deleted, and the table structure is also deleted.
|
| Option F | All data in the table is deleted, but the structure of the table is retained.
|
| Correct Answer | ABDE |
Explanation Explanation/Reference: Explanation: You cannot roll back DROP TABLE statement. All pending transactions related on this table are committed. If the table is dropped, Oracle automatically drops any index, trigger and constraint associated with the table as well. All data in the table is deleted, and the table structure is also deleted. Incorrect Answers C: All views based on the DEPT table become invalid, but they are not deleted. F: All data in the table is deleted, and the table structure is also deleted. Command TRUNCATE deletes all data in the table, but does not delete the structure of the table. G: All synonyms based on the DEPT table are not deleted after dropping the table. OCP Introduction to Oracle 9i: SQL Exam Guide, Jason Couchman, p. 225 Chapter 5: Creating Oracle Database Objects