好记性不如烂博客

174. Which two statements are true regarding B-tree index? (Choose two.)A.The leaf blocks in the index are doubly linked.  B.The leaf node stores a bitmap for each key value.C.The rows wit

38. To make audit information more productive, the DBA executes the following command before startingan audit operation:SQL> ALTER SYSTEM SET AUDIT_TRAIL=DB,EXTENDED SCOPE=SPFILE;Which sta

You are creating a locally managed tablespace to meet the following requirements: All the extents should be of the same size. The data should be spread across two data files.A bitmap should be

3: Identify two situations in which you can use Data Recovery Advisor for recovery. (Choose two.) —° A.The database files are corrupted when the database is open. B.The user has dropped an

44. Your database is functional with a peak load for the last one hour. You want to preserve theperformance statistics collected during this period to be used for comparison when you analyze the

96. Which two operations can be performed on an external table? (Choose two.)A.Create a view on the table.B.Create an index on the table.C.Create a synonym on the table.D.Add a virtual

50. Which two statements are true about alerts? (Choose two.)A.Clearing an alert sends the alert to the alert history.B.Response actions cannot be specified with server-generated alerts.C.

27. Which two statements are true regarding transactions in an Oracle database? (Choose two.)A.Multiple transactions can use the same undo segment.B.A transaction is assigned an undo segment

34. Which two statements are true regarding a PL/SQL package body? (Choose two.)A) It cannot be created without a package specification.B) It cannot invoke subprograms defined in other package