Select the correct order in which these tasks need to be performed.

You want to protect your database from single point of failure by multiplexing the control file. Yourdatabase is started using SPFILE. You have to perform the following tasks:1. Shut down the database instance.2. Copy the control file to new location.3. Configure the CONTROL_FILES parameter.4. Restart the instance.Select the correct order in which these tasks need […]

Read More

Which two statements are true regarding the database in ARCHIVELOG mode?

Which two statements are true regarding the database in ARCHIVELOG mode? (Choose two.) A.Archiving information is written to the data files and redo log files. B.You can perform complete database backups without closing the database. C.Online redo log files have to be multiplexed before putting the database in ARCHIVELOG mode. D.All the previous database backups […]

Read More

Which three statements are true about the stages of database startup?

Which three statements are true about the stages of database startup? (Choose three.) A.Data files and redo log files can be renamed at the MOUNT stage. B.Control files are required to bring the database to the NOMOUNT stage. C.Data files and online redo log files are checked for consistency while opening the database. D.Data files […]

Read More

Which statement is true after HR issues the REVOKE command?

The HR user owns the EMP table. The HR user grants privileges to the SCOTT user by using thiscommand:SQL> GRANT SELECT,INSERT,UPDATE ON emp TO scott WITH GRANT OPTION;The SCOTT user executes this command to grant privileges to the JIM user:SQL> GRANT SELECT,INSERT,UPDATE ON hr.emp TO jim;Now the HR user decides to revoke privileges from JIM […]

Read More

Which statement regarding the dept and emp tables is true?

View the Exhibit. Which statement regarding the dept and emp tables is true? A.When you delete a row from the dept table, automatically the corresponding rows are updated with null values in the emp table. B.When you delete a row from the dept table, automatically the corresponding rows are deleted from the emp table. C.When […]

Read More

What action would you take to detect the cause of this behavior?

You created a response file and want to check it before starting installations in silent mode. Youstarted installation of Oracle software in interactive mode by providing the response file. In themiddle of the installation, you realize that the behavior of the Oracle Universal Installer (OUI) is notconsistent with the response file. What action would you […]

Read More

which situation would you use the Oracle Shared Server configuration?

In which situation would you use the Oracle Shared Server configuration? A.when performing export and import using Oracle Data Pump B.when performing batch processing and bulk loading operation in a data warehouse environment C.in an online transaction processing (OLTP) system where large number of client sessions are idle most of the time D.when performing backup […]

Read More

Which action would you consider to overcome the performance degradation?

You find that the database performance degrades while you backup the PROD database usingRecovery Manager (RMAN). The PROD database is running in shared server mode. Thedatabase instance is currently using 60% of total operating system memory. You suspect theshared pool fragmentation to be the reason. Which action would you consider to overcome theperformance degradation? A.Increase […]

Read More

Which two actions would you take to overcome this error?

View the Exhibit to see the structure of the EMPLOYEES and DEPARTMENTS tables. Your organization plans to dissolve the department with department ID 30. You execute thefollowing command to delete rows from the DEPARTMENTS table:SQL>delete from DEPARTMENTSwhere DEPT_ID = 30;The command fails and displays the following error:ERROR at line 1:ORA-02292: integrity constraint (HR.SYS_C005374) violated – […]

Read More