Oracle认证考试
单选题By mistake, you ran the batch job (for updating the BILL_DETAILS table) twice. You are not sure which rows in the BILL_DETAILS table were affected. You need to identify: a) a list of changes made along with the transaction identifier of each change b) the necessary SQL statements to undo the erroneous changes Which option would you choose?()
单选题View the Exhibit and examine the properties of the TT tablespace. Using Database Control, you have scheduled a job to shrink the TRANS table residing on the TT tablespace. The job would run at 5:00 p.m. every Friday.When you examine the space usage of the table after the completion of the job, you find that the table has not been shrunk. What could have been the reason for this?()
单选题You are working on Oracle Database 10g, which is in ARCHIVELOG mode. All the archived log files are intact. In which scenario would performing a recovery require the opening of the database with the RESETLOGS option?()
单选题An RMAN backup job fails, displaying the following error message: ORA/x7f19809: limit exceeded for recovery files Your analysis shows that the Flash Recovery area is full. What would you do to resolve the error?()
单选题You are maintaining your database in Oracle10g. You are not using the recovery catalog to maintain the backup information of your database. Which file can be used as a repository to store information regarding the RMAN backup?()
单选题You have configured the flash recovery area to store online redo log files, control files, archived redo logs and RMAN backups. Which of the following files can you successfully delete from the flash recovery area if you want to reclaim the space within it?()
单选题You are designing an application for a telecom company and you have been asked to design a database table to facilitate monthly bill generation. The bill would include details of customer calls, listed in chronological order. Which method would you follow to achieve this objective without increasing the overhead of sorting the rows?()
单选题You are maintaining an OLTP database in Oracle10g. You find that the database is generating a large number of trace files. You decide to disable the trace files generated by the ARCn background process. Which action will enable you to disable the trace files generated by the ARCn background process?()
单选题You executed the following query: SELECT operation, undo_sql, table_name FROM flashback_transaction_query; Which statement is correct regarding the query output?()
单选题In which scenario do you use the Flashback Database feature?()
单选题You issued the following statement: SQL> ALTER SESSION SET NLS_LANG=FRENCH_CANADA.WE8ISO8859P1; Which parameter is NOT overridden by using the above statement?()
多选题You decided to configure the flash recovery area in your database to centralize the storage of all the recovery files in a certain location on disk. Which two parameters will you specify in the init.ora file?()
单选题Which background process sequentially writes Flashback Database data from the flashback buffer to the Flashback Database logs?()
单选题What will be the result of using the SQL> DROP USER SCOTT CASCADE; command?()
多选题Which two statements are true about Block Media Recovery (BMR)?()
单选题Your database is configured on non-ASM disk storage. You need to migrate your database to ASM disk storage. Which statement is true about migrating from non-ASM disk storage to ASM disk storage?()
单选题You are maintaining the database in Oracle10g. You are performing an incomplete recovery by using RMAN because an important table, EMPLOYEE, is dropped and purged from the Recycle Bin. Which statement is NOT true regarding an incomplete recovery?()
单选题You want to enable the user, Scott, to change to the GRP1 consumer group by issuing the following code: SQL> EXEC DBMS_SESSION.SWITCH_CURRENT_CONSUMER_GROUP (’SCOTT’, ’GRP1’, FALSE); How will you grant the switch privilege to the user, Scott?()
单选题Your database is running in the automatic Program Global Area (PGA) memory management and Shared Memory Management mode. You want to increase the memory available for the SQL work areas. What would you do?()
单选题You are working in an online transaction processing (OLTP) environment. You realize that the salary for an employee, John, has been accidentally modified in the EMPLOYEES table. Two days ago, the data was in the correct state. Flashback logs generated during last two days are available in the flash recovery area. Which option would you choose to bring the data to the correct state while ensuring that no other data in the same table is affected?()
当前列表仅展示前20条试题,搜“题王”小程序查看更多考题~