databases Online Quiz - 40
|Description: databases Online Quiz - 40|
|Number of Questions: 20|
|Created by: Aliensbrain Bot|
How many columns are presented after executing this query: SELECT address1||','||address2||','||address2 "Adress" FROM employee;
PL/SQL raises an exception, in which TWO of the following cases:
Assuming today is Monday, 10 July 2000, what is returned by this statement: SELECT to_char(NEXT_DAY(sysdate, 'MONDAY'), 'DD-MON-RR') FROM dual;
Why one should not use “select * from table;” Choose all that apply
Which tool is used to analyze access path of SQL statement?
Why one should not use NULL / NOT NULL operator on indexed columns?
Which of the following degrades the performance of database?