as a flat file
as a BPEL-compiled definition
as an XML file with an associated document type definition (DTD)
as an XML file without an associated document type definition (DTD)
第1题:
You issue this statement:ALTER DATABASE BACKUP CONTROLFILE TO TRACE; What does the statement generate?()
第2题:
You are maintaining your database in Oracle10g. You are not using the recovery catalog to maintain the backup metadata information. You want to enable the reusable section of the control file to expand itself if the oldest record cannot be reused, and whenever a new record is added to the reusable section of the control file. Which value will you set for the CONTROL_FILE_RECORD_KEEP_TIME parameter?()
第3题:
You are maintaining your production database in Oracle10g. You want the circular reuse records in the control file of the target database to be reused as required. Which value will you set for the CONTROL_FILE_RECORD_KEEP_TIME initialization parameter?()
第4题:
You have been tasked with creating Business Events for an E-Business Suite workflow project. Whatwould you use to create your Business Events?()
第5题:
You work as a database administrator for Certkiller .com. You added atablespaceto your database. Because of the changes to the physical structure of your database, you performed a backup of the control file to trace. After this, you lost only the control files and the instance aborted due to a hardware failure. How would you proceed to recover the database?()
第6题:
You want the user APP_DBA to administer the Oracle database from a remote machine. APP_DBA is granted the SYSDBA privilege to perform administrative tasks on the database. Which file is used by the Oracle database server to authenticate APP_DBA?()
第7题:
You perform a security audit of a server named CRM1. You want to build a list of all DNS requests that are initiated by the server. You install the Microsoft Network Monitor 3.0 application on CRM1. You capture all local traffic on CRM1 for 24 hours. You save the capture file as data.cap. You find that the size of the file is more than 1 GB. You need to create a file named DNSdata.cap from the existing capture file that contains only DNS-related data. What should you do? ()
第8题:
Issue ALTER DATABASE BACKUP CONTROLFILE TO filename
Make a copy of the control file with the database shut down
Issue ALTER DATABASE BACKUP CONTROLFILE TO trace
Make a copy of the control file with the database still running
第9题:
Apply the display filter !DNS and save the displayed frames as a DNSdata.cap file.
Apply the capture filter DNS and save the displayed frames as a DNSdata.cap file.
Add a new alias named DNS to the aliases table and save the file as DNSdata.cap.
Run the nmcap.exe /inputcapture data.cap /capture DNS /file DNSdata.cap command.
第10题:
0
1
NONE
DEFAULT
第11题:
:!ls-I myfile
:/ls-l myfile
esc :Is -I myfile
:?ls-l myfile
第12题:
Start the instance and open the database, instance recovery automatically recovers control files
Create a file based on the contents of the trace file and save it to the control file locations and start the database
Re-create the database (The recovery of the control file is not possible because you have lost all the control files.)
Start the instance, in the NOMOUNTstate,re-create the control file using the CREATE CONTROLFILE command stored in the trace file.
Start the instance and MOUNT the database, then re-create the control file using the CREATE CONTROLFILE command stored in the trace file.
第13题:
You are connected to Recovery Manager (RMAN) without a recovery catalog. There is no copy of the control file available. You want to restore the control file from an autobackup. To retrieve the autobackup, you need the database ID (DBID). In which two sources would you find the DBID? ()
第14题:
You are connected to Recovery Manager (RMAN) without a recovery catalog. There is no copy of the control file available. You want to restore the control file from an autobackup. To retrieve the autobackup,you need the database ID (DBID). In which two sources would you find the DBID? ()
第15题:
You work as a database administrator for Supportcenter.cn. You added atablespaceto your database. Because of the changes to the physical structure of your database, you performed a backup of the control file to trace. After this, you lost only the control files and the instance aborted due to a hardware failure. How would you proceed to recover the database?()
第16题:
You completed your workflow definition. You want to save a copy of the definition to the file system for source control purposes. How does Oracle Workflow Builder save that file?()
第17题:
You are maintaining your database in Oracle10g. You want to store the information about the backup of the database in the control file. You issue the following statement: SQL>ALTER SYSTEM SET CONTROL_FILE_RECORD_KEEP_TIME=400; What is the outcome of this statement? ()
第18题:
You work in a company which is named Wiikigo Corp. The company uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance. There is a database named Dworks in the instance. The Dworks database has a table named Orderthings. According to the company requirement, you have to export all data from the Orderthings table to a file. During the export, you must make sure that the data export process is saved for reuse and a Microsoft Office Open XML document format is used. What should you do?()
第19题:
You perform a security audit of a server named CRM1. You want to build a list of all DNS requests that are initiated by the server. You install the Microsoft Network Monitor 3.0 application on CRM1. You capture all local traffic on CRM1 for 24hours. You save the capture file as data.cap. you find that the size of this file is more tahn 1GB. you need to create a file named DNSdata.cap from the existing capture file taht contains only dNS -related data What should you do()?
第20题:
The statement will not execute successfully.
The statement will execute successfully, and the backups metadata will be maintained in the control file for 400 days
The statement will execute successfully, and the backups metadata will be maintained in the recovery catalog for 400 days.
Backups will be deleted from the media after 400 days.
第21题:
save configuration <filename>
save config <filename>
save <filename>
save run <filename>
第22题:
Start the instance and open the database, instance recovery automatically recoverscontrol files
Create a file based on the contents of the trace file and save it to the control file locations and start the database
Re-create the database (The recovery of the control file is not possible because you have lost all the control files.)
Start the instance, in the NOMOUNTstate,re-create the control file using the CREATE CONTROLFILE command stored in the trace file.
Start the instance and MOUNT the database, then re-create the control file using the CREATE CONTROLFILE command stored in the trace file.
第23题:
Zero
One or more
NONE
DEFAULT
第24题:
as a flat file
as a BPEL-compiled definition
as an XML file with an associated document type definition (DTD)
as an XML file without an associated document type definition (DTD)