Are u looking to Pass your Certification Exam? Then you have came to the right place here you will find real exam questions of any exam taken from the testing center and aslo links to sites that sell them. So now passing your certification exam has become much easier than before all you have to do is memorize the questions you will see exactly the same questions in the real exam. In today world time is money so by this not only you save time plus you aslo save yourself the hassale of failing
Download Pass4sure Oracle 1Z0-206 Dumps from the link below
Download CertifyMe Oracle 1Z0-206 Dumps from the link below
Download Testking Oracle 1Z0-206 Dumps from the link below
PrepKing.com Oracle 1Z0-206 Sample Questions
Download Pass4sure Oracle 1Z0-110 Dumps Dumps from the link below
Download CertifyMe Oracle 1Z0-110 Dumps Dumps from the link below
Download Testking Oracle 1Z0-110 Dumps Dumps from the link below
PrepKing.com Oracle 1Z0-110 Dumps Sample Questions
Download Pass4sure Oracle 1Z0-109 Dumps from the link below
Download CertifyMe Oracle 1Z0-109 Dumps from the link below
Download Testking Oracle 1Z0-109 Dumps from the link below
PrepKing.com Oracle 1Z0-109 Sample Questions
Download Pass4sure Oracle 1Z0-144 Dumps from the link below
Download CertifyMe Oracle 1Z0-144 Dumps from the link below
Download Testking Oracle 1Z0-144 Dumps from the link below
PrepKing.com Oracle 1Z0-144 Sample Questions
Download Pass4sure Oracle 1Z1-054 Dumps from the link below
Download CertifyMe Oracle 1Z1-054 Dumps from the link below
Download Testking Oracle 1Z1-054 Dumps from the link below
PrepKing.com Oracle 1Z1-054 Sample Questions
Exam : Oracle 1Z1-054
Title : Oracle Database 11g: Performance Tuning
1. View the Exhibit exhibit1 to examine the series of SQL commands and parameter settings.
View the Exhibit exhibit2 to examine the plans available in the SQL plan baseline.
The first plan (in red) is created when OPTIMIZER_MODE is set to ALL_ROWS and the second plan (in blue) is created when OPTIMIZER_MODE is set to FIRST_ROWS.
Which SQL plan baseline would be used if the SQL query in exhibit1 is executed again when the value of OPTIMIZER_MODE is set to FIRST_ROWS?
A. the second plan, because it is a fixed plan
B. the first plan, because it is an accepted plan
C. the second plan, because it is the latest generated plan in FIRST_ROW mode
D. A new plan, because the second plan in FIRST_ROW mode is not an accepted plan
Answer: B
2. View the Exhibit and examine a portion of the output obtained from the following query:
SQL> SELECT * FROM v$sys_time_model;
Select three correct interpretations of the time model statistics. (Choose three.)
A. DB time includes the wait time of all the nonidle and idle user sessions.
B. SQL execute elapsed time includes the time spent in performing fetches of query results.
C. DB CPU includes the CPU time spent on database user-level calls and background CPU time.
D. SQL execute elapsed time includes components of the hard parse elapsed time like bind elapsed time.
E. DB time includes the connection management call elapsed time excluding the background process time.
Answer: BDE
3. You are working on a development database that was upgraded to Oracle Database 11g from Oracle Database 9i. An ADDM finding in this database says that the shared pool is inadequately sized, as shown in the Exhibit.
You diagnosed that this is due to different kinds of workloads and this occurs only during peak hours. You tried to resize this by shrinking the database buffer cache but that caused inadequate buffer cache problems. The following are the related parameter settings:
SQL> show parameter sga
name TYPE VALUE
—————————— ————— —————–
lock_sga boolean FALSE
pre_page_sga boolean FALSE
sga_max_size big integer 300M
sga_target big integer 0
SQL> show parameter target
name TYPE VALUE
—————————— ————— —————–
…..
fast_start_mttr_target integer 0
memory_max_target big integer 0
memory_target big integer 0
pga_aggregate_target big integer 100M
sga_target big integer 0
You want to balance the memory between the System Global Area (SGA) components within SGA without affecting the size of the Program Global Area (PGA).
Which action would solve this problem?
A. Set the SGA_TARGET parameter to 300M.
B. Set the SGA_MAX_SIZE parameter to 400M.
C. Set the MEMORY_TARGET parameter to 100M.
D. Set the MEMORY_MAX_TARGET parameter to 300M.
Answer: A
4. You are working on an online transaction processing (OLTP) system. You detected free buffer waits events for your database instance running in a machine that has multiple CPUs. You increased the database buffer cache size as the first step. After a few hours of work on the database, further investigation shows that the same event is being recorded.
What would be your next step to avoid this event in future?
A. Decrease the value of the DBWR_IO_SLAVES parameter.
B. Set the USE_INDIRECT_DATA_BUFFERS parameter to TRUE.
C. Increase the value of the DB_WRITER_PROCESSES parameter.
D. Increase the value of the DB_FILE_MULTIBLOCK_READ_COUNT parameter.
Answer: C
5. You observed that some of the queries are performing poorly on the SALES_RECORDS table in your database.
On further investigation, you find that at the end of each day the contents of the SALES_RECORDS table are transferred to the SALES table and deleted from the SALES_RECORDS table. The deleted operations cause the table to be sparsely populated.
You decided to use the ALTER TABLE…SHRINK SPACE COMPACT command to shrink the table.
Why would you choose this method? (Choose all that apply.)
A. because it can be used during peak hours
B. because it avoids unnecessary cursor invalidation
C. because it adjusts the high-water mark (HWM) immediately
D. because you have long-running queries that might span the shrink operation
E. because it does not allow any data manipulation language (DML) operations, thereby making the shrink operation faster
Answer: ABD
6. A batch workload that historically completed in the maintenance window between 10:00 PM and midnight is currently showing poor performance and completing at 2 AM.
To help in the diagnosis of the performance degradation, the senior DBA in your organization asks you to execute the awrddrpt.sql script to produce a Compare Periods report.
Which two statements are true about the report produced by this script? (Choose two.)
A. It is refreshed automatically based on the moving window baseline.
B. It compares details between any two selected time periods of the same duration.
C. It normalizes the statistics by the amount of time spent on the database for each time period.
D. It compares details between two consecutive time periods of the same or different durations and is refreshed every 60 minutes.
Answer: BC
7. You work as a DBA for a company and you have the responsibility of managing one of its online transaction processing (OLTP) systems. The database encountered performance-related problems and you generated an Automatic Workload Repository (AWR) report to investigate it further.
View the Exhibits and examine the AWR report.
What could be the problem in this database?
A. Java pool is not configured.
B. The CPU in the system is slow.
C. The shared pool size is inadequate.
D. The database buffer cache is inadequate.
E. The OPEN_CURSORS parameter is set to a small value.
Answer: C
8. After running SQL Performance Analyzer (SPA), you observe a few regressed SQL statements in the SPA output. Identify the two actions that you would suggest for these regressed SQL statements. (Choose two.)
A. Running SQL Access Advisor
B. Adding them to SQL Plan Baseline
C. Submitting them to SQL Tuning Advisor
D. Running Automatic Database Diagnostic Monitor (ADDM)
Answer: BC
Download Pass4sure Oracle 1z1-052 Dumps from the link below
Download CertifyMe Oracle 1Z1-052 Dumps from the link below
Download Testking Oracle 1Z1-052 Dumps from the link below
PrepKing.com Oracle 1Z1-052 Sample Questions.
Exam : Oracle 1Z1-052
Title : Oracle Database 11g: Administrator I
1. Note the following points describing various utilities in Oracle Database 11g:
1: It enables the high-speed transfer of data from one database to another.
2: It provides a complete solution for the backup, restoration, and recovery needs of the entire database.
3: It enables the loading of data from an external file into an Oracle database.
4: It provides a tape backup management for the Oracle ecosystem.
Which point describes Oracle Secure Backup?
A.1
B.2
C.3
D.4
E.1, 2, and 4
F.1, 2, 3, and 4
Answer: D
2. Which two statements are true about the Automatic Workload Repository (AWR)? (Choose two.)
A.All AWR tables belong to the SYSTEM schema.
B.The AWR contains systemwide tracing and logging information.
C.The snapshots collected by the AWR are accessible through data dictionary views.
D.The snapshots collected by the AWR are used by self-tuning components in the database.
Answer: CD
3. Observe the information in the columns:
1: The SGAa. Text and parsed forms of all SQL statements
2: The cursor stateb. Run-time memory values for the SQL statement, such as rows retrieved
3: User-session datac. Security and resource usage information
4: The stack spaced. Local variables for the process
Which option has the correct match between the memory areas and their contents?
A.1-c, 2-b, 3-d, 4-a
B.1-c, 2-b, 3-d, 4-a
C.1-a, 2-b, 3-c, 4-d
D.1-a, 2-b, 3-d, 4-c
Answer: C
4. The database instance is currently using SPFILE. View the Exhibit and examine the error that you received while running the DB Structure Integrity check.
Given below are the steps to recover from the error in random order:
1: Shut down the instance, if not already done.
2: Copy one of the remaining control files to a new location.
3: Change the value of the CONTROL_FILES initialization parameter to correspond to the new location of the control files.
4: Start up the database instance to the NOMOUNT stage.
5: Recover the database to the point of failure of the control file.
6: Open the database.
Identify the correct sequence of steps?
A.1, 2, 4, 3, 5, 6
B.2, 4, 3, 5, 6; 1 not required
C.4, 5, 6, 2, 3; 1 not required
D.5, 2, 3, 4; 1 and 6 not required
Answer: A
5. You have issued a SHUTDOWN ABORT command to bring down your database instance. Consider the steps that will be performed later when you open the database:
1: SGA is allocated.
2: Control file is read.
3: Redo log files are read.
4: Instance recovery is started.
5: Background processes are started.
6: Data files are checked for consistency.
7: Server parameter file or the initialization parameter file is read.
Which option has the correct order in which these steps occur?
A.7, 1, 5, 2, 3, 6, 4
B.1, 2, 3,7, 5, 6, 4
C.7, 1, 4, 5, 2, 3, 6
D.1, 7, 5, 4, 2, 3, 6
Answer: A
6. View the Exhibit and examine the attributes of an undo tablespace.
In an OLTP system, the user SCOTT has started a query on a large table in the peak transactional hour that performs bulk inserts. The query runs for more than 15 minutes and then SCOTT receives the following error:
ORA-01555: snapshot too old
What could be the reason for this error?
A.The query is unable to get a read-consistent image.
B.There is not enough space in Flash Recovery Area.
C.There is not enough free space in the flashback archive.
D.The query is unable to place data blocks in undo tablespace
Answer: A
7. While observing the index statistics, you find that an index is highly fragmented, thereby resulting in poor database performance. Which option would you use to reduce fragmentation without affecting the users who are currently using the index?
A.Validate the index structure using the ANALYZE…INDEX command.
B.Rebuild the index using the ALTER INDEX..REBUILD ONLINE command.
C.Change the block space utilization parameters using the ALTER INDEX command.
D.Deallocate the unused space in the index using the ALTER INDEX..DEALLOCATE UNUSED command.
Answer: B
8. Your test database is running in NOARCHIVELOG mode. Which statement is true regarding the type of backups that can be performed on the database?
A.You can perform online whole database backups.
B.You can perform offline whole database backups.
C.You cannot perform schema-level export/import operations.
D.You can perform the backup of only the SYSTEM tablespace when the database is open.
Answer: B
Download Pass4sure Oracle 1Z1-051 Dumps from the link below
Download CertifyMe Oracle 1Z1-051 Dumps from the link below
Download Testking Oracle 1Z1-051 Dumps from the link below
Download Pass4sure Oracle 1Z1-403 Dumps from the link below
Download CertifyMe Oracle 1Z1-403 Dumps from the link below
Download Testking Oracle 1Z1-403 Dumps from the link below
PrepKing.com Oracle 1Z1-403 Sample Questions
Exam : Oracle 1Z1-403
Title : Enterprise Linux System Administration
1. While importing user accounts in bulk along with passwords using the newusers command, you noticed that user passwords are saved in the /etc/shadow file in the crypt format.
How would you enable the newusers command to use the preferred MD5 format when writing passwords to the /etc/shadow file?
A. Add the MD5_ENAB=yes line to the /etc/login.defs file.
B. Add the MD5_CRYPT yes line to the /etc/login.defs file.
C. Add the MD5_CRYPT_ENAB yes line to the /etc/login.defs file.
D. Add the MD5_CRYPT_ENAB yes line to the /etc/security/limits.conf file.
Answer: C
2. You have the default syslogd configuration in your system. You plugged in a USB keydrive into the system.
Which command would help you to find the bus and the device number of the keydrive?
A. lsusb
B. lsmod
C. insmod
D. cat /proc/self/mounts
Answer: A
3. As an administrator, you execute the following command to verify the integrity of mysql:
[root@server1]#rpm -Va mysql
S.5….T c /etc/my.cnf
What attributes of the /etc/my.cnf file have changed?
A. The permissions, user ownership, and file type have changed.
B. The permissions, group ownership, and file type have changed.
C. The user ownership, group ownership, and file type have changed.
D. The MD5 signature, file size, and modification time have changed.
Answer: D
4. You have written a udev rule as shown below:
KERNEL==”fb[0-9]*”, NAME=”fb/%n”, SYMLINK+=”%k”, GROUP=”video”
KERNEL==”fd[0-9]*”, OWNER=”john”
Which two statements are true? (Choose two.)
A. The user john would own all the floppy devices.
B. The user john would own all the floppy and frame buffer devices.
C. The video group on the system would own all the floppy devices.
D. The video group on the system could be controlled by john only.
E. The video group on the system would own all the frame buffer devices.
Answer: AE
5. You have bound your system to the Network Information Service (NIS) domain ORACLE and all client-side configurations are done. The users report a problem that they are not able to log in through NIS accounts, whereas local users are successfully authenticated, after the system reboots.
As a Linux administrator, you executed the nisdomainname command and you get the output “(none)”, and no traces of yp are found in the /var/log/messages file.
What would you do to resolve this error? (Choose all that apply.)
A. Re-create the NIS domain on the server that runs the NIS domain ORACLE.
B. Restart the ypserv service on the server that runs the NIS domain ORACLE.
C. Restart the network service on the server that runs the NIS domain ORACLE.
D. Use the chkconfig command to set the ypbind service to be on at the desired runlevels.
E. Use the ntsysv command to select the ypbind service to be automatically started with the desired runlevels.
Answer: DE
6. You have trouble in booting the Linux system and want to troubleshoot it. To find the cause, you want to make the kernel start the bash program in place of init.
What would you do to achieve this objective? (Choose all that apply.)
A. Pass S as the kernel parameter to the grub menu.
B. Pass 1 as the kernel parameter to the grub menu.
C. Pass init=/bin/bash as the kernel parameter to the grub menu.
D. Pass INIT=/sbin/bash as the kernel parameter to the grub menu.
Answer: C
7. You want to install the ieee80211 module on your Linux system. While building the module, you receive the following error:
Make [2]: *** [ieee 80211-1.2.17/ieee80211_module.o] Error 1
Make [1]: *** [_module_/ieee80211-1.2.17] Error 2
Make [1]: Leaving directory ‘/usr/src/kernels/2.6.9-42.0.0.0.1.EL-i686′
Make: *** [modules] Error 2
What do you infer from this error?
A. The ieee80211 module conflicts with the current kernel version.
B. The dependency modules for ieee80211 are not installed on the system.
C. The ieee80211 module given is not supported by the machine architecture.
D. The kernel source package, which must be installed to compile external device drivers, is not installed on the system.
Answer: D
8. You are logged in to server1 and want to allow remote connections to server1 through X Display Manager Control Protocol (XDMCP). You change the entry “Enable=false” to “Enable=true” in the “[xdmcp]” section of the gdm.conf configuration file.
To test the XDMCP configuration, you log in to station1 as smith and try to connect to server1 by using the following command:
[smith@station1]$ X -query server1.example.com :1
What is the result?
A. A connection to the gdm display manager on server1.example.com would be established using direct XDMCP.
B. A connection to the xdm display manager on server1.example.com would be established using direct XDMCP.
C. A connection to the gdm display manager on server1.example.com would be established using indirect XDMCP.
D. A connection to the xdm display manager on server1.example.com would be established using indirect XDMCP.
Answer: A
Download Pass4sure Oracle 1z0-053 Dumps from the link below
Download CertifyMe Oracle 1z0-053 Dumps from the link below
Download Testking Oracle 1z0-053 Dumps from the link below
PrepKing.com Oracle 1z0-053 Sample Questions
Download Pass4sure Oracle 1Z0-041 Dumps from the link below
Download CertifyMe Oracle 1Z0-041 Dumps from the link below
Download Testking Oracle 1Z0-041 Dumps from the link below
PrepKing.com Oracle 1Z0-041 Sample Questions
