Limited Time Discount Offer 30% Off - Ends in 02:00:00

×

Oracle 1z0-052 Exam - Oracle Database 11g: Administration I

Purchase Individually

Purchase Individually

  • Premium File

    284 Questions & Answers
    Last Update: Sep 3, 2019

    $21.41
    $14.99
  • Study Guide

    845 Pages

    $14.27
    $9.99

Download Free Oracle 1z0-052 Exam Questions

Questions & Answers for Oracle 1z0-052

Showing 1-15 of 205 Questions

Question #1 - Topic 1

SQL> CREATE BIGFILE TABLESPACE MRKT
2 DATAFILE '/u01/app/oracle/oradata/orcl/mrkt.dbf' size 10M LOGGING
3 EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO;
Tablespace created.
SQL> ALTER DATABASE DEFAULT TABLESPACE MRKT;
Database altered.
Which two statements are true regarding the MRKT tablespace? (Choose two.)

A. No more data files can be added to the tablespace.

B. Segment space is managed by free lists in the tablespace.

C. A user created without being assigned a default tablespace uses this tablespace.

D. The tablespace can be dropped with the current setting with segments present in it.

Question #2 - Topic 1

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?
Exhibit:

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.

Question #3 - Topic 1

View the Exhibit to examine the error that occurred during the database startup.

You opened an RMAN session for the database. To repair the failure, you executed the
following command as the first RMAN command:
RMAN> REPAIR FAILURE;
Which statement describes the consequence of this command?

A. The command performs the recovery and closes the failure

B. The command only displays the advice and the RMAN script required for recovery

C. The command executes the RMAN script to repair the failure and remove the entry from the Automatic Diagnostic Repository (ADR)

D. The command produces an error because the ADVISE FAILURE command was not executed before the REPAIR FAILURE command

Question #4 - Topic 1

The HR user creates a stand-alone procedure as follows and grants the EXECUTE
privilege on the procedure to many database users:
CREATE OR REPLACE PROCEDURE create_dept ( v_deptno NUMBER, v_dname
VARCHAR2, v_mgr NUMBER, v_loc NUMBER)
BEGIN
INSERT INTO hr.departments VALUES (v_deptno, v_dname, v_mgr, v_loc);
END;
The users having permission to execute the procedure are able to insert records into the
DEPARTMENTS table even though they do not have the INSERT privilege on the table.
You want only those users who have privileges on the DEPARTMENTS table to be able to
execute the procedure successfully.
What would you suggest to the PL/SQL developers to achieve this?

A. Create the procedure with definer's right.

B. Create the procedure with invoker's right.

C. Grant the EXECUTE privilege with GRANT OPTION on the procedure to selected users.

D. Create the procedure as part of a PL/SQL package and grant the EXECUTE privilege on the package to selected users.

Question #5 - Topic 1

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

Question #6 - Topic 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 table of 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

Question #7 - Topic 1

The database instance has the following parameter setting:
OS_AUTHENT_PREFIX = OPS$
OS_ROLES = FALSE
REMOTE_OS_AUTHENT = FALSE
REMOTE_OS_ROLES = FALSE
TIMED_OS_STATISTICS = 0
You have a local operating system user SKD. You create a database user OPS$SKD, and
then assign external authentication. The user OPS$SKD has the CREATE SESSION
privilege.
What would you achieve by the above process?

A. The database user OPS$SKD will be able to administer the database.

B. The authentication detail for the database user OPS$SKD is recorded in the password file.

C. The local operating system user SKD will be able to access the database instance without specifying the username and password.

D. The database user OPS$SKD has to login with the password of the local operating system user SKD to access the database instance.

Question #8 - Topic 1

Examine the command:
SQL>DBMS_STATS.SET_TABLE_PREFS('SH','CUSTOMERS','PUBLISH','false');
Which statement describes the effect of the above command?

A. Automatic statistics collection is stopped for the CUSTOMERS table

B. Statistics for the CUSTOMERS table are locked and cannot be overwritten

C. Existing statistics for the CUSTOMERS table become unusable for the query optimizer

D. Subsequently, statistics gathered on the CUSTOMERS table are stored as pending statistics

Question #9 - Topic 1

Examine the values for the following initialization parameters:
FAST_START_MTTR_TARGET=0
LOG_CHECKPOINT_INTERVAL=0
Which two will be the implications of these values in your database? (Choose two.)

A. The SGA advisor will be disabled

B. The MTTR advisor will be disabled

C. Automatic checkpoint tuning will be disabled

D. Checkpoint information will not be written to the alert log file

Question #10 - Topic 1

View the Exhibit and examine the privileges granted to the SL_REP user.

The EMP table is owned by the SCOTT user. The SL_REP user executes the following
command: SQL> GRANT SELECT ON scott.emp TO hr;
Which statement describes the outcome of the command?

A. The command executes successfully

B. The command produces an error because the EMP table is owned by SCOTT

C. The command produces an error because SL_REP has the GRANT ANY OBJECT PRIVILEGE without ADMIN_OPTION

D. The command produces an error because SL_REP does not have the SELECT privilege with GRANT_OPTION on the EMP table

Question #11 - Topic 1

Examine the values for the following initialization parameters:
FAST_START_MTTR_TARGET=0
LOG_CHECKPOINT_INTERVAL=0
Which two will be the implications of these values in your database? (Choose two.)

A. The SGA advisor will be disabled

B. The MTTR advisor will be disabled

C. Automatic checkpoint tuning will be disabled

D. Checkpoint information will not be written to the alert log file

Question #12 - Topic 1

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

Question #13 - Topic 1

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_ACCESSIBLILITY
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 5

D. 2,3,4 and 5

Question #14 - Topic 1

You execute this command to drop the ITEM table, which has the primary key referred in
the ORDERS table:
SQL> DROP TABLE scott.item CASCADE CONSTRAINTS PURGE;
Which two statements are true about the effect of the command? (Choose two.)

A. No flashback is possible to bring back the ITEM table.

B. The ORDERS table is dropped along with the ITEM table.

C. The dependent referential integrity constraints in the ORDERS table are disabled.

D. The dependent referential integrity constraints in the ORDERS table are removed.

E. The table definition of the ITEM table and associated indexes are placed in the recycle bin.

Question #15 - Topic 1

In which situation may the UNDO_RETENTION parameter be ignored, even if it is set to a
value?

A. When the data file of the undo tablespace is autoextensible

B. When there are more than one undo tablespace available in the database

C. When the undo tablespace is of a fixed size and retention guarantee is not enabled

D. When the undo tablespace is autoextensible and retention guarantee is not enabled

  • Premium File

    284 Questions & Answers
    Last Update: Sep 3, 2019

    $21.41
    $14.99
  • Study Guide

    845 Pages

    $14.27
    $9.99

You Need Avanset VCE Player in Order to Open VCE Files

Try Our Special 30% Discount Offer for
Premium 1z0-052 VCE File

  • Verified by experts

1z0-052 Premium File

  • Real Questions
  • Last Update: Sep 3, 2019
  • 100% Accurate Answers
  • Fast Exam Update

$14.99

$21.41

AUTUMN SALE: 30% DISCOUNT
This is ONE TIME OFFER

You save
30%

Enter Your Email Address to Receive Your 30% Discount Code

AUTUMN SALE: 30% DISCOUNT

You save
30%

Use Discount Code:

A confirmation link was sent to your e-mail.

Please check your mailbox for a message from [email protected] and follow the directions.