1Z0-052 Oracle 11i Braindump
ExamSoon 1Z0-052 Exams
Oracle Oracle Database 11g: Administration I
O rder : 1Z0-052 Exam
Practice Exam: 1Z0-052
Exam Number/Code: 1Z0-052
Exam Name: Oracle Database 11g: Administration I
Questions and Answers: 209 Q&As
Free 1Z0-052 Braindumps
Exam : Oracle 1Z0-052
Title : Oracle Database 11g: Administration I
1. 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?
A. The ALTER TABLE command modifies the column successfully.
B. The DDL operation gets higher priority and transaction for user A is rolled back.
C. The ALTER TABLE command waits indefinitely until user A ends the transaction.
D. The ALTER TABLE command fails after waiting for 60 seconds due to the resource being busy.
Answer: D
2. You perform differential incremental level 1 backups of your database on each working day and level 0 backup on
Sundays, to tape. Which two statements are true about differential incremental backups? (Choose two.)
A. The backup performed on Sundays contains all the blocks that have ever been used in the database.
B. The backup performed on Sundays contains all the blocks that have changed since the last level 1 backup.
C. The backup performed on each working day contains all the blocks that have changed since the last level 0
backup.
D. The backup performed on Monday contains all the blocks that have changed since the level 0 backup, and every
other working day contains all the blocks that have changed since the level 1 backup.
Answer: AD
3. You are working on a new Oracle Database 11g server, where only the software is installed and no database is
created. You plan to create a database on this server using the Database Configuration Assistant (DBCA).
Some of the requir