PassLeader now are offering 100% pass ensure 1Z0-052 dumps! All 1Z0-052 exam questions have been updated with correct answers, welcome to download the newest PassLeader 1Z0-052 VCE dumps and PDF dumps: http://www.passleader.com/1z0-052.html (261 Q&As)
BTW: Download PassLeader 1Z0-052 dumps from Google Drive for free: https://drive.google.com/open?id=0B-ob6L_QjGLpaXlIQVBWWmRoa1U
QUESTION 101
Which three statements are true about logical structures of the Oracle database? (Choose three.)
A. Each segment contains one or more extents.
B. Multiple tablespaces can share a single data file.
C. A data block is the smallest unit of input/output (I/O) in data files.
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 operating system block.
Answer: ACD
QUESTION 102
You are managing an Oracle Database 11g database. You configured the database to run in ARCHIVELOG mode. Which two statements are true in this scenario? (Choose two.)
A. You must shut down the database instance to perform the backups.
B. You must configure the Flash Recovery Area (FRA) for the database.
C. You can perform complete database backups without closing the database.
D. All the previous closed database backups including control files become invalid afteryou configure the database to ARCHIVELOG mode.
Answer: CD
QUESTION 103
View the Exhibit to examine the output of the DBA_OUTSTANDING_ALERTS view. After 30 minutes, you executed the following command:
What could be the reason for the elimination of the other rows in the output?
A. An Automatic Workload Repository snapshot has been taken recently.
B. The non-threshold-based alerts are transferred to DBA_ALERT_HISTORY.
C. The threshold alerts conditions are cleared and the alerts are transferred to BA_ALERT_HISTORY.
D. The threshold alerts related to database metrics are permanently stored in DBA_ALERT_HISTORY but not the threshold alerts related to instance metrics.
Answer: C
QUESTION 104
Which two statements are true regarding listeners? (Choose two.)
A. Listeners use only the TCP/IP protocol.
B. Multiple listener processes can run simultaneously on a host.
C. Multiple database instances can be registered with a single listener.
D. The listener-related errors can be traced only at the administrative level.
E. Only one database instance can be registered with a single listener at any time.
Answer: BC
QUESTION 105
You have two database servers SEMP and SACCT. The database in the SEMP server maintains the employee information and the database in the SACCT server maintains the accounts payable information. The employees submit the expense reports to the accounts payable department. A user of the accounts payable database wants to extract the employee information from the database in the SEMP server for crossverification. Which schema object enables the user to access the information from the remote database?
A. Cluster
B. Database link
C. Mapping table
D. Materialized view
Answer: B
QUESTION 106
In a new installation of Oracle Database 11g, you perform these activities:
1. Organize software and data on different subdirectories to avoid poor performance.
2. Use consistent naming conventions for database files.
3. Separate administrative information pertaining to the database in different directories.
Which option corresponds to the type of activities you performed?
A. Oracle Managed Files
B. Oracle Grid Architecture
C. Optimal Flexible Architecture
D. Oracle database architecture
E. Automatic Storage Management
Answer: C
QUESTION 107
You configured the Flash Recovery Area (FRA) for your database. The database instance is running in ARCHIVELOG mode. The default location for the archived redo log files is the Flash Recovery Area. Which two files are removed automatically if the space is required in the FRA as per the retention policy? (Choose two.)
A. Flashback log files
B. Backups that have become obsolete
C. User managed backups of the data files and control files
D. Archived redo log files that have multiple copies in a different archive location and not backed up
Answer: AB
QUESTION 108
All the database users are presently connected to the database instance and working. The HR user has opened three database sessions and executed the following command in one of his sessions:
SQL> UPDATE persons SET ccode=’U031′ WHERE ccode=’U029′;
123 rows updated.
SQL> DELETE FROM persons WHERE exp=’Y’;
3 rows deleted.
The SYS user opens a new session after HR executed the above commands. Which sessions can see the effect of the UPDATE and DELETE commands?
A. All sessions of the HR user only
B. All sessions of the HR user and the SYS user
C. The session of the HR user that executed the commands
D. All the sessions for which the database users have access privilege to the PERSONS table
Answer: C
QUESTION 109
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
QUESTION 110
The user HR receives the following error while inserting data into the TTK table:
ERROR at line 1:
ORA-01653: unable to extend table HR.TTK by 128 in tablespace SMD
Upon investigation, you find that SMD is a small file tablespace. Which three action would allow the user to insert data? (Choose three.)
A. Add a data file to the SMD tablespace.
B. Add a data file to the temporary tablespace associated with the user HR.
C. Resize the data file associated with the SMD tablespace to make it larger.
D. Alter the data file associated with the SMD tablespace to grow automatically.
E. Change the segment space management for the SMD tablespace to automatic.
Answer: ACD
QUESTION 111
Which two statements are true about checkpointing? (Choose two.)
A. The checkpoint frequency decreases with the smaller redo log file size.
B. It ensures that all committed data is written to the data files during normal shutdown.
C. The frequent full checkpoint in a database can cause the overall degradation of the database performance.
D. It prompts the Checkpoint (CKPT) process to write data to the data files and redo information to the online redo log files.
Answer: BC
QUESTION 112
Which two statements are true regarding the Oracle Data Pump export and import operations? (Choose two.)
A. You cannot export data from a remote database.
B. You can rename tables during an import operation.
C. You can overwrite existing dump files during an export operation.
D. You can compress the data during export but not the metadata because it is not supported.
Answer: BC
QUESTION 113
View the Exhibit. You are creating an additional database by using the Database Configuration Assistant (DBCA). You opted to create a General Purpose database and during the database creation realize that the Block Size field is not enabled. What could be the reason for this?
A. You have chosen the File System option as the storage option.
B. You have chosen the Automatic Storage Management (ASM) as the storage option.
C. The data block size can be increased only when DBCA is invoked from Oracle Universal Installer (OUI).
D. You are using General Purpose template and not the Custom Database template to create the database.
Answer: D
QUESTION 114
Your database is functional with a peak load for the last one hour. You want to preserve the performance statistics collected during this period to be used for comparison when you analyze the performance of the database in the future. What action would you take to achieve this task?
A. Insert finding directives for ADDM tasks in the future.
B. Create a baseline on a pair of snapshots spanning the peak-load period.
C. Decrease the snapshot interval in the AWR to collect more snapshots during the peakload period.
D. Set the snapshot retention period in the Automatic Workload Repository (AWR) to zero to avoid automatic purging of snapshots.
Answer: B
QUESTION 115
Which of these is true about undo tablespace?
A. Undo tablespace is a temporary tablespace
B. Undo tablespace has only one datafile
C. Undotablespace has a datafile which is reused in cyclic manner
Answer: A
QUESTION 116
Your database is in shutdown state. What will happend if you issue next command:
SQL> startup
A. instance will started
B. instance started and DB is mounted
C. instance started, DB opened and finally mounted
D. instance started, DB mounted and finally opened
Answer: D
QUESTION 117
Which two statements are true about standard database auditing? (Choose two.)
A. DDL statements can be audited.
B. Statements that refer to standalone procedure can be audited.
C. Operations by the users logged on as SYSDBA cannot be audited.
D. Only one audit record is ever created for a session per audited statement even though it is executed more than once.
Answer: AB
QUESTION 118
View Exhibit to examine the current memory allocation and parameter settings, respectively. Why are advisors not available for the shared pool and the buffer cache?
A. because the DB_CACHE_ADVICE parameter is set to OFF
B. because Automatic Memory Management (AMM) is disabled for the database instance
C. because Automatic Shared Memory Management (ASMM) is enabled for the database instance
D. because the values for the DB_CACHE_SIZE and SHARED_POOL_SIZE parameters were not set initially
Answer: C
QUESTION 119
You receive complaints from users regarding the high waiting time for their transactions. On investigation, you find that some users are not committing their transactions though they are not performing any activity for a long time. As a result, SQL statements need to wait for rowlevel locks. Which two actions could you take to prevent this locking problem in the future? (Choose two.)
A. Decrease the IDLE_TIME resource limit in the profile assigned to the blocking users.
B. Use Database Resource Manager to automatically log out sessions that block others and are idle.
C. Set the limit in the profile of blocking users to control the number of blocks to be accessed in a session.
D. Decrease the maximum number of interested transaction list (ITL) slots for the segments on which the blocking user performs the transaction.
Answer: AB
QUESTION 120
A database user SMITH tries to query the V$SESSION view and fails to access it as follows:
Which are the two possible solutions to enable SMITH to query the data in V$SESSION? (Choose two.)
A. granting SELECT privilege to SMITH on V$SESSION
B. granting SELECT privilege to SMITH on V_$SESSION
C. asking the user SMITH to run the catalog.sql script
D. granting SELECT privilege to SMITH on V$FIXED_TABLES
E. setting the O7_DICTIONARY_ACCESSIBILITY parameter to TRUE
F. creating a view based on V$SESSION and granting SELECT privilege to SMITH on the view that was created
Answer: BF
PassLeader now are offering 100% pass ensure 1Z0-052 dumps! All 1Z0-052 exam questions have been updated with correct answers, welcome to download the newest PassLeader 1Z0-052 VCE dumps and PDF dumps: http://www.passleader.com/1z0-052.html (261 Q&As)
BTW: Download PassLeader 1Z0-052 dumps from Google Drive for free: https://drive.google.com/open?id=0B-ob6L_QjGLpaXlIQVBWWmRoa1U