#22. You work as a database administrator for Company.com. Users in the Company.com PROD database complain about the slow response of transactions. While investigating the reason you find that the transactions are waiting for the undo segments to be available, and undo retention has been set to zero. What would you do to overcome this problem?
#24. Exhibit #1 Exhibit #2, command Exhibit #3, error You work as a database administrator for Company.com. You have created a database link, devdb.uk.oracle.com, between the database PRODDB and DEVDB. You want to import schema objects of the HR user using Oracle Data Pump from the development database, DEVDB, to the production database, PRODDB. View Exhibit #1 to see the source and target database.l You execute the code in Exhibit #2. The code fails and produces the error displayed in Exhibit #3. What would you do to overcome the error?
#25. You work as a database administrator for Company.com. The database is open. A media failure has occurred, resulting in loss of all the control files in your database. Which statement regarding the database instance is true in this scenario?
#26. You work as a database administrator for Company.com. In a production environment, users complain about the slow response time when accessing the database. You have not optimized the memory usage of the Oracle instance and you suspect the problem to be with the memory. To which type of object would you refer to determine the cause of the slow response?
#28. You work as a database administrator for Company.com. You have set the retention period for Automatic Repository (AWR) statistics to four days and collection interval to 15 minutes. You want to view the statistics collected and stored in AWR snapshot. Which two methods would you use to view the AWR statistics? Choose two
#29. You work as a database administrator for Company.com. As a result of performance analysis, you created an index on the prod_name column of the Companyprod table, which contains about ten thousand rows. Later, you updated a product name in the table. How does this change affect the index?
#30. Two database users, Company are accessing the staff table of the db database. when ExamS modifies a value in the table, the new value is invisible to Sheets. Which is the modified value invisible to SHEETS?
ген. 0.049
Форум
Главный бреиндамп