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...
Get Certified for Mnc Companies
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...
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,...
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:...
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...
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...
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...
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? 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...
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...
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...