The latest 10 BusyThumbs posts tagged with the word or phrase <i>1z0-042</i>. http://www.busythumbs.com/tags/1z0-042/ Thu, 26 Nov 2009 14:04:03 +0000 FeedCreator 1.7.2 http://killy.busythumbs.com/entry_id/713054/action/viewentry/ 10g DBA OCA <a href='http://www.testinside.com/1z0-042.htm' target='_blank'>1Z0-042</a> exam demo:<br /> <br /> 1. You execute the following command to audit the database activities:<br /> SQL> AUDIT DROP ANY TABLE BY scott BY SESSION WHENEVER SUCCESSFUL;<br /> What is the effect of this command?<br /> A. One audit record is created for the whole session if user SCOTT successfully drops one or more tables in his session.<br /> B. One audit record is created for every session when any user successfully drops a table owned by SCOTT. <br /> C. One audit record is created for each successful DROP TABLE command executed by any user to drop tables owned by SCOTT.<br /> D. One audit record is generated for the session when SCOTT grants the DROP ANY TABLE privilege to other users in his session.<br /> E. One audit record is created for each successful DROP TABLE command executed in the session of SCOTT.<br /> Answer: A <br /> 2. The SAVE_AMT column in the ACCOUNTS table contains the balance details of customers in a bank. As part of the year-end tax and interest calculation process, all the rows in the table need to be accessed. The bank authorities want to track access to the rows containing balance amounts exceeding $200,000, and then send an alert message to the administrator. <br /> Which method would you suggest to the bank for achieving this task? <br /> A. implementing value-based auditing by using triggers<br /> B. implementing fine-grained auditing with audit condition and event handler<br /> C. performing standard database auditing to audit object privileges by setting the AUDIT_TRAIL parameter to EXTENDED<br /> D. performing standard database auditing to audit SQL statements with granularity level set to ACCESS <br /> Answer: B <br /> 3. Which three statements are true regarding the fine-grained auditing (FGA)? (Choose three.)<br /> A. FGA is possible on SELECT statements only.<br /> B. The audit trail for FGA is stored in the FGA_LOG$ table.<br /> C. The audit trail for FGA is stored in the AUD_LOG$ table.<br /> D. FGA enables a SQL predicate to define when to audit an event.<br /> E. FGA audits DELETE statements only when audit columns are specified. <br /> F. FGA includes the SQL statement used by the user as part of the audit event entry.<br /> Answer: BDF <br /> 4. You plan to use static database registration for a new listener when you create it. What could be the two reasons for this? (Choose two.)<br /> A. More than one database is to be registered with the listener.<br /> B. The users will connect the database by using the host naming method.<br /> C. The Oracle Enterprise Manager is to be used to monitor an Oracle9i database.<br /> D. The database that is to be registered with the listener is configured in shared server mode.<br /> E. The listener is not configured on the default port of 1521 and the instance is not configured to register with a nondefault port.<br /> Answer: CE <br /> 5. Which three pieces of information are to be mandatorily provided while creating a new listener using Enterprise Manager Database Control? (Choose three.) <br /> A. the port used by the listener<br /> B. the protocol used by the listener<br /> C. the server name where the listener runs<br /> D. the log file and trace file destination for the listener<br /> E. the database services to be registered with the listener<br /> Answer: ABC Killysa Thu, 02 Jul 2009 09:56:48 +0000