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
第1题:
You work as a database administrator for Supportcenter.cn. In a production environment, users complain about the slow response time when accessing the database. You have not optimized the memory usage of the Oracle instance and you suspect the problem to be with the memory. To which type of object would you refer to determine the cause of the slow response?()
第2题:
You work as a database administrator for Supportcenter.cn. Your database is in NOARCHIVELOG mode and you want to perform a backup. Which type of backup would be appropriate in this case?()
第3题:
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?()
第4题:
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?()
第5题:
snmp.ora
names.ora
spfile.ora
sqlnet.ora
listener.ora
tnsnames.ora
第6题:
Hot backup
Online backup
consistent backup
incremental backup
inconsistent backup
第7题:
The DBMS_JOB package
The BACKUP_JOB package
The DBMS_BACKUP_RESTORE package
The calendar tool in the Operating System (OS)
The backup scheduler in Enterprise Manager (EM)
The DBMS_BACKUP_SCHEDULER packager inline mode
第8题:
Execute the ALTER DATABASE ARCHIVELOG statement
Select ARCHIVELOG option in the database control and restart the database to apply the changes.
Shut down and start the instance, and in the NOMOUNT state execute the ALTER DATABASE ARCHIVELOG statement.
Shut down and start the instance, mount the database, then execute the ALTER DATABASE ARCHIVELOG statement.
第9题:
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
第10题:
Monitor thealert.logfile
Enable server-side SQL tracing for user sessions
Enable fine-grained auditing for the customer table
Enable Fine-Grained Access Control (FGAC) for the customer table
Write a database trigger on the customer table on the SELECT event
第11题:
Enable instance failover
Configure shared server
Enable database failover
Enable connect-time failover
Enable Transparent Application Failover (TAF)
第12题:
Application Server Control
Oracle Management Service
Oracle Enterprise Manager Repository
Oracle Enterprise Manager Database Control
第13题:
You work as a database administrator for Supportcenter.cn. You want to create your database with the automatic undo management feature enable.Which two tasks must you perform to achieve this?()
第14题:
You work as a database administrator for Supportcenter.cn. You received the following error while working on your database: ORA-01555: snapshot too old ,In which situation would you receive such an error?()
第15题:
You work as a database administrator for Supportcenter.cn. You determine that archiving was not successful in one of thedestinators. You want to check the alert log file for more information on this.Which initialization parameter gives you the location of the alert log file?()
第16题:
You work as a database administrator for Supportcenter.cn. In your production database, the size of Database Buffer Cache needs to be increased immediately for the current as well as future instances of the database. The Oracle instance has been configured to accommodate any changes in the size of the memory structures. At this is production database, you want to accomplish this task with no impact on the user’s connections. Which activity must you have completed before accomplishing this task?()
第17题:
Host naming
Local naming
Easy Connect
External naming
directory naming
第18题:
Database Control
Management Server
Management Repository
Application Server Control
Oracle Management Agent
第19题:
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.
第20题:
Memory Advisors
Segment Advisors
SQL Tuning and Access Advisors
Automated Workload Repository (AWR)
Automatic Database Diagnostic Monitor (ADDM)
第21题:
USER_DUMP_DEST
CORE_DUMP_DEST
ALERT_LOG_DEST
ALERT_DUMP_DEST
TRACE_DUMP_DEST
BACKGROUND_DUMP_DEST
第22题:
3 hours
6 months
until last year
until last commit
until the point when the undotablespacewas refreshed
until the database is shut down and the memory erased
第23题:
The trace file
The fixed views
The data dictionary views
The operating system log fields
The dynamic performance views.
第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