100% Correct of 1z0 052 dumps free practice questions materials and preparation for Oracle certification for IT candidates, Real Success Guaranteed with Updated oracle database 11g administration i 1z0 052 pdf dumps vce Materials. 100% PASS Oracle Database 11g: Administration I exam Today!
♥♥ 2021 NEW RECOMMEND ♥♥
Free VCE & PDF File for Oracle 1Z0-052 Real Exam (Full Version!)
★ Pass on Your First TRY ★ 100% Money Back Guarantee ★ Realistic Practice Exam Questions
Free Instant Download NEW 1Z0-052 Exam Dumps (PDF & VCE):
Available on:
http://www.surepassexam.com/1Z0-052-exam-dumps.html
Q41. Identify two situations in which you can use Data Recovery Advisor for recovery. (Choose two.)
A. The database files are corrupted when the database is open
B. The user has dropped an important table that needs to be recovered
C. The archived redo log files are missing for which the backup is not available
D. The database is not opening because the required database files are missing
Answer: AD
Q42. You executed the following command to perform a backup of the USERS tablespace:
SQL> ALTER TABLESPACE users BEGIN BACKUP;
ALTER TABLESPACE users BEGIN BACKUP
*
ERROR at line 1:
ORA-01123: cannot start online backup; media recovery not enabled
What could be the reason for this error?
A. The MTTR Advisor is disabled.
B. The database is in NOARCHIVELOG mode.
C. The tablespace is already in backup mode.
D. The Flash Recovery Area is not configured.
Answer: B
Q43. Your database is open and the LISTENER listener is running. The new DBA of the system stops the listener by using the command: LSNRCTL> STOP
What happens to the sessions that are presently connected to the database instance?
A. The sessions are able to perform only queries
B. The sessions are not affected and continue to function normally
C. The sessions are terminated and the active transactions are rolled back
D. The sessions are not allowed to perform any operations till the listener is started
Answer: B
Q44. View the Exhibit and examine the user information.
The user has been granted CONNECT and RESOURCE roles and no individual system privileges.
The SL_REP user executes this command to create a table:
SQL> CREATE TABLE orders (
oid number(6),
odate date,
ccode number(4),
oamt number(10,2)
) TABLESPACE purchase_space;
The PURCHASE_SPACE tablespace already exists in the database.
Which statement describes the effect of the command?
Exhibit:
A. The command executes successfully and creates the table in the USERS tablespace.
B. The command executes successfully and creates the table in the PURCHASE_SPACE tablespace.
C. The command produces an error because the user does not have the privilege to createthe table.
D. The command produces an error because the user does not have quota in the PURCHASE_SPACE tablespace.
Answer: B
Q45. 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
Q46. Which three statements are true about logical structures of the Oracle database? (Choose three.)
A. Each segment contains one or more extents.
B. Multiple tablespaces can share a single data file.
C. A data block is the smallest unit of input/output (I/O) in data files.
D. It is possible to have tablespaces of different block sizes in a database.
E. Each data block in the database always corresponds to one operating system block.
Answer: ACD
Q47. You execute a command to resize a data file, sales.dbf, of size 200 MB in your database:
ALTER DATABASE DATAFILE '/remorse/sales.dbf' RESIZE 150M;
Which statement is true about this command?
A. The command must be issued in MOUNT state.
B. The command succeeds only if the data file is offline.
C. The command must be issued when the database is in the archivelog mode.
D. The command succeeds if no extent in the tablespace is currently allocated above the 150 MB boundary of the file.
Answer: D
Q48. User A executes the following command to drop a large table in your database:
SQL> DROP TABLE trans;
While the drop table operation is in progress; user B executes the following command on the same table;
SQL> DELETE FROM trans WHERE tr_type='SL'
Which statement is true regarding the DELETE command?
A. It fails to delete the records because the records are locked in the SHARE mode
B. It deletes the rows successfully because the table is locked in the SHARE mod
C. It fails to delete the records because the table is locked in EXCLUSIVE mode
D. It deletes the rows successfully because the table is locked in SHARE ROW EXCLUSIVE mode
Answer: C
Q49. The HR user creates a stand-alone procedure as follows and grants the EXECUTE privilege on the procedure to many database users:
CREATE OR REPLACE PROCEDURE create_dept ( v_deptno NUMBER, v_dname VARCHAR2,
v_mgr NUMBER, v_loc NUMBER)
BEGIN
INSERT INTO hr.departments VALUES (v_deptno, v_dname, v_mgr, v_loc);
END;
The users having permission to execute the procedure are able to insert records into the
DEPARTMENTS table even though they do not have the INSERT privilege on the table. You want only those users who have privileges on the DEPARTMENTS table to be able to execute the procedure successfully.
What would you suggest to the PL/SQL developers to achieve this?
A. Create the procedure with definer's right.
B. Create the procedure with invoker's right.
C. Grant the EXECUTE privilege with GRANT OPTION on the procedure to selected users.
D. Create the procedure as part of a PL/SQL package and grant the EXECUTE privilege on the package to selected users.
Answer: B
Q50. 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
Answer: AB
