1Z0-041 - Oracle Database 10g 2 Day DBA Assessment Exam
Go back to Oracle
Which three components comprise a relational database model? (Choose three.)
Data integrity rules
A collection of objects or relations
A set of operators to manage the tables
You are the database administrator of a financial institution. The application developer in your company is working on the Loans module. This module requires you to create a reusable database object that computes and returns the fixed rate of interest for a loan by using the principal amount, the tenure of the loan, and the category of the customer. Which database object would you create?
You created a new Enterprise Manager user. What privileges does this user have?
The user can log in to Oracle Enterprise Manager Database Control and perform database management tasks.
A control file has been accidentally deleted. What happens when you try to start an instance and connect to the database?
An error message is displayed and the database is not mounted.
In which of the following states can administrators perform certain administrative functions that cannot be performed when other users are accessing the database?
when the database is mounted
You manually configured the System Global Area (SGA). If you want the Oracle server to manage the size of the SGA dynamically on its own, then which option would be the solution?
You enable Automatic Shared Memory Management.
How would you ensure that the System Global Area (SGA) is optimally shared among all its subcomponents?
Enable Automatic Shared Memory Management in the database by setting the value of the SGA_TARGET parameter.
How do you access the Oracle Enterprise Manager Database Control on a host, myhost, in the domain, oracle.com, that uses the default port, from a client browser?
Open a browser window and type the URL: http://myhost.oracle.com:5500/em.
Which three statements are true about database storage structures? (Choose three.)
Tablespaces comprise one or more datafiles.
Segments can span datafiles within a tablespace.
Data objects are stored as segments in tablespaces.
Examine the following features of a backup strategy: The backup operation is performed when the instance is shut down. All the changes in the redo logs have been applied to the datafiles. The database can be opened immediately after the restore operation. What type of backup is created when this backup strategy is implemented?
To protect the sample schema accounts from an unauthorized user access, these accounts are _____.
initially locked with their passwords expired
Which three Oracle tools have their correct uses listed next to them? (Choose three.)
Oracle Net Manager: to configure a listener
SQL*Loader: to load data into database tables
Oracle Universal Installer (OUI): to provide a common, user-friendly interface when installing Oracle software on any platform
Which two system privileges or roles enable you to access the database instance even when the database is not open? (Choose two.)
the SYSDBA system privilege
the SYSOPER system privilege
You are installing Oracle10g on Linux operating system. Which two scripts would you need to run as user root? (Choose two.)
Which condition causes the status of a redo log group member to be invalid?
when a redo log member is added to a group and this member is not yet written to
Which two statements are correct regarding naming methods? (Choose two.)
Easy connect naming method requires no configuration.
Directory naming method stores connect identifiers in a centralized, LDAP-compliant directory server.
Which two settings of the Workload Repository page affect the behavior of the Automatic Database Diagnostic Monitor (ADDM)? (Choose two.)
interval of snapshots
retention period of snapshots
Which method can you use to receive a notification when the free disk space in the recovery area falls below 10%?
Create an alert that sends a notification when the threshold value is reached.
The contents of a SQL* Loader control file and the datafile are as follows: Control file: load.ctl LOAD DATA INTO TABLE myuser.purchase_orders REPLACE FIELDS TERMINATED BY ';' (po_id, po_date date 'yyyymmdd', po_desc char(25), po_item char(25), po_item2 char(25)) Datafile: load.dat 1; 20031025; DSL/Wireless Expense Oct; Home DSL; Wireless 2; 20031125; Office Equipment; Optical Mouse; Network Router 3; 20031225; Computer System; Dell Pentium 4 Laptop; Docking Bay Which two database users can log in to Enterprise Manager and perform the batch load of this data? (Choose two.)
A long running query to a database fails to execute because the undo records for this query have been overwritten. Which two of these options provide a solution to this problem? (Choose two.) Which statement represents the Segment Advisor's feature?
The Segment Advisor provides advice on whether the database has space available for reclamation based on the level of space fragmentation within the tablespaces.
The Segment Advisor provides advice on whether a tablespace has space available for reclamation based on the level of space fragmentation within the tablespace.
You are unable to access the Oracle Enterprise Manager Database Control and connect to a database from a client browser. Which two reasons can cause this problem? (Choose two.)
The dbconsole process is not started on the database server.
The listener service for the instance is not running on the database server.
The Oracle Enterprise Manager Database Control on your system uses a port that is not the default port. Which method helps you to identify the port number for your system?
Execute the emctl status dbconsole command to display the port used by Enterprise Manager on your system.
Which two methods can you use to proactively monitor the workload and database state? (Choose two.)