1.Which three statements are true about temporary tables? A) Their rows are not lost when a session fails.

B) DML on temporary tables may be rolled back.

C) Their rows are never lost when a transaction commits.

D) Their rows are always lost when a session logs out.

E) temporary tables are always created in a user’s temporary tablespace.

F) Their rows are always lost when a transaction commits.

Answer:BDE

2.zonedata contains millions of rows and is accessed for analytic purposes in a data warehouse. The only updates to the table are done using bulk loads.

Which two are true about indexes for the zonedata table ?

A) A B-Tree index on the zone column can contain only four leaf blocks.

B) A bitmap index on the zone column would contain four bitmaps.

C) A bitmap index on the zone column would contain a bitmap for null zones.

D) A B-Tree index on the zone column would contain only one branch block.

E) A B-Tree index on the zone column would contain four branch blocks.

Answer:CE

3.USER1.EMP hasareferentialintegrityconstraintdefinedonEMP.DNOthatreferences USER1.DEPT.DNO.

USER1 executes these commands:

SQL> UPDATE dept SET loc=‘UK’ where dno=1;

1 row updated.

SQL> UPDATE emp SET sal=1000 where eno=100; 1 row updated.

SQL>ALTER TABLE dept DROP(dno)

What will be the outcome and why?

A)It will fail because a referential integrity constraint is defined on USER1.EMP.

B)It will execute successfully and drop DEPNT.DNO.

C) It will fail because there is an uncommitted transaction on USER1.DEPT.

D) It will execute successfully and drop the DEPT.DNO and EMP.DNO columns. E)It will fail because there is an uncommitted transaction on USER1.EMP

Answer:A

4.Examine these commands and their output:

SQL> SELECT * FROM empENOENAME

—————

100Adam

101Alan

SQL> INSERT INTO emp VALUES(102,’Ben’); 1 row created.

SQL>COMMIT;

Commit completed.

SQL>UPDATE emp SET ename=‘Bryan’ WHERE eno=102;

1 row updated.

A power failure occurs. The instance is restarted and this query is executed.

SQL>SELECT ename FROM emp;

What is the outcome?

A)Only Adam and Alan are displayed. B)No rows are returned.

C)Only Adam, Alan, and Bryan are displayed.

D)Adam, Alan, Ben, and Bryan are displayed.

E)Only Adam, Alan, and Ben are displayed.

Answer:E

5.EachrowintheTRANS_SUMMARY tablecontainsdetailsofoneproduct. EachrowintheTRANS_MONTHLY tablecontainstransactiondetailseitherfornewproductsorfor updates to existing products.

There is a monthly requirement to:

1.InsertTRANS_MONTHLY rowsfornewproductstotheTRANS_SUMMARY table

2. Update the TRANS_SUMMARY table whena TRANS_MONTHLY rowreferstoanexisting product. Which two can be used to do this?

A)INSERT INTO .. SELECT FROM ..

B)a called procedure.

C)an Oracle loader type external table.

D)the MERGE command.

E)CREATE TABLE AS SELECT (CTAS)

Answer:BD

6.Which four statements are true about truncating a table?

A)Any insert triggers for the table will be executed.

B)Any of the table‟s indexes are also truncated.

C)Any delete triggers for the table will be executed.

D)All table storage can be retained.

E)Only HEAP tables may be truncated.

F)All table storage is converted to free space.

G)MINEXTENTS amountofstorageforthetablecanberetained.

Answer:BDFG

7.Examine these attributes for the profile assigned to USER1 whose password is oracle_4U.

·PASSWORD_REUSE_MAX is5.

·PASSWORD_REUSE_TIME is10. ·PASSWORD_GRACE_TIME is15.

Which two conditions must be met for USER1 to reuse oracle_4U?

A)At least 5 days must have passed since oracle_4U was last used.

B)The password must have changed 5 times since oracle_4U was last used. C)At least 10 days must have passed since oracle_4U was last used.

D)The password must have changed 10 times since oracle_4U was last used. E)At least 15 days must have passed since oracle_4U was last used.

Answer:BC

8.Examine these attributes for the profile assigned to USER1 whose password is oracle_4U

·PASSWORD_REUSE_MAX is5

·PASSWORD_REUSE_TIME is10

·PASSWORD_GRACE_TIME is15 Which two are true?

A)The USER1 password must not have been used for at least 10 days b efore oracle_4U can be reused as the password

B)The USER1 account will be locked if the password is changed more then 5 times in 10 days

C)The USER1 password must be changed 5 times before oracle_4U can be reused as the password

D)The USER1 account will be locked if the password is not changed at least 5 times in 15 days

E)The USER1 password must not have been used for at least 25 days before oracle_4U can be reused as the password

Answer:AC

9.Which is true about invalid PL/SQL objects?

A)They are automatically recompiled against the new definition of a referenced object when they are called.

B)They must be manually recompiled before they can be used if a DDL is performed on a table that is referenced in the PL/SQL object.

C)Theyareautomatically recompiled againstthenewdefinition ofareferencedobjectatthesame

time as the referenced object is modified.

D)They can be manually recompiled only by using SQL commands.

Answer:A

10.Which two are true about PL/SQL objects?

A)They must be in an invalid state to be recompiled.

B)They can never be manually recompiled.

C)They can be manually recompiled.

D)They must be manually recompiled.

E)They can be automatically recompiled.

Answer:CE

oracle视频教程，考前辅导一对一通过服务，联系微信号 18601575886，QQ:909577120