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:

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?

Name                             NULL                                 Type

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

SALES ID                     NOT NULL                              NUMBER

STORE ID                     NOT NULL                             NUMBER

ITEMS ID                                                                    NUMBER

QUANTITY                                                                 NUMBER

SALES DATE                                                                DATE

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?

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?

Name                      NuLL?                                 Type

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

EMP_ID                   NOT NULL                        NUMBER

EMP_NAME                     VARCHAR2(10)

DEPT_ID                         NUMBER(2)

SALARY                                     NUMBER(8，2)

JOIN_DATE                     DATE

NLS_DATE FORMAT is set to DD-MON-YY.

Which query requires explicit data type conversion? 

Name                                         NULL?                                      TYPE

PROD ID                                     NOT NULL                                NUMBER

PROD NAME                                                                              VARCHAR2(40)

COST                                                                                           NUMBER(8,2)

RELEASE_DATE                                                                             DATE

Which query is valid?

Name

EMP ID

EMP NAME

DEPT ID

SALARY

JOIN DATE

Nul1?

NOT NULL

Type

NUMBER

VARCHAR2(40

NUMBER(2)

NUMBER(8，2)

DATE