Question 1

When WORKAREA_SIZE_POLICY is set to AUTO, the work areas are sized to accomplish which two goals? (Choose two)

technology databases

To tune memory using the existing *_AREA_SIZE parameters.
To allocate memory to work areas in order to optimize throughput only.
To allocate memory to work areas in order to optimize response time only.
To allocate memory to work areas in order to optimize both throughput and response time.
To ensure that the overall size of the PGA will never exceed the value of PGA_AGGREGATE_TARGET.

Answer

Correct Option: D,E

Question 2

In what way are the two initialization parameters PGA_AGGREGATE_TARGET and WORKAREA_SIZE_POLICY related to each other?

technology databases

The default value for PGA_AGGREGATE_TARGET depends on the setting of WORKAREA_SIZE_POLICY.
You must provide a non-default value for PGA_AGGREGATE_TARGET before setting
The value of PGA_AGGREGATE_TARGET can only be changed dynamically (that is, when the instance is
You must not provide a non-default value for PGA_AGGREGATE_TARGET before setting

Answer

Correct Option: B

Question 3

Which one the following occurs when the extract phase of the ETL is going on

technology databases

Data is collected from multiple data sources
Data is loaded into data warehouse
Meta data is built
None of the above

Answer

Correct Option: A

Question 4

Which one of the primary keys are most commonly used for a fact table

technology databases

Single Field
Composite
Index Based
Finite State

Answer

Correct Option: B

Question 5

Which one of the query languages are specialized for Data mining models

technology databases

Structured Query Language
XQuery
Data Mining Extensions
Multi dimensional Expressions

Answer

Correct Option: C

Question 6

Expand MOLAP

technology databases

Multiple Dimensions Online Analytical Processing
Multiple Dimensions Online Analysis Processing
Multidimensional Online Analysis Processing
Multidimensional Online Analytical Processing

Answer

Correct Option: D

Question 7

If you are using a validation which looks for similar matches in data when cleansing data. Which one the following types of validation works

technology databases

Balloon
Fuzzy
Strict
Cloud

Answer

Correct Option: B

Question 8

which is Implicit data type Conversion?

technology databases

Char >> number
Char >> date
Number >> varchar2
Date >> varchar2

Answer

Correct Option: A,B,C,D

Question 9

Which is NOT Date function?

technology databases

ADD_MONTHS
NEXT_DAY
LAST_DAY
NEXT_MONTHS

Answer

Correct Option: B

Question 10

Which is NOT TCL Statements ?

technology databases

SAVEPOINT
GRANT
ROLLBACK
COMMIT

Answer

Correct Option: B

Question 11

Which is Single Row Function?

technology databases

CONCAT
MOD
ROUND
CONVERSION FUNCTION

Answer

Correct Option: A,B,C,D

Question 12

Normalization: which is automatic NORMAL form? (NF=normal form)

technology databases

1NF
2NF
3NF
4NF

Answer

Correct Option: A

Question 13

What is VOB

technology databases

Versioned Object
Versioned Object Base
Version Objects
Versioned Objects

Answer

Correct Option: A,B,C,D

Question 14

Choose All Approriate About Clear Case

technology databases

provides parallel development
provides versioning
provides automation
All the above

Answer

Correct Option: A,B,C,D

Question 15

Using Clear Case what are all can be created

technology databases

Branches
Labels
Both 1 and 2
All the above

Answer

Correct Option: A,B,C,D

Question 16

After an element is added to a directory "Add to Source Control" need to done to give control to the clearcase over that element

technology databases

True
False

Answer

Correct Option: A

Question 17

You are developing SQL statements for the application. Which of the following SQL operations requires the use of a subquery?

technology databases

IN
Between
Exists
Like

Answer

Correct Option: C

Question 18

Which is the most commonly used type of table?

technology databases

Clustered
Partitioned
Regular
Index organized

Answer

Correct Option: C

Question 19

You are developing some code to handle transaction processing. Which signifies the beginning of a new transaction ?

technology databases

set transaction
Opening a new session
commit
savepoint

Answer

Correct Option: A,B,C

Question 20

An object in Oracle contains many columns, The object requires segments to be stored in areas of the database other than the data dictionary ?

technology databases

Sequence
View
Synonym
Table

Answer

Correct Option: D

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

databases Online Quiz - 204

Find more quizzes from top tags