databases Online Quiz - 204
Description: databases Online Quiz - 204 | |
Number of Questions: 20 | |
Created by: Aliensbrain Bot | |
Tags: databases |
When WORKAREA_SIZE_POLICY is set to AUTO, the work areas are sized to accomplish which two goals? (Choose two)
In what way are the two initialization parameters PGA_AGGREGATE_TARGET and WORKAREA_SIZE_POLICY related to each other?
Which one the following occurs when the extract phase of the ETL is going on
Which one of the primary keys are most commonly used for a fact table
Which one of the query languages are specialized for Data mining models
Expand MOLAP
If you are using a validation which looks for similar matches in data when cleansing data. Which one the following types of validation works
which is Implicit data type Conversion?
Which is NOT Date function?
Which is NOT TCL Statements ?
Which is Single Row Function?
Normalization: which is automatic NORMAL form? (NF=normal form)
- What is VOB
Choose All Approriate About Clear Case
Using Clear Case what are all can be created
After an element is added to a directory "Add to Source Control" need to done to give control to the clearcase over that element
You are developing SQL statements for the application. Which of the following SQL operations requires the use of a subquery?
Which is the most commonly used type of table?
You are developing some code to handle transaction processing. Which signifies the beginning of a new transaction ?
An object in Oracle contains many columns, The object requires segments to be stored in areas of the database other than the data dictionary ?