LOG
HELP
BUFFER
PARFILE
INCTYPE
第1题:
You are using flat files as the data source for one of your data warehousing applications. To optimize the application performance, you plan to move the data from the flat files to clustered tables in an Oracle database.While migrating the data, you want to have minimal impact on the database performance and optimize the dataload operation. Which method would you use to load data into the Oracle database()
第2题:
Very soon you will be performing maintenance operations. You would have several jobs to run as soon as the maintenance period starts. Which method would you use to create jobs without specifying the time period when the job should be run?()
第3题:
You are working in an online transaction processing (OLTP) environment. You realize that the salary for an employee, John, has been accidentally modified in the EMPLOYEES table. Two days ago, the data was in the correct state. Flashback logs generated during last two days are available in the flash recovery area. Which option would you choose to bring the data to the correct state while ensuring that no other data in the same table is affected?()
第4题:
You are using flat files as the data source for one of your data warehousing applications. You plan to move the data from the flat file structures to an Oracle database to optimize the application performance. In your database you have clustered tables. While migrating the data, you want to have minimal impact on the database performance and optimize the data load operation. Which method would you use to load data into Oracle database?()
第5题:
Which two statements are true regarding the Oracle Data Pump export and import operations()
第6题:
Which of the following dynamic view would you query to identify the online CURRENT redo log group?()
第7题:
The ORACLE_SID environment variable is set to +ASM. ASMLIB is not used in the configuration. You executed the following command to startup the Automatic Storage Management (ASM) instance. SQL> STARTUP; Which two activities are performed during a successful start up operation?()
第8题:
when performing export and import using Oracle Data Pump
when performing backup and recovery operations using Oracle Recovery Manager
when performing batch processing and bulk loading operation in a data warehouse environment
in an online transaction processing (OLTP) system where large number of client sessions are idle most of the time
第9题:
ADD DIRECTORY
DROP DISK
RESIZE DISK
REBALANCE
ADD FAILGROUP
第10题:
client.BeginGetFlight(GetFlightCallback, null); client.GetFlight();
client.GetFlight(); client.BeginGetFlight(GetFlightCallback, null);
client.GetFlightCompleted += new EventHandler
IAsyncResult asyncResult = client.BeginGetFlight(GetFlightCallback, client); client.EndGetFlight(asyncResult);
第11题:
Because row IDs may change during the flashback operation
Because the object number changes after the flashback operation
Because the rows are retrieved from the recycle bin during the flashback operation
Because the table is moved forward and back to a temporary during the flashback operation
第12题:
LOG
HELP
BUFFER
PARFILE
INCTYPE
第13题:
As A DBA, which of the following methods can you use to make a backup of your table?()
第14题:
Which statements are true regarding the Oracle Data Pump export and import operations()
第15题:
You are using flat files as the data source for one of your data warehousing applications. To optimizethe application performance, you plan to move the data from the flat files toclustered tablesin an Oracle database. While migrating the data, you want to have minimal impact on the database performance and optimize thedata load operation. Which method would you use to load data into the Oracle database()
第16题:
The production database has been functional for the last seven days. Because of application requirements, some of the initialization parameters were changed during run time without any comments. You have been asked to find out the value of the parameters when the instance was started. Which source would you use to locate this information?()
第17题:
You work as a database administrator at Certkiller .com. You are working in an online transaction processing (OLTP) environment. You realize that the salary for an employee, John, has been accidentally modified in the EMPLOYEEStable. Two days ago, the data was in the correct state. Flashback logs generated during last two days are available in the flash recovery area. Which option would you choose to bring the data to the correct state while ensuring that no other data in the same table is affected?()
第18题:
Which of the following parameters would you use to record the errors that might be generated during the import operation?()
第19题:
perform point-in-time recovery
perform a Flashback Table operation to restore the table to the state it was in two days ago
perform a Flashback Database operation to restore the database to the state it was in two days ago
perform Flashback Versions Query and Flashback Transaction Query to determine all the necessary undo SQL statements, and then use them for recovery
第20题:
Fixed views
The alert log file
The parameter file
The server parameter file
Dynamic performance views
第21题:
Because row IDs may change during the flashback operation
Because the object number changes after the flashback operation
Because the rows are retrieved from the recycle bin during the flashback operation
Because the table is moved forward and back to a temporary during the flashback opertion
第22题:
use DBMS_IJOB package
use Oracle Scheduler
use DBMS_JOB package
use Oracle Data Pump Export and Import
第23题:
ADD DIRECTORY
DROP DISK
RESIZE DISK
REBALANCE
ADD FAILGROUP
第24题:
perform point-in-time recovery
perform a Flashback Table operation to restore the table to the state it was in two days ago
perform a Flashback Database operation to restore the database to the state it was in two days ago
perform Flashback Versions Query and Flashback Transaction Query to determine all the necessary undo SQL statements, and then use them for recovery