View the Exhibit and examine the structure of the product, component, and PDT_COMP
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?
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?
You need to create a table for a banking application. One of the columns in the table has the
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
Which data type would you use for such a column in the table?
Which three tasks can be performed using SQL functions built into Oracle Database?