Which three statements are true about Oracle synonyms? A) A synonym cannot be created for a PL /SQL package. B) A SEQUENCE can have a synonym. C) A synonym can be available to all users . D) A synonym ...

.A session's NLS_DATE_FORMAT is set to DD Mon YYYY . Which two queries return the value 1 Jan 2019? A) SELECT to_date(' 2019-01-01 ', 'YYYY -MM-DD' ) FROM DUAL; B) SELECT DATE '2019-01-01' FROM DUAL ; ...

Which two statements are true? A) AIl conditions evaluated using DECODE can also be evaluated using CASE. B) All conditions evaluated using CASE can also be evaluated using DECODE. C) CASE is a functi ...

which is true about the round,trunc and mod functions>? A ROUND(MOD(25,3),-1) IS INVALID B ROUND(MOD(25,3),-1) AND TRUNC(MOD(25,3),-1) ARE BOTH VALID AND GIVE THE SAME RESULT. C.ROUND(MOD(25,3),-1) AN ...

Examine this Statement which returns the name of each employee and their manager, SELECT e.last name AS emp,,m.last_name AS mgr FROM employees e JOIN managers m ON e.manager_ id = m. employee_ id ORDE ...

which three statements are true about indexes and their administration in an Oracle database? A) The same table column can be part of a unique and non-unique index B)A DESCENDING INDEX IS A type of fu ...

Examine the description of the PRODUCT_ STATUS table :Name Null? Type PROD_ID NOT NULL NUMBER(2) STATUS NOT NULL VARCHAR2 (15) The STATUS column contains the values IN STOCK or OUT OF STocK for each r ...

Examine this query: SELECT SUBSTR (SYSDATE,1,5) ‘Result’ FROM DUAL Which statement is true? A. It fails unless the expression is modified to TO-CHAR(SUNBSTR(SYSDATE,1,5) B. It fails unless the expre ...