Oracle 1z0-042: Oracle Database 10g: Administration I
#11. You work as a database administrator for Company.com. You find that users with DBA role are using more CPU resources than what is allocated in their profiles. Which action would you take to ensure that resources limits are imposed on these users?
#12. You work as a database administrator for Company.com. In your Oracle database 10g installation you have set ORACLE_BASE to /u01/app/oracle. Which objective will be achieved by this setting?
#13. The operating system file cratab in the Linux platform gets updated whenever you create a new database on the same host machine. What kind of information is stored is stored in this file?
#14. You work as a database administrator for Company.com. Your database is configured for automatic undo management. UNDO_RETENTION is set to 3 hours. You want to flash back a table that was created last year. How far back can the flashback query go?
#15. In your Company.com production database, you find that the database users are able to create and read files with unstructured data, available in any location on the host machine from an application. You want to restrict the database users to access files in a specific location on the host machine. What could do to achieve this?
#17. You work as a database administrator for Company.com. On a Monday morning, you find the database instance aborted. After inspecting the alert log file, you execute the STARTUP command in SQL*Plus to bring the instance up. What statement is true?
#19. Exhibit: You work as a database administrator for Company.com. You have started the database instance and you want to manage your database remotely with Enterprise Manager through a Web browser. Which two URLs would you use to access the Database Control? (Choose two.)
#20. You work as a database administrator for Company.com. While loading data into the Company STAFF table using Oracle Enterprise Manager 10g Database Control, you find the status of the job as failed. On further investigation, you find the following error message in the output log: ORA-01653 unable to extend table HR.CompanySTAFF by 8 in tablespace USERS Which task would you perform to load the data successfully without affecting the users who are accessing the table?
ген. 0.047
Форум
Главный бреиндамп