2016 June Oracle Official News: 1Z0-052 Oracle Database 11g: Administration I Exam Questions New Updated Today! Free Download 1Z0-052 PDF and VCE Dumps 261Q&As in Braindump2go.com! 100% Exam Pass Guaranteed!
NEW QUESTION 41 – NEW QUESTION 50:
QUESTION 41
Which two operations can be performed on an external table? (Choose two.)
A. Create a view on the table
B. Create an index on the table
C. Create a synonym on the table
D. Add a virtual column to the table
E. Update the table using the UPDATE statement
F. Delete rows in the table using the DELETE command
Answer: AC
QUESTION 42
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 43
Which three statements are correct about temporary tables? (Choose three.)
A. Indexes and views can be created on temporary tables.
B. Both the data and the structure of temporary tables can be exported.
C. Temporary tables are always created in a user’s temporary tablespace.
D. The data inserted into a temporary table in a session is available to other sessions.
E. Data manipulation language (DML) locks are never acquired on the data of temporary tables.
Answer: ACE
QUESTION 44
You set the following parameters in the parameter file and restarted the database:
MEMORY_MAX_TARGET=0
MEMORY_TARGET=500M
PGA_AGGREGATE_TARGET=90M
SGA_TARGET=270M
Which two statements are true about these parameters after the database instance is restarted?
(Choose two.)
A. The MEMORY_MAX_TARGET parameter is automatically set to 500 MB.
B. The PGA_AGGREGATE_TARGET and SGA_TARGET parameters are automatically set to zero.
C. The value of the MEMORY_MAX_TARGET parameter remains zero until it is changed manually.
D. The lower bounds of PGA_AGGREGATE_TARGET and SGA_TARGET parameters are set to 90
MB and 270 MB, respectively.
Answer: AD
QUESTION 45
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 opened.
4. Instance recovery is started.
5. Background processes are started.
6. Data file headers 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
QUESTION 46
A user, who is authenticated externally, logs in to a remote machine and connects to the database instance. What action would you take to ensure that a user cannot connect to the database instance by merely logging in to a remote machine?
A. Set REMOTE_OS_ROLES to FALSE
B. Set OS_ROLES parameter to FALSE
C. Set the REMOTE_OS_AUTHENT parameter to FALSE
D. Set the REMOTE_LOGIN_PASSWORD_FILE parameter to NONE
Answer: C
QUESTION 47
Which two statements are true about setting the FAST_START_MTTR_TARGET initialization parameter to a nonzero value? (Choose two.)
A. The MTTR advisor will be disabled
B. Automatic checkpoint tuning will be enabled
C. The value for the LOG_CHECKPOINT_INTERVAL initialization parameter will be override the value
for FAST_START_MTTR_TARGET
D. The time taken to recover the instance after the crash is always exactly the same as the value given
for the FAST_START_MTTR_TARGET initialization parameter
Answer: BC
QUESTION 48
You want to create a role to meet these requirements:
1. The role is to be protected from unauthorized usage.
2. The password of the role is not to be embedded in the application source code or stored in a table.
Which method would you use to restrict enabling of such roles?
A. Create the role with external authentication.
B. Create the role as a secure application role.
C. Create the role as a password-protected role.
D. Create a role and use Fine-Grained Access Control (FGAC) to secure the role.
Answer: B
QUESTION 49
View the Exhibit and identify the component marked with a question mark.
A. Checkpoint (CKPT)
B. Process Monitor (PMON)
C. Archiver Processes (ARcn)
D. Recoverer Process (RECO)
E. Memory Manager Process (MMAN)
Answer: A
QUESTION 50
Note the following points describing various utilities in Oracle Database 11g:
1. It enables the 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 tables of an Oracle Database
4. It provides a tape backup management for the Oracle ecosystem
Which point describes the Oracle Data Pump utility?
A. 1
B. 2
C. 3
D. 4
E. 1 and 3
F. 1, 2, 3 and 4
Answer: A
2016 Valid Oracle 1Z0-052 Exam Study Materials:
1.| Latest Oracle 1Z0-052 Exam PDF and VCE Dumps 261q from Braindump2go: http://www.braindump2go.com/1z0-052.html [100% Exam Pass Guaranteed!]
2.| New Oracle 1Z0-052 Exam Questions and Answers – Google Drive: https://drive.google.com/folderview?id=0B75b5xYLjSSNT1YxVElVOWxKbmM&usp=sharing
MORE Practice is the Most Important IF You want to PASS Oracle 1Z0-052 Exam 100%!
————— Braindump2go.com
————— Pass All IT Exams at the first Try!