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.
You work as a database administrator for Certkiller .com. As a result of performance analysis, you created an index on theprod_namecolumn of the
Certkiller prodtable, which contains about ten thousand rows. Later, you updated a product name in the table.
How does this change affect the index?()
A.A leaf will be marked as invalid.
B.An update in a leaf row takes place.
C.The index will be updated automatically at commit.
D.A leaf row in the index will be deleted and inserted.
E.The index becomes invalid when you make any updates
最新试题
Your database is running under automatic undo management and the UNDO_RETENTION parameter is set to 900 sec. You executed the following command to enable retention guarantee: SQL> ALTER TABLESPACE undotbs1 RETENTION GUARANTEE; What effect would this statement have on the database?()
Which two statements regarding the LOGGING clause of the CREATE TABLESPACE. .. statement are correct?()
User SCOTT executes the following command on the EMP table but has not issued COMMIT, ROLLBACK,or any data definition language (DDL) command: SQL> SELECT job FROM emp 2 WHERE job=’CLERK’ FOR UPDATE OF empno; SCOTT has opened another session to work with the database. Which three operations would wait when issued in SCOTT’s second session?()
Your database is open and users are connected using the LISTENER listener. The new DBA of the system stops the listener by using the following command:LSNRCTL> STOP What would happen to the sessions that are presently connected to the database instance?()
The ST_INFO master table has millions of rows that are updated very rarely. It has a STATE_CODE column that contains the value for 25 states. The table is frequently queried on the STATE_CODE column. Which type of index would you suggest to improve the query performance?()
You started a long transaction. Before committing, you executed a query on one of the tables currently being modified. You received the following error: ORA-01555: snapshot too old How would you prevent such an error in the future?()
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 three statements are true regarding the logical structure of the Oracle database?()
A user receives the following error while executing a query:ORA01555:snapshot too oldWhich two options can be the solutions to avoid such errors in future?()
You have two databases, FINDB and PAYDB, on single operating system and using Optimal Flexible architecture (OFA). FINDB is functional and is currently being accessed by the users. While starting up the instance for the PAYDB database you get the following error: ORA-01081: cannot start - already running ORACLE - shut it down first Which environmental variable would you set before starting up the PAYDB database to overcome this error?()