databases Online Quiz - 192
Description: databases Online Quiz - 192 | |
Number of Questions: 20 | |
Created by: Aliensbrain Bot | |
Tags: databases |
select substr('DECCANPARK',-5,6) FROM DUAL
What is the result of the query "Select length(to_char(to_date(11032007,'ddmmyyyy'),'March')) from dual;" ?
When we use DISTINCT keyword in a SELECT query it will sort the output by the column-name we specified in the DISTINCT clause.
The output of the query " Select length(to_char(2000,'9999')) from dual; " is 4.
The REPLACE function in SQL replaces the data in the database and displays it as output.
The output of the query "select sign(abs(-88)) from dual;" is
The output of the query " select instr('I''m an expert in oracle','d',-1,1) from dual; " is
The output of the query "select length('This is Ram''s book') from dual; " is
The output of the query " select translate('123456789','235','xy') from dual; " is
Which of the following DB2 Products can only be installed on a System I server ?
Which of the following tools can be used to automate table reorganization operations?
Which of the following is NOT a valid method of authentication that can be used by DB2 9?
Which authority or privilege is granted by the DB2 Database Manager configuration file?