Host naming
Local naming
Easy Connect
External naming
directory naming
第1题:
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?()
第2题:
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?()
第3题:
You work as a database administrator for Certkiller .com. In your organization, you have four databases, Certkiller DB01, Certkiller DB02, Certkiller DB03, and Certkiller DB04, which are located in Berlin, Frankfurt,Rammstein, and Munich respectively, and which were created using Database Configuration Assistant (DBCA). You want to perform administrative tasks on these databases that include startup and shutdown, taking regular backups, and so on, fromFrankfurtusing Oracle tools. Which Oracle file would you enable to perform this task?()
第4题:
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?()
第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题:
Increase the undo return
Create more undo segments
Create another undotablespace
Increase the size of the undotablespace
第8题:
Hot backup
Online backup
consistent backup
incremental backup
inconsistent backup
第9题:
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.
第10题:
Database Control
Management Server
Management Repository
Application Server Control
Oracle Management Agent
第11题:
Configure Java Pool to cache the java objects.
Configure Streams Pool to enable parallel processing.
Increase Shared Pool size to cache more PL/SQL objects.
Increase Database Buffer Cache size to increase cache hits.
Configure Large Pool to be used by RMAN and shared server.
Increase the total System Global Area (SGA) size to increase memory hits.
第12题:
Information about each Oracle Net connection.
Information about each entry in theLinstener.orafile
Information about the changed done in the database
Information about the different listeners in your system
Information about all thenondatabasefiles required to operate the database
第13题:
You work as a database administrator for Certkiller .com. You enabled tracing while creating a listener to your database. What additional information is available to you when you enable tracing?()
第14题:
You work as a database administrator for Certkiller .com. Users in the Certkiller .com PROD database complain about the slow response of transactions. While investigating the reason you find that the transactions are waiting for the undo segments to be available, and undo retention has been set to zero. What would you do to overcome this problem?()
第15题:
You work as a database administrator at Certkiller .com. In your production database, you observe that users’ transactions are consuming a lot of resource and you plan to impose resource restrictions by using Resource Manager. For which three resources can you enable usage restrictions by using Resource Manager? ()
第16题:
You work as a database administrator for Certkiller .com. Your listener process, L1,is currently listening to three databases:CertK INDB04,Certkiller DB05 and Certkiller DB06. Using Database Configuration Assistant (DBCA) you create one more database,Certkiller DB07,and enable dynamic registration. Which two commands of Listener Control Utility (lsnrct1) would you use to determine whether the dynamic registration occurred for the database, Certkiller DB07, with the L1 listener process?()
第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题:
You work as a database administrator for Supportcenter.cn. You are using three database, SupportCenter DB01, SupportCenter DB02, and SupportCenter DB03, on different host machines in your development environment. The database server configuration, such as IP address and listener port number, change frequently due to development requirements, and you have the task of notifying the developers of the changes. Which connection method would you use to overcome this overhead?()
第19题:
Host naming
Local naming
Easy Connect
External naming
directory naming
第20题:
Control file
Password file
Parameter file
Online redo log file
Listener controller file
Server parameter file
第21题:
alert_ Certkiller .log
alertlog_ Certkiller .log
alert_log_ Certkiller .log
Certkiller _alert_log.log
log_alert_: Certkiller .log
trace_alert_ Certkiller .log
第22题:
snmp.ora
names.ora
spfile.ora
sqlnet.ora
listener.ora
tnsnames.ora
第23题:
Restart the database instance and run the job
Truncate the Certkiller STAFF table and run the job
Delete all rows from the Certkiller STAFF table and run the job
Increase the size of the USERStablespacethe and run the job
Increase the size of the database default permanenttablespaceand run the job