0

databases Online Quiz - 206

Description: databases Online Quiz - 206
Number of Questions: 20
Created by:
Tags: databases
Attempted 0/20 Correct 0 Score 0

What is syntax to unlock the table statastics?

  1. exec DBMS_STATS.UNLOCK_SCHEMA_STATS('TABLE_NAME','OWNER');

  2. exec DBMS_STATS.UNLOCK_SCHEMA_STATS('OWNER','TABLE_NAME');

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

  4. exec DBMS_STATS.UNLOCK_TABLE_STATS('TABLE_NAME','OWNER');

  5. exec DBMS_STATS.UNLOCK_TABLE_STATS('OWNER','TABLE_NAME');


Correct Option: E

A Tablespace can hold objects from different Schemes.

  1. True

  2. False


Correct Option: A

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

  1. colons

  2. parentheses

  3. commas

  4. semi-colons


Correct Option: B

A Tablespace can have multiple datafiles.

  1. True

  2. False


Correct Option: A

A Datafile can be part of multiple tablespaces.

  1. True

  2. False


Correct Option: B

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

  1. Indexes

  2. Hints

  3. Tables

  4. Bitmaps


Correct Option: A,C

What type of joins extends the result of a simple join

  1. left join

  2. right join

  3. outer join

  4. equil join

  5. simple join


Correct Option: C

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

  1. left outer join

  2. inner join

  3. equil join

  4. right outer join


Correct Option: D

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

  1. This is hard to determine

  2. One or more scalar typed object attributes of a cluster

  3. One or more columns of a table

  4. A nested table storage table


Correct Option: B,C,D
  1. outer join

  2. equil join

  3. simple join

  4. right join

  5. left join


Correct Option: C

When will a Cartesian product be returned

  1. when two tables in a join query have only a single join condition

  2. when two tables in a join query have too many join conditions

  3. This is hard to determine.

  4. when two tables in a join query have no join condition


Correct Option: D

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

  1. True

  2. False


Correct Option: A

The ALTER SEQUENCE statement can affect only the future sequence numbers

  1. True

  2. False


Correct Option: A

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

  1. True

  2. False


Correct Option: A

which datatype store pointer to binary file on disk

  1. BLOB

  2. CLOB

  3. BFILE

  4. NCLOB


Correct Option: C

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

  1. A is correct

  2. B is correct

  3. A & B Both correct

  4. A & B both Incorrect


Correct Option: C

32-bit floating point number datatype is?

  1. BINARY_FLOAT

  2. BINARY_DOUBLE

  3. ROWID

  4. NCHAR


Correct Option: A

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

  1. BLOB

  2. CLOB

  3. NCLOB

  4. BFILE

  5. ALL


Correct Option: E

Find the odd one out?

  1. MicroStrategies

  2. Actuate

  3. Siebel Analytics

  4. Cognos DecisionStream


Correct Option: D
- Hide questions