Oracle 1Z1-052 Actual Free Exam Questions & Community Discussion

Your database is in shutdown state. What will happend if you issue next command:
SQL> startup

Your test database is configured to run in NOARCHIVELOG mode. One of the data files in the USERS tablespace is lost due to a media failure. You notice that all the online redo logs have been overwritten since the last backup.
What would you do to recover the data file?

You have executed this command to change the size of the database buffer cache:
SQL> ALTER SYSTEM SET DB_CACHE_SIZE=2516582;
System altered.
To verify the change in size, you executed this command:

Why is the value set to 4194304 and not to 2516582?

View the Exhibit.

You are creating an additional database by using the Database Configuration Assistant (DBCA). You opted to create a General Purpose database and during the database creation realize that the Block Size field is not enabled.
What could be the reason for this?

The ORCL database has CONTROL FILE AUTOBACKUP and BACKUP OPTIMIZATION
enabled.
TBS1 and TBS2 are the only user-defined tablespaces in ORCL.
USER1.EMP is a table in TBS1.
Examine these commands:

From which files are modified blocks backed up?

These are points that describe the contents of different memory components:
1: Descriptive information or metadata about schema objects that are queried by using SQL statements
2: The runtime area for data manipulation language (DML) or data definition language (DDL) statements
3 : Results of SQL queries and PL/SQL functions
4 : Executable forms of SQL cursors, PL/SQL programs, and Java classes
5 : The information necessary to reconstruct changes made to the database by a transaction Which of these will be stored in the Shared Pool if the necessary configurations are done?

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?

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?

For which requirement should you configure shared servers?

See the Exhibit:

Identify the component marked with a question mark:

Which two are true about the Inventory directory? (Choose two.)

Which two statements are true regarding listeners? (Choose two.)

Which two are true about roles? (Choose two.)

A database instance was terminated due to a lost data file and has not been restarted.
You wish to restore database availability by using the Data Recovery Advisor.
Examine this list of RMAN commands:

What are the minimum required commands and in what order must they be executed to achieve this?