READ Free Dumps For Oracle- 1z0-050

Question ID 1917	You installed Oracle Database 11g afresh. Which statements are true regarding the default audit settings in this database? (Choose all that apply.)
Option A	A.    Auditing is enabled for all privileges.
Option B	B.    Auditing is disabled for all privileges.
Option C	C.    The audit trail is stored in the database
Option D	D.    The audit trail is stored in an operating system file.
Option E	E.    Auditing is enabled for certain privileges related to database security.
Correct Answer	C,E

Explanation

Question ID 1918	The INVJHISTORY table is created using the command: SQL>CREATE TABLE INV_HISTORY (inv_no NUMBER(3), inv_date DATE, inv_amtNUMBER(10,2)) partition by range (inv_date) interval (numtoyminterval(1 ,'month')) (partition pO values less than (to_date(l01-01-2005llldd-mm-yyyy1)), partition p1 values less than (to_date('01-01-2006','dd-mm-yyyy'))); The following data has been inserted into the INVJHISTORY table : INV_NO INV_DATE INV_AMT 1 30-dec-2004 1000 2 30-dec-2005 2000 3 1-feb-2006 3000 4 1-mar-2006 4000 5 1-apr-2006 5000 You would like to store the data belonging to the year 2006 in a single partition and issue the command: SQL> ALTER TABLE inv_history MERGE PARTITIONS FOR(TO_DATE(l15-feb-2006l,ldd-mon-yyyy,)),FOR(TO_DATE(l15-apr-20061)) INTO PARTITION sys_py; What would be the outcome of this command?
Option A	A.    It executes successfully, and the transition point is set to "l-apr-20061.
Option B	B.    It executes successfully, and the transition point is set to '15-apr-2006'.
Option C	C.    It produces an error because the partitions specified for merging are not adjacent.
Option D	D.    It produces an error because the date values specified in the merge do not match the date values stored in the table.
Correct Answer	C

Explanation

Previous-Page 1 2. . . 67 68 69 70 71 72 73. . . 177 178 Next-Page

Send email to admin@getfreedumps for new dumps request!!!