SHOW L1
SPAWN L1
STATUS L1
SERVICES L1
STATUS LISTENER
SERVICES LISTENER
SHOWcurrent_listener
第1题:
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?()
第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 Supportcenter.cn. Your listener process, L1, is currently listening to three databases: CertK INDB04, SupportCenter DB05 and SupportCenter DB06. Using Database Configuration Assistant (DBCA) you create one more database, SupportCenter 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, SupportCenter DB07, with the L1 listener process?()
第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题:
Hot backup
Online backup
consistent backup
incremental backup
inconsistent backup
第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题:
START
RELOAD
RESTART
REFRESH
START L1
RELOAD L1
RESTART L1
REFRESH L1
第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题:
SHOW L1
SPAWN L1
STATUS L1
SERVICES L1
STATUS LISTENER
SERVICES LISTENER
SHOWcurrent_listener
第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 have a listener process, L1, currently listening for the connections to the PROD and ADMIN databases. You create a new database, PAY, using CREATE DATABASE.. command. You have not enabled dynamic instance registration. You modified the LISTENER.ORA file manually to include PAY database for L1 listener process. Which command of Listener control utility (LSNRCTL) would you use to enable L1 process to start listening for the connections to the PAY database without disrupting any existing database communications?()
第19题:
Control file
Password file
Parameter file
Online redo log file
Listener controller file
Server parameter file
第20题:
Database Control
Management Server
Management Repository
Application Server Control
Oracle Management Agent
第21题:
Enable instance failover
Configure shared server
Enable database failover
Enable connect-time failover
Enable Transparent Application Failover (TAF)
第22题:
CPU usage
degree of parallelism
number of open cursors
number of sorts performed
idle time for blocking sessions
number of disk I/O operations performed
number of memory I/O operations performed
第23题:
SHOW L1
SPAWN L1
STATUS L1
SERVICES L1
STATUS LISTENER
SERVICES LISTENER
SHOWcurrent_listener
第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