Oracle 1Z0-052 Actual Free Exam Questions & Community Discussion
Examine these components:
* Execution plan for a non-embedded SQL statement
* Local, global, and package variables for a session
* Execution plan for a SQL statement contained in a PL/SQL program unit
* Results of executed queries and query fragments
* PL/SQL function result sets
Which of these are stored in the shared SQL area?
* Execution plan for a non-embedded SQL statement
* Local, global, and package variables for a session
* Execution plan for a SQL statement contained in a PL/SQL program unit
* Results of executed queries and query fragments
* PL/SQL function result sets
Which of these are stored in the shared SQL area?
Correct Answer: C
Vote an answer
Explanation: Only visible for EduDump members. You can sign-up / login (it's free).
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?
SQL> ALTER SYSTEM SET DB_CACHE_SIZE = 100M;
Which statement is true in this scenario?
Correct Answer: B
Vote an answer
You are managing an Oracle Database 11g database. You configured the database to run in ARCHIVELOG mode.
Which two statements are true in this scenario? (Choose two.)
Which two statements are true in this scenario? (Choose two.)
Correct Answer: B,D
Vote an answer
In which situations does the Oracle Data Pump use external tables and not the direct path load while exporting a table? (Choose all that apply.)
Correct Answer: A,B,C
Vote an answer
All the database users are presently connected to the database instance and working. The HR user has opened three database sessions and executed the following command in one of his sessions:
SQL> UPDATE persons SET ccode='U031' WHERE ccode='U029';
1 23 rows updated.
SQL> DELETE FROM persons WHERE exp='Y';
3 rows deleted.
The SYS user opens a new session after HR executed the above commands.
Which sessions can see the effect of the UPDATE and DELETE commands?
SQL> UPDATE persons SET ccode='U031' WHERE ccode='U029';
1 23 rows updated.
SQL> DELETE FROM persons WHERE exp='Y';
3 rows deleted.
The SYS user opens a new session after HR executed the above commands.
Which sessions can see the effect of the UPDATE and DELETE commands?
Correct Answer: A
Vote an answer
Archivelog mode is enabled for your database and DB_CREATE_FILE_DEST is set to
'/u01/oracle/db01'.
The parameters, DB_CREATE_ONLINE_LOG_DEST_n and
DB_RECOVERY_FILE_DEST, are not specified.
Which four are stored in the location specified by DB-CREATE_FILE_DEST? (Choose four.)
'/u01/oracle/db01'.
The parameters, DB_CREATE_ONLINE_LOG_DEST_n and
DB_RECOVERY_FILE_DEST, are not specified.
Which four are stored in the location specified by DB-CREATE_FILE_DEST? (Choose four.)
Correct Answer: A,B,F,G
Vote an answer
Explanation: Only visible for EduDump members. You can sign-up / login (it's free).
In a system, large online transaction processing (OLTP) jobs run during the daytime that require a large database buffer cache. In the night, the system supports batch jobs that require a higher value to be set for the large pool. You must simultaneously configure the memory components to accommodate the peak requirement.
What would you do to automate this configuration for the memory components with change in mode of working?
What would you do to automate this configuration for the memory components with change in mode of working?
Correct Answer: A
Vote an answer
Examine these commands and their output:
A power failure occurs. The instance is restarted and this query is executed.
SQL> SELECT ename FROM emp;
What is the outcome?
A power failure occurs. The instance is restarted and this query is executed.
SQL> SELECT ename FROM emp;
What is the outcome?
Correct Answer: D
Vote an answer
Which two statements are true about the Automatic Workload Repository (AWR)? (Choose two.)
Correct Answer: A,D
Vote an answer
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?
Which schema object enables the user to access the information from the remote database?
Correct Answer: D
Vote an answer
Which two statements describe good practices for an application developer to reduce locking conflicts in Oracle database? (Choose two.)
Correct Answer: B,C
Vote an answer
0
0
0
10