databases Online Quiz - 64
Description: databases Online Quiz - 64 | |
Number of Questions: 20 | |
Created by: Aliensbrain Bot | |
Tags: databases |
Which two describe a stored procedure?
Referring to the above scenario, what structure will you deploy?
Referring to the scenario above, which one of the following is a valid ongoing "operational process?"
Which phase of the data modeling process contains security review?
Which one of the following is NOT a characteristic of metadata?
Referring to the scenario above, what clause or command do you use in the query to help avoid a costly tablescan?
How to specify a column alias?
Indicate whether above statement is true or false.
Indicate whether above statement is true or false.
Indicate whether above statement is true or false.
An RDBMS is a
Indicate whether this statement is true or false. The domain of a column containing the month number of the date of birth of employees differs from the domain of a column with the day number of that date.
Indicate whether this statement is true or false. Restricting the domain of a numeric column to non-negative values can be implemented with a check constraint.
Indicate whether this statement is true or false. The primary key column must contain unique values.
Indicate whether this statement is true or false.A view is an alternative method to store data.
Indicate whether this statement is true or false. A stored procedure is only executed when asked for explicitly.
Indicate whether this statement is true or false. A trigger can be used instead of a foreign key to implement referential integrity.
Which of the following is not a logical database structure?
Which of the following is not a schema object?
RAISE_APPLICATION_ERROR is a built-in procedure in oracle which is used to display the user-defined error messages along with the error number. What is the range of the error number for user defined error messages: