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

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

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

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

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

  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
  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
  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
  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

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

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
Explanation:

To answer this question, the user needs to have a basic understanding of SQL triggers and the difference between row level and statement level triggers.

The OLD and NEW qualifiers are used in row level DML triggers. These qualifiers refer to the old and new values of the row being modified by the DML statement.

A row level trigger is executed once for every row affected by the triggering DML statement. This means that if a DML statement modifies multiple rows, the row level trigger will be executed multiple times, once for each affected row.

Option A is correct because row level DML triggers are the only type of trigger that can use the OLD and NEW qualifiers to reference the old and new values of the row being modified.

Option B is incorrect because row level system triggers do not use the OLD and NEW qualifiers. System triggers are used to perform administrative tasks related to the database system, such as logging database activity.

Option C is incorrect because statement level DML triggers do not use the OLD and NEW qualifiers. Statement level triggers are executed once for each triggering DML statement, rather than once for each affected row.

Option D is incorrect because row level application triggers do not exist.

Therefore, the answer is: A. Row level DML trigger.

- Hide questions