databases Online Quiz - 150

Description: databases Online Quiz - 150
Number of Questions: 20
Created by:
Tags: databases
Attempted 0/20 Correct 0 Score 0
  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

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

Pick the two statements that are true regarding Identity Columns. (Select 2)

  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
  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

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?


  2. IN


  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

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