You are designing the structure of a table in which two columns have the specifications:
COMPONENT_ID - must be able to contain a maximum of 12 alphanumeric characters and must uniquely identify the row
EXECUTION_DATETIME - contains Century, Year, Month, Day, Hour, Minute, Second to the maximum precision and is used for calculations and comparisons between components.
Which two options define the data types that satisfy these requirements most efficiently? (Choose two.)

• A.The EXECUTION_DATETIME must be of TIMESTAMP data type.
• B.The EXECUTION_DATETIME must be of DATE data type.
• C.The COMPONENT_ID must be of VARCHAR2 data type.
• D.The COMPONENT_ID column must be of CHAR data type.
• E.The EXECUTION_DATETIME must be of INTERVAL DAY TO SECOND data type.
• F.The COMPONENT_ID must be of ROWID data type.

Comment: *

Name: *

Email: *

Verification: *

Examine the data in the ORD_ITEMS table:

Evaluate this query:

Which statement is true regarding the result?

• A.It displays the item nos with their average quantity where the average quantity is more than double the minimum quantity of that item in the table.
• B.It returns an error because the HAVING clause should be specified after the GROUP BY clause.
• C.It displays the item nos with their average quantity where the average quantity is more than double the overall minimum quantity of all the items in the table.
• D.It returns an error because all the aggregate functions used in the HAVING clause must be specified in the SELECT list.

Comment: *

Name: *

Email: *

Verification: *

Which two are true about scalar subquery expressions? (Choose two.)

• A.You must enclose them in parentheses.
• B.You can use them as a default value for a column.
• C.You cannot correlate them with a table in the parent statement.
• D.They can return at most one row.
• E.They can return two columns.

Comment: *

Name: *

Email: *

Verification: *

View the exhibit and examine the structure of the SALES, CUSTOMERS, PRODUCTSand TIMEStables.

The PROD_IDcolumn is the foreign key in the SALEStable, which references the PRODUCTStable.
Similarly, the CUST_IDand TIME_IDcolumns are also foreign keys in the SALEStable referencing the CUSTOMERSand TIMEStables, respectively.
Evaluate the following CREATE TABLEcommand:
CREATE TABLE new_sales (prod_id, cust_id, order_date DEFAULT SYSDATE)
AS
SELECT prod_id, cust_id, time_id
FROM sales;
Which statement is true regarding the above command?

• A.The NEW_SALEStable would not get created because the DEFAULTvalue cannot be specified in the column definition.
• B.The NEW_SALEStable would get created and all the NOTNULLconstraints defined on the specified columns would be passed to the new table.
• C.The NEW_SALEStable would not get created because the column names in the CREATETABLE command and the SELECTclause do not match.
• D.The NEW_SALEStable would get created and all the FOREIGNKEYconstraints defined on the specified columns would be passed to the new table.

Comment: *

Name: *

Email: *

Verification: *

Examine the structure of the PROGRAMS table:

Which two SQL statements would execute successfully? (Choose two.)

• A.SELECT NVL(TO_CHAR(MONTHS_BETWEEN(start-date,end_date)),'Ongoing')FROM programs;
• B.SELECT TO_DATE(NVL(SYSDATE-END_DATE,SYSDATE))FROM programs;
• C.SELECT NVL(ADD_MONTHS(END_DATE,1)SYSDATE)FROM programs;
• D.SELECT NVL(MONTHS_BETWEEN(start_date,end_date),'Ongoing')FROM programs;

Comment: *

Name: *

Email: *

Verification: *