snmp.ora
names.ora
spfile.ora
sqlnet.ora
listener.ora
tnsnames.ora
第1题:
You work as a database administrator for Supportcenter.cn. When you tried to connect to the database, you received the following error: ERROR: ORA-12541:TNS:no_listener You found that the listener is not running on the server, so you issued the following command in the Listener Control utility to start the listener. lsnrctl>START What statement is true?()
第2题:
You work as a database administrator for Certkiller .com. Your database is in the MOUNT state and you execute the following command to open it ALTER DATABASE OPEN; What two actions are performed as a result of this command?()
第3题:
You work as a database administrator for Certkiller .com. When you tried to connect to the database, you received the following error: ERROR: ORA-12541:TNS:no_listener You found that the listener is not running on the server, so you issued the following command in the Listener Control utility to start the listener. lsnrctl>START What statement is true?()
第4题:
You work as a database administrator for Certkiller .com. Because of space constraints, you decided to manually shrink the table. You executed the ALTER TABLE ....SHRINK SPACE statement to shrink the space and you receive an error as follows: ERROR at Line 1: ORA-10635: Invalid segment ortablespacetype What could be the reason?()
第5题:
You work as a database administrator for Certkiller .com. You decided to manage client and server connections using Local Naming method in Certkiller .com. When you try to connect to the database you get the following error: ERROR: ORA-12154:TNS:couldnot resolve service name Which network configuration files would you look into to resolve this error?()
第6题:
You work as a database administrator for Certkiller .com. You find that the database performance degrades while you backup the Certkiller database using Recovery Manager (RMAN). The Certkiller database is running in shared server mode. The database instance is currently using 60% of total operating system memory. You suspect the shared pool fragmentation to be the reason. Which action would you consider to overcome the performance degradation?()
第7题:
snmp.ora
names.ora
spfile.ora
sqlnet.ora
listener.ora
tnsnames.ora
第8题:
Use a flashback query to retrieve the rows that were deleted
Useconventialincremental export and then import the affected object
Shutdown the database inNORMALmode and restart the database instance
Use DBMS_META package to reconstruct the object using undo segments
UseTablespacePoint in Time Recovery (TSPITR) method to recover the table and the data
Use Oracle DataPumptwithflashback_timeoption toentableflashback export and then import the affected object.
第9题:
snmp.ora
names.ora
spfile.ora
sqlnet.ora
listener.ora
tnsnames.ora
第10题:
You performed rollback after commit.
If a log switch occurs in your database.
Thearchiverfails to generate an archived log file.
Instance recovery fails to find one of the redo log files.
A long-running query is unable to get read-consistent image.
If you perform manual undo management operations in auto mode.
第11题:
Enable instance failover
Configure shared server
Enable database failover
Enable connect-time failover
Enable Transparent Application Failover (TAF)
第12题:
It would attempt to start the default listener
It would start the most recently created listener.
It would display an error with a message asking for the listener name to be specified.
It would show you a list of listeners and prompts for the listener name that you want to start.
第13题:
You work as a database administrator for Certkiller .com. Your database is in NOARCHIVELOG mode and you want to perform a backup. Which type of backup would be appropriate in this case? ()
第14题:
You work as a database administrator for Certkiller .com. While loading data into the Certkiller STAFF table using Oracle Enterprise Manager 10g Database Control, you find the status of the job as failed. On further investigation, you find the following error message in the output log: ORA-01653 unable to extend table HR. Certkiller STAFF by 8 intablespaceUSERS Which task would you perform to load the data successfully without affecting the users who are accessing the table?()
第15题:
You work as a database administrator for Supportcenter.cn. You decided to manage client and server connections using Local Naming method in Supportcenter.cn. When you try to connect to the database you get the following error: ERROR: ORA-12154:TNS:couldnot resolve service name Which network configuration files would you look into to resolve this error?()
第16题:
You are connecting to an Oracle database server from a client by using the following connect string: SQL> CONNECT hr/hr@pdserver.us.oracle.com:1521/proddb Which naming method is being used in this case?()
第17题:
You work as a database administrator for Certkiller .com. You have been asked to use a centralized administrative tool to administer your database servers and application servers. In order to achieve the objective, which component would you configure on each database server?()
第18题:
Hot backup
Online backup
consistent backup
incremental backup
inconsistent backup
第19题:
The table is partitioned
The table name is wrong.
It is an index-Organized table (IOT)
The table is stored in locally managedtablespace.
The table is stored in atablespacewhere segment space is managed manually.
第20题:
Database Control
Management Server
Management Repository
Application Server Control
Oracle Management Agent
第21题:
It would attempt to start the default listener
It would start the most recently created listener.
It would display an error with a message asking for the listener name to be specified.
It would show you a list of listeners and prompts for the listener name that you want to start.
第22题:
Host naming
Local naming
Easy Connect
External naming
directory naming
第23题:
Application Server Control
Oracle Management Service
Oracle Enterprise Manager Repository
Oracle Enterprise Manager Database Control
第24题:
All control files are opened
All redo files are opened
The password file is opened
The parameter file is opened
All online data files are opened