Category: 1z0-061 (v.1)

Exam 1z0-061: Oracle Database 12c: SQL Fundamentals (update November 2th, 2015)

Which combination of joins used in the blanks in the above query gives the correct output?

View the Exhibit and examine the structure of the product, component, and PDT_COMP
tables.
In product table, PDTNO is the primary key.
In component table, COMPNO is the primary key.
In PDT_COMP table, <PDTNO, COMPNO) is the primary key, PDTNO is the foreign key
referencing PDTNO in product table and COMPNO is the foreign key referencing the
COMPNO in component table. You want to generate a report listing the product names and
their corresponding component names, if the component names and product names exist.
Evaluate the following query:
SQL>SELECT pdtno, pdtname, compno, compname
FROM product _____________ pdt_comp
USING (pdtno) ____________ component USING (compno)
WHERE compname IS NOT NULL;
Which combination of joins used in the blanks in the above query gives the correct output?

What is the reason for the error?

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

Using the products table, you issue the following query to generate the names, current list
price, and discounted list price for all those products whose list price falls below $10 after a
discount of 25% is applied on it.

The query generates an error. What is the reason for the error?

Which data type would you use for such a column in the table?

You need to create a table for a banking application. One of the columns in the table has the
following requirements:
1) You want a column in the table to store the duration of the credit period.
2) The data in the column should be stored in a format such that it can be easily added and
subtracted with date data type without using conversion functions.
3) The maximum period of the credit provision in the application is 30 days.
4) The interest has to be calculated for the number of days an individual has taken a credit
for.
Which data type would you use for such a column in the table?


Page 1 of 812345...Last »