databases Online Quiz - 64
|Description: databases Online Quiz - 64|
|Number of Questions: 20|
|Created by: Aliensbrain Bot|
Which two describe a stored procedure?
Referring to the scenario above, what clause or command do you use in the query to help avoid a costly tablescan?
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.A view is an alternative method to store data.
Indicate whether this statement is true or false. A trigger can be used instead of a foreign key to implement referential integrity.
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: