This is a note. Please give me your attention if you are preparing for your Oracle 1Z0-040 exam. It is really a tough task to pass 10g DBA 1Z0-040 exam. However, CertBus will help you on that with the most comprehensive PDF and VCEs of the latest 10g DBA 1Z0-040 exam questions, covering each and every aspect of 10g DBA 1Z0-040 Oracle database 10g:new features for adminsitrators exam curriculum.
We CertBus has our own expert team. They selected and published the latest 1Z0-040 preparation materials from Oracle Official Exam-Center: http://www.certgod.com/1Z0-040.html
QUESTION NO:1
Which three methods can you use to run an Automatic Database Diagnostic Monitor (ADDM)
analysis over a specific time period? (Choose three.)
A. Enterprise Manager GUI
B. DBMS_TRACE package APIs
C. DBMS_ADVISOR package APIs
D. DBMS_MONITOR package APIs
E. $ORACLE_HOME/rdbms/admin/addmrpt.sql script
Answer: A,C,E
Explanation:
To make use of ADDM, a PL/SQL interface called DBMS_ADVISOR has been implemented. This
PL/SQL interface may be called through the supplied $ORACLE_HOME/ rdbrns /admin/
addmrpt.sqI script, called directly, or used in combination with the Oracle Enterprise Manager
application. Besides tins PL/SQL package a number of views (with names starting with the
DBA_ADVISOR prefix) allow retrieval of the results of any actions performed with the
DBMS_ADVISOR API. The preferred way of accessing ADDM is through the Enterprise Manager
interface, as it shows a complete performance overview including recommendations on how to
solve bottlenecks on a single screen. When accessing ADDM manually, you should consider using
the ADDMRPT.SQL script provided with your Oracle release, as it hides the complexities involved
in accessing the DBMS_ADVISOR package.
QUESTION NO:76
You have created the following auditing policy:
Which statement is true about the fine-grained auditing implemented by this policy?
A. An audit record is created for all INSERT and UPDATE statements on either the ACCOUNT_ID or
AMOUNT columns.
B. An audit record is created for all INSERT and UPDATE statements on both the ACCOUNT_ID and
AMOUNT columns.
C. An audit record is created for all INSERT statements on the ACCOUNT_ID column and the UPDATE
statement on the AMOUNT column.
D. An audit record is created for all INSERT and UPDATE statements when the ACCOUNT_ID or the
AMOUNT column contains a NULL value.
Correct Answer: B
QUESTION NO:109
Which parameter avoids the overwriting of archived redo log files when you recover the database with the
RESETLOGS option?
A. LOG_ARCHIVE_DEST
B. LOG_ARCHIVE_TRACE
C. LOG_ARCHIVE_FORMAT
D. LOG_ARCHIVE_CONFIG
E. LOG_ARCHIVE_DEST_10
F. LOG_ARCHIVE_LOCAL_FIRST
Correct Answer: C
QUESTION NO:92
An online tablespace, TEST_TBS, is full and you realize that no server-managed tablespace threshold
alerts were generated for the TEST_TBS tablespace. What could be the reason, if the TEST_TBS
tablespace does not include autoextensible data files?
A. TEST_TBS is a small file tablespace.
B. TEST_TBS is a bigfile tablespace (BFT).
C. TEST_TBS is the default temporary tablespace.
D. TEST_TBS is a dictionary-managed tablespace.
E. Threshold values for the TEST_TBS tablespace are not explicitly specified.
Correct Answer: D
QUESTION NO:106
View the Exhibit and examine the SQL statement used to create the EMP table. You need to shrink the
EMP table segment. Which SQL statement would you execute as a prerequisite before you execute the
ALTER TABLE emp SHRINK SPACE; command?
A. ALTER TABLESPACE emp OFFLINE;
B. ALTER TABLESPACE emp READ ONLY;
C. ALTER TABLE emp DEALLOCATE UNUSED;
D. ALTER TABLE emp ENABLE ROW MOVEMENT;
E. ALTER TABLE emp DISABLE ALL TRIGGERS;
F. ALTER TABLE emp ENABLE NOVALIDATE CONSTRAINT emp_last_name_nn;
Correct Answer: D
QUESTION NO:63
You want to perform the database backup when user activity on your system is low, such as between
12:00 a.m. and 2:00 a.m. Which command terminates with an error if the backup is not complete at the end
of the specified duration?
A. RMANandgt; BACKUP DURATION 2:00 MINIMIZE LOAD DATABASE;
B. RMANandgt; BACKUP DURATION 2:00 PARTIAL FILESPERSET 1 DATABASE;
C. RMANandgt; BACKUP DURATION 2:00 PARTIAL MINIMIZE TIME DATABASE;
D. RMANandgt; BACKUP AS COPY DURATION 2:00 PARTIAL MINIMIZE LOAD DATABASE;
Correct Answer: A
QUESTION NO:8
Examine the following commands of Data Pump to import objects to new non-existent users hr1 and oe1 .
Which objective would be achieved by the above command sets?
A. expdp will fail because no path has been defined for the dumpfile.
B. expdp will succeed but Impdp will fail because users do not exist.
C. impdp would create two schemas called hr1 and oe1 and copy the schema objects to the new users.
D. impdp would create two schemas called hr1 and oe1 and import tables owned by hr and oe schemas to
hr1 and oe1 schemas, respectively.
Correct Answer: B
QUESTION NO:8
You want to enforce a company\’s business policy on several objects by using a single policy
function. Which two types of policies can be assigned to the policy_type argument in the
dbms_rls.add_policy procedure to achieve the above objective? (Choose two.)
A. DBMS_RLS.STATIC
B. DBMS_RLS.DYNAMIC
C. DBMS_RLS.SHARED_STATIC
D. DBMS_RLS.CONTEXT_SENSITIVE
E. DBMS_RLS.SHARED_CONTEXT_SENSITIVE
Answer: C,E
Explanation:
DBMS_RLS. SHARED_STATIC
The policy function executes once, Once, then the predicate is cached in the SGA, and it\’s Shared
Across Multiple Objects, like Hosting environments, such as data warehouses where the same
predicate must be applied to multiple database objects DBMS_RLS.
SHARED_CONTEXT_SENSITIVE The policy function executes f irst time and the object is
reference in a database session Predicates are cached in the private session memory UGA so
policy functions can be shared among objects. REF.: Oracle(r) Database Security Guide 10g
Release 2 (10.2) – p 15-30
QUESTION NO:68
While exporting data by using Data Pump, you find that the export runs for a long period. Because this
action is being performed during peak hours, you decide to stop the job and restart it during off-peak
hours. Which view would you query to determine the name and status of the stopped job?
A. DBA_JOBS
B. V$SESSION
C. V$SESSION_LONGOPS
D. DBA_DATAPUMP_JOBS
E. DBA_DATAPUMP_SESSIONS
Correct Answer: D
QUESTION NO:80
You executed the following command to drop a user: DROP USER scott CASCADE; Which two
statements regarding the above command are correct? (Choose two.)
A. All the objects of scott are moved to the Recycle Bin.
B. Any objects in the Recycle Bin belonging to scott are purged.
C. All the objects owned by scott are permanently dropped from the database.
D. All the objects of scott in the Recycle Bin must be purged before executing the DROP command.
E. Any objects in the Recycle Bin belonging to scott will not be affected by the above DROP command.
Correct Answer: BC
CertBus exam braindumps are pass guaranteed. We guarantee your pass for the 1Z0-040 exam successfully with our Oracle materials. CertBus Oracle database 10g:new features for adminsitrators exam PDF and VCE are the latest and most accurate. We have the best Oracle in our team to make sure CertBus Oracle database 10g:new features for adminsitrators exam questions and answers are the most valid. CertBus exam Oracle database 10g:new features for adminsitrators exam dumps will help you to be the Oracle specialist, clear your 1Z0-040 exam and get the final success.
1Z0-040 Latest questions and answers on Google Drive(100% Free Download): https://drive.google.com/file/d/0B_3QX8HGRR1mb0hJN3dIdkIxTEU/view?usp=sharing
1Z0-040 Oracle exam dumps (100% Pass Guaranteed) from CertBus: http://www.certgod.com/1Z0-040.html [100% Exam Pass Guaranteed]
Why select/choose CertBus?
Millions of interested professionals can touch the destination of success in exams by certgod.com. products which would be available, affordable, updated and of really best quality to overcome the difficulties of any course outlines. Questions and Answers material is updated in highly outclass manner on regular basis and material is released periodically and is available in testing centers with whom we are maintaining our relationship to get latest material.