Tag: databases

Questions Related to databases

Which company tops the 2008 Gartner's Magic Quadrant for DW?
technology databases

  1. Oracle

  2. IBM

  3. Teradata

  4. Microsoft

Show answer
Correct Option: C

This is the first column-oriented database to hit the data warehousing market.

technology databases

  1. Vertica

  2. Sybase IQ

  3. ParAccel

  4. SAND

Show answer
Correct Option: B

Which company coined the word Data Warehouse Appliance?
technology databases

  1. Teradata

  2. DATAllegro

  3. Netezza

  4. Greenplum

Show answer
Correct Option: C

Name the DW database recently released by Oracle in co-operation with HP -
technology databases

  1. Petadata

  2. Exadata

  3. Megadb

  4. OracleMPP

Show answer
Correct Option: B

Choose the 3 Massively Parallel Processing (MPP) architecture based DBMS below -
technology databases

  1. Teradata

  2. Netezza

  3. DATAllegro

  4. Sybase IQ

Show answer
Correct Option: A,B,C

SELECT LAST_DAY('15-MAR-00') FROM DUAL.
technology databases

  1. 30-MAR-00

  2. 31-MAR-00

  3. 15-MAR-00

  4. THERE IS NO FUNCTION LIKE LAST_DAY

Show answer
Correct Option: B

What is the result of this: initsmall("GANESH");

technology databases

  1. ganesh

  2. gANESH

  3. Ganesh

  4. THERE IS NO FUNCTION LIKE initsmall();

Show answer
Correct Option: D

What is the result of this: initcap("gadde");

technology databases

  1. GADDE

  2. Gadde

  3. gADDE

  4. THERE IS NO FUNCTION LIKE initcap();

Show answer
Correct Option: B

What is the result of this: initcap("gadde");
technology databases

  1. GADDE

  2. Gadde

  3. gADDE

  4. THERE IS NO FUNCTION LIKE initcap();

Show answer
Correct Option: B

create global temporary table employee (eno number, ename varchar(20));

technology databases

  1. Error generates

  2. Temporary table is created with name "employee" and it get removed at the end of transaction.

  3. similar to normally creating table.

  4. created in database permenantly

Show answer
Correct Option: B