databases Online Quiz - 132 Online Test

Back

databases Online Quiz - 132

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

Start the Quiz

Which company coined the word Data Warehouse Appliance?

technology databases

Teradata
DATAllegro
Netezza
Greenplum

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

technology databases

Petadata
Exadata
Megadb
OracleMPP

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

technology databases

Teradata
Netezza
DATAllegro
Sybase IQ

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

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

technology databases

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

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

technology databases

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

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

technology databases

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

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

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

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.

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();

select round(1601.916718 -3) from dual.

technology databases

1601.916
2000
1598
1598.916

REPLACE('GEORGE' 'GE' NULL);

technology databases

NULLORNULL
GEGE
OR
2

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

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

technology databases

2
3
4
None of the above

Which statement removes the function?

technology databases

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

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

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.

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

technology databases

14
10
12
None of the above

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

- Hide questions

databases Online Quiz - 132

Find more quizzes from top tags