Ucertify offers free demo for oracle database 11g administration i 1z0 052 exam. "Oracle Database 11g: Administration I", also known as 1z0 052 dumps exam, is a Oracle Certification. This set of posts, Passing the Oracle 1z0 052 pdf exam, will help you answer those questions. The 1z0 052 pdf Questions & Answers covers all the knowledge points of the real exam. 100% real Oracle oracle database 11g administration i 1z0 052 exams and revised by experts!
Q16. 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?
A. Using the MERGE command
B. Using the SQL*Loader utility
C. Using the correlated UPDATE command
D. Using the INSERT command to perform bulk operation
Answer: A
Q17. The job to gather optimizer statistics for objects runs as part of the automatic maintenance window in your database instance. At a certain point of time, the maintenance window closes before the statistics are gathered for all objects.
Which statement is true in this scenario?
A. The statistics collection continues until all objects are processed.
B. The job is terminated and the statistics collected are restored to a time before the job started.
C. This produces an error and the statistics collected are locked until the next time that the maintenance window is opened.
D. The job is terminated and the statistics for the remaining objects are collected the next time that the maintenance window is opened.
Answer: D
Q18. A constraint in a table is defined with the INITIALLY IMMEDIATE clause. You executed the ALTER TABLE command with the ENABLE VALIDATE option to enable the constraint that was disabled.
What are the two effects of this command? (Choose two.)
A. It fails if any existing row violates the constraint.
B. It does not validate the existing data in the table.
C. It enables the constraint to be enforced at the end of each transaction.
D. It prevents insert, update, and delete operations on the table while the constraint is in the process of being enabled.
Answer: AD
Q19. You plan to implement the distributed database system in your company. You invoke Database Configuration Assistant (DBCA) to create a database on the server. During the installation, DBCA prompts you to specify the Global Database Name.
What must this name be made up of?
A. It must be made up of a database name and a domain name.
B. It must be made up of the value in ORACLE_SID and HOSTNAME.
C. It must be made up of the value that you plan to assign for INSTANCE_NAME and HOSTNAME.
D. It must be made up of the value that you plan to assign for ORACLE_SID and SERVICE_NAMES.
Answer: A
Q20. 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
Answer: AC
Q21. Examine the following steps performed on a database instance:
1. The DBA grants the CREATE TABLE system privilege to the SKD user with ADMIN OPTION
2. The SKD user creates a table
3. The SKD user grants the CREATE TABLE system privilege to the HR user
4. The HR user creates a table
5. The DBA revokes the CREATE TABLE system privilege from SKD
Which statement is true after step 5 is performed?
A. The table created by SKD is not accessible and SKD cannot create new tables
B. The tables created by SKD and HR remain, but both cannot create new tables
C. The table created by HR remains and HR still has the CREATE TABLE system privilege
D. The table created by HR remains and HR can grant the CREATE TABLE system privilege to other users
Answer: C
Q22. Examine the values for the following initialization parameters:
FAST_START_MTTR_TARGET=0
LOG_CHECKPOINT_INTERVAL=0
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
Answer: BC
Q23. Note the functionalities of various background processes:
1: Perform recovery at instance startup.
2: Free the resources used by a user process when it fails.
3: Cleanup the database buffer cache when a process fails.
4: Dynamically register database services with listeners.
5: Monitor sessions for idle session timeout.
6: Cleanup unused temporary segments.
7: Record the checkpoint information in control file.
Which option has the correct functionalities listed for a background process?
A. Checkpoint (CKPT): 1, 2, 5
B. System Monitor (SMON): 1, 6
C. Process Monitor (PMON): 4, 6, 7
D. Database Writer (DBWR): 1, 3, 4
Answer: B
Q24. Which of these is true about undo tablespace?
A. Undo tablespace is a temporary tablespace
B. Undo tablespace has only one datafile
C. Undotablespace has a datafile which is reused in cyclic manner
Answer: A
Q25. You are working on a database that must be functioning 24 hours a day, 7 days a week. The database is configured in ARCHIVELOG mode.
Which two options do you have for performing user-managed backups? (Choose two.)
A. You can perform consistent backups only.
B. You can perform a complete database backup without shutting down the database instance.
C. You can back up data files only when all data files have the same SCN recorded in the control file.
D. You can back up only those data files whose headers are frozen by using ALTER TABLESPACE BEGIN BACKUP or ALTER DATABASE BEGIN BACKUP commands.
Answer: BD
Q26. 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?
A. CLOB
B. BLOB
C. BFILE
D. LONG RAW
Answer: C
Q27. You are in the middle of a transaction updating a very important table. The machine on which a database was running reboots because of power outage. This caused a database instance failure.
Which statement is true in this situation?
A. The online redo log files and archived redo log files are required to accomplish the recovery
B. The uncommitted transaction will be committed at the next startup of the database instance
C. The uncommitted transaction is rolled back automatically at the next opening of the database
D. The DBA has to perform the recovery on the database to recover the uncommitted transaction
Answer: C
Q28. Your database instance is currently configured to support 1,500 connections. The Web application that uses the database allows a large number of users to work with the database simultaneously.
Some users of the Web application do not interact with the server all the time. You want to increase the scalability by configuring the database instance to handle more connections. As a DBA, which configuration would you set to support more than 1,500 connections at a time?
A. You would configure more listeners for the database.
B. You would configure the database in shared server mode to use the connection pooling feature.
C. You would increase the value of the PGA_AGGREGATE_TARGET initialization parameter that assigns more session memory to users.
D. You would decrease the value of the PRIVATE_SGA resource limit in the profiles used by the users to accommodate more session information.
Answer: B
Q29. Examine the following statement that is used to modify the primary key constraint on the SALES table:
SQL> ALTER TABLE SALES MODIFY CONSTRAINT pk DISABLE VALIDATE;
Which three statements are true regarding the above command? (Choose three.)
A. The constraint remains valid.
B. The index on the constraint is dropped.
C. It allows the loading of data into the table using SQL *Loader.
D. New data conforms to the constraint, but existing data is not checked.
E. It allows the data manipulation on the table using INSERT/UPDATE/DELETE SQL statements.
Answer: ABC
Q30. Which statement is true about the Manageability Monitor (MMON) background process?
A. It transfers statistics from memory to disk at regular intervals.
B. It coordinates the rebalance activity for disk groups when ASM is used.
C. It communicates with the Automatic Storage Management (ASM) instance on behalf of the database instance.
D. It performs dynamic memory management when Automatic Shared Memory Management is enabled for the database instance.
Answer: A