SELECT * FROM bricks,colors; Which two statements are true? A) You can add an ON clause with a join condition. B) You can add a WHERE clause with filtering criteria. c) It returns the number of rows i ...

Which two statements will convert the string Hello world to ello wozid? A) SELECT LOWER (SUBSTR(‘Hello World, 2, 1)) FROM DUAL; B) SELECT LOWER (SUBSTR(‘Hello World’, 2)) FROM DUAL; C) SELECT LOWER ...

Examine this query which executes successfully; Select job,deptno from emp Union all Select job,deptno from jobs_history; What will be the result? A. It will return rows from both select statements af ...

Examine this SQL statement DELETE FROM employees e WHERE EXISTS (SELECT' dummy' FROM emp history WHERE employee_ id= e. employee id); Which two are true? A) The subquery is not a correlated subquery. ...

You execute this command: TRUNCATE TABLE depts; Which two are true? A) It retains the indexes defined on the table. B) It drops any triggers defined on the table. C) A Flashback TABLE statement can b ...

Which three queries execute successfully? A) SELECT (SYSDATE-DATE '2019-01-01') / 1 FROM DUAL; B) SELECT 1 / SYSDATE - DATE'2019-01-01' FROM DUAL; C) SELECT SYSDATE / DATE '2019-01-01' - 1 FROM DUA D ...

Examine the description of the ORDERS table: Name Null? Type ----------------- -------- -------------- ORDER_ ID NUMBER (38) ORDER_ DATE ...

Examine the data in the EMPLOYEES table: EMPLOYEE_ID LAUT NANE MONTHLY SALARY MONTTHLY COMEHISSIOM PCT 101 Kochhar 24000 102 ...