View the Exhibit and examine the structure of the stores table.

You want to display the name of the store along with the address, START_DATE, PROPERTV_PRICE, and the projected property price, which is 115% of the property price. The stores displayed must have START_DATE in the range of 36 months starting from 01Jan-2000 and above.
Which SQL statement would get the desired output?
A)

B)

C)

D)

• A.Option D
• B.Option A
• C.Option B
• D.Option C

Comment: *

Name: *

Email: *

Verification: *

Which two tasks can be performed by using Oracle SQL statements?

• A.changing the password for an existing database user
• B.connecting to a database instance
• C.querying data from tables across databases
• D.starting up a database instance
• E.executing operating system (OS) commands in a session

Comment: *

Name: *

Email: *

Verification: *

You need to produce a report where each customer's credit limit has been incremented by
$1000. In the output, the customer's last name should have the heading Name and the incremented credit limit should be labeled New Credit Limit. The column headings should have only the first letter of each word in uppercase.
Which statement would accomplish this requirement?

• A.SELECT cust_last_name AS Name, cust_credit_limit + 1000"New Credit Limit"FROM customers;
• B.SELECT cust_last_name AS Name, cust_credit_limit + 1000AS New Credit LimitFROM customers;
• C.SELECT cust_last_name AS "Name", cust_credit_limit + 1000AS "New Credit Limit"FROM customers;
• D.SELECT INITCAP (cust_last_name) "Name", cust_credit_limit + 1000INITCAP ("NEW CREDIT LIMIT")FROM customers;

Comment: *

Name: *

Email: *

Verification: *

Which two statements are true about conditional INSERT ALL? (Choose two.)

• A.A single WHEN condition can be used for multiple INTOclauses.
• B.The total number of rows inserted is always equal to the number of rows returned by the subquery.
• C.It cannot have an ELSEclause.
• D.Each row returned by the subquery can be inserted into only a single target table.
• E.Each WHENcondition is tested for each row returned by the subquery.

Comment: *

Name: *

Email: *

Verification: *

In which normal form is a table, if it has no multi-valued attributes and no partial dependencies?

• A.second normal form
• B.first normal form
• C.third normal form
• D.fourth normal form

Comment: *

Name: *

Email: *

Verification: *