Our pass rate is high to 98.9% and the similarity percentage between our 1z0 052 dumps study guide and real exam is 90% based on our seven-year educating experience. Do you want achievements in the Oracle oracle database 11g administration i 1z0 052 exam in just one try? I am currently studying for the Oracle 1z0 052 pdf exam. Latest Oracle 1z0 052 dumps Test exam practice questions and answers, Try Oracle oracle database 11g administration i 1z0 052 Brain Dumps First.
Q21. Examine the commands executed in the following sequence:
Which statement is true about the above commands?
A. The commands execute successfully.
B. Command 6 produces an error because of circular role grant.
C. Command 5 produces an error because a role cannot be granted to another role.
D. Command 3 produces an error because the MGRROLE role already contains system privileges. The table created by HR remains and HR still has the CREATE TABLE system privilege.
E. The table created by HR remains and HR can grant the CREATE TABLE system privilege to other users.
Q22. You created a profile APP_USER and assigned it to the users. After a month, you decide to drop the profile. Some user sessions are currently connected to the database instance and are using the APP_USER profile.
This command is used to drop the profile:
SQL> DROP PROFILE app_user;
Which statement describes the result?
A. The command produces an error.
B. The profile is dropped and current user sessions use the DEFAULT profile immediately.
C. The profile is dropped and only the subsequent user sessions use the DEFAULT profile.
D. The profile is dropped, the sessions are terminated, and the subsequent user sessions use the DEFAULT profile.
Q23. You executed the following commands in an RMAN session for your database instance that has failures:
RMAN> LIST FAILURE;
After some time, you executed the following command in the same session:
RMAN> ADVISE FAILURE;
But there are new failures recorded in the Automatic Diagnostic Repository (ADR) after the execution of the last LIST FAILURE command. Which statement is true for the above ADVISE FAILURE command in this scenario?
A. It produces a warning for new failures before advising for CRITICAL and HIGH failures.
B. It ignores new failures and considers the failures listed in the last LIST FAILURE command only.
C. It produces advice only for new failures and the failures listed in the last LIST FAILURE command are ignored.
D. It produces an error with recommendation to run the LIST FAILURE command before the ADVISE FAILURE command.
Q24. Examine the values for the following initialization parameters:
Which two will be the implications of these values in your database? (Choose two.)
A. The SGA advisor will be disabled
B. The MTTR advisor will be disabled
C. Automatic checkpoint tuning will be disabled
D. Checkpoint information will not be written to the alert log file
Q25. 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?
A. 1 and 2
B. 2 and 5
C. 1,3, and 4
D. 3,4 and 5
E. 1,2,3 and 4
Q26. 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.)
A. The online redo log files and online data files are opened
B. All the online data files headers are checked for consistency
C. Instance recovery is performed before opening the database
D. The path and existence of all the log file members are checked
Q27. The tnsnames.ora file has an entry for the service alias ORCL as follows:
( DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.156.24.216)(PORT = 1521))
(SERVER = DEDICATED)
(SERVICE_NAME = orcl.oracle.com)
The TNSPING command executes successfully when tested with ORCL, but you are not able to connect to the database instance with the following command:
SQL> CONNECT scott/tiger@orcl
What could be the reason for this?
A. The listener is not running on the database node.
B. The TNS_ADMIN environmental variable is set to a wrong value.
C. The orcl.oracle.com database service is not registered with the listener.
D. The DEFAULT_DOMAIN parameter is set to a wrong value in the sqlnet.ora file.
Q28. Which two statements are true regarding undo tablespaces? (Choose two.)
A. The database can have more than one undo tablespace
B. The UNDO_TABLESPACE parameter is valid in both automatic and manual undo management
C. Undo segments automatically grow and shrink as needed, acting as circular storage buffer for their assigned transactions
D. An undo tablespace is automatically created if the UNDO_TABLESPACE parameter is not set and the UNDO_MANAGEMENT parameter is set to AUTO during the database instance start up
Q29. Which naming method uses the tnsnames.ora file to store the connect descriptor used by the client while connecting to the database instance from a remote machine?
A. Host naming method
B. Local naming method
C. External naming method
D. Directory naming method
Q30. You execute this command to drop the ITEM table, which has the primary key referred in the ORDERS table:
SQL> DROP TABLE scott.item CASCADE CONSTRAINTS PURGE;
Which two statements are true about the effect of the command? (Choose two.)
A. No flashback is possible to bring back the ITEM table.
B. The ORDERS table is dropped along with the ITEM table.
C. The dependent referential integrity constraints in the ORDERS table are disabled.
D. The dependent referential integrity constraints in the ORDERS table are removed.
E. The table definition of the ITEM table and associated indexes are placed in the recycle bin.