Which data types would you use for the new column?
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...
Category: Oracle >> 1z0-052 v.2
Which type of script would be generated by the backup scheduler?
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,...
Which tool or utility would you use to achieve this?
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:...
Which statements describe the effect of the command?
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...
What will be the implications on the archiving and the location of archive redo log files?
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...
Which two statements are true regarding the session of SCOTT in this scenario?
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...
Which two actions resolve the issue?
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...
Which statement is true regarding undo tablespace?
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...
Which option has the correct order in which these steps occur?
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...
Which method would you use to load data into the Oracle database?
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...