Examine this command:

SQL> CREATE TABLE T1(c1 INT PRIMARY KEY, c2 CLOB);

Which segment or segments, if any, are created as a result of executing the command?

Which statement will create a synonym called EMP for the HCM.EMPLOYEE_RECORDS table that is accessible to all users?

Examine this schema information:

1. EMPLOYEES.DEPARTMENT_ID has a foreign key referencing

DEPARTMENTS.DEPARTMENT_ID.

2. EMP_VIEW is based on the EMPLOYEES and DEPARTMENTS tables.

3. EMP_VIEW has columns EMPLOYEE_ID, EMPLOYEE_NAME and

DEPARTMENT_NAME. You must add a new column, MANAGER_ID, from the EMPLOYEES table, to the view, showing

each employee's manager.

Which statement will do this?

SELECT 1 AS id, 'John' AS first_name, NULL AS commission FROM DUAL INTERSECT SELECT 1, 'John' ,NULL FROM DUAL ORDER BY 3;

What is returned upon execution?

（含图）

SALES2 is a table with the same description as SALES1. Some sales data is duplicated in both tables. You want to display the rows from the SALES1 table which are not present in the SALES2 table.

Which set operator generates the required output?

Name Null Type

-----------------------------------------------------------------------

SALES_ID

STORE_ID

ITEMS_ID

QUANTITY

SALES_DATE

SALES2 is a table with the same description as SALES1.

Some sales data is contained

erroneously in both tables. You must display rows from SALES1 and SALES2 and wish to see the duplicates too.

Which set operator generates the required output?

Examine these statements:

CREATE TABLE alter_test ( c1 VARCHAR2 (10), c2 NUMBER(10)) ;

INSERT INTO alter_test VALUES ('123', 123) ;

COMMIT ;

Which is true about modifying the columns in ALTER_TEST?

Which two statements are true about an Oracle database?

The table has two rows whose CUST LAST NAME values are Anderson and Ausson.

Which query produces output for CUST LAST NAME containing oder for the first row and Aus for the second?

What is the result?

（含图）

Using the CUSTOMERS table, you must generate a report that displays a credit limit increase of 15% for all customers. Customers with no credit limit should have “Not Available” displayed.

Which SQL statement would produce the required result?

NLS_DATE FORMAT is set to DD-MON-YY. 

Which query requires explicit data type conversion?

（含图）

Which query is valid?

（含图）

Which query can be used?

（含图）

For customers whose income level has a value, you

want to display the first name and due_amount as 5% of their credit limit. Customers whose due_amount is null should not be displayed.

Which query should be used?