|
Related Questions |
View Answer |
|
Which initialization parameter cannot be changed after creating the database?
|
View Answer
|
|
Which command should be issued before you can execute the CREATE DATABASE command?
|
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
|
|
. What is the recommended configuration for control files?
|
View Answer
|
|
Which environment variable or registry entry variable is used to represent the instance name?
|
View Answer
|
|
How many control files are required to create a database?
|
View Answer
|
|
Which DB administration tools are included in the DBA Studio Pack?
|
View Answer
|
|
Which view has information about users who are ghranted SYSDBA or SYSOPER privilege?
|
View Answer
|
|
When you issue the command ALTER SYSTEM ENABLE RESTRICTED SESSION, what happens to the users who are connected to the database?
|
View Answer
|
|
Using SQL*Plus, list two options which show the value of the parameter DB_BLOCK_SIZE?
|
View Answer
|
|
How many panes are there in the Enterprise Manager console?
|
View Answer
|
|
When performing the command SHUTDOWN TRANASACTIONAL, Oracle performs the following tasks in what order?
|
View Answer
|
|
Which command will “bounce” the database-that is, shut down the database and start up the database in a single command?
|
View Answer
|
|
User SCOTT has opened a SQL * Plus session and left for lunch. When you queired the V$SESSION view, the STATUS was INACTVE. You terminated SCOTT’s session in V$SESSION?
|
View Answer
|
|
At which stage of the database start-up is the control file opened?
|
View Answer
|
|
Which priviledge do you need to connect to the database, if the database is started up by using STARTUP RESTRICT?
|
View Answer
|
|
Which parameter in the ORAPWD utility is optional?
|
View Answer
|
|
Which role is created by default to administer databases?
|
View Answer
|
|
How do you make a database read-only?
|
View Answer
|
|
Which SHUTDOWN option will wait for the users to complete their uncommitted transactions?
|
View Answer
|