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

After performing a clean shut down of the database instance for maintenance, you mount the database and then execute a command to open the database:
SQL> ALTER DATABASE OPEN;
Which two statements are true? (Choose two.)

You executed this command to create a temporary table:
SQL> CREATE GLOBAL TEMPORARY TABLE report_work_area (
startdate DATE,
enddate DATE,
class CHAR(20)
) ON COMMIT PRESERVE ROWS;
Which statement is true about the rows inserted into the REPORT_WORK_AREA table during a transaction?

User A executes the following command to drop a large table in your database:
SQL> DROP TABLE trans;
While the drop table operation is in progress; user B executes the following command on the same table; SQL> DELETE FROM trans WHERE tr_type='SL'; Which statement is true regarding the DELETE command?

You are installing Oracle Database 11g on your server. During the installation Oracle Universal Installer (OUI) prompts you to enter the path of the inventory directory and also prompts you to specify an operating system group name.
Which statement is true in this case?

View the Exhibit and examine the parameters. User A executes the following command to update the TRANS table:
SQL> UPDATE B.trans SET tr_amt=tr_amt+500 WHERE c_code='C005';
Before user A issues a COMMIT or ROLLBACK command, user B executes the following command on the TRANS table:
SQL> ALTER TABLE trans MODIFY (tr_type VARCHAR2(3));
What would happen in this scenario?
Exhibit:

You executed the following command to create a password file in the database server:
$ orapwd file = orapworcl entries = 5 ignorecase=N
Which statement describes the purpose of the above password file?

Identify two situations in which the block header grows in a data block. (Choose two.)

You have two database servers SEMP and SACCT. The database in the SEMP server maintains the employee information and the database in the SACCT server maintains the accounts payable information. The employees submit the expense reports to the accounts payable department. A user of the accounts payable database wants to extract the employee information from the database in the SEMP server for crossverification.
Which schema object enables the user to access the information from the remote database?

You want to create a role to meet these requirements:
1. The role is to be protected from unauthorized usage.
2. The password of the role is not to be embedded in the application source code or stored in a table.
Which method would you use to restrict enabling of such roles?

View the Exhibit and examine the user information.
The user has been granted CONNECT and RESOURCE roles and no individual system privileges. The SL_REP user executes this command to create a table:
SQL> CREATE TABLE orders (
oid number(6),
odate date,
ccode number(4),
oamt number(10,2)
) TABLESPACE purchase_space;
The PURCHASE_SPACE tablespace already exists in the database.
Which statement describes the effect of the command?
Exhibit:

The instance abnormally terminates because of a power outage.
Which statement is true about redo log files during instance recovery?

You want to access employee details contained in flat files as part of the EMPLOYEE table.
You plan to add a new column to the EMPLOYEE table to achieve this.
Which data types would you use for the new column?

Which three are true about auditing? (Choose three.)

Examine these attributes for the profile assigned to USER1 whose password is oracle_4U.
* PASSWORD_REUSE_MAX IS 5
* PASSWORD_REUSE_TIME IS 10
* PASSWORD_GARCE_TIME IS 15
Which two conditions must be met for USER1 to reuse oracle_4U? (Choose two.)