QUESTION 172
Examine the structure proposed for the TRANSACTIONS table:

Which two statements are true regarding the storage of data in the above table structure? (Choose two.)

QUESTION 173
Examine the data in the EMPLOYEEStable.

Which statement will compute the total annual compensation for each employee?
SELECT last_name, (monthly_salary * 12) + (monthly_salary * 12 *

QUESTION 174
View the Exhibits and examine the structure of the COSTSand PROMOTIONStables.
You want to display PROD_IDSwhose promotion cost is less than the highest cost PROD_IDin a promotion time interval.
Examine this SQL statements:

What will be the result?
Exhibit 1.

Exhibit 2.

QUESTION 175
View the exhibit and examine the structure of ORDERSand CUSTOMERStables.
ORDERS
Name
Null? Type
ORDER_ID NOT NULL NUMBER(4)
ORDER_DATE NOT NULL DATE
ORDER_MODE VARCHAR2(8)
CUSTOMER_ID NOT NULL NUMBER(6)
ORDER_TOTAL NUMBER(8, 2)
CUSTOMERS
Name Null? Type
CUSTOMER_ID NOT NULL NUMBER(6)
CUST_FIRST_NAME NOT NULL VARCHAR2(20)
CUST_LAST_NAME NOT NULL VARCHAR2(20)
CREDIT_LIMIT NUMBER(9,2)
CUST_ADDRESS VARCHAR2(40)
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.

QUESTION 176
View the exhibit and examine the descriptions of the DEPT and LOCATIONS tables.

You want to update the CITY column of the DEPT table for all the rows with the corresponding value in the CITY column of the LOCATIONS table for each department.
Which SQL statement would you execute to accomplish the task?

QUESTION 177
Which three statements are correct regarding indexes? (Choose three.)

QUESTION 178
You want to display the date for the first Monday of the next month and issue the following command:

What is the outcome?

QUESTION 179
Examine the structure of the MEMBERS table: (Choose the best answer.)

Examine the SQL statement:
SQL > SELECT city, last_name LNAME FROM MEMBERS ORDER BY 1, LNAME DESC; What would be the result execution?

QUESTION 180
View the exhibit and examine the structure of the STOREStable.
STORES table
Name Null? Type
—————– —– ————-
STORE_ID NUMBER
NAME VARCHAR2(100)
ADDRESS VARCHAR2(200)
CITY VARCHAR2(100)
COUNTRY VARCHAR2(100)
START_DATE DATE
END_DATE DATE
PROPERTY_PRICE NUMBER
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?

QUESTION 181
Which two are true about the data dictionary?

QUESTION 182
View the exhibit and examine the structure in ORDERSand ORDER_ITEMStables.

You need to create a view that displays the ORDER_ID, ORDER_DATE, and the total number of items in each order.
Which CREATEVIEWstatement would create the views successfully?

QUESTION 183
Which two statements are true regarding constraints?

QUESTION 184
Which two statements are true regarding constraints? (Choose two.)

QUESTION 185
Examine the description of the EMPLOYERS table:

Examine these requirements:
Disable the manager ID and salary of the lowest paid employees for that manager.
Exclude anyone whose manager is not known.
Exclude any managers where the minimum salary is 6000 or less.
Sort the output by minimum salary with the highest salary shown first.
Which statement will do this?

QUESTION 186
Examine these SQL statements which execute successfully:

Which two statements are true after execution?

QUESTION 187
View the Exhibit and examine the details of the PRODUCT_INFORMATION table.

You have the requirement to display PRODUCT_NAME and LIST_PRICE from the table where the CATEGORYJD column has values 12 or 13, and the SUPPLIER_ID column has the value 102088. You executed the following SQL statement:
SELECT product_name, list_price
FROM product_information
WHERE (category_id = 12 AND category_id = 13) AND supplier_id = 102088; Which statement is true regarding the execution of the query?

QUESTION 188
Which two queries return the string Hello! we’re ready?

QUESTION 189
Which two statements are true about a full outer join? (Choose two.)