Get real exam questions for 1Z0-052 Oracle Database 11g: Administration I. 100% Free.
Q1. 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
Q1. Which two kinds of failures make the Data Recovery Advisor (DRA) generate a manual checklist? (Choose two.)A. Failure when no standby database is configuredB. Failure because a data file is renamed accidentallyC. Failure that requires no archive logs to be applied for recoveryD. Failure due to loss of connectivity-for example, an unplugged disk cableView AnswerAnswer: BDQ2. View the Exhibit
Q1. Which three statements are correct about temporary tables? (Choose three.)A. Indexes and views can be created on temporary tablesB. Both the data and structure of temporary tables can be exportedC. Temporary tables are always created in a user's temporary tablespaceD. The data inserted into a temporary table in a session is available to other sessionsE. Data Manipulation Language (DML) lo
Q1. Which two statements are true about standard database auditing? (Choose two.)A. DDL statements can be audited.B. Statements that refer to standalone procedure can be audited.C. Operations by the users logged on as SYSDBA cannot be audited.D. Only one audit record is ever created for a session per audited statement even though it is executed more than once.View AnswerAnswer: ABQ2. View the E
Q1. Which three statements regarding the server parameter file (SPFILE) are true? (Choose three.)A. An SPFILE is a binary fileB. An SPFILE cannot reside on a clientC. An SPFILE cannot contain static parametersD. An SPFILE can store changes persistently across instance restartsE. An SPFILE can be read by the database server, but it is not written to by the serverF. An SPFILE must be created manual
Q1. 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 co
Q1. You have a large amount of historical data in a flat file. Some analysts in your organization need to query this data in the file. The file is too large to load the data in it into your current database.Which is the most effective method to access this data in your database?A. Use the database link.B. Use the SQL*Loader utility.C. Use the Oracle Data Pump utility.D. Create an external table a
Q1. You want to configure and schedule offline database backups to run automatically.Which tool or utility would you use to achieve this?A. The XML scriptB. The PL/SQL scriptC. The DBMS_SCHEDULER packageD. Enterprise Manager to schedule the backupView AnswerAnswer: DQ2. You have set Tablespace Full Metrics Threshold values for the USERS tablespace as follows:Warning (%): 90Critical (%): 95Which
Q1. You executed the following command to create a password file in the database server:$ orapwd file = orapworcl entries = 5 ignorecase=NWhich statement describes the purpose of the above password file?A. It records usernames and passwords of users when granted the DBA roleB. It contains usernames and passwords of users for whom auditing is enabledC. It is used by Oracle to authenticate users fo
Q1. You are managing an Oracle Database 11g database. The database is open, and you plan to perform Recovery Manager (RMAN) backups.Which three statements are true about these backups? (Choose three.)A. The backups would be consistent.B. The backups would be inconsistent.C. The backups would be possible only if the database is running in ARCHIVELOG mode.D. The backups would be possible only if th
Q1. 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 tableB. The ORDERS table is dropped along with the ITEM tableC. The dependent referential integrity constrai
Q1. Which two statements are true regarding B-tree index? (Choose two.)A. The leaf blocks in the index are doubly linked.B. The leaf node stores a bitmap for each key value.C. The rows with NULL value in key columns also have entries in the index.D. The deletion of a row from the table causes a logical deletion in index leaf block and the space becomes available for the new leaf entry.View Answer
Q1. Automatic Shared Memory Management is disabled for your database instance. You realize that there are cases of SQL statements performing poorly because of repeated parsing activity, resulting in degradation of performance.What would be your next step to improve performance?A. Run the SQL Access AdvisorB. Run the memory Advisor for the SGAC. Run the memory Advisor for the PGAD. Run the memory
Q1. SQL> AUDIT DROP ANY TABLE BY scott BY SESSION WHENEVER SUCCESSFUL;What is the effect of this command?A. One audit record is created for every successful DROP TABLE command executed in the session of SCOTTB. One audit record is generated for the session when SCOTT grants the DROP ANY TABLE privilege to other usersC. One audit record is created for the whole session if user SCOTT successfull
Q1. Your database instance is configured with automatic undo management and the UNDO_RETENTION parameter is set to 900 seconds. You executed the following command to enable retention guarantee:SQL> ALTER TABLESPACE undotbs1 RETENTION GUARANTEE;What affect would this command have on the database?A. The extents in the undo tablespace retain data until the next full database backupB. The extents
Q1. You are using flat files as the data source for one of your data warehousing applications. To optimize the application performance, you plan to move the data from the flat files to clustered tables in an Oracle database. While migrating the data, you want to have minimal impact on the database performance and optimize the data load operation. Which method would you use to load data into the O