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

Your database is using Automatic Memory Management.
Which two SGA components must be managed manually? (Choose two)

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

You have two tables with referential integrity enforced between them. You need to insert data to the child table first because it is going to be a long transaction and data for the parent table will be available in a later stage, which can be inserted as part of the same transaction.
View the Exhibit to examine the commands used to create tables.
Which action would you take to delay the referential integrity checking until the end of the transaction?
Exhibit:

USER1.EMP has a referential integrity constraint defined on EMP.DNO that references USER1.DEPT.DNO.
USER1 executes these commands:

What will be the outcome and why?

Which two types of information can be found in the alert log? (Choose two.)

Which two statements are true regarding a tablespace? (Choose two.)

In a new installation of Oracle Database 11g, you perform these activities:
1 . Organize software and data on different subdirectories to avoid poor performance.
2 . Use consistent naming conventions for database files.
3 . Separate administrative information pertaining to the database in different directories.
Which option corresponds to the type of activities you performed?

In your database:
SGA_TARGET = 270M
PGA_AGGREGATE_TARGET = 90M
The MEMORY_TARGET and MEMORY_MAX_TARGET parameters are currently not
configured.
You execute the command:
ALTER SYSTEM SET MEMORY_TARGET = 400M;
What is the outcome and why?

View the Exhibit to examine the output for the CROSSCHECK BACKUP command.

Which statement is true about the output of the command?

Which three descriptions are correct about the effects of the TRUNCATE command on a table? (Choose three.)

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?