Pass 1z0-071 Exam – Real Test Engine PDF with 305 Questions [Q169-Q187]

NEW QUESTION 169
View and Exhibit and examine the structure and data in the INVOICE table.

Which two statements are true regarding data type conversion in query expressions? (Choose two.)

NEW QUESTION 170
View the Exhibit and examine the data in the PROMOTIONStable.

PROMO_BEGIN_DATEis stored in the default date format, dd-mon-rr.
You need to produce a report that provides the name, cost, and start date of all promos in the POST category that were launched before January 1, 2000.
Which SQL statement would you use?
SELECT promo_name, promo_cost, promo_begin_date

NEW QUESTION 171
Examine the commands used to create the DEPARTMENT_DETAILS and the COURSE- DETAILS tables:
SQL> CREATE TABLE DEPARTMfiNT_DeTAILS
DEPARTMENT_ID NUMBER PRIMARY KEY ,
DEPARTMEHT_NAME VARCHAR2(50) ,
HOD VARCHAP2(50));
SQL> CREATE TABLE COURSE-DETAILS
(COURSE ID NUMBER PRIMARY KEY ,
COURS_NAME VARCHAR2 (50) ,
DEPARTMEHT_ID NUMBER REFERENCES DEPARTMENT_DETAIL
You want to generate a list of all department IDs along with any course IDs that may have been assigned to them.
Which SQL statement must you use?

NEW QUESTION 172
View the Exhibit and examine the description of the EMPLOYEES table.

You want to calculate the total remuneration for each employee. Total remuneration is the sum of the annual salary and the percentage commission earned for a year. Only a few employees earn commission.
Which SQL statement would you execute to get the desired output?

NEW QUESTION 173
Evaluate these commands which execute successfully:

Which two statements are true about the ORD_ITEMS table and the ORD_SEQ sequence?

NEW QUESTION 174
View the Exhibit and examine the structure of the PRODUCT_INFORMATION table.

You want to see the product names and the date of expiration of warranty for all the products, if the product is purchased today. The products that have no warranty should be displayed at the top and the products with maximum warranty period should be displayed at the bottom.
Which SQL statement would you execute to fulfill this requirement?

NEW QUESTION 175
Examine the command:

What does ON DELETE CASCADE imply?

NEW QUESTION 176
Which two statement are true regarding table joins available in the Oracle Database server? (Choose two.)

NEW QUESTION 177
View the exhibit and examine the structure of ORDERSand CUSTOMERStables.

Which INSERT statement should be used to add a row into the ORDERStable for the customer whose CUST_LAST_NAMEis Robertsand CREDIT_LIMITis 600? Assume there exists only one row with CUST_LAST_NAME as Roberts and CREDIT_LIMIT as 600.
INSERT INTO (SELECT o.order_id, o.order_date, o.order_mode, c.customer_id,

NEW QUESTION 178
You have the privileges to create any type of synonym.
Which stalement will create a synonym called EMP for the HCM.EMPLOYEE_RECORDS table that is accesible to all users?

NEW QUESTION 179
SCOTTis a user in the database.
Evaluate the commands issued by the DBA:

Which statement is true regarding the execution of the above commands?

NEW QUESTION 180
Which statements are true regarding primary and foreign key constraints and the effect they can have on table data?

NEW QUESTION 181
Which three are true about dropping columns from a table?

NEW QUESTION 182
Which three privileges can be restricted to a subset of columns in a table?

NEW QUESTION 183
Which two queries execute successfully?

NEW QUESTION 184
View the exhibit and examine the structure of the STOREStable.

You must display the NAME of stores along with the ADDRESS, START_DATE, PROPERTY_PRICE, and the projected property price, which is 115% of property price.
The stores displayed must have START_DATEin the range of 36 months starting from 01-Jan-2000 and above.
Which SQL statement would get the desired output?
SELECT name, concat (address| | ‘,’| |city| |’, ‘, country) AS full_address,

NEW QUESTION 185
View the exhibit and examine the structure of the STOREStable.

You want to display the NAME of the store along with the ADDRESS, START_DATE, PROPERTY_PRICE, and the projected property price, which is 115% of property price.
The stores displayed must have START_DATEin the range of 36 months starting from 01-Jan-2000 and above.
Which SQL statement would get the desired output?
SELECT name, concat (address| | ‘,’| |city| |’, ‘, country) AS full_address,

NEW QUESTION 186
Examine this description of the PRODUCTS table:

You successfully execute this command:

Which two statements execute without errors?

NEW QUESTION 187
View the Exhibit and examine the structure of the PRODUCT_INFORMATION table. (Choose the best answer.)

PRODUCT_ID column is the primary key.
You create an index using this command:
SQL > CREATE INDEX upper_name_idx
ON product_information(UPPER(product_name));
No other indexes exist on the PRODUCT_INFORMATION table.
Which query would use the UPPER_NAME_IDX index?