Tag: databases

Questions Related to databases

Which from the following is not an ERP package?

technology databases

  1. SAP

  2. Peoplesoft

  3. Oracle 11g

  4. JD Edwards

Show answer
Correct Option: C

From below list which are the open source CMSs.
technology databases

  1. Drupal

  2. Joomla

  3. PHP

  4. Wordpress

Show answer
Correct Option: A,B,D

which of the following is the default format for date display
technology databases

  1. DD-MM-YYYY

  2. DD-Mon-RR

  3. DD-Mon-YY

  4. DD-MON-RR

Show answer
Correct Option: D

what will be the output of: select rpad('*$*',3,'*') from dual;
technology databases

  1. $***

  2. $

  3. ***$

Show answer
Correct Option: B

what is the output: select substr('Oracle Basics',-5,3) from dual
technology databases

  1. 'asi'

  2. 'isa'

  3. 'le '

  4. 'acl'

Show answer
Correct Option: A

what is the output: select mod(1600,300) from dual;

technology databases

  1. 300

  2. 100

  3. 500

  4. 000

Show answer
Correct Option: B

Which of the following is not a grouping function?

technology databases

  1. avg

  2. count

  3. abs

  4. min

Show answer
Correct Option: C

Which of the folowing is not a oracle function?
technology databases

  1. round

  2. trunc

  3. maximum

  4. initcap

Show answer
Correct Option: C

Which method returns the number of rows in a set.
technology databases

  1. sum

  2. num_rows

  3. count

  4. total

Show answer
Correct Option: C

Which operator is equivalent to concat function?

technology databases

  1. &

  3. ||

  4. &&

Show answer
Correct Option: C