Question 1

What is syntax to unlock the table statastics?

technology databases

exec DBMS_STATS.UNLOCK_SCHEMA_STATS('TABLE_NAME','OWNER');
exec DBMS_STATS.UNLOCK_SCHEMA_STATS('OWNER','TABLE_NAME');
exec DBMS_STATS.UNLOCK_DB_STATS('DB_NAME','OWNER','TABLE_NAME');
exec DBMS_STATS.UNLOCK_TABLE_STATS('TABLE_NAME','OWNER');
exec DBMS_STATS.UNLOCK_TABLE_STATS('OWNER','TABLE_NAME');

Answer

Correct Option: E

Question 2

A Tablespace can hold objects from different Schemes.

technology databases

True
False

Answer

Correct Option: A

Question 3

You can use ____________ in a SQL expression to override operator precedence

technology databases

colons
parentheses
commas
semi-colons

Answer

Correct Option: B

Question 4

A Tablespace can have multiple datafiles.

technology databases

True
False

Answer

Correct Option: A

Question 5

A Datafile can be part of multiple tablespaces.

technology databases

True
False

Answer

Correct Option: B

Question 6

Which of the following can be partitioned (choose all that apply):

technology databases

Indexes
Hints
Tables
Bitmaps

Answer

Correct Option: A,C

Question 7

What type of joins extends the result of a simple join

technology databases

left join
right join
outer join
equil join
simple join

Answer

Correct Option: C

Question 8

To write a query that performs an outer join of tables A and B and returns all rows from B, you need a:

technology databases

left outer join
inner join
equil join
right outer join

Answer

Correct Option: D

Question 9

You may use the CREATE INDEX statement to create an index on (choose all that apply):

technology databases

This is hard to determine
One or more scalar typed object attributes of a cluster
One or more columns of a table
A nested table storage table

Answer

Correct Option: B,C,D

Question 10

An inner join is always a:

technology databases

outer join
equil join
simple join
right join
left join

Answer

Correct Option: C

Question 11

When will a Cartesian product be returned

technology databases

when two tables in a join query have only a single join condition
when two tables in a join query have too many join conditions
This is hard to determine.
when two tables in a join query have no join condition

Answer

Correct Option: D

Question 12

The UNION ALL operator does not eliminate duplicate selected rows from the result set

technology databases

True
False

Answer

Correct Option: A

Question 13

The ALTER SEQUENCE statement can affect only the future sequence numbers

technology databases

True
False

Answer

Correct Option: A

Question 14

If you use the CREATE DATABASE statement on an existing database, all data in the datafiles will be lost

technology databases

True
False

Answer

Correct Option: A

Question 15

which datatype store pointer to binary file on disk

technology databases

BLOB
CLOB
BFILE
NCLOB

Answer

Correct Option: C

Question 16

For Which datatype Maximum size is 4GB

technology databases

CLOB
BLOB
NCLOB
ALL

Answer

Correct Option: D

Question 17

A) Long raw - Variable length binary strings B) LONG - Character data of variable length

technology databases

A is correct
B is correct
A & B Both correct
A & B both Incorrect

Answer

Correct Option: C

Question 18

32-bit floating point number datatype is?

technology databases

BINARY_FLOAT
BINARY_DOUBLE
ROWID
NCHAR

Answer

Correct Option: A

Question 19

Which datatype can store large and unstructured data such as text, image, video?

technology databases

BLOB
CLOB
NCLOB
BFILE
ALL

Answer

Correct Option: E

Question 20

Find the odd one out?

technology databases

MicroStrategies
Actuate
Siebel Analytics
Cognos DecisionStream

Answer

Correct Option: D

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

databases Online Quiz - 206

Find more quizzes from top tags