Control file
Password file
Parameter file
Online redo log file
Listener controller file
Server parameter file
第1题:
You work as a database administrator for Supportcenter.cn. In your organization, you have four databases, SupportCenter DB01, SupportCenter DB02, SupportCenter DB03, and SupportCenter 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?()
第2题:
You are working on the Certkiller database. What is the default name of the alert log file in this database?()
第3题:
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?()
第4题:
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?()
第5题:
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?()
第6题:
Increase the undo return
Create more undo segments
Create another undotablespace
Increase the size of the undotablespace
第7题:
Memory Advisors
Segment Advisors
SQL Tuning and Access Advisors
Automated Workload Repository (AWR)
Automatic Database Diagnostic Monitor (ADDM)
第8题:
Database Control
Management Server
Management Repository
Application Server Control
Oracle Management Agent
第9题:
Host naming
Local naming
Easy Connect
External naming
directory naming
第10题:
Average row size
Last analyzed date
Size of table in bytes
Size of table in database blocks
Number of free blocks in the free list
Number of extents present in the table.
第11题:
Control file
Password file
Parameter file
Online redo log file
Listener controller file
Server parameter file
第12题:
AppDomain.CurrentDomain.ShadowCopyFiles
AppDomain.CurrentDomain.CachePath
AppDomain.CurrentDomain.ConfigurationFile
AppDomain.CurrentDomain.Evidence
第13题:
You work as a database administrator for Certkiller .com. In the Certkiller PRODUCTION database you have granted RESUMABLE system privilege to the CONNECT role.Resumablespace operation has been enabled for all user session. You want users NOT to be aware of any kind of space-related problems while performing transactions. Instead, you want the problem to be resolved by a database trigger automatically. Which combination of triggering time and event would you use to achieve this objective?()
第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 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?()
第16题:
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?()
第17题:
You work as an application developer at Certkiller .com. You have recently created an application domain for Certkiller .com. A few weeks later, you are required to determine if assembly references in this application domain, which is the current application domain, are being cached. What property should you use to achieve this objective?()
第18题:
Hot backup
Online backup
consistent backup
incremental backup
inconsistent backup
第19题:
alert_ Certkiller .log
alertlog_ Certkiller .log
alert_log_ Certkiller .log
Certkiller _alert_log.log
log_alert_: Certkiller .log
trace_alert_ Certkiller .log
第20题:
snmp.ora
names.ora
spfile.ora
sqlnet.ora
listener.ora
tnsnames.ora
第21题:
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
第22题:
A
B
C
D
第23题:
AFTER CREATE
AFTER SUSPEND
BEFORE CREATE
AFTER TRUNCATE
BEFORE SUSPEND
AFTER INSERT OR DELETE OR DELETE
BEFORE INSERT OR DELETE OR DELETE