1Z0-052 Online Practice Questions and Answers

You want to install an Oracle 11g database and deploy it on ASM. Your plan is to install both Oracle database and Grid Infrastructure.

Which two are true in this scenario? (Choose two.)

A. Grid Infrastructure must be installed first

B. Both products must be installed by the same OS user

C. Each product must be installed in a different ORACLE_HOME

D. Both products must be installed by using the same ORACLE_BASE

E. Both products must be of the same version

F. Both products can share the OS group assigned to their OSDBA and OSOPER privileged groups

Where is backup metadata stored for use by Recovery Manager (RMAN)?

A. in the SYSTEM tablespace

B. in the control file

C. in the SPFILE

D. in the SYSAUX tablespace

E. in the diagnostic destination files

Which three are true about the Automatic Workload Repository (AWR)? (Choose three.)

A. It is maintained by executing the PL/SQL procedures in the DBMS_STATS package.

B. It includes statistics that contain the number of distinct values per table column.

C. It includes statistics that contain the number of rows per table.

D. AWR data is stored in the SYSAUX tablespace.

E. Automatic AWR snapshots are created by the Manageability Monitor (MMON) background process.

F. By default, AWR data is retained for eight days.

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.

Which two kinds of failures make the Data Recovery Advisor (DRA) generate a manual checklist? (Choose two.)

A. Failure when no standby database is configured

B. Failure because a data file is renamed accidentally

C. Failure that requires no archive logs to be applied for recovery

D. Failure due to loss of connectivity-for example, an unplugged disk cable

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

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.

You configured the Flash Recovery Area for your database. The database instance has been started in ARCHIVELOG mode and the LOG_ARCHIVE_DEST_1 parameter is not set.

What will be the implications on the archiving and the location of archive redo log files?

A. Archiving will be disabled because the destination for the redo log files is missing

B. The database instance will shut down and the error details will be logged in the alert log file

C. Archiving will be enabled and the destination for the archived redo log file will be set to the Flash Recovery Area implicitly

D. Archiving will be enabled and the location for the archive redo log file will be created in the default location $ORACLE_HOME/log

Which three operations require undo data? (Choose three.)

A. Committing a transaction

B. Flashing back a transaction

C. Recovering a failed transaction

D. Running a read-consistent query

E. Changing a tablespace status from READ ONLY to READ WRITE

View the Exhibit and examine the command used to create the ZONEDATA table. The table contains a million rows for zonewise analysis in the DSS system. DML operations are performed very rarely on the table. You decide to prepare an index on the ZONE column to enhance the performance of the queries on the ZONE column.

Which type of index would you select in this scenario?

Exhibit:

A. Bitmap index

B. Reverse key index

C. Normal BTree index

D. Functionbased index