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 parametersLRM-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?
You enable block change tracking. You issue the following command:BACKUP INCREMENTAL LEVEL 0 DATABASE;The next day, you issue the following command:BACKUP INCREMENTAL LEVEL 1 CUMULATIVE DATABASE;Which statement about the use of the change tracking file is true?
Youre performing tablespace point-in-time recovery on a tablespace called USERS. If an object in that tablespace has a foreign key constraint owned by another object in the INDEX_TBS, which statement is true?
Which of the following is not a valid calendaring syntax element?
The NLS_SORT parameter sets the default sort method for which of the following operations? (Choose all that apply.)
The INV_HISTORY table is created using the command:The following data has been inserted into the INV_HISTORY table: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('15-feb-2006','dd-mon-yyyy')),FOR(TO_DATE('15-apr-2006'))INTO PARTITION sys_py;What would be the outcome of this command?
