databases Online Quiz - 150
|Description: databases Online Quiz - 150|
|Number of Questions: 20|
|Created by: Aliensbrain Bot|
ETL stands for
Variables can only be defined at scope of entire package.
How is a parent package variable value passed to child package?
Partition Primary Index would be defined in which stage of modeling?
Number of NULLs is considered a data demographic
Which two data demographics should you consider when deciding whether or not to store or calculate derived data? (Select 2)
Pick the two statements that are true regarding Identity Columns. (Select 2)
What is contained in a USI subtable? (Select 3)
What is one significant aspect about a Cover Query?
Select two true statements about Join Indexes. (Select 2)
When denormalizing a table, what are some things to consider? (Select 2)
Which operator allows you to specify multiple values in a WHERE clause?
The UNION operator is used to combine the result-set of two or more SELECT statements when
Which of the following are Scalar functions?
Running an IMS program in DBB is faster than running it in DLI.
Which of the following are true regarding SSA's and IMS database calls?