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

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

  1. Teradata

  2. Netezza

  3. DATAllegro

  4. Sybase IQ


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

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

  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

CREATE TABLE Persons( P_Id int NOT NULL AUTO_INCREMENT=100, LastName varchar(255) NOT NULL);

  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

what is true about function now();

  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
  1. 1601.916

  2. 2000

  3. 1598

  4. 1598.916


Correct Option: B

REPLACE('GEORGE' 'GE' NULL);

  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

How Many minimum lines of code required to compile the Pl/Sql block successfully?

  1. 2

  2. 3

  3. 4

  4. None of the above


Correct Option: B
  1. DROP gen_email_name;

  2. REMOVE gen_email_name;

  3. DELETE gen_email_name;

  4. DROP FUNCTION gen_eamil_name;


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

The OLD and NEW qualifiers can be used in which type of trigger?

  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