|
Question 1.
You need to create a schedule that will run a job on the second Friday of each month.
What should the repeat interval of the schedule be set to?
A. FREQ = MONTHLY; BYDAY = 2FRI;
B. FREQ = MONTHLY; BYDAY = FR12;
C. FREQ = MONTHLY; BYDAY = -2FRI;
D. FREQ = MONTHLY; BYDAY = FRI (2);
Answer: A
Question 2.
The list below display four step that you need to execute in order to switch from the primary database role to the standby database role.
Choose the correct order of execution for the steps;
1. Shut down and start up the former primary instance without mounting the database.
2. Issue the ALTER DATABASE COMMIT TO SWITCHOVER TO PHYSICAL STANDBY command.
3. Issue the ALTER DATABASEMOUNT STANDBY DATABASE command.
4. End read or update activity on the former primary and standby database.
A. 1,2,3,4
B. 3,2,4,1
C. 4,2,1,3
D. 4,3,2,1
Answer: C
Explanation:
Stop read or update activity on the primary and standby databases.
You must have exclusive database access before beginning a switchover. Ask users to log off the primary and standby databases, or query the V$SESSION view to identify users that are connected to the databases and close all open sessions except the SQL*Plus session from which you are going to execute the switchover statement.
Switch the primary database to the physical standby role.
On the primary database (in New York), execute the following statement:
SQL> ALTER DATABASE COMMIT TO SWITCHOVER TO PHYSICAL STANDBY
2>WITH SESSTION SHUT Down;
This statement does the following:
? Closes the primary database, terminating any active sessions
? Transmits any un archived redo log files and applies them to the standby database
? Adds an end-of-redo marker to the header of the last log file being archived
? Creates a backup of the current control file
? Converts the current control file into a standby control file
Shut down and start up the former primary instance, and mount the database.
Execute the following statement on the former primary database:
SQL>WITH SHUT Down NORMAL;
SQL>STARTUP MOUNT;
Switch the original standby database to the primary role.
Issue the following SQL statement:
SQL> ALTER DATABASE COMMIT TO SWITCHOVER TO PRIMARY
DATABASE;
Reference:
Oracle(r) Data Guard Concepts and Administration 10g Release 2 (10.2), 12-39
Question 3.
You want to enforce a company's business policy on several objects by using a single policy function.
Which two types of polices can be assigned to the policy type argument in the dbms_rls.add_policy procedure to achieve the above objective?
A. DBMS_RLS. STATIC
B. DBMS_RLS.DYNAMIC
C. DBM_RLS.SHARED_STATIC
D. DBMS_RLS.SHARED_DYNAMIC
E. DBMS_RLS. CONTEXT_SENSITIVE
F. DBMS_RLS.SHARED_CONTEXT_SENSITIVE
Answer: C, F
Question 4.
You decided to activate the presumable space allocation feature for all your database users by enabling the feature in a logon trigger.
This causes a statement that requires space beyond a user's quota________
A. to wait indefinitely for the quota to be increased, regardless of the timeout setting for other
space allocation problem
B. to fail because quota limits do not activate the resumable space allocation feature
C. to wait in a suspended state until the quota increased or until the timeout value is reached
D. to invoke the default trigger that resets user quota, if there is free space in the related table
space
Answer: C
Question 5.
Which statements are true regarding the new Persistent CONFIGURATION FEATURE IN RMAN? (Choose two)
A. It allows you to set the retention period of backups.
B. It remember the last backup command you used so that you can rescheule it easily.
C. It enables you to store your channel attribute settings in the Recovery catalog with each script.
D. It enables you to store the settings for channel attributes so that you do not have to specify
them in each backup o restore command
Answer: A, D
Explanation:
When implementing an RMAN-based backup strategy, you can use RMAN more effectively if you understand the more common options available to you. Many of these can be set in the RMAN environment on a persistent basis, so that you do not have to specify the same options every time you issue a command.
To simplify ongoing use of RMAN for backup and recovery, the RMAN lets you set a number of persistent configuration settings for each target database. These settings control many aspects of RMAN's behavior when working with that database, such as backup retention policy, default destinations for backups to tape or disk, default backup device type (tape or disk), and so on.
Reference:
Oracle(r) Backup and Recovery Basics 10g Release 2 (10.2), 3-7 and 3-8
Question 6.
You are using the Automatic Shared Memory Management configuration.
Which four initialization parameters will be tuned automatically?
A. LOG_BUFFER
B. DB_CACHE_SIZE
C. JAVA_POOL_SIZE
D. LARGE_POOL_SIZE
E. STREAMS_POOL_SIZE
F. DB_Nk_cache_size
G. Shared_pool_size
H. Db_keep_cache_size
I. DB_RECYCLE_CACHE_SIZE
Answer: B, C, D, G
Explanation:
ASMM will tune automatically Db_cache_size, Shared_pool_size, large_pool_size and Java_pool_size
Question 7.
You need to ensure that the database users should be able to use the various flashback query features in order to go back in time by four hours.
What would you do to achieve this?
A. set SQL_TRACE =True
B. set UNDO_RETENTION =14400
C. set FAST_START_MTTR_TARGET=240
D. set LOG_CHECKPOINT_INTERVAL= 240
E. set DB_FLASHBACK_RETENTION_TARGET= 14400
F. issue ALTER DATABASE FLASHBACK ON; command
G. set the RETENTION GUARANTEE clause for the undo table space
Answer: E, F
Question 8.
You executed the following command to drop a user;
DROP USER Scott CASCADE;
Which two statements regarding the above command are correct?
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 be scott are permanently dropped from the database
D. All 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.
Answer: B, C
Question 9.
Which four statements regarding the block change track file are correct?
A. The minimum size of this file is 10MB
B. The maintenance of this file is fully automatic.
C. The changed block are tracked in this file as redo is generated
D. The location of this file must be different from that of the database files.
E. The Oracle database records block change information in this file by default
F. The V$BLOCK_CHANGE_TRACKING view contains the name and location of this file.
Answer: A, C, E, F
Explanation:
A - True. Should say "start" not "minimum". The size of the change tracking file is proportional to the size of the database and the number of enabled threads of redo. The size is not related to the frequency of updates to the database. Typically, the space required for block change tracking is Overview of Reporting on Backups and the RMAN Repository approximately 1/30,000 the size of the data blocks to be tracked.
B - False. Using change tracking in no way changes the commands used to perform incremental backups, and the change tracking files themselves generally require little maintenance after initial configuration.
C - True. Changed blocks are tracked by the CTWR background process as redo is generated. Database incremental backup, automatically use the change tracking file;
D - False. You can also create the change tracking file in a location you choose yourself, using the following SQL statement:
SQL> ALTER DATABASE ENABLE BLOCK CHANGE TRACKING
USING FILE '/mydlr/rinan_change_track.fREUSE
E - True. One change tracking file is created for the whole database. By default, the change tracking file is created as an Oracle managed file in DB_CREATE_FILE_DEST.
F - True. From SQL*Plus, you can query V$BLOCK_CHANGE_TRACKING.STATUS to determine whether change tracking is enabled, and if it is, query V$BLOCK_CHANGE_TRACKING.FILENAME to display the filename.
Reference:
Oracle(r) Backup and Recovery Basics, 4-19, 4-20 and 4-21
Question 10.
What must you do to enable Automated SQL Execution Memory Management?
A. Execute the DBMS_STATS.GATHER_SYSTEM_STATES procedure with appropriate values
B. Set the instance parameters PGA_AGGREGATE_TARGET and WORKAREA_SIZE_POLICY
to appropriate values.
C. Set the instance parameters SORT_AREA_SIZE,BITMAP_MERGE_AREA_SIZE,
CREATE_BITMAP_AREA-SIZE,HASH_AREA_SIZE,SORT_AREA_SIZE, and
SORT_AREA_RETAINED_SIZE, all to Auto.
D. Unset the instance parameters SORT_AREA_SIZE, BITMAP_MERGE_AREA_SIZE,
CREATE_BITMAP_AREA_SIZE, HASH_AREA_SIZE,SORT_AREA_SIZE, and
SORT_AREA_RETAINED_SIZE.
Answer: B
Explanation:
The automatic SQL execution memory management feature is enabled by setting the parameter WORKAREA_SIZE_POLICY to AUTO and by specifying a size of PGA_AGGREGATE_TARGET in the initialization file.
Reference:
Meta link Note: 262946.1
Question 11.
When enabling a flashback, you must identify the version of the database contents you want to see.
Which two options can you use to identify this version? (choose two)
A. a point in time
B. a start and an end time
C. a start and an end SCN
D. a System Change Number (SCN)
E. a transaction ID
Answer: A, D
Question 12.
Identify four uses of the Oracle Scheduler. (choose four)
A. Enables you to set idle time limits for a resource plan.
B. Enables you to schedule job execution based on time
C. Enables you to execute jobs in a clustered environment
D. Enables you to assign priorities to the consumer groups
E. Enables you to map a consumer group to an Oracle user.
F. Enables you to create a job that makes use of saved program and schedules
Answer: B, C, D, F
Question 13.
You have 100 segments in the users table space. You get an alert that the users table space is running low on space.
You decide to shrink some segments. Which option would you use to determine which segments to shrink?
A. Segment Advisor
B. SQL Tuning Advisor
C. SQL Access Advisor
D. Segment Resource Estimation
E. Automatic Database Diagnostic Monitor
Answer: A
Explanation:
The Segment Advisor identifies segments that have space available for reclamation. It performs its analysis by examining usage and growth statistics in the Automatic Workload Repository (AWR), and by sampling the data in the segment. It is configured to run automatically at regular intervals, and you can also run it on demand (manually).
The regularly scheduled Segment Advisor run is known as the Automatic Segment Advisor.
Reference:
Oracle(r) 10g Administrator Guide, 14-16
Question 14.
You have three production databases HRDB, FINDB, and ORGDB, that use the same ASM instance. At the end of the day, you execute the following command on the ASM instance to shut down; SQL> shutdown immediate;
What is the result of executing this command?
A. All the instances, including the ASM instance, are shut down in the ABROT mode.
B. The ASM instance is shut down, but the other instances are still running
C. The ASM instance is still functional, but the other instances are shut down.
D. All the instances including the ASM instance, are shut in the IMMEDIATE mode.
E. HRDB, FINDB, and ORGDB instances are shut down in the ABORT mode and the ASM
instance is shut down in the IMMEDIATE mode.
F. HRDB, FIND, and ORGDB instances are shout down NORMAL mode and the ASM instance is
shut down in the IMMEDIATE mode.
Answer: D
Question 15.
Which two data types can be converted to LOBs using an ALTERMODIFY command?
A. raw
B. long
C. varchar
D. long raw
Answer: B, D
Question 16.
The application tables owned by the user TEST in a test database need to be exported to the APPS schema in the production database by using Data Pump.
Which option of Data Pump import would you use to accomplish this?
A. owner
B. touser
C. attach
D. fromuser
E. remap_schema
Answer: E
Explanation:
The REMAP_SCHEMA parameter changes the ownership of database objects. If you do not specify REMAP_SCHEMA, all database objects (such as tables and indexes) are created in the same user schema as in the source database, and those users must already exist in the target database. If they do not exist, then the import utility returns an error.
Reference:
Oracle(r) 10g Administrator Guide, 8-36
Question 17.
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. RMAN> BACKUP DURATION 2:00PARTIAL LOAD DATABASE;
B. RMAN> BACKUP DURATION 2:00PARTIAL FILESPERSET 1 DATABASE;
C. RMAN> BACKUP DURATION 2:00PARTIAL MINIMIZE TIME DATABASE;
D. RMAN> BACKUP AS COPY DURATION 2:00PARTIAL MINIMIZE LOAD DATABASE;
Answer: A
Explanation:
By default, when a BACKUP... DURATION command runs out of time before the backup completes, RMAN reports an error. (The effect of this is that if the command is running in a RUN block, the RUN block terminates.) You can control this behavior by adding the PARTIAL option to the BACKUP... DURATION command, as in this example:
BACKUP DURACTION 4:00 PARTIAL TABLESPACE user FILE ESPERSET1;
When PARTIAL is used, no error is reported when a backup command is interrupted due to the end of the backup window. Instead, a message showing which files could not be backed will be displayed. If the BACKUP command is part of a RUN block, then the remaining commands in the RUN block will continue to execute.
When using DURATION you can run the backup with the maximum possible performance, or run as slowly as possible while still finishing within the allotted time, to minimize the performance impact of backup tasks. To extend the backup to use the full time available, use the MINIMIZE LOAD option,
Reference:
Oracle(r) 10g Backup and Recovery Guide, 2-40 and 2-41
Question 18.
Which two statements regarding unusable indexes are correct?
A. You can set skip_UNUSABLE_INDEXES to true to skip unusable indexes
B. You can check the alert log file to get a message recorded about unusable indexes
C. You do not need to set any parameter because unusable indexes are skipped automatically
D. Your Data Definition Language statement shows a warning message when an index is made
unusable
Answer: A, B
Question 19.
What is the result of setting the CURSOR_SHARING = SIMILAR initialization parameter?
A. turn off all literal replacement for the shared cursor
B. causes the optimizer to share cursors for all statements
C. causes the optimizer to examine the statement of ensure cursor sharing occurs for safe literals
only
D. causes the optimizer to ignore all indexes and static's to establish the appropriate execution
path
Answer: C
Question 20.
If the database is showing degraded performance, which three charts on the Database Control Console Performance page will help you to resolve the problem? (Choose three)
A. overall availability chart
B. instance throughput chart
C. waiting and working sessions chart
D. host paging and run queue information chart
E. undo generation and table space usage chart
Answer: B, C, D
|
Question 1.
You work as the Exchange Administrator at ABC.com. The ABC.com network has an Exchange Server 2007 infrastructure. The network contains a mailbox named TestResources. At present all users are able to diarize appointments for TestResources. A new company policy states that only Kara Lang and Mia Hamm are permitted to diarize appointments for TestResources.
What actions must you take to comply with the ABC.com policy?
A. You should run the following cmdlet:
Set- MailboxCalendarSettings - Identity"TestResources" - MonthCalendar calendar = new
MonthCalendar(); KaraLang , MiaHamm.
B. You should run the following cmdlet:
Set-MailboxCalendarSettings - Identity " TestResources" - BookInPolicy KaraLang , MiaHamm
-AllBookInPolicy $false cmdlet.
C. You should run the following cmdlet:
Set - MonthCalendar calendar = new MonthCalendar(); “host.KaraLang , MiaHamm = calendar
" this.Content = host;.
D. You should run the following cmdlet:
Set - MonthCalendar calendar = new MonthCalendar();
HwndSource source = HwndSource.FromHwnd(calendar.Handle);
this.Content = calendar;Delegates KaraLang , MiaHamm.
Answer: B
Explanation:
Question 2.
You work as the Exchange Administrator at ABC.com. The ABC.com network has an Exchange Server 2007 environment. ABC.com has headquarters in London and branch offices in Paris and Berlin. The marketing department is located at the Paris office. The personnel in Paris connect to the network through the Internet and use Outlook Anywhere on their laptops. To ensure productivity management wants you to make sure that the marketing personnel have access to the companies' mailboxes.
What actions must you take?
A. You should utilize the Test- MAPIConnectivity and the Test- WebServicesConnectivity cmdlet.
B. You should utilize Get- Recipient – Filter cmdlet.
C. You should utilize Show-MailboxStatistics cmdlet.
D. You should utilize List-Mailbox cmdlet.
Answer: A
Explanation:
Question 3.
You work as the Exchange administrator at ABC.com. The ABC.com network has an Exchange Server 2007 environment. The ABC.com network has an Exchange Server 2007 environment. The Edge Transport Server role is installed on a server named ABC-EX01. Due to this server failure, you have decided to install a new Microsoft Windows Server 2003 server named ABCEX03 on the network with the reinstallation of the Edge Transport Server role. However, the address rewrites that was functional on ABC-EX01 did not in operation on ABC-EX03. This functionality is needed.
What actions must you take?
A. You should use the ImportEdgeConfig.ps1 on ABC-EX03.
B. You should use the iiscnfg/enable: application name check version.
C. You should use the Transaction Logs for sp_configure configuration.
D. You should use create a new Send connector on ABC-EX03.
Answer: A
Explanation:
Question 4.
You work as the Exchange administrator at ABC.com. ABC.com has headquarters in London and a branch office in Paris. The Exchange Server 2007 server in the London office is named ABCEX07 and the Exchange Server 2003 server in the London office is named ABC-EX08. You need to transfer the mailbox from ABC-EX07 to ABC-EX08.
What actions must you take?
A. You should include the IgnoreRuleLimitErrors parameter when using the Move-Mailbox
cmdlet.
B. You should use the System configuration data collector.
C. You should create a mapping schema definition.
D. You should enable the Windows Remote Management (WinRM).
Answer: A
Explanation:
Question 5.
You work as the Exchange administrator at ABC.com. ABC.com has its headquarters in Chicago and a branch office in Dallas. You are implementing a new Exchange Server 2007 Organization. The Exchange Server 2007 environment of ABC.com has the following server installed:
• An Edge Transport server named ABC-EX01
• A Hub Transport server named ABC-EX02.
During the course of the day you have received instruction from the CIO to have e-mail routing configured on ABC-EX01 and ABC-EX02. In your solution you need to ensure that ABC-EX01 is able to transmit e-mail messages to and from the Internet. You should also ensure that Internet email is sent to ABC-EX01 via ABC-EX02.
What actions must you take?
A. You should use the Microsoft System Center Configuration Manager (SCCM).
B. You should export a new Edge Subscription file to ABC-EX01 and Import the Edge
Subscription file to ABC-EX02.
C. You should use the Microsoft System Center Operations Manager (SCOM).
D. You should use the Microsoft Exchange Internet Message Access Protocol, Version 4
(IMAP4).
Answer: B
Explanation:
Question 6.
You work as the Exchange administrator at ABC.com. The ABC.com network has an Exchange Server 2007 environment. You were compelled to restore the directory objects and settings from a backup. However, after the restoration a number of employees reported that they are unable to access their mailboxes that were assigned to them before the backup was made. The employees need to access their mailboxes.
What actions must you take?
A. You should use the Get-Mailbox cmdlet.
B. You should use the Get-MailboxInformation cmdlet.
C. You should use the Connect-Mailbox cmdlet.
D. You should use the Show-Information cmdlet.
Answer: C
Explanation:
Question 7.
You work as the Exchange administrator at ABC.com. The ABC.com network has an Exchange Server 2007 environment. During routine maintenance of the Exchange server you discover that the storage limits are all different in the mailboxes.
What actions must you take to ensure that the storage limits to be the same?
A. You should use the Get-MailboxStatistics cmdlet and forward it to the Get-Mailbox cmdlet.
B. You should use the Show-MailboxStatistics cmdlet and forward it to the Select-Object cmdlet.
C. You should use the Get-MailboxInformation cmdlet and forward it to the Select-Object cmdlet.
D. You should create an Exchange Management Shell script and forward the Get-Mailbox
Database cmdlet output to the Set-Mailbox Database cmdlet.
Answer: D
Explanation:
Question 8.
You work as the Exchange administrator at ABC.com. The ABC.com network has an Exchange Server 2007 environment. The ABC.com network contains a stand-alone server named ABCSR09. Your boss, Tess King, wants to know which Exchange Server 2007 server role can ABC-SR09 support.
What would you reply?
A. It can support the Terminal Service Session Broker (TS Session Broker) role.
B. It can support the Edge Transport server role.
C. It can support the PDC emulator role.
D. It can support the Exchange Recipient Administrators role.
Answer: B
Explanation:
Question 9.
You work as the Exchange Administrator at ABC.com. The ABC.com network has an Exchange Server 2007 infrastructure that has two Client Access Servers with load balancing. The employees on the intranet has 24/7 access to data when utilizing Outlook Anywhere. During the course of the day you have received instruction from the CIO to ensure that the employees who connect to the Exchange infrastructure via the IUnernet also have access to data 24/7.
What actions must you take?
A. You should enable the Microsoft Exchange Information Store.
B. You should enable the Microsoft Exchange Search Service.
C. You should set the external URL on every Client Access Server.
D. You should enable the Microsoft Exchange File Distribution service.
Answer: C
Explanation:
Question 10.
You work as the Exchange administrator at ABC.com. The ABC.com network has an Exchange Server 2007 environment. You have received several complaints from employees in various departments stating that e-mail messages are ending up in their Junk E-mail folder even though the sender’s e-mail address is on their Safe Senders List. You need to ensure that the employees' Safe Senders Lists are used.
What actions must you take?
A. You should modify the SMTP Send connectors.
B. You should utilize the Get-Mailbox cmdlet.
C. You should utilize the Show-Information cmdlet.
D. You should utilize the Update-SafeList cmdlet on each mailbox.
Answer: D
Explanation:
Copyright © 2004 CertsBraindumps.com Inc. All rights reserved.