Your database supports an online transaction processing (OLTP) application. The application is undergoing some major schema changes, such as addition of new indexes and materialized views. You want to check the impact of these changes on workload performance. What should you use to achieve this?()
The online redo log group configuration for your database is as follows: What will happen if the online redo log file ’ora02/oradata/redo02b.log’is corrupted while working on the database?()
You are working in an online transaction processing (OLTP) environment. You used the FLASHBACK TABLE command to flash back the CUSTOMERS table. Before executing the FLASHBACK TABLE command, the System Change Number (SCN) was 663571. After flashing back the CUSTOMERS table, you realize that the table is not in the correct state and the resultant changes are not what you had desired. So, you need to reverse the effects of the FLASHBACK TABLE command while ensuring that: a) No other user data in the database is affected. b) The operation takes the minimum possible time. Which option would you choose?()
In your database, online redo log files are multiplexed and one of the members in a group is lost due to media failure. How would you recover the lost redo log member?()
In one of your online transaction processing (OLTP) applications, most users frequently modify the values, including the key values, of the application tables. Some users generate application reports by using multiple application tables. What is the best table structure that you can use to gain optimal performance?()
An online retailer is considering deploying a database application on xSeries and Windows to serve their Web-based transactions. The database will need about 4TB of usable storage. Downtime costs the customer tens of thousands of dollars per minute, so system availability will be of highest priority. The customer needs to acquire the system within a certain budget but will pay for things that provide higher system availability. Which of the following will be the most appropriate solution?()
The configuration of the online redo log files is as follows: Based on this configuration, which statement is true?()
Top colleges and universities are rushing into online education, but the big news is the proliferation of a new breed of for-profit online institutions bringing Internet education to the masses. “The Internet will probably be the single most democratizing force in education,” says Columbia Business School Dean Meyer Feldberg, who envisions educational programs being routed through the Net to hundreds of millions of people. The largest online institution is the University of Phoenix (http://onl.uophx.edu/), with some 6, 000 students today and hopes of reaching 200, 000 students in 10 years. The University offers bachelor’s, master’s, and doctoral degrees in business management, technology, education and nursing. The institution boasts that if you’re a student “you can earn your degree via the Internet whenever and wherever you want.” The University notes that its degree programs cost far less and may take some students far less time to complete. On the other hand, a Business Week survey of 247 companies found that only a handful would consider hiring applicants who earned their MBA degrees online. Whether that will change as for-profit online universities improve their offerings—and graduates prove their worth—is anyone’s guess.
A database is running In ARCHIVBXXMS mode. It has two online redo log groups and each group has one member. A LGWR Input/output (I/O) fells due to permanent media failure that has resulted In the loss of redo log file and the LWGR terminates causing the instance to crash. The steps to recover from the loss of a current redo log group member in the random order are as follow. 1) Restore the corrupted redo log group. 2) Restore from a whole database backup. 3) Perform incomplete recovery. 4) Relocate by renaming the member of the damaged online redo log group to a new location. 5) Open the database with the RESETLOGS option. 6) Restart the database instance. 7) Issue a checkpoint and clear the log. Identify the option with the correct sequential steps to accomplish the task efficiently().
This is the online redo log files and the control file configurations: Based on these configurations, which statement is true?()