Ceritified Information
You want to access employee details contained in flat files as part of the EMPLOYEE table. You plan to add a new column to the EMPLOYEE table to achieve this.Which data types would you use for the new column? Question: Which data types would you use for the new column? Options: CLOB BLOB BFILE LONG … Read more
You are using Enterprise Manager to schedule backups for your database.Which type of script would be generated by the backup scheduler?• Recovery Manager (RMAN): Oracle tool that provides a complete solution for the backup, restoration, and recovery needs of the entire database or of specific database files. Question: Which type of script would be generated … Read more
You want to configure and schedule offline database backups to run automatically. Which tool or utility would you use to achieve this? Question: Which tool or utility would you use to achieve this? Options: The XML script The PL/SQL script The DBMS_SCHEDULER package Enterprise Manager to schedule the backup Correct Answer The Correct Answer for … Read more
You execute the following command to change the status of the SALES tablespace:SQL> ALTER TABLESPACE sales OFFLINE;Which statements describe the effect of the command? (Choose all that apply.)Altering a Tablespace (continued)• Offline: You can take an online tablespace offline so that this portion of the database is temporarily unavailable for general use. The rest of … Read more
You configured the Flash Recovery Area for your database. The database instance has been started in ARCHIVELOG mode and the LOG_ARCHIVE_DEST_1 parameter is not set.What will be the implications on the archiving and the location of archive redo log files?LOG_ARCHIVE_DEST_nThe LOG_ARCHIVE_DEST_n parameters (where n = 1, 2, 3, … 10) define up to ten archive … Read more
The session of user SCOTT receives the following error after executing an UPDATE command on the EMP table:ERROR at line 1:ORA-00060: deadlock detected while waiting for resourceOn investigation, you find that a session opened by user JIM has a transaction that caused the deadlock.Which two statements are true regarding the session of SCOTT in this … Read more
You notice that the performance of the database has degraded because of frequent checkpoints.Which two actions resolve the issue? (Choose two.) Question: Which two actions resolve the issue? Options: Disable automatic checkpoint tuning Check the size of the redo log file size and increase the size if it is small Set the FAST_START_MTTR_TARGET parameter as … Read more
Which statement is true regarding undo tablespace? Question: Which statement is true regarding undo tablespace? Options: Undo tablespace is a temporary tablespace. Only one undo tablespace can exist in a database. Undo tablespace can consist of only one data file that is reused in a cyclic fashion. Multiple undo tablespace can exist in a database … Read more
You have issued a SHUTDOWN ABORT command to bring down your database instance. Consider the steps that will be performed later when you open the database:1.SGA is allocated.2.Control file is read.3.Redo log files are read.4.Instance recovery is started.5.Background processes are started.6.Data file headers are checked for consistency.7.Server parameter file or the initialization parameter file is … Read more
You are using flat files as the data source for one of your data warehousing applications. To optimize the application performance, you plan to move the data from the flat files to clustered tables in an Oracle database. While migrating the data, you want to have minimal impact on the database performance and optimize the … Read more