1Z0-052 | What Approved 1Z0-052 exam Is?
Q41. The user HR owns the EMP table. The user HR grants privileges to the user SCOTT by using this command:
Which statement is true after HR issues the REVOKE command?
A. The command fails because SCOTT still has privileges.
B. The command succeeds and privileges are revoked from JIM.
C. The command fails because HR cannot revoke the privileges from JIM.
D. The command succeeds and only HR has the privilege to perform the SELECT, INSERT, and UPDATE operations on the EMP table.
Answer: C
Q42. View the Exhibit and examine the command used to create the ZONEDATA table. The table contains a million rows for zonewise analysis in the DSS system. DML operations are performed very rarely on the table. You decide to prepare an index on the ZONE column to enhance the performance of the queries on the ZONE column.
Which type of index would you select in this scenario?
Exhibit:
A. Bitmap index
B. Reverse key index
C. Normal BTree index
D. Functionbased index
Answer: A
Q43. 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
Q44. Why does performance degrade when many UPDATE, INSERT or DELETE statements are issued on a table that has an associated bitmap index?
A. The DML operations re-create the bitmap index blocks
B. The bitmap index is rebuilt automatically after a DML operation
C. The smallest amount of a bitmap that can be locked is a bitmap segment
D. Additional time is taken to remove NULL values from the bitmap index after a DML operation
Answer: C
Q45. You want to move all objects of the APPS user in the test database to the DB_USR schema of the production database. Which option of IMPDP would you use to accomplish this task?
A. FULL
B. SCHEMAS
C. TRANSFORM
D. REMAP_SCHEMA
E. REMAP_TABLESPACE
Answer: D
Q46. Given below is a list of scenarios:
1. A user terminates his session abnormally.
2. The connection between the server and the client application terminates because of a network failure.
3. A schema is accidentally dropped.
4. The tablespace is accidentally dropped from the database.
5. The hard disk gets corrupted and the data files in the disk are lost.
6. The database instance abnormally shuts down because of power failure.
Which scenarios require DBA intervention to perform recovery?
A. 1, 3, and 6
B. 4, 5, and 6
C. 3, 4, and 5
D. 1, 2, and 6
Answer: C
Q47. You configured the Flash Recovery Area for your database. The database instance has been started in ARCHIVELOG mode and the LOG_ARCHIVE_DEST_1 parameter is not set.
What will be the implications on the archiving and the location of archive redo log files?
A. Archiving will be disabled because the destination for the redo log files is missing
B. The database instance will shut down and the error details will be logged in the alert log file
C. Archiving will be enabled and the destination for the archived redo log file will be set to the Flash Recovery Area implicitly
D. Archiving will be enabled and the location for the archive redo log file will be created in the default location $ORACLE_HOME/log
Answer: C
Q48. 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.
Answer: B
Q49. Your database is functional with a peak load for the last one hour. You want to preserve the performance statistics collected during this period to be used for comparison when you analyze the performance of the database in the future.
What action would you take to achieve this task?
A. Insert finding directives for ADDM tasks in the future.
B. Create a baseline on a pair of snapshots spanning the peak-load period.
C. Decrease the snapshot interval in the AWR to collect more snapshots during the peakload period.
D. Set the snapshot retention period in the Automatic Workload Repository (AWR) to zero to avoid automatic purging of snapshots.
Answer: B
Q50. 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?
A. Set the SGA_TARGET initialization parameter to zero.
B. Set the PRE_PAGE_SGA initialization parameter to TRUE.
C. Set the MEMORY_MAX_TARGET initialization parameter to zero.
D. Set the SGA_TARGET initialization parameter to a nonzero value.
Answer: D