1Z0-052 Online Practice Questions and Answers

Which two are true about space management in tablespaces? (Choose two.)

A. Extent allocation must be specified as automatic for automatic segment space management (ASSM) tablespaces

B. Free lists are used for managing free space for segments in locally managed tablespaces

C. ASSM tablespaces prevent row chaining

D. Locally managed tablespaces track adjacent free space automatically by using bitmaps

E. Locally managed tablespaces have either ASSM or manual segment space management (MSSM), and all the segments in these tablespaces are managed one way or the other

Which two are true about server-generated alerts? (Choose two.)

A. Stateful alerts are preserved across instance restarts.

B. They are automatically written to alert.log.

C. By default, an email is sent by the database instance for each server-generated alert.

D. Stateless alerts can be found in DBA_OUTSTANDING_ALERTS.

E. By default, a server-generated alert is raised for each tablespace that has 85 % or more of its space used.

Your database is down. You log in as the user SYS and issue the following command:

SQL>STARTUP

Which steps occur and in what order as a result of executing this command?

A. Only the instance is started.

B. Instance is started and then database is mounted but not opened.

C. Instance is started, then the database is mounted and finally opened.

D. Instance is started, then the database is opened and finally mounted.

You perform differential incremental level 1 backups of your database on each working day and level 0 backup on Sunday to tape:

Which two statements are true about differential incremental backups? (Choose two.)

A. The backup performed on Sundays contains all the blocks that have ever been used in the database

B. The backup performed on Sundays contains all the blocks that have changed since the last level 1 backup

C. The backup performed on each working day contains all the blocks that have changed since the last level 0 backup

D. The backup performed on Monday contains all the blocks that have changed since the level 0 backup and every other working day contains all the blocks that have changed since the level 1 backup

You have statistics collected for some selected tables. Your requirement is that the statistics for the tables and all dependent indexes must not be overwritten by further statistics collection until a certain point of time. How would you achieve this?

A. Lock statistics for the tables.

B. Change STALE_PERCENT to zero for the tables.

C. Set the TIMED_STATISTICS parameter to TRUE.

D. Set the STATISTICS_LEVEL parameter to BASIC.

E. Set the OPTIMIZER_USE_PENDING parameter statistics to TRUE.

Automatic Shared Memory Management (ASMM) has been enabled for your database instance. The initialization parameters for the components that are managed by ASMM are not set. After observing the effects of ASMM, you executed the following command:

SQL> ALTER SYSTEM SET DB_CACHE_SIZE = 100M;

Which statement is true in this scenario?

A. The minimum memory size for the database buffer cache is set to 100 MB.

B. The maximum memory size that can be obtained by the database buffer cache during ASMM is set to 100 MB.

C. The minimum memory size allocated for a server process in the database buffer cache in dedicated mode is set to 100 MB.

D. The maximum memory size from the database buffer cache that can be released for dynamic distribution during ASMM is set to 100 MB.

You are using Enterprise Manager to schedule backups for your database. Which type of script would be generated by the backup scheduler?

A. XML script

B. PL/SQL script

C. Operating system script

D. Recovery Manager (RMAN) script

Which two statements are true regarding transactions in an Oracle database? (Choose two.)

A. Multiple transactions can use the same undo segment.

B. A transaction is assigned an undo segment when it is started.

C. More than one transaction cannot share the same extent in the undo tablespace.

D. The transactions use system undo segment to store undo data if all the segments in the undo tablespace are used.

Examine the following statement that is used to modify the primary key constraint on the SALES table:

SQL> ALTER TABLE SALES MODIFY CONSTRAINT pk DISABLE VALIDATE;

Which three statements are true regarding the above command? (Choose three.)

A. The constraint remains valid.

B. The index on the constraint is dropped.

C. It allows the loading of data into the table using SQL *Loader.

D. New data conforms to the constraint, but existing data is not checked.

E. It allows the data manipulation on the table using INSERT/UPDATE/DELETE SQL statements.

You are working on a database that must be functioning 24 hours a day, 7 days a week. The database is configured in ARCHIVELOG mode.

Which two options do you have for performing user-managed backups? (Choose two.)

A. You can perform consistent backups only.

B. You can perform a complete database backup without shutting down the database instance.

C. You can back up data files only when all data files have the same SCN recorded in the control file.

D. You can back up only those data files whose headers are frozen by using ALTER TABLESPACE BEGIN BACKUP or ALTER DATABASE BEGIN BACKUP commands.