-
A redo log file is corrupted while the database is open； as a consequence， database operations are stopped because archiving cannot continue. What would you do to solve the problem？（）
A . clear the redo log group
B . perform redo log file import
C . perform an incomplete recovery
D . perform a redo log recovery using Recovery Manager （RMAN）
E . shut down the database and open the database in the NOARCHIVELOG mode
-
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 . the DBNEWID utility
B . the DBVERIFY utility
C . the ANALYZE command
D . the RMAN REPORT command
E . the RMAN CROSSCHECK command
F . the CHECK_OBJECT procedure of the DBMS_REPAIR package
-
The IOS of a North American Cisco Aironet 1130AG Series standalone access point has become corrupt.You must therefore reload the TFTP firmware. Before you press and hold the MODE button，you shouldverify that the file name is which of the following？（）
A . c1130-k9w7-tar.boot
B . c1130-k9w7-tar.default
C . c1130-k9w7-tar.recover
D . c1130-k9w7-tar.123-7.JA1.tar
-
A file system has been corrupted and needs to be restored. Which file contains the ufsdump levels for this file system？ （）
A . /etc/backup
B . /etc/ufsdump
C . /etc/dumpdates
D . /etc/fsdumpdate
-
Identify the two tablespaces whose data files are so critical that only a closed recovery is possible.（）
A . SYSAUX
B . TOOLS
C . UNDO
D . INDEX
E . SYSTEM
F . USERS
G . TEMP
-
You have a computer that runs Windows XP Professional. You need to create a floppy disk to start Windows XP Professional on the computer if the start files become corrupt. What should you do?（）
A . From the Windows XP Professional computer, run diskcopy.exe /v a:.
B . From a computer that runs Windows 98, create a MS-DOS-based startup disk.
C . From the Windows XP Professional computer, create an Automated System Recovery (ASR) disk.
D . From the Windows XP Professional computer, format a floppy disk. Copy the NTLDR, ntdtetect.com, and boot.ini files to the floppy disk.&e
-
Which data dictionary views displays the error information related to a data file， when an internal read fails on that file？（）
A . V$DATAFILE
B . V$DATAFILE_HEADER
C . DBA_DATA_FILES
D . V$DBFILE
E . V$DATAFILE_ERRORS
-
If a log file becomes corrupted， it may cause the database to stall. How would you correct such a situation？（）
A . Recover the online redo log from backup.
B . Delete and re-create the log file.
C . Use the alter database clear logfile command to clear the log file.
D . Shut down the database and restart it.
E . Shut down the database and then mount it. Clear the log file with the alter database clear logfile command and then restart the database with alter database open resetlogs.
-
The database is running in NOARCHIVELOG mode. A data file is lost. Which two are valid options for recover？（）
A . Restore the data file and perform incomplete recovery.
B . Restore the data file and perform point-in-time recover.
C . Drop the tablespace and lose all data in the tablespace.
D . Restore the database and lose all data since the last backup.
-
Your database is in the NOARCHIVELOG mode. Since last night’s offline backup， the logs in group 1 have been written to twice. This morning， the SYSTEM data file has become corrupted. Up to what point can it be recovered？（）
A . until the last commit
B . cannot be recovered
C . until the last offline backup
D . until the beginning of the last transactio
-
The data file belonging to the SYSTEM tablespace is corrupted and no backup of the file is available. How do you recover the data file？（）
A . The data file cannot be recovered.
B . The date file can be restored from the SYSTEM auto backup.
C . Take thetablespaceoffline，drop，kand re-create it.
D . Recovery Manager （RMAN） is used to recover the data file.
E . The ALTER DATABSE CREATE DATAFILE..commandis used to recover the data file.
-
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？（）
A . the alert log file and the trace files
B . the redo log files
C . the control file
D . the change tracking file
-
The datafiles of your database are ASM files. You are performing a check for datafile block corruption by using the DBVERIFY utility. What is a prerequisite for checking block corruption on an ASM datafile by using the DBVERIFY utility？（）
A . The block change tracking feature must be enabled.
B . OMF must be configured on your database.
C . The database must be in ARCHIVELOG mode.
D . A USERID must be supplied.
-
The IOS of a North American Cisco Aironet 1230 Series access point has become corrupt， necessitating the need for a TFTP firmware reload. Before you press and hold the MODE button，what must the file be named in order for the reload to occur？（）
A . c1200-k9w7-tar.default
B . c1200-k9w7-tar.boot
C . c1200-k9w7-tar.123-7.JA1.tar
D . c1200-k9w7-tar.recover
-
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?（）
A . It records the usernames and passwords of users when granted the DBA role.
B . It contains the usernames and passwords of users for whom auditing is enabled.
C . Is used by Oracle to authenticate users for remote database administration.
D . It records the usernames and passwords of all users when they are added to the OSDBA or OSOPER operating system groups.
E . It supports the SYSBACKUP, SYSDG, and SYSKM system privileges.
-
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？（）
A . Extractor， ID Resolver， XML Transformer， Mass Loader
B . ID Resolver， Text Transformer， Mass Loader
C . Text Transformer， XML Transformer， ID Resolver， Mass Loader
D . XML Transformer， ID Resolver， Mass Loader
E . XML Transformer， Mass Loader， ID Resolver
-
The data file belonging to theSYSTEMtablespaceis corrupted and no backup of the file is available. How do you recover the data file？（）
A . The data file cannot be recovered.
B . The date file can be restored from theSYSTEMauto backup.
C . Take thetablespaceoffline，drop，kand re-create it.
D . Recovery Manager （RMAN） is used to recover the data file.
E . The ALTER DATABSE CREATE DATAFILE..commandis used to recover the data file.
-
You need to rename a data file of a tablespace. How would you perform this？（）https://assets.asklib.com/images/image2/2018080115362766064.jpg
A . A
B . B
C . C
D . D
-
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 . the DBNEWID utility
B . the DBVERIFY utility
C . the ANALYZE command
D . the RMAN REPORT command
E . the RMAN CROSSCHECK command
F . the CHECK_OBJECT procedure of the DBMS_REPAIR package
-
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 . flash back all the tables in the data file， one by one
B . restore the data file to a new location and perform a media recovery
C . flash back the database; there is no need to restore the data file
D . restore the data file from the most recent backup and flash back the database
-
A computer file is a collection of ( ) data, used to organize the shortage and processing of data by computer.
-
34. The data may become corrupted in any of the following process except ______.
-
（72） is a collection of data sets, which is so large and complex that it becomes difficult to process using on-hand database management tools or traditional data processing applications.
A．Big data
B．Cluster
C．Parallel computing
D．Data warehouse
-
在Activity中使用【 】方法可以打开/data/data/包名/files/a.txt文件的输出流对象。
