Examine the description of the SALES table:

The SALES table has 55,000 rows.
Examine this statement:

Which two statements are true?

• A.SALES1 is created with no rows.
• B.SALES1 is created with 1 row.
• C.SALES1 has NOT NULL constraints on any selected columns which had those constraints in the SALES table.
• D.SALES1 is created with 55,000 rows.
• E.SALES1 has PRIMARY KEY and UNIQUE constraints on any selected columns which had those constraints in the SALES table.

Comment: *

Name: *

Email: *

Verification: *

View the exhibit and examine the structure of the SALES, CUSTOMERS, PRODUCTS and TIMES tables.
The PROD_ID column is the foreign key in the SALES table referencing the PRODUCTS table.
The CUST_ID and TIME_ID columns are also foreign keys in the SALES table referencing the CUSTOMERS and TIMES tables, respectively.
Examine this command:
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?

• A.The NEW_SALES table would get created and all the FOREIGN KEY constraints defined on the selected columns from the SALES table would be created on the corresponding columns in the NEW_SALES table.
• B.The NEW_SALES table would not get created because the DEFAULT value cannot be specified in the column definition.
• C.The NEW_SALES table would not get created because the column names in the CREATE TABLE command and the SELECT clause do not match.
• D.The NEW_SALES table would get created and all the NOT NULL constraints defined on the selected columns from the SALES table would be created on the corresponding columns in the NEW_SALES table.

Comment: *

Name: *

Email: *

Verification: *

Examine the BRICKS table:

You write this query:
SELECT
FROM bricks b1 CROSS JOIN bricks b2
WHERE b1. Weight < b2. Weight:
How many rows will the query return?

• A.10
• B.0
• C.6
• D.1
• E.16
• F.4

Comment: *

Name: *

Email: *

Verification: *

Which two statements are true regarding the COUNT function? (Choose two.)

• A.The COUNT function can be used only for CHAR, VARCHAR2, and NUMBER data types.
• B.COUNT(cust_id) returns the number of rows including rows with duplicate customer IDs and NULLs in the CUST_ID column.
• C.A SELECT statement using the COUNT function with a DISTINCT keyword cannot have a WHERE clause.
• D.COUNT(DISTINCT inv_amt) returns the number of rows excluding rows containing duplicates and NULLs in the INV_AMT column.
• E.COUNT(*) returns the number of rows including duplicate rows and rows containing NULL value in any column.

Comment: *

Name: *

Email: *

Verification: *

Examine the structure proposed for the TRANSACTIONS table:

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

• A.The TRANS_DATE column would be able to store day, month, century, year, hour, minutes, seconds, and fractions of seconds.
• B.The CUST_STATUS column would give an error.
• C.The TRANS_VALIDITY column would have a maximum size of one character.
• D.The TRANS_VALIDITY column would give an error.
• E.The CUST_CREDIT_LIMIT column would be able to store decimal values.
• F.The CUST_STATUS column would store exactly one character.

Comment: *

Name: *

Email: *

Verification: *