Choose three 

Which three are true about the CREATE TABLE command? 

Choose two 

The CUSTOMERS table has a CUST_CREDT_LIMIT column of data type number. 

Which two queries execute successfully? 

Choose the best answer 

The CUSTOMERS table has a CUST_LAST_NAME column of data type VARCHAR2. 

The table has two rows whose COST_LAST_MANE values are Anderson and Ausson. 

Which query produces output for CUST_LAST_SAME containing Oder for the first row and Aus for the 

second?

Choose three 

Which three statements are true about indexes and their administration in an Oracle database? 

Choose three 

Which three are true about granting object privileges on tables, views, and sequences?

Choose the best answer 

The EMPLOYEES table contains columns EMP_ID of data type NUMBER and HIRE_DATE of data type DATE 

You want to display the date of the first Monday after the completion of six months since hiring 

The NLS_TERRITORY parameter is set to AMERICA in the session and, therefore, Sunday is the first day of the week 

Which query can be used? 

Choose three 

Which three statements are true about views in an Oracle database? 

Choose two 

Which two statements are true about Oracle synonyms? 

Choose two. 

Which two statements are true about a self join? 

Choose two

Which three statements are true about dropping and unused columns in an Oracle database?

Choose the best answer.

Examine this query:

SELECT TRUNC (ROUND(156.00,-2),-1) FROM DUAL;

What is the result?

Choose two.

Examine this SQL statement:

UPDATE orders o

SET customer_name =

      (SELECT cust_last_name

       FROM customers

       WHERE customer_id=o.customer_id);

Which two are true?

Choose two.

Examine this partial command:

CREATE TABLE cust (

cust_id  NUMBER(2),

credit_limit  NUMBER(10)

)

ORGANIZATION EXTERNAL

Which two clauses are required for this command to execute successfully?

Choose two

Examine this business rule:

Each student can work on multiple projects and earth project can have multiple students

You must decision an Entity Relationship (ER) model for optional data storage and allow generating

reports in this format:

STUDENT_ID FIRST_NAME  LAST_NAME  PROJECT_ID PROJECT_NAME PROJECT_TASK

Which two statements are true?

Choose two

Which two statements are true about the WHERE and HAVING clauses in a SELECT statement?

Choose two

The INVOICE table has a QTY_SOLD column of data type NUMBER and an INVOICE_DATE column of

data type DATE

NLS_DATE_FORMAT is set to DD-MON-RR.

Which two are true about data type conversions involving these columns in query expressions?

Choose two

The PRODUCT_INFORMATION table has a UNIT_PRICE column of data type NUMBER(8, 2).

Evaluate this SQL statement:

SELECT TO_CHAR(unit_price,'$9,999') FROM PRODUCT_INFORMATION;

Which two statements are true about the output?