Question 1

Which company coined the word Data Warehouse Appliance?

technology databases

Teradata
DATAllegro
Netezza
Greenplum

Answer

Correct Option: C

Question 2

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

technology databases

Petadata
Exadata
Megadb
OracleMPP

Answer

Correct Option: B

Question 3

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

technology databases

Teradata
Netezza
DATAllegro
Sybase IQ

Answer

Correct Option: A,B,C

Question 4

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

technology databases

30-MAR-00
31-MAR-00
15-MAR-00
THERE IS NO FUNCTION LIKE LAST_DAY

Answer

Correct Option: B

Question 5

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

technology databases

ganesh
gANESH
Ganesh
THERE IS NO FUNCTION LIKE initsmall();

Answer

Correct Option: D

Question 6

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

technology databases

GADDE
Gadde
gADDE
THERE IS NO FUNCTION LIKE initcap();

Answer

Correct Option: B

Question 7

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

technology databases

GADDE
Gadde
gADDE
THERE IS NO FUNCTION LIKE initcap();

Answer

Correct Option: B

Question 8

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

technology databases

Error generates
Temporary table is created with name "employee" and it get removed at the end of transaction.
similar to normally creating table.
created in database permenantly

Answer

Correct Option: B

Question 9

This is the name of the database object containing information about all comments on table....

technology databases

USER_COMMENTS
USER_ALL_COMMENTS
USER_TAB_ALL
USER_TAB_COMMENTS

Answer

Correct Option: D

Question 10

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

technology databases

When trying to enter NULL value for P_Id then 100 will be placed there.
P_Id value starts from 1 and then it is auto incremented by value 1 upto 100.
Generates error as there is no constraint like "AUTO_GENERATE".
P_Id value starts from 100 and then it is auto incremented by value 1.

Answer

Correct Option: D

Question 11

what is true about function now();

technology databases

Returns current system date and time.
Returns only current time
Returns only current date.
There is no function like now();

Answer

Correct Option: A

Question 12

select round(1601.916718 -3) from dual.

technology databases

1601.916
2000
1598
1598.916

Answer

Correct Option: B

Question 13

REPLACE('GEORGE' 'GE' NULL);

technology databases

NULLORNULL
GEGE
OR
2

Answer

Correct Option: C

Question 14

What are the Sql Cursor Attributes in Pl/sql?

technology databases

SQL%ROWCOUNT, SQL%ISFOUND,SQL%NOTFOUND,SQL%ISOPEN
SQL%ROWCOUNT, SQL%FOUND,SQL%NOTFOUND,SQL%OPEN
SQL%ROWCOUNT, SQL%FOUND,SQL%NOTFOUND,SQL%ISOPEN
All of the above

Answer

Correct Option: C

Question 15

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

technology databases

2
3
4
None of the above

Answer

Correct Option: B

Question 16

Which statement removes the function?

technology databases

DROP gen_email_name;
REMOVE gen_email_name;
DELETE gen_email_name;
DROP FUNCTION gen_eamil_name;

Answer

Correct Option: D

Question 17

Is it possible to use Transaction control Statements such a ROLLBACK or COMMIT in Database Trigger ?

technology databases

Yes
No
1 & 2
None of the above

Answer

Correct Option: B

Question 18

What is true about stored procedures?

technology databases

A stored procedure uses the DELCLARE keyword in the procedure specification to declare formal parameters
A stored procedure is named PL/SQL block with at least one parameter declaration in the procedure specification.
A stored procedure must have at least one executable statement in the procedure body.
A stored procedure uses the DECLARE keyword in the procedure body to declare formal parameters.

Answer

Correct Option: C

Question 19

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

technology databases

14
10
12
None of the above

Answer

Correct Option: C

Question 20

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

technology databases

Row level DML trigger
Row level system trigger
Statement level DML trigger
Row level application trigger

Answer

Correct Option: A

Description: databases Online Quiz - 132
Number of Questions: 20
Created by: Aliensbrain Bot
Tags: databases

databases Online Quiz - 132

Find more quizzes from top tags