0

databases Online Quiz - 132

Description: databases Online Quiz - 132
Number of Questions: 20
Created by:
Tags: databases
Attempted 0/20 Correct 0 Score 0

Which company coined the word Data Warehouse Appliance?

  1. Teradata

  2. DATAllegro

  3. Netezza

  4. Greenplum


Correct Option: C

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

  1. Petadata

  2. Exadata

  3. Megadb

  4. OracleMPP


Correct Option: B

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

  1. 30-MAR-00

  2. 31-MAR-00

  3. 15-MAR-00

  4. THERE IS NO FUNCTION LIKE LAST_DAY


Correct Option: B

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

  1. ganesh

  2. gANESH

  3. Ganesh

  4. THERE IS NO FUNCTION LIKE initsmall();


Correct Option: D
  1. GADDE

  2. Gadde

  3. gADDE

  4. THERE IS NO FUNCTION LIKE initcap();


Correct Option: B

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

  1. GADDE

  2. Gadde

  3. gADDE

  4. THERE IS NO FUNCTION LIKE initcap();


Correct Option: B
  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


Correct Option: B
  1. USER_COMMENTS

  2. USER_ALL_COMMENTS

  3. USER_TAB_ALL

  4. USER_TAB_COMMENTS


Correct Option: D
  1. When trying to enter NULL value for P_Id then 100 will be placed there.

  2. P_Id value starts from 1 and then it is auto incremented by value 1 upto 100.

  3. Generates error as there is no constraint like "AUTO_GENERATE".

  4. P_Id value starts from 100 and then it is auto incremented by value 1.


Correct Option: D
  1. Returns current system date and time.

  2. Returns only current time

  3. Returns only current date.

  4. There is no function like now();


Correct Option: A

select round(1601.916718 -3) from dual.

  1. 1601.916

  2. 2000

  3. 1598

  4. 1598.916


Correct Option: B
  1. NULLORNULL

  2. GEGE

  3. OR

  4. 2


Correct Option: C

What are the Sql Cursor Attributes in Pl/sql?

  1. SQL%ROWCOUNT, SQL%ISFOUND,SQL%NOTFOUND,SQL%ISOPEN

  2. SQL%ROWCOUNT, SQL%FOUND,SQL%NOTFOUND,SQL%OPEN

  3. SQL%ROWCOUNT, SQL%FOUND,SQL%NOTFOUND,SQL%ISOPEN

  4. All of the above


Correct Option: C

Which statement removes the function?

  1. DROP gen_email_name;

  2. REMOVE gen_email_name;

  3. DELETE gen_email_name;

  4. DROP FUNCTION gen_eamil_name;


Correct Option: D

What is true about stored procedures?

  1. A stored procedure uses the DELCLARE keyword in the procedure specification to declare formal parameters

  2. A stored procedure is named PL/SQL block with at least one parameter declaration in the procedure specification.

  3. A stored procedure must have at least one executable statement in the procedure body.

  4. A stored procedure uses the DECLARE keyword in the procedure body to declare formal parameters.


Correct Option: C

How many types of database triggers can be specified on a table ?

  1. 14

  2. 10

  3. 12

  4. None of the above


Correct Option: C
  1. Row level DML trigger

  2. Row level system trigger

  3. Statement level DML trigger

  4. Row level application trigger


Correct Option: A
- Hide questions