0

databases Online Quiz - 150

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

ETL stands for

  1. Export Transform Load

  2. Extract Track Load

  3. Extract Tool Load

  4. Extract Transform Load


Correct Option: D

Variables can only be defined at scope of entire package.

  1. True

  2. False


Correct Option: B

How is a parent package variable value passed to child package?

  1. by global variables

  2. by setting package configurations in child package

  3. by setting package configurations in parent package

  4. by Execute Package task


Correct Option: B

Partition Primary Index would be defined in which stage of modeling?

  1. Logical

  2. Extended Logical

  3. Physical

  4. Extended Physical


Correct Option: C

Number of NULLs is considered a data demographic

  1. True

  2. False


Correct Option: A

Which two data demographics should you consider when deciding whether or not to store or calculate derived data? (Select 2)

  1. Maximum Number of NULLs

  2. Access Frequency

  3. Change Rating

  4. Typical Rows Per Value


Correct Option: B,C
  1. They don't have to be a Primary Index column

  2. They are not allowed to be a Primary Index column.

  3. They are required to be a Non-Unique Primary Index

  4. You can only specify one Identity Column per table.


Correct Option: A,D

What is contained in a USI subtable? (Select 3)

  1. The buckets containing the AMP numbers where the data is stored.

  2. The USI column value

  3. The Row ID of the base row.

  4. The Secondary Index Row ID.

  5. The Integer Type of all Value-Ordered NUSIs.


Correct Option: B,C,D

What are some benefits of using a USI?

  1. They eliminate Full Table Scans.

  2. Duplicate row checks are avoided.

  3. There is no overhead involved.

  4. They are best used for range queries.

  5. You cannot insert rows with a duplicate USI value.


Correct Option: A,B,E

Data type assignments should be made at the row level to avoid data conversion.

  1. True

  2. False


Correct Option: B

What is one significant aspect about a Cover Query?

  1. All columns required by the query are available via the Primary index.

  2. All columns required by the query are available via a Join Index.

  3. All columns required by the query are available via the Hash Index

  4. The PE covers the query by looking into cache to see if the same query has been run in the last 240 minutes. If it has been cached the PE doesn't have to generate steps for the AMPs.


Correct Option: B

Select two true statements about Join Indexes. (Select 2)

  1. Join Indexes have repeating values.

  2. Join Indexes do not have repeating values.

  3. Join Indexes are updated automatically when their underlying rows change

  4. Join Indexes are not updated automatically when their underlying rows change.


Correct Option: A,C

When denormalizing a table, what are some things to consider? (Select 2)

  1. Downtime

  2. Stability

  3. Performance

  4. Volatility


Correct Option: C,D

The OR operator displays a record if both the first condition and the second condition is true.

  1. True

  2. False


Correct Option: B

Which operator allows you to specify multiple values in a WHERE clause?

  1. BETWEEN

  2. IN

  3. HAVING

  4. ALIAS


Correct Option: B

The UNION operator is used to combine the result-set of two or more SELECT statements when

  1. each SELECT statement within the UNION has the same number of columns

  2. The columns have similar data types

  3. the columns in each SELECT statement are in same order.

  4. None


Correct Option: A,B,C

Which of the following are Scalar functions?

  1. MAX( )

  2. MID( )

  3. SUM( )

  4. NOW( )


Correct Option: B,D

WHERE keyword could not be used with aggregate functions.

  1. True

  2. False


Correct Option: A

Running an IMS program in DBB is faster than running it in DLI.

  1. True

  2. False


Correct Option: A

Which of the following are true regarding SSA's and IMS database calls?

  1. INIT call gets the database availability status

  2. It is not advisable to use GOBACK for ending an IMS COBOL program

  3. If the SSA contains only the segment name, byte 9 must contain a blank

  4. Basic checkpoint calls do not support GSAM files


Correct Option: A,C,D
- Hide questions