The REPLACE function in SQL replaces the data in the database and displays it as output.
True
False
The output of the query "select sign(abs(-88)) from dual;" is
-
+
0
1
None of the above
The output for the qyery "select lpad('sql functions',18,'*#$') from dual;" is
#$#$sql function
error
#$#sql functions
The output of the query " select instr('I''m an expert in oracle','d',-1,1) from dual; " is
null
The output of the query "select length('This is Ram''s book') from dual; " is
18
19
21
none of the above
The output of the query " select instr('I am an expert in sql functions','n',-10,2) from dual; " is
30
7
2
10
The output of the query " select translate('123456789','235','xy') from dual; " is
1x4y6789
1xy456789
1xy46789
Which of the following DB2 Products can only be installed on a System I server ?
DB2 for z/OS
DB2 for i5/OS
DB2 Data Warehouse Edition
DB2 Enterprise Server Edition
Which of the following tools can be used to automate table reorganization operations?
Control Center
Command Center
Command Line Processor
Task Center