You issue the following statement： SQL SELECT FIRSTNAME， LASTNAME FROM HR.EMPLOYEE； You receive the following error： 01578： ORACLE data block corrupted （file# 6， block # 54） ORA-01110 ： data file 6： ’u01/oracle/oradata/data1.dbf’ How will you resolve this problem of data block corruption by reducing the mean time to recover （MTTR）？（）A、 by using the DBMS_REPAIR packageB、 by using the DBVERIFY utilityC、 by using Block Media RecoveryD、 by issuing the ANALYZE TABLE HR.EMPLOYEES VALIDATE STRUCTURE command
You issue the following statement： SQL> SELECT FIRSTNAME， LASTNAME FROM HR.EMPLOYEE； You receive the following error： 01578： ORACLE data block corrupted （file# 6， block # 54） ORA-01110 ： data file 6： ’u01/oracle/oradata/data1.dbf’ How will you resolve this problem of data block corruption by reducing the mean time to recover （MTTR）？（）
- A、 by using the DBMS_REPAIR package
- B、 by using the DBVERIFY utility
- C、 by using Block Media Recovery
- D、 by issuing the ANALYZE TABLE HR.EMPLOYEES VALIDATE STRUCTURE command
相关考题：
You executed the following command:RMAN RECOVER COPY OF DATAFILE ‘／u01／app／oracle／oradata／orcl／users01.dbf‘;Which statement regarding the above command is correct?() A. The ‘/u01/app/oracle/oradata/orcl/users01.dbf‘ data file is recovered from the image copyB. The ‘/u01/app/oracle/oradata/orcl/users01.dbf‘ data file is recovered from the last incremental backupC. Image copies of the ‘/u01/app/oracle/oradata/orcl/users01.dbf‘ data file are updated with all changes up to incremental backup SCN. ‘/ u01/app/oracle/oradata/orcl/users01.dbfD. Image copies of the ‘/u01/app/oracle/oradata/orcl/users01.dbf‘ data file are recovered using the above command if data file recovery fails
Whileworkingonthedatabase，youreceivethefollowingerror：01578：ORACLEdatablockcorrupted（file6，block54）ORA-01110：datafile6：’u01/oracle/oradata/data1.dbf’YoudecidetorecoverthecorrupteddatablockbyusingtheBlockMediaRecoveryfeature.WhichoptionisNOTadisadvantageofusingblockmediarecovery？（）A.BlockMediaRecoverymustbeusedwithRMAN.B.Youmustperformcompleterecoveryofindividualblocks.C.YoumusthaveafullRMANbackup，notanincrementalbackup.D.YoumustusetheDBVERIFYutilitybeforeusingtheBlockMediaRecoveryfeature.
From SQL*Plus, you issue this SELECT statement:You use this statement to retrieve data from a data table for()。 A. UpdatingB. ViewingC. DeletingD. InsertingE. Truncating
You are the administrator of a SQL Server 2000 computer in your company's personnel department. Employee data is stored in a SQL Server 2000 database. A portion of the database schema is shown in the exhibit.You want to create a text file that lists these data columns in the following format title, FirstName, LastName, WorkPhone, PositionName, DepartmentName.You want to create the text file as quickly as possible. You do not expect to re-create this file, and you want to avoid creating new database objects if possible.What should you do?A．Use the bcp utility to export data from each table to a separate text file. Use format files to select the appropriate columns. Merge the data from each text file into a single text file.B．Create a view that joins data from all three tables include only the columns you want to appear in the text file. Use the bcp utility to export data from the view.C．Create a SELECT query that joins the data from the appropriate columns in the three tables. Add an INTO clause to the query to create a local temporary table. Use the bcp utility to export data from the local temporary table to a text file.D．Create a SELECT query that joins the data from the appropriate columns in the three tables. Add an INTO clause to the query to create a global temporary table. Use the bcp utility to export data from the global temporary table to a text file.
Given the following function:CREATE FUNCTION emplist () RETURNS TABLE ( id CHAR(6) , firstname VARCHAR(12) , lastname VARCHAR(15) ) LANGUAGE SQL BEGIN ATOMIC RETURN SELECT EMPNO, FIRSTNME, LASTNAME FROM EMPLOYEE WHERE WORKDEPT IN (‘A00‘, ‘B00‘); ENDHow can this function be used in an SQL statement?A.SELECT TABLE(EMPLIST()) FROM EMPLOYEEB.SELECT TABLE(EMPLIST()) AS t FROM EMPLOYEEC.SELECT EMPLIST(id, firstname, lastname) FROM EMPLOYEED.SELECT id, firstname, lastname FROM TABLE(EMPLIST()) AS t
A user executes a query on the EMPtable， which contains thousands of rows， to get details about employees in one of the departments. The user receives the following error： SQL SELECT ename FROM emp WHERE deptno=10 ORDER BY sal； SELECT ename FROM emp WHERE deptno=10 ORDER BY sal ERROR at line 1： ORA-01157： cannot identify/lock data file 201 - see DBWR trace file ORA-01110： data file 201：’/u01/app/oracle/oradata/orcl/temp01.dbf’ What is a possible reason？（）A、 The tempfile belonging to the default temporary tablespace is missing.B、 The database is opened in restricted mode， so queries are not allowedC、 The default temporary tablespace required to execute the query is offline.D、 The default temporary tablespace required to execute the query is dropped.E、 The default temporary tablespace required to execute the query is read-only.
Given the following function: CREATE FUNCTION emplist （ ） RETURNS TABLE ( id CHAR(6) , firstname VARCHAR(12) , lastname VARCHAR(15) ) LANGUAGE SQL BEGIN ATOMIC RETURN SELECT EMPNO, FIRSTNME, LASTNAME FROM EMPLOYEE WHERE WORKDEPT IN ('A00', 'B00'); END How can this function be used in an SQL statement?A、SELECT TABLE(EMPLIST()) FROM EMPLOYEEB、SELECT TABLE(EMPLIST()) AS t FROM EMPLOYEEC、SELECT EMPLIST(id, firstname, lastname) FROM EMPLOYEED、SELECT id, firstname, lastname FROM TABLE(EMPLIST()) AS t
While working on the database， you receive the following error： 01578： ORACLE data block corrupted （file# 6， block # 54） ORA-01110 ： data file 6： ’u01/oracle/oradata/data1.dbf’ You decide to recover the corrupted data block by using the Block Media Recovery feature. Which option is NOT a disadvantage of using block media recovery？（）A、 Block Media Recovery must be used with RMAN.B、 You must perform complete recovery of individual blocks.C、 You must have a full RMAN backup， not an incremental backup.D、 You must use the DBVERIFY utility before using the Block Media Recovery feature.
Your database is open and running in ARCHIVELOG mode. You take RMAN full backups every Sunday night. On Monday morning， while querying the user1.employees table， you receive the following error message： 01578： ORACLE data block corrupted （file # 5， block # 51） ORA-01110： data file 5： ’/u01/app/oracle/oradata/orcl/example01.dbf’ You need to rectify the corruption while ensuring the following： The data file should remain online. The mean time to recover （MTTR） should be minimal. You are not using a backup control file， and all the archived logs are accessible. Which option would you choose？（）A、flash back the corrupted blocksB、use the DBMS_REPAIR packageC、use the RMAN TSPITR commandD、use the RMAN BLOCKRECOVER commandE、use the RESTORE DATABASE and RECOVER DATABASE commandsF、investigate the time at which the corruption occurred and perform a point-in-time recovery
The accounting manager wants you to create a form that when queried will display a calculated total of year-to-date actual expenditures for the fund code entered. The value needed to generate this summary data are stored in multiple tables. How would you define the data source for this data block without having the DBA create a database object? （）A、Choose Tools - Data Block Wizard, select View as the data source type, and base the block on the columns from the bales. B、Choose Tools - Data Block Wizard, select Table as the data source type, and base the block on the columns from the tables. C、Select the Data Blocks node in the Object Navigator and click the Create button. Choose to build the data block manually and alter the Query Data Source Columns and Query Data Source Arguments properties to enter the SELECT statement. D、Select the Data Blocks node in the Object Navigator and click the Create button. Choose to build the data block manually, alter the Query Data Source Type property to 'Table', and enter the SELECT statement in the Query Data Source Name property. E、Choose Tools - Data Block Wizard, select Stored Procedure as the data source type, and base the block on the columns the tables. F、Select the Data Blocks node in the Object Navigator and click the Create button. Choose to build the data block manually. Alter the Query Data Source Type to 'FROM' clause query', and enter the SELECT statement in the Query Data Source Name property.
You work as a database administrator at Certkiller .com. Your database is open and running in ARCHIVELOGmode. You take RMANfull backups every Sunday night. On Monday morning， while querying the user1.employeestable， you receive the following error message： 01578： ORACLE data block corrupted （file # 5， block # 51） ORA-01110： data file 5：’/u01/app/oracle/oradata/orcl/example01.dbf’ You need to rectify the corruption while ensuring the following： The data file should remain online. The mean time to recover （MTTR） should be minimal. You are not using a backup control file and all the archived logs are accessible. Which option would you choose？（）A、 flash back the corrupted blocksB、 use the DBMS_REPAIR packageC、 use the RMAN TSPITR commandD、 use the RMAN BLOCKRECOVER commandE、 use the RESTORE DATABASE and RECOVER DATABASE commandsF、 investigate the time at which the corruption occurred and perform a point-in-time recovery
From SQL*Plus, you issue this SELECT statement: SELECT* FROM order; You use this statement to retrieve data from a data table for （）.A、UpdatingB、ViewingC、DeletingD、InsertingE、Truncating
Your database is open and running in ARCHIVELOG mode. You take RMAN full backups every Sunday night. On Monday morning， while querying the user1.employees table， you receive the following error message： 01578： ORACLE data block corrupted （file # 5， block # 51） ORA/x7f01110： data file 5： ’/u01/app/oracle/oradata/orcl/example01.dbf’ You need to rectify the corruption while ensuring the following： The data file should remain online. The mean time to recover （MTTR） should be minimal. You are not using a backup control file， and all the archived logs are accessible. Which option would you choose？（）A、flash back the corrupted blocksB、use the DBMS_REPAIR packageC、use the RMAN TSPITR commandD、use the RMAN BLOCKRECOVER commandE、use the RESTORE DATABASE and RECOVER DATABASE commandsF、investigate the time at which the corruption occurred and perform a pointintime recovery
You executed the following command： RMAN RECOVER COPY OF DATAFILE ’/u01/app/oracle/oradata/orcl/users01.dbf’； Which statement regarding the above command is correct？（） A、 The ’/u01/app/oracle/oradata/orcl/users01.dbf’ data file is recovered from the image copy.B、 The ’/u01/app/oracle/oradata/orcl/users01.dbf’ data file is recovered from the last incremental backup.C、 Image copies of the ’/u01/app/oracle/oradata/orcl/users01.dbf’ data file are updated with all changes up to incremental backup SCN.D、 Image copies of the ’/u01/app/oracle/oradata/orcl/users01.dbf’ data file are recovered using the above command if data file recovery fails.
You executed the following command: RMAN RECOVER COPY OF DATAFILE '/u01/app/oracle/oradata/orcl/users01.dbf'; Which statement regarding the above command is correct?（）A、The '/u01/app/oracle/oradata/orcl/users01.dbf' data file is recovered from the image copyB、The '/u01/app/oracle/oradata/orcl/users01.dbf' data file is recovered from the last incremental backupC、 Image copies of the '/u01/app/oracle/oradata/orcl/users01.dbf' data file are updated with all changes up to incremental backup SCN. '/ u01/app/oracle/oradata/orcl/users01.dbfD、Image copies of the '/u01/app/oracle/oradata/orcl/users01.dbf' data file are recovered using the above command if data file recovery fails
You issued the following command to analyze the SCOTT.EMP table for block corruption： ANALYZE TABLE SCOTT.EMP VALIDATE STRUCTURE； You received the following error： ORA-01578： ORACLE data block corrupted （file # %s， block # %s） How will you resolve the block corruption problem？（）A、 by using the DBMS_REPAIR packageB、 by using the DB_BLOCK_CHECKING parameterC、 by using the DBVERIFY utilityD、 will not be completely resolved until the hardware fault is corrected
While querying the EMPLOYEES table， you receive an ORA-01578 message indicating block corruption in File# 1201 and Block# 1968. You analyze the table and the corruption is verified. Which RMAN command do you use to perform BMR and repair the corrupt block？（） A、 RECOVER FILE=1201 BLOCK=1968B、 RECOVER CORRUPTION LISTC、 RECOVER DATAFILE 1201 BLOCK 1968D、 RECOVER BLOCK CORRUPTION LISTE、 None of the above
You are managing an Oracle Database 10g database that uses Oracle Managed Files （OMF）. You enabled the block change tracking feature for the database. Which statement regarding the change tracking file is true？（）A、 One block change tracking file is created for each data file. By default， the file is created in DB_CREATE_FILE_DEST.B、 One block change tracking file is created for each data file. By default， the file is created in BACKGROUND_DUMP_DEST.C、 One block change tracking file is created for the database. By default， the file is created in DB_CREATE_FILE_DEST.D、 One block change tracking file is created for the database. By default， the file is created in BACKGROUND_DUMP_DEST.
You have control-file autobackups enabled. When starting your database from SQL*Plus， you receive the following error message： SQL startup ORA-01078： failure in processing system parameters LRM-00109： could not open parameter file ， C:///ORACLE/PRODUCT/11.1.0/DB_1/DATABASE/INITORCL.ORA Using RMAN， how would you respond to this error？（） A、 Issue the startup nomount command and then issue the restore parameter file command from the RMAN prompt.B、 Issue the startup nomount command and then issue the restore spfile command from the RMAN prompt.C、 Issue the startup nomount command and then issue the restore spfile from autobackup command from the RMAN prompt.D、 Issue the startup nomount command and then issue the restore spfile from backup command from the RMAN prompt.E、 Issue the restore spfile from autobackup command from the RMAN prompt.
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 filesB、 the redo log filesC、 the control fileD、 the change tracking file
单选题You issue the following statement： SQL SELECT FIRSTNAME， LASTNAME FROM HR.EMPLOYEE； You receive the following error： 01578： ORACLE data block corrupted （file# 6， block # 54） ORA-01110 ： data file 6： ’u01/oracle/oradata/data1.dbf’ How will you resolve this problem of data block corruption by reducing the mean time to recover （MTTR）？（）A by using the DBMS_REPAIR packageB by using the DBVERIFY utilityC by using Block Media RecoveryD by issuing the ANALYZE TABLE HR.EMPLOYEES VALIDATE STRUCTURE command
单选题The accounting manager wants you to create a form that when queried will display a calculated total of year-to-date actual expenditures for the fund code entered. The value needed to generate this summary data are stored in multiple tables. How would you define the data source for this data block without having the DBA create a database object? （）AChoose Tools - Data Block Wizard, select View as the data source type, and base the block on the columns from the bales. BChoose Tools - Data Block Wizard, select Table as the data source type, and base the block on the columns from the tables. CSelect the Data Blocks node in the Object Navigator and click the Create button. Choose to build the data block manually and alter the Query Data Source Columns and Query Data Source Arguments properties to enter the SELECT statement. DSelect the Data Blocks node in the Object Navigator and click the Create button. Choose to build the data block manually, alter the Query Data Source Type property to 'Table', and enter the SELECT statement in the Query Data Source Name property. EChoose Tools - Data Block Wizard, select Stored Procedure as the data source type, and base the block on the columns the tables. FSelect the Data Blocks node in the Object Navigator and click the Create button. Choose to build the data block manually. Alter the Query Data Source Type to 'FROM' clause query', and enter the SELECT statement in the Query Data Source Name property.
单选题You issued the following command to analyze the SCOTT.EMP table for block corruption： ANALYZE TABLE SCOTT.EMP VALIDATE STRUCTURE； You received the following error： ORA-01578： ORACLE data block corrupted （file # %s， block # %s） How will you resolve the block corruption problem？（）A by using the DBMS_REPAIR packageB by using the DB_BLOCK_CHECKING parameterC by using the DBVERIFY utilityD will not be completely resolved until the hardware fault is corrected
多选题From SQL*Plus, you issue this SELECT statement: SELECT* FROM order; You use this statement to retrieve data from a data table for （）.AUpdatingBViewingCDeletingDInsertingETruncating
多选题While querying the EMPLOYEES table， you receive an ORA-01578 message indicating block corruption in File# 1201 and Block# 1968. You analyze the table and the corruption is verified. Which RMAN command do you use to perform BMR and repair the corrupt block？（）ARECOVER FILE=1201 BLOCK=1968BRECOVER CORRUPTION LISTCRECOVER DATAFILE 1201 BLOCK 1968DRECOVER BLOCK CORRUPTION LISTENone of the above
单选题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？（）Athe alert log file and the trace filesB the redo log filesC the control fileD the change tracking file
单选题Given the following function: CREATE FUNCTION emplist （ ） RETURNS TABLE ( id CHAR(6) , firstname VARCHAR(12) , lastname VARCHAR(15) ) LANGUAGE SQL BEGIN ATOMIC RETURN SELECT EMPNO, FIRSTNME, LASTNAME FROM EMPLOYEE WHERE WORKDEPT IN ('A00', 'B00'); END How can this function be used in an SQL statement?ASELECT TABLE(EMPLIST()) FROM EMPLOYEEBSELECT TABLE(EMPLIST()) AS t FROM EMPLOYEECSELECT EMPLIST(id, firstname, lastname) FROM EMPLOYEEDSELECT id, firstname, lastname FROM TABLE(EMPLIST()) AS t