|
Question |
Rating |
View Answer |
|
How many control files are required to create a database? |
|
View Answer |
|
Which environment variable or registry entry variable is used to represent the instance name? |
|
View Answer |
|
. What is the recommended configuration for control files? |
|
View Answer |
|
You have specified the LOGFILE clause in the CREATE DATABASE command as follows. What happens if the size of the log file redo0101.log, which already exists, is 10MB? |
|
View Answer |
|
Which command should be issued before you can execute the CREATE DATABASE command? |
|
View Answer |
|
Which initialization parameter cannot be changed after creating the database? |
|
View Answer |
|
What does OFA stand for? |
|
View Answer |
|
When creating a database, where does Oracle find information about the control files that need to be created?
|
|
View Answer |
|
Which script creates the data dictionary views? |
|
View Answer |
|
Which prefix for the data dictionary views indicate that the contents of the view belong to the current user? |
|
View Answer |
|
Which data dictionary view shows information about the status of a procedure? |
|
View Answer |
|
How do you correct a procedure that has become invalid when one of the tables it is referring to was altered to drop a constraint? |
|
View Answer |
|
Which event trigger from the following cannot be created at the database level? |
|
View Answer |
|
How many data files can be specified in the DATAFILE clause when creating a database? |
|
View Answer |
|
Who owns the data dictionary? |
|
View Answer |
|
What is the default password for the SYS user? |
|
View Answer |
|
Which data dictionary view provides information on the version of the database and installed components? |
|
View Answer |
|
What is the prefix for dynamic performance views? |
|
View Answer |
|
Which clauses in the CREATE DATABASE command specify limits for the database? |
|
View Answer |
|
Which clauses in the CREATE DATABASE command specify limits for the database? |
|
View Answer |