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

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

CUSTOMER_ID NOT NULL NUMBER(38)

CUSTOMER_NAME NOT NULL VARCHAR2 (100)

INSERT_DATE NOT NULL DATE

Which two statements will do an implicit conversion?

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?

SELECT e.last_name AS emp, m.1ast_name AS mgr FROM employees e JOIN managers m ON e.manager_id = m.employee_id ORDER BY emp;

You want to extend the query to include employees with no manager.

What must you add before JOIN to do this?

SELECT d.department_name, ROUND (AVG (NULLIF (e.salary,0))) AS avgsal, MAX(e.salary) AS maxsal FROM employees e JOIN departments d ON (e.department_id = d.department_iD

GROUP BY d. department_name ORDER BY 2;

In which order are the rows displayed?

Name Null? Type

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

EMPLOYEE_ID NOT NULL NUMBER(38)

SALARY NOT NULL NUMBER (38)

DEPARTMENT_ID NOT NULL NUMBER(38)

Which statement increases each employee's SALARY by the minimum SALARY for their DEPARTMENT_ID?

ALTER SESSION SET NLS_DATE_FORMAT = 'DD-MON-YYYY HH24:MI:SS' ;

ALTER SESSION SET TIME_ZONE = '-5:00' ;

SELECT DBTIMEZONE, SYSDATE FROM DUAL;

Examine the result:

DBTIMEZONE SYSDATE

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

+00.00 11- JUL-2019 11:00:00

If LOCALTIMESTAMP was selected at the same time, what would it return?

PROD_ID PROD_NAME PROD_LIST CATEGORY_ID

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

101

102

103

104

105

Plate

Cup

Saucer

Knife

Fork

10

20

20

30

30

1

1

1

1

1

Examine these queries:

1). SELECT prod_name, prod_list FROM products WHERE prod_list = ANY (10, 20) AND category_id = 1;

2). SELECT prod_name, prod_list FROM products WHERE prod_list IN (10, 20) AND category_id = 1;

3). SELECT prod_name, prod_list FROM products WHERE prod_list = ALL (10, 20) AND category_id = 1;

Which queries generate the same output?