ExamBible.co.uk 1Z0-042.pdf

Loading ...
Global Do...
News & Politics
 
 
Your Partner of IT Exam                                                            http://www.exambible.co.uk/
 
 
 
 
Oracle 1Z0-042： 
Oracle Database 10g: 
Administration I 
Version :  
Demo 
 
 
 
 
 
 
 
 
 
 
 
 
Your Partner of IT Exam                                                            http://www.exambible.co.uk/
About Exambible 
Your Partner of IT Exam 
 
Found in 1998 
Exambible is a company specialized on providing high quality IT exam practice study 
materials, especially Cisco CCNA, CCDA, CCNP, CCIE, Checkpoint CCSE, CompTIA A+, 
Network+ certification practice exams and so on. We guarantee that the candidates will not only 
pass any IT exam at the first attempt but also get profound understanding about the certificates they 
have got. 
There are so many alike companies in this industry, however, Exambible has its unique 
advantages that other companies could not achieve. 
 
 
Our Advances 
    * 99.9% Uptime 
      All examinations will be up to date. 
    * 24/7 Quality Support 
      We will provide service round the clock. 
    * 100% Pass Rate 
      Our guarantee that you will pass the exam. 
* Unique Gurantee 
      If you do not pass the exam at the first time, we will not only arrange FULL REFUND for 
you, but also provide you another exam of your claim, ABSOLUTELY FREE! 
 
 
 
 
 
 
 
 
 
Your Partner of IT Exam                                                            http://www.exambible.co.uk/
1. In your Oracle 10g database , you have scheduled a job to update the optimizer statistics at 05:00 pm 
every Friday. The job has successfully completed. Which three pieces of information would you check to 
confirm that the statistics have been collected? (Choose three.) 
A. average row size 
B. last analyzed date 
C. size of table in bytes 
D. size of table in database blocks 
E. number of free blocks in the free list 
F. number of extents present in the table 
Answer: ABD 
 
2. You are in the middle of a transaction and very crucial data has been modified. Because of a 
hardware failure, the instance has shut down before synchronizing all the database files. 
Which two statements are true? (Choose two.) 
A. On startup, SMON coordinates instance recovery. 
B. On startup, CKPT coordinates instance recovery. 
C. On startup, use RMAN to perform instance recovery. 
D. Uncommitted changes will be rolled back after the database is opened. 
E. On startup, perform media recovery and then instance recovery. 
F. On startup, all the files will be synchronized and you get both committed and uncommitted data. 
Answer: AD 
 
3. You are using the backup scheduler in Enterprise Manager (EM) to schedule a backup of your 
database. 
Which type of script does the backup scheduler generate? 
A. SQL script 
B. PL/SQL script 
C. Operating System (OS) script 
D. Enterprise Manager (EM) script 
E. Recovery Manager (RMAN) script 
 
 
 
Your Partner of IT Exam                                                            http://www.exambible.co.uk/
Answer: E 
 
4. You executed the following command to export the EMPLOYEES table from a remote machine: 
$ EXPDP hr/hr@data.us.oracle.com 
DUMPFILE=my_dir:exp_hr.log 
LOGFILE=data_pump_dir:log_hr.log 
TABLES=employees 
What would be the outcome of this command? 
A. The command would execute successfully and the export dump file would be created in the 
destination 
of the directory object MY_DIR. 
B. The command would execute successfully. But log file would not be created as DATA_PUMP_DIR 
directory is only accessible to user with SYSDBA privilege. 
C. The command fails with an error because DATA_PUMP_DIR directory have higher precedence over 
the perfile directory. 
D. The command fails with an error because no absolute path is specified for log file and dumpfile. 
Answer: A 
 
5. Which step do you need to perform to enable a user with the SYSDBA privilege to log in as SYSDBA 
in iSQL*Plus? 
A. The user must be granted the database administrator (DBA) privilege. 
B. The user must be listed in the password file for the authentication. 
C. No special setup is needed for the user to connect as SYSDBA in iSQL*Plus. 
D. Set up a user in the Oracle Application Server Containers for J2EE (OC4J) user manager, and grant 
the webDba role to the user. 
Answer: D 
 
6. Which two statements regarding the LOGGING clause of the CREATE TABLESPACE. .. statement 
are correct? (Choose two.) 
A. This clause is not valid for a temporary or undo tablespace. 
 
 
 
Your Partner of IT Exam                                                            http://www.exambible.co.uk/
B. If the tablespace is in the NOLOGGING mode, no operation on the tablespace will generate redo. 
C. The tablespace will be in the NOLOGGING mode by default, if not specified while creating a 
tablespace. 
D. The tablespacelevel logging attribute can be overridden by logging specifications at the table, index, 
materialized view, materialized view log, and partition levels. 
Answer: AD 
 
7. Which two statements are true about the primary key constraint in a table? (Choose two.) 
A. It is not possible to disable the primary key constraint. 
B. It is possible to have more than one primary key constraint in a single table. 
C. The primary key constraint can be referred by only one foreign key constraint. 
D. The primary key constraint can be imposed by combining more than one column. 
E. The nondeferrable primary key constraint creates an unique index on the primary key column if it is 
not already indexed. 
Answer: DE 
 
8. You want the user APP_DBA to administer the Oracle database from a remote machine. APP_DBA is 
granted the SYSDBA privilege to perform administrative tasks on the database. 
Which file is used by the Oracle database server to authenticate APP_DBA? 
A. control file 
B. password file 
C. listener controller file 
D. control file and password file 
Answer: B 
 
9. Which three statements are true regarding the logical structure of the Oracle database? (Choose 
three.) 
A. Each segment contains one or more extents. 
B. Multiple tablespaces can share single data file. 
C. A data block is the smallest unit of I/O for data files. 
 
 
 
Your Partner of IT Exam                                                            http://www.exambible.co.uk/
D. It is possible to have tablespaces of different block sizes in a database. 
E. Each data block in the database always corresponds to one OS block. 
Answer: ACD 
 
10. Which is the memory area that is created when a dedicated server process is started, and contains 
data and control information for that server process? 
A. SGA 
B. PGA 
C. Shared Pool 
D. Streams Pool 
Answer: B 
 
11. You find that the database performance degrades while you backup the PROD database using 
Recovery Manager (RMAN). The PROD database is running in shared server mode. The database 
instance is currently using 60% of total operating system memory. You suspect the shared pool 
fragmentation to be the reason. 
Which action would you consider to overcome the performance degradation? 
A. Configure Java Pool to cache the java objects. 
B. Configure Streams Pool to enable parallel processing. 
C. Increase Shared Pool size to cache more PL/SQL objects. 
D. Increase Database Buffer Cache size to increase cache hits. 
E. Configure Large Pool to be used by RMAN and shared server. 
F. Increase the total System Global Area (SGA) size to increase memory hits. 
Answer: E 
 
12. You execute the following command to audit the database activities: 
SQL> AUDIT DROP ANY TABLE BY scott BY SESSION WHENEVER SUCCESSFUL; 
What is the effect of this command? 
A. One audit record is created for the whole session if user SCOTT successfully drops one or more 
tables in his session. 
 
 
 
Your Partner of IT Exam                                                            http://www.exambible.co.uk/
B. One audit record is created for every session when any user successfully drops a table owned by 
SCOTT. 
C. One audit record is created for each successful DROP TABLE command executed by any user to 
drop tables owned by SCOTT. 
D. One audit record is generated for the session when SCOTT grants the DROP ANY TABLE privilege 
to other users in his session. 
E. One audit record is created for each successful DROP TABLE command executed in the session of 
SCOTT. 
Answer: A 
 
13. The SAVE_AMT column in the ACCOUNTS table contains the balance details of customers in a 
bank. As part of the yearend 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. 
Which method would you suggest to the bank for achieving this task? 
A. implementing valuebased 
auditing by using triggers 
B. implementing finegrained 
auditing with audit condition and event handler 
C. performing standard database auditing to audit object privileges by setting the AUDIT_TRAIL 
parameter to EXTENDED 
D. performing standard database auditing to audit SQL statements with granularity level set to ACCESS 
Answer: B 
 
14. Which three statements are true regarding the finegrained auditing (FGA)? (Choose three.) 
A. FGA is possible on SELECT statements only. 
B. The audit trail for FGA is stored in the FGA_LOG$ table. 
C. The audit trail for FGA is stored in the AUD_LOG$ table. 
D. FGA enables a SQL predicate to define when to audit an event. 
 
 
 
Your Partner of IT Exam                                                            http://www.exambible.co.uk/
E. FGA audits DELETE statements only when audit columns are specified. 
F. FGA includes the SQL statement used by the user as part of the audit event entry. 
Answer: BDF 
 
15. 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.) 
A. More than one database is to be registered with the listener. 
B. The users will connect the database by using the host naming method. 
C. The Oracle Enterprise Manager is to be used to monitor an Oracle9i database. 
D. The database that is to be registered with the listener is configured in shared server mode. 
E. The listener is not configured on the default port of 1521 and the instance is not configured to register 
with a nondefault port. 
Answer: CE 
 
 
 
 
Your Partner of IT Exam                                                            http://www.exambible.co.uk/
Contact us 
We are proud of our high-quality customer service, which serves you around the clock 24/7. 
 
Contact us by emails 
Please allow up to 24 hours for us to respond 
problems about sales and so on       problems about payment,installation, acitvation and so on 
Sales Email   sales@exambible.com      Support Email   support@exambible.com 
Please Note: Please accept mail from an official, do not believe any of the other E-mail