A data file become corrupted in your database due to bad sectors on the disk. Because of corruption, you lost all the important tables in that data file. Which method would you use for recovery?()
Due to media failure you lost one of the data files belonging to the USERS tablespace, and the tablespace is not available to use. Which statement regarding the status of the database is true?()
You want to drop the TBS1 tablespace from your database. You also want to delete the corresponding data files automatically, and not have to do it manually. What should you do?()
There was media failure and you need to check the data files for any block corruption. Which option would you use to create a report on any corruptions found within the database?()
You are evaluating whether to add an additional hard disk drive to each file server and create a striped volume for the data files. Which storage requirement is met by adding the hard disk drive and creating the striped volume?()
Which of the following SQL*Loader parameters enables you to load a specified number of records stored in the data file?()
You lost a temporary file that belongs to the default temporary tablespace in your database. From the options provided, which approach would you take to solve the problem?()
Which data dictionary views displays the error information related to a data file, when an internal read fails on that file?()
Which background process is responsible for writing the dirty buffers from the write list to the data files during a checkpoint?()
You have a large amount of historical data in an operating system file. Some analysts in your organization need to query this data. The file is too large to load into your current database. Which is the most effective method to accomplish the task?()
You need to perform a block media recovery on the tools01.dbf data file in the SALES database by using Recovery Manager (RMAN).Which two are the prerequisites to perform this operation?()
Cisco IOS XR software is partitioned into three planes: control, data, and management. Which three ofthese belong to the data plane?()
You received the following error: ORA-01578: ORACLE data block corrupted (file # %s, block # %s) Which file will you check to view additional information regarding the cause of this error?()
You need to perform a block media recovery on the tools01.dbf data file in the SALES database by using Recovery Manager (RMAN). Which two are the prerequisites to perform this operation? ()(Choose two)
You Execute the Following command to create a password file in the database server: $ orapwd file = ‘+DATA/PROD/orapwprod entries = 5 ignorecase = N format = 12’ Which two statements are true about the password file?()
Your data recovery strategy must meet the following requirements: Back up all data files and folders in C:\Data. Restore individual files and folders in C:\Data. Ensure that data is backed up to and restored from external media. What should you do?()
Multi Protocol Label Switching (MPLS) is a data-carrying mechanism that belongs to the family of packet-switched networks. For an MPLS label, if the stack bit is set to1, which option is true?()
You lost a data file that belongs to an index tablespace in your database, which operates in ARCHIVELOG mode. Loss of the data file resulted in increased response time on your queries. Which two options would you use to solve this problem? ()
You need to import all definitions of objects belonging to the TS_EMPLOYEES tablespace by using the export file expdat.dmp. Which import statement is correct?()
A product manager has prepared catalog data using a spreadsheet and has exported the data to a file in CSV format. What is the correct sequence to execute the Loader Package tools to import the data into the WebSphere Commerce database?()
The data file belonging to theSYSTEMtablespaceis corrupted and no backup of the file is available. How do you recover the data file?()
There was media failure and you need to check the data files for any block corruption. Which option would you use to create a report on any corruptions found within the database?()
A data file became corrupted in your database due to bad sectors on the disk. Because of corruption, you lost all the important tables in that data file. Which method would you use for recovery?()
A computer file is a collection of ( ) data, used to organize the shortage and processing of data by computer.