• databases Online Quiz - 150
Back
0

databases Online Quiz - 150

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

ETL stands for

technology databases

  1. Export Transform Load

  2. Extract Track Load

  3. Extract Tool Load

  4. Extract Transform Load

Show answer
Correct Option: D

Variables can only be defined at scope of entire package.

technology databases

  1. True

  2. False

Show answer
Correct Option: B

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

technology databases

  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

Show answer
Correct Option: B

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

technology databases

  1. Logical

  2. Extended Logical

  3. Physical

  4. Extended Physical

Show answer
Correct Option: C

Number of NULLs is considered a data demographic

technology databases

  1. True

  2. False

Show answer
Correct Option: A

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

technology databases

  1. Maximum Number of NULLs

  2. Access Frequency

  3. Change Rating

  4. Typical Rows Per Value

Show answer
Correct Option: B,C

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

  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.

Show answer
Correct Option: A,D

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

technology databases

  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.

Show answer
Correct Option: B,C,D

What are some benefits of using a USI?

technology databases

  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.

Show answer
Correct Option: A,B,E

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

technology databases

  1. True

  2. False

Show answer
Correct Option: B

What is one significant aspect about a Cover Query?

technology databases

  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.

Show answer
Correct Option: B

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

technology databases

  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.

Show answer
Correct Option: A,C

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

technology databases

  1. Downtime

  2. Stability

  3. Performance

  4. Volatility

Show answer
Correct Option: C,D

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

technology databases

  1. True

  2. False

Show answer
Correct Option: B

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

technology databases

  1. BETWEEN

  2. IN

  3. HAVING

  4. ALIAS

Show answer
Correct Option: B

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

technology databases

  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

Show answer
Correct Option: A,B,C

Which of the following are Scalar functions?

technology databases

  1. MAX( )

  2. MID( )

  3. SUM( )

  4. NOW( )

Show answer
Correct Option: B,D

WHERE keyword could not be used with aggregate functions.

technology databases

  1. True

  2. False

Show answer
Correct Option: A

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

technology databases

  1. True

  2. False

Show answer
Correct Option: A

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

technology databases

  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

Show answer
Correct Option: A,C,D
- Hide questions
ADVERTISEMENT

Find more quizzes from top tags

general knowledge
3615 Quizzes
119858 Questions
 technology
307 Quizzes
36705 Questions
 sports
963 Quizzes
19148 Questions
 history
1187 Quizzes
13475 Questions
 physics
598 Quizzes
13441 Questions
 biology
1160 Quizzes
12174 Questions
 science & technology
551 Quizzes
11015 Questions
 chemistry
490 Quizzes
9892 Questions
 maths
518 Quizzes
9324 Questions
 softskills
0 Quizzes
7131 Questions