Upgrade to remove ads
Oracle Database Administration 1Z0-052
Terms in this set (20)
Which two statements are true regarding the usage of the SQL*Loader utility?
A. You can load data into multiple tables during the same load session.
B. You can load data from multiple files to a table during the same load session.
C. You cannot perform selective data loading based on the values available in the records.
D. You can use an export file generated by the EXPDP utility as an input data file to load the
E. You can load data only if the input file is available on the disk and tape but not in a named
Answer: A, B
The instance abnormally terminates because of a power outage. Which statement is true about
redo log files during instance recovery?
A. Inactive and current redo log files are required to accomplish recovery.
B. Online and archived redo log files are required to accomplish instance recovery.
C. All redo log entries after the last checkpoint are applied from redo log files to data files.
D. All redo log entries recorded in the current redo log file until the checkpoint position are applied
to data files.
SGA and PGA?
SGA: System global area. The block of shared memory that contains the memory structures that make up an Oracle instance.
PGA: Program global area. The variable-sized block of memory used to maintain the state of a database session. PGAs are private to the session and controlled by the session's server process.
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
You want to create a tablespace to contain objects with block size 16 KB. But while configuring
the storage you find that the block size that you can provide is only 8 KB. Which configuration
could have enabled the block selection of 16 KB?
A. Choosing the extent allocation type to uniform
B. Choosing the Segment Space Management option to manual
C. Setting autoextension on for the data file mentioned for the tablespace
D. setting the DB_16K_CACHE_SIZE parameter for the database instance to a nonzero value
To make audit information more productive, the DBA executes the following command before
starting an audit operation:
SQL> ALTER SYSTEM SET AUDIT_TRAIL=DB,EXTENDED SCOPE=SPFILE;
Which statement is true regarding the audit record generated when auditing starts after restarting
A. It contains only the plan for the SQL statement executed by the user.
B. It contains the SQL text executed by the user and the bind variables used with it.
C. It contains the plan and statistics associated with the SQL statement executed by the user.
D. It contains the plan for the SQL statement executed by the user and the bind variables used
Which two statements about the background process of the database writer
are true? (Choose two.)
A. It is possible to have multiple database writers in an Oracle instance.
B. It writes dirty buffers, if any, to data files whenever a checkpoint occurs.
C. It writes dirty buffers, if any, to data files whenever a transaction commits.
D. It writes dirty buffers, if any, to data files before the log writer (LGWR) writes.
Answer: A, B
The TRANS_SUMMARY table contains product-wise transaction details that get updated with
every transaction in the system. Each row has cumulative transaction details of a single product
and every product is identified by a product code, which is the primary key. As part of the archival
process, the company wants to transfer the rows in the TRANS_SUMMARY table to the
TRANS_SUMMARY_DUP table at the end of every quarter of the year. Along with existing
products, the company deals with many new products during every quarter.
Which method is best suited for this quarterly data transfer?
A. Using the MERGE command
B. Using the SQL*Loader utility
C. Using the correlated UPDATE command
D. Using the INSERT command to perform bulk operation
You executed the following command to perform a backup of the USERS tablespace:
SQL> ALTER TABLESPACE users BEGIN BACKUP;
ALTER TABLESPACE users BEGIN BACKUP
ERROR at line 1:
ORA-01123: cannot start online backup; media recovery not enabled
What could be the reason for this error?
A. The MTTR Advisor is disabled.
B. The database is in NOARCHIVELOG mode.
C. The tablespace is already in backup mode.
D. The Flash Recovery Area is not configured.
Which two statements are true regarding a PL/SQL package body? (Choose two.)
A. It cannot be created without a package specification.
B. It cannot invoke subprograms defined in other packages.
C. It can contain only the subprograms defined in the package specification.
D. It can be changed and recompiled without making the package specification invalid.
Answer: A, D
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
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?
E. 1, 2, and 4
F. 1, 2, 3, and 4
In your database instance, the user sessions are connected to the database server from the
remote machines. You want to achieve the following for these users:
1. The user account must be locked after four unsuccessful login attempts.
2. The user must be prompted to change the password at regular intervals.
3. The user may not have more than three simultaneous sessions.
4. The user session must automatically be logged off if more than 10 minutes elapsed time used.
How would you accomplish the above?
A. By assigning profiles for the users
B. By implementing Fine-Grained Auditing (FGA)
C. By granting a secure application role to the users
D. By implementing the Database Resource Manager plan
Identify the memory component from which memory may be allocated for:
1. Session memory for the shared server
2. Buffers for I/O slaves
3. Oracle Database Recovery Manager (RMAN) backup and restore operations
A. Large Pool
B. Redo Log Buffer
C. Database Buffer Cache
D. Program Global Area (PGA)
Which two statements are true about alerts? (Choose two.)
A. Clearing an alert sends the alert to the alert history.
B. Response actions cannot be specified with server-generated alerts.
C. The nonthreshold alerts appear in the DBA_OUTSTANDING_ALERTS view.
D. Server-generated alerts notify the problems that cannot be resolved automatically and require
administrators to be notified.
Answer: A, D
Observe the information in the columns:
1. The SGA
a. Text and parsed forms of all SQL statements
2. The cursor state b. Run-time memory values for the SQL statement, such as rows retrieved
3. User-session data c. Security and resource usage information
4. The stack space d. 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-b, 2-c, 3-d, 4-a
C. 1-a, 2-b, 3-c, 4-d
D. 1-a, 2-b, 3-d, 4-c
You plan to move data from a flat file to a table in your database. You decide to use SQL*Loader
direct path load method to perform this task. The table in which you plan to load data is an
important table having various integrity constraints defined on it. Which constraints will remain
enabled by default during this operation? (Choose all that apply.)
C. NOT NULL
D. PRIMARY KEY
E. FOREIGN KEY
Answer: B, C, D
Which statements listed below describe the data dictionary views?
1) These are stored in the SYSTEM tablespace.
2) These are the based on the virtual tables.
3) These are owned by the SYS user.
4) These can be queried by a normal user only if O7_DICTIONARY_ACCESSIBILTY parameter
is set to TRUE.
5) The V$FIXED_TABLE view can be queried to list the names of these views.
A. 1 and 3
B. 2, 3, and 5
C. 1, 2, and 3
D. 2, 3, 4, and 5
You execute the following command to audit database activities:
SQL> AUDIT DROP ANY TABLE BY scott BY SESSION WHENEVER SUCCESSFUL;
What is the effect of this command?
A. One audit record is created for every successful DROP TABLE command executed in the
session of SCOTT.
B. One audit record is generated for the session when SCOTT grants the DROP ANY TABLE
privilege to other users.
C. One audit record is created for the whole session if user SCOTT successfully drops one or
more tables in his session.
D. One audit record is created for every session of any other user in which a table owned by
SCOTT is dropped successfully.
E. One audit record is created for every successful DROP TABLE command executed by any
user to drop tables owned by SCOTT.
In your database instance, the STATISTICS_LEVEL initialization parameter is set to BASIC.
What is the impact of this setting?
A. Optimizer statistics are collected automatically.
B. Only timed operating system (OS) statistics and plan execution statistics are collected.
C. The snapshots for the Automatic Workload Repository (AWR) are not generated automatically.
D. Snapshots cannot be collected manually by using the DBMS_WORKLOAD_REPOSITORY
E. The Oracle server dynamically generates the necessary statistics on tables as part of query optimization.
Note the following functionalities of various background processes:
1. Record the checkpoint information in data file headers.
2. Perform recovery at instance startup.
3. Cleanup unused temporary segments.
4. Free the resources used by a user process when it fails.
5. Dynamically register database services with listeners.
6. Monitor sessions for idle session timeout.
Which option has the correct functionalities listed for a background process?
A. Archiver Process (ARCn): 1, 2, 5
B. System Monitor Process (SMON): 1, 4, 5
C. Process Monitor Process (PMON): 4, 5, 6
D. Database Writer Process (DBWn): 1, 3, 4
THIS SET IS OFTEN IN FOLDERS WITH...
Oracle 11g Administration
Beginning Oracle Database 11g Administration
ORACLE 11g 1 and 2
YOU MIGHT ALSO LIKE...
Oracle Database 11g Certified Associate (OCA) (Fun…
SQL Interview Questions
OTHER SETS BY THIS CREATOR
GEO 101 Final_6 set combo
GEO 308 Final_combo
GEO 308 - Final exam
GEO 308 midterm, isotopes