File Info
| Exam | Oracle Datbase 12c SQL |
| Number | 1z0-071 |
| File Name | Oracle.1z0-071.Pass4Sure.2018-11-19.101q.tqb |
| Size | 9 MB |
| Posted | Nov 19, 2018 |
| Download | Oracle.1z0-071.Pass4Sure.2018-11-19.101q.tqb |
How to open VCEX & EXAM Files?
Files with VCEX & EXAM extensions can be opened by ProfExam Simulator.
Coupon: MASTEREXAM
With discount: 20%
Demo Questions
Question 1
Examine the structure of the MEMBERS table:
You execute the SQL statement:
SQL > SELECT member_id, ' ' , first_name, ' ' , last_name "ID FIRSTNAME LASTNAME " FROM members;
What is the outcome?
- It fails because the alias name specified after the column names is invalid.
- It fails because the space specified in single quotation marks after the first two column names is invalid.
- It executes successfully and displays the column details in a single column with only the alias column heading.
- It executes successfully and displays the column details in three separate columns and replaces only the last column heading with the alias.
Correct answer: D
Question 2
You issue the following command to drop the PRODUCTS table:
SQL > DROP TABLE products;
Which three statements are true about the implication of this command? (Choose three.)
- All data along with the table structure is deleted.
- A pending transaction in the session is committed.
- All indexes on the table remain but they are invalidated.
- All views and synonyms on the table remain but they are invalidated.
- All data in the table is deleted but the table structure remains.
Correct answer: ABD
Question 3
View the Exhibit and examine the structure of ORDERS and ORDER_ITEMS tables.
ORDER_ID is the primary key in the ORDERS table. It is also the foreign key in the ORDER_ITEMS table wherein it is created with the ON DELETE CASCADE option.
Which DELETE statement would execute successfully?
- DELETE orders o, order_items iWHERE o.order_id = i.order_id;
- DELETEFROM ordersWHERE (SELECT order_idFROM order_items);
- DELETE ordersWHERE order_total < 1000;
- DELETE order_idFROM ordersWHERE order_total < 1000;
Correct answer: B
