A.Displays only the list of default values
B.Displays only the list of all basic parameters
C.Displays the currently in effect parameter values
D.Displays only the list of all advanced parameters
E.Displays the list of all the parameter files of a database
F.Displays the current contents of the server parameter file.
您可能感兴趣的试卷
你可能感兴趣的试题
A.Host naming
B.Local naming
C.Easy Connect
D.External naming
E.directory naming
You work as a database administrator for Certkiller .com. Your database is opened in NOARCHIVEKLOG mode. You decide to place the database in ARCHIVELOG mode.
How would you do this?()
A.Execute the ALTER DATABASE ARCHIVELOG statement
B.Select ARCHIVELOG option in the database control and restart the database to apply the changes.
C.Shut down and start the instance, and in the NOMOUNT state execute the ALTER DATABASE ARCHIVELOG statement.
D.Shut down and start the instance, mount the database, then execute the ALTER DATABASE ARCHIVELOG statement.
You work as a database administrator for Certkiller .com. Your database is in NOARCHIVELOG mode. The database has been configured with three redo logs groups, and there have been five log switches. You lost one non-system-critical data file from your database.
Which method would you use to recover the data file?()
A.Restore all the data files and open the database
B.Create the data file and performtablespacerecovery
C.No need to restore any file, just recover the database
D.Restore only the system data file and recover the database
E.Restore only lost date file and performtablespacerecovery
A.Event Viewer gives more details on the failure.
B.The alert log file gives detailed information about the failure.
C.PMON rolls back the transaction and releases the locks.
D.SMON rolls back the transaction and releases the locks.
E.The transaction is rolled back by the next session that refers to any of the blocks updates by the failed transaction.
F.Data modified by the transaction up to the last commit before the abnormal termination is retained in the database.
A.The database is in mount state.
B.One of the tablespaces is offline.
C.One of the tablespaces is read only.
D.The database operates in ARCHIEVELOG mode.
E.The database operates in NOARCHIEVELOG mode.
You work as a database administrator for Certkiller .com. Users in the Certkiller PROD database complain about the slow response when accessing the database. In the Active Session Waiting: Configuration page you find that the majority of the wait time is for the redo log buffer.Further investigation using the Run Queue graph and operating system tools reveals that the redo log files are on the same disks, and that the disk I/O for the redo log files is the reason for the performance degradation.
Which two actions would you take to gain performance?()
A.Increase the size of redo log files
B.Increase the size of redo log buffer
C.Increase the number of redo log files
D.Place the redo log files on a separate disk
E.Decrease the number of redo log groups to two
F.Increate the number Log Writer (LGWR) process
You work as a database administrator for Certkiller .com. Redo log files are not multiplexed in your database. Redo log blocks are corrupted in group 2, and archiving has stopped. All the redo logs are filled and database activity is halted. Database writer has written everything to disk.
Which command would you execute to proceed further?()
A.RECOVER LOFIEL BLOCK GROUP 2;
B.ALTER DATABASE DROP LOGFILE GROUP 2;
C.ALTER DATABASE CLEAR LOGFILE GROUP 2;
D.ALTER DATABASE RECOVER LOGFILE GROUP 2;
E.ALTER DATABASE CLEAR UNARCHIVED LOGFILE GROUP 2;
A.It degrades the run time and compiler performance.
B.It provides better run time and compiler performance.
C.It provides better optimization of the statement during parse time.
D.It forces the rule based optimizer to be used for statement optimization.
E.It provides better run time performance but slightly degraded compiler performance.
F.It provides better run time performance but slightly degraded run time performance.
You work as a database administrator for Certkiller .com. You find that reports are running for a long time in your data warehousing applications. You suspect a lack of indexes is the reason for the performance degradation.
Which advisory component would you refer to, in order to determine the appropriate indexes?()
A.Memory Advisors
B.Segment Advisors
C.SQL Tuning and Access Advisors
D.Automated Workload Repository (AWR)
E.Automatic Database Diagnostic Monitor (ADDM)
Two database users, Jack and Bill, are accessing the Certkiller STAFF table of the Certkiller DB database. When Jack modifies a value in the table, the new value is invisible to Bill.
Which is the modified value invisible to Bill?()
A.The modified data are not available on disk.
B.The modified data have been flushed out from memory.
C.The modified rows of the Certkiller STAFF table have been locked.
D.Jack has not committed the changes after modifying the value.
E.Both users are accessing the database from two different machines.
最新试题
One of the users in the PROD database, Adams, complains that his update on the table, TRANS, is taking an unusually long time to complete. You find that the table gets locked by another database user before Adams starts his transactions, and you are unable to contact the user holding the table lock. As Adams is updating some crucial rows in the table, he should get the highest priority. Which method would you use to overcome this problem?()
In your database, the STATISTICS_LEVEL initialization parameter is set to BASIC. What is the impact of this setting?()
You have been recently hired as a database administrator. Your senior manager asks you to study the production database server and submit a report on the settings done by the previous DBA. While observing the server settings, you find that the following parameter has been set in the parameter file of the database: REMOTE_OS_AUTHENT = TRUE What could have been the reason to set this parameter as TRUE?()
Which three statements are true regarding the logical structure of the Oracle database?()
In your Oracle 10g database , you have scheduled a job to update the optimizer statistics at 05:00 pm every Friday. The job has successfully completed. Which three pieces of information would you check to confirm that the statistics have been collected?()
You want to monitor and control the resource usage by sessions. You want to be warned automatically when more than 100 sessions are opened with your database. What action would you take to achieve this?()
Which two are valid locking levels that are used by transactions in an Oracle database?()
The application workload on your database is same between 10 a.m. and 11 a.m. on weekdays. Suddenly you observe poor performance between 10 a.m. and 11 a.m. in the middle of the week. How would you identify the changes in configuration settings, workload profile,and statistics to diagnose the possible causes of the performance degradation?()
A constraint in a table is defined with the INITIALLY IMMEDIATE clause. You executed the ALTER TABLE command with the ENABLE VALIDATE option to enable the constraint that was disabled. What are the two effects of this command?()
According to your backup strategy, you performed an incremental level 0 backup of your database. Which statement regarding this backup is true?()