CMS专题
单选题You want to check the EMP table in the user， Scott’s schema for block corruption. You also want to fix the corrupted blocks， if any. How will you accomplish the required task？（）A by using the ANALYZE utilityB by using the DBVERIFY utilityC by using the
题目
by using the ANALYZE utility
by using the DBVERIFY utility
by using the DB_BLOCK_CHECKING parameter
by using the DBMS_REPAIR package
相似问题和答案
第1题：
You want to check the EMP table in the user， Scott’s schema for block corruption. You also want to fix the corrupted blocks， if any. How will you accomplish the required task？（）
- A、by using the ANALYZE utility
- B、by using the DBVERIFY utility
- C、by using the DB_BLOCK_CHECKING parameter
- D、by using the DBMS_REPAIR package
正确答案:D
第2题：
You are shrinking the SCOTT.EMP table by executing the ALTER TABLE SCOTT.EMP SHRINK SPACE CASCADE statement. What is a prerequisite for shrinking the SCOTT.EMP table？（）
- A、 You must enable the block change tracking feature.
- B、 You must have enable the flashback feature.
- C、 You must use the OMF in your database.
- D、 You must define the tablespace of the SCOTT.EMP table for automatic segment space management.
正确答案:D
第3题：
A. An error is generated.
B. You will have two identical tables in the HR schema with different names.
C. You create a table called employees in the HR schema based on you EMP table.
D. You create an alternative name for the employees table in the HR schema in your own schema.
第4题：
You created the DEPT table by using the following command： CREATE TABLE scott.dept （deptno NUMBER（3）， dname VARCHAR2（15）， loc VARCHAR2（15） ） STORAGE （INITIAL 100K NEXT 50K MAXEXTENTS 10 PCTINCREASE 5 FREELIST GROUPS 6 FREELISTS 4）；You are required to shrink the DEPT table. While performing the shrink operation， you want to ensure that the recovered space is returned to the tablespace in which the DEPT table is stored. You do not want to shrink the indexes created on the DEPT table. What will you do to shrink the SCOTT.EMP table？（）
- A、 Issue the ALTER TABLE SCOTT.DEPT SHRINK SPACE COMPACT； statement.
- B、 Issue the ALTER TABLE SCOTT.DEPT SHRINK SPACE； statement.
- C、 Issue the ALTER TABLE SCOTT.DEPT SHRINK SPACE CASCADE； statement.
- D、 You cannot shrink the SCOTT.EMP table.
正确答案:D
第5题：
In which scenario do you use the Flashback Database feature？（）
- A、 when a table is dropped and you restore it from the Recycle Bin
- B、 when a user’s schema is dropped and you recover the user’s schema
- C、 when some incorrect data is inserted in the table and you retrieve the table to a state that was at a certain timestamp
- D、 when a row of a table is updated frequently and committed， and you view all the versions of the row within a specific duration
正确答案:B
第6题：
Your database is running in ARCHIVELOG mode. The SCOTT.EMP table belongs to the DATA1 tablespace. The junior DBA erroneously runs a script that executes the following statement： SQL> DROP TABLE SCOTT.EMP PURGE； After one hour， you are performing the user managed incomplete recovery. Which datafiles will you restore from the last full backup？（）
- A、 the datafiles associated with the SYSTEM tablespace
- B、 the datafiles associated to the DATA1 tablespace
- C、 the datafiles associated to the SYSTEM and DATA1 tablespaces
- D、 all the datafiles in the database
正确答案:D
第7题：
You are performing flashback of the EMPLOYEE table in SCOTT’s schema because some incorrect data was inserted into the table and committed by mistake. Which two clauses will you use in the FLASHBACK TABLE statement for using the Flashback Table feature？ （）
- A、 RESETLOGS
- B、 TO TIMESTAMP
- C、 TO BEFORE DROP
- D、 RENAME TO
- E、 TO SCN
正确答案:B,E
第8题：
View the Exhibit for some of the current parameter settings. A user logs in to the HR schema and issues the following commands:SQL> CREATE TABLE emp(empno NUMBER(3),ename VARCHAR2(20),sal NUMBER(8,2));SQL> INSERT INTO emp(empno,ename) VALUES(1,‘JAMES‘);At this moment, a second user also logs in to the HR schema and issues the following command:SQL> ALTER TABLE emp MODIFY sal NUMBER(10,2);What happens in the above scenario?（）
A. The second user‘s session immediately produces the resource busy error.
B. The second user‘s command executes successfully.
C. The second user‘s session waits for a time period before producing the resource busy error.
D. A deadlock is created.
第9题：
The HR user creates a view with this command： SQL> CREATE VIEW emp_v AS SELECT * FROM scott.emp； Now HR wants to grant the SELECT privilege on the EMP_V view to the JIM user. Which statement is true in this scenario？（）
- A、HR can grant the privilege to JIM but without GRANT OPTION.
- B、HR can grant the privilege to JIM because HR is the owner of the view.
- C、SCOTT has to grant the SELECT privilege on the EMP table to JIM before this operation.
- D、HR needs the SELECT privilege on the EMP table with GRANT OPTION from SCOTT for this operation.
正确答案:D
第10题：
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 package
- B、 by using the DB_BLOCK_CHECKING parameter
- C、 by using the DBVERIFY utility
- D、 will not be completely resolved until the hardware fault is corrected
正确答案:D