AllExam Dumps

DUMPS, FREE DUMPS, VCP5 DUMPS| VMWARE DUMPS, VCP DUMPS, VCP4 DUMPS, VCAP DUMPS, VCDX DUMPS, CISCO DUMPS, CCNA, CCNA DUMPS, CCNP DUMPS, CCIE DUMPS, ITIL, EXIN DUMPS,


READ Free Dumps For Oracle- 1z0-001





Question ID 8176

Which statement shows the view definition of the view emp_view that is created based on the emp table?

Option A

DESCRIBE emp

Option B

DESCRIBE view emp_view

Option C

SELECT TEXT FROM user_views WHERE view_name= 'EMP_VIEW';

Option D

SELECT view_text FROM my_views WHERE view_name= 'EMP_VIEW';

Option E

SELECT view_text FROM table emp WHERE view_name= 'EMP_VIEW';

Correct Answer C
Explanation Explanation/Reference: Explanation: Answer C is correct because this statement uses USER_VIEWS with correct condition in the WHERE clause. Incorrect Answers: A: This command will show description of EMP table, not a view. B: You cannot see description of view with DESCRIBE command. D: There is no MY_VIEWS in the Oracle. E: Statement is incorrect because of usage FROM TABLE. Also you can not see description of view using table EMP. Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 114-119 Chapter 3: Creating Oracle Database Objects


Question ID 8177

Examine the structure of the BOOK_TITLE, COPY and CHECK_OUT tables. BOOK TITLE Id.PK title Author COPY Id PK Title_id PK available CHECK_OUT Id PK Copy_id Title_id Customer-id Check_out_date Expected_return_date You need to create the BOOKS_AVAILABLE view. These are the desired results? 1. Include the title of each book. 2. Include the availability of each book. 3. Order the results by the author. Evaluate this SQL statement: CREATE VIEW books_available AS SELECT b.title,c.available FROM book_title b,copy c WHERE b.id=c.title_id ORDER BY b.author; What does this statement provide?

Option A

All the desired results.

Option B

Two of the desired results.

Option C

One of the desired results.

Option D

A syntax error.

Correct Answer A
Explanation Explanation/Reference: Explanation: Answer A is correct because this view will show results, including the title and availability, ordered by the author. Incorrect Answers: B: All three results will be shown, not two. C: All three results will be shown, not one. D: There is no syntax error in this statement. Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 160-169 Chapter 4: Creating Other Database Objects in Oracle

Send email to admin@getfreedumps for new dumps request!!!