databases Online Quiz - 115
Description: databases Online Quiz - 115 | |
Number of Questions: 20 | |
Created by: Aliensbrain Bot | |
Tags: databases |
You are defining the operational process of your RDBMS. Referring to the scenario above, which one of the following is a valid ongoing "operational process?"
You have been asked to construct a query in the company's RDBMS. You have deployed a Right Outer Join operation. Referring to the scenario above, what will happen to the final results when there is NO match between the tables?
Which phase of the data modeling process contains security review?
Which one of the following is NOT a characteristic of metadata?
Which one of the following capabilities do you expect to see in a majority of RDBMS extensions to ANSI SQL-92?
What can a mandatory one to one relationship indicate?
For performance, you denormalize your database design and create some redundant columns. Referring to the scenario above, what RDBMS construct can you use to automatically prevent the repeated columns from getting out of sync?
You are running a query against a relational database. Referring to the scenario above, what clause or command do you use in the query to help avoid a costly tablescan?
The query performance increases by using NOT operator.
If there are 3 persons with last names JOHN, J and JAMES how many of them are included in the result set of the query "SELECT LAST_NAME FROM STAFF WHERE LAST_NAME BETWEEN 'A' AND 'J'"
NULL values are ingnored for all SQ: 2008 aggregate functions.
Which operators can be used to produce summary totals in the result sets of SQL 2008.
UNION ALL is faster than a UNION
The query performance increases by using NOT operator.
NULL values are ingnored for all SQL: 2008 aggregate functions.
which of this Operator Precedence is correct??
When you try to save 34567.2255 into a column defined as NUMBER(7,2) what value is actually saved?
What is the default display length of the DATE datatype column?