READ Free Dumps For Oracle- 1z0-146
| Question ID 2841 |
|
| Option A | A.Use cursors to fetch values. |
| Option B | B. Remove redundant SQL statements in the procedures. |
| Option C | C. Avoid the NOT NULL constraint when declaring the variable. |
| Option D | D. Define and compile procedures independently, and not as part of a package. |
| Correct Answer | B,C |
| Question ID 2842 | Which two statements are true about BFILES? (Choose two.) |
| Option A | A. BFILES support only sequential reads. |
| Option B | B. BFILES can be used as attributes in an object type. |
| Option C | C. When LOB is deleted, the corresponding physical file is automatically deleted. |
| Option D | D. The RMAN backup automatically backs up the BFILE locators and the corresponding physical files. |
| Option E | E. The physical file corresponding to a BFILE locator must reside on the file system that is accessible from the server where the database exists. |
| Correct Answer | B,E |