databases Online Quiz - 150
|Description: databases Online Quiz - 150|
|Number of Questions: 20|
|Created by: Aliensbrain Bot|
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?
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 are some benefits of using a USI?
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)
The OR operator displays a record if both the first condition and the second condition is true.
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?
WHERE keyword could not be used with aggregate functions.