Question 1

Can we use a subquery in insert statement

technology databases

True
False

Answer

Correct Option: A

Question 2

maximum limit of VARCHAR2 datatype in SQL & PLSQLRespectively

technology databases

4000 / 4000
4000 / 32767
2000 / 4000
None of these

Answer

Correct Option: B

Question 3

Default type of compilation in Oracle

technology databases

INTERPRETTED
NATIVE
BOTH
None of these

Answer

Correct Option: B

Question 4

A Package spec is compulsory but a package Body is not compulsory

technology databases

True
False

Answer

Correct Option: A

Question 5

For a certain row ina table, a VARCHAR2 coilumn contains the value TCSLTD, padded to the right with seven spaces by the application when the length() function processes the coplumn value , what will be the value returned

technology databases

6
13
30
60

Answer

Correct Option: B

Question 6

Dropping of table has which of the following effects on the non unique index created on the table

technology databases

no effect
The Index will be dropped
The index will become unusable
the index will have NULLvalues
You cannot drop a table until you drop the index

Answer

Correct Option: B

Question 7

Which of the following requires correlated subquery

technology databases

IN
BETWEEN
LIKE
EXISTS

Answer

Correct Option: D

Question 8

Which of the following is a valid statement for Sequences

technology databases

IDENTIFIED BY
USING TEMPORARY TABLESPACE
MAXVALUE
ON DELETE CASCADE
CURRVAL
NEXTVAL

Answer

Correct Option: C

Question 9

Can we modify Primary key constraint

technology databases

True
False

Answer

Correct Option: A

Question 10

Select the incorrect statement

technology databases

alter table table1 rename column column1 to column2
alter table table1 rename to table 2
alter table table1 add (c1 char(10))
alter table table1 enable constraint t1_pk

Answer

Correct Option: D

Question 11

We can update the value of the columns that is selected on view list

technology databases

yes always
yes on simple views with group by
no on simple views with group by and distinct clause
yesy on complex views

Answer

Correct Option: C

Question 12

The Default indexing system in oracle

technology databases

BALANCED TREE
BITMAP
FUNCTIONAL
BINARY TREE

Answer

Correct Option: A

Question 13

An Equi join can be:

technology databases

Natural join
Inner Join
Both
Cross Join

Answer

Correct Option: C

Question 14

What are the different methods of refreshing the materialized view?

technology databases

Complete
Slow
Fast
Never

Answer

Correct Option: A,C,D

Question 15

Which index will be beneficial to create on the column Gender of a table name employee which permits entry of only two values (M/F)?

technology databases

Compressed Index
Function based Index
Bitmap Index
B*-Tree index

Answer

Correct Option: C

Question 16

Which type of join is this?

technology databases

Left Outer Join
Right outer Join
Full Outer Join
Inner Join

Answer

Correct Option: A

Question 17

Which is not a valid join?

technology databases

Equi Join
Natural Join
Left Inner Join
Cartesian product

Answer

Correct Option: C

Question 18

There are 10 rows in Table A and 0 Rows in table B. If you fire the following query:

technology databases

10
0
1
Syntax Error

Answer

Correct Option: B

Question 19

What does the following query Do?

technology databases

Null
The Null values of COMMISSION column will be displayed as Null after addition to sal
The Null values of COMMISSION column will be changed to 0 & will be added to sal
Syntax error

Answer

Correct Option: C

Question 20

Examine the SQL Statements that creates ORDERS table: For which columns would an index be automatically created when you execute the above SQL statement?

technology databases

) SER_NO, PROD_ID_NUMBER
ORDER_ID and ORDER_DATE
SER_NO, Composite index on ORDER_ID and ORDER_DATE
SER_NO, ORDER_ID and ORDER_DATE

Answer

Correct Option: C

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

databases Online Quiz - 105

Find more quizzes from top tags