Q. Your company hired Joe, a DBA who will be working from home. Joe needs to have the ability to start the database remotely. You created a password file for your database and set REMOTE_LOGIN_PASSWORDFILE = EXCLUSIVE in the parameter file. Which command adds Joe to the password file, allowing him remote DBA access?
A. GRANT DBA TO JOE;
B. GRANT SYSDBA TO JOE;
C. GRANT RESOURCE TO JOE;
D. orapwd file=orapwdPROD user=JOE password=DBA
Answer: D
Q. Which command can you use to display the date and time in the form 17:45:01 JUL-12-2000 using the default US7ASCII character set?
A. ALTER SYSTEM SET NLS_DATE_FORMAT='HH24:MI:SS MON-DD-YYYY';
B. ALTER SESSION SET DATE_FORMAT='HH24:MI:SS MON-DD-YYYY';
C. ALTER SESSION SET NLS_DATE_FORMAT='HH24:MI:SS MON-DD-YYYY';
D. ALTER SYSTEM SET NLS_DATE_FORMAT='HH:MI:SS MON-DD-YYYY';
Answer: C
Q. When preparing to create a database, you should be sure that you have sufficient disk space for your database files. When calculating the space requirements you need to consider that some of the files may be multiplexed. Which two types of files should you plan to multiplex? (Choose two.)
A. data files
B. control file
C. password file
D. online redo log files
E. initialization parameter file
Answer: AB
Q. Which is true when considering the number of indexes to create on a table?
A. Every column that is updated requires an index.
B. Every column that is queried is a candidate for an index.
C. Columns that are part of a WHERE clause are candidates for an index.
D. On a table used in a Data Warehouse application there should be no indexes.
Answer: C
Q. You issue the following queries to obtain information about the redo log files:
SQL> SELECT group#, type, member FROM v$logfile;
You immediately issue this command:
ALTER DATABASE DROP LOGFILE MEMBER
'/databases/DB01/ORADATA/u03/log2b.rdo';
Why does the command fail?
A. Each online redo log file group must have two members.
B. You cannot delete any members of online redo log file groups.
C. You cannot delete any members of the current online redo log file group
D. You must delete the online redo log file in the operating system before issuing the ALTER DATABASE command.
Answer: C
Q. The ORDERS table has a constant transaction load 24 hours a day, so down time is not allowed. The indexes become fragmented. Which statement is true?
A. The index needs to be dropped, and then re-created.
B. The resolution of index fragmentation depends on the type of index.
C. The index can be rebuilt while users continue working on the table.
D. The index can be rebuilt, but users will not have access to the index during this time.
E. The fragmentation can be ignored because Oracle resolves index fragmentation by means of a freelist.
Answer: C
Q. The DBA can structure an Oracle database to maintain copies of online redo log files to avoid losing database information. Which three are true regarding the structure of online redo log files? (Choose three.)
A. Each online redo log file in a group is called a member.
B. Each member in a group has a unique log sequence number.
C. A set of identical copies of online redo log files is called an online redo log group.
D. The Oracle server needs a minimum of three online redo log file groups for the normal operation of a database.
E. The current log sequence number of a redo log file is stored in the control file and in the header of all data files.
F. The LGWR background process concurrently writes the same information to all online and archived redo log files in a group.
Answer: BCE
Q. Which type of segment is used to improve the performance of a query?
A. index
B. table
C. temporary
D. boot strap
Answer: A
Q. You have just accepted the position of DBA with a new company. One of the first things you want to do is examine the performance of the database. Which tool will help you to do this?
A. Recovery Manager
B. Oracle Enterprise Manager
C. Oracle Universal Installer
D. Oracle Database Configuration Assistant
Answer: B
Q. Which steps should you take to gather information about checkpoints?
A. Set the LOG_CHECKPOINTS_TO_ALERT initialization parameter to TRUE. Monitor the alert log file.
B. Set the LOG_CHECKPOINT_TIMEOUT parameter. Force a checkpoint by using the FAST_START_MTTR_TARGET parameter. Monitor the alert log file.
C. Set the LOG_CHECKPOINT_TIMEOUT parameter. Force a log switch by using the command ALTER SYSTEM FORCE LOGSWITCH. Force a checkpoint by using the command ALTER SYSTEM FORCE CHECKPOINT. Monitor the alert log file.
D. Set the FAST_START_MTTR_TARGET parameter to TRUE. Force a checkpoint by using the command ALTER SYSTEM FORCE CHECKPOINT.
Monitor the alert log file.
Answer: A
Q. Examine the SQL statement:
CREATE TABLESPACE user_data
DATAFILE '/u01/oradata/user_data_0l.dbf' SIZE 100M
LOCALLY MANAGED UNIFORM SIZE 1M
AUTOMATIC SEGMENT SPACE MANAGEMENT;
Which part of the tablespace will be of a uniform size of 1 MB?
A. extent
B. segment
C. Oracle block
D. operating system block
Answer: A
Q. You are in the process of dropping the BUILDING_LOCATION column from the HR.EMPLOYEES table. The table has been marked INVALID until the operation completes. Suddenly the instance fails. Upon startup, the table remains INVALID. Which step(s) should you follow to complete the operation?
A. Continue with the drop column command:
ALTER TABLE hr.employees DROP COLUMNS CONTINUE;
B. Truncate the INVALID column to delete remaining rows in the column and release unused space immediately.
C. Use the Export and Import utilities to remove the remainder of the column from the table and release unused space.
D. Mark the column as UNUSED and drop the column:
ALTER TABLE hr.employees
SET UNUSED COLUMN building location;
ALTER TABLE hr.employees
DPOP UNUSED COLUMN building_location
CASCADE CONSTRAINTS;
Answer: D
Q. Based on the following profile limits, if a user attempts to log in and fails after five tries, how long must the user wait before attempting to log in again?
ALTER PROFILE DEFAULT LIMIT
PASSWORD_LIFE_TIME 60
PASSWORD_GRACE_TIME 10
PASSWORD_REUSE_TIME 1800
PASSWORD_REUSE_MAX UNLIMITED
FAILED_LOGIN_ATTEMPTS 5
PASSWORD_LOCK_TIME 1/1440
PASSWORD_VERIFY_FUNCTION verify_function;
A. 1 minute
B. 5 minutes
C. 10 minutes
D. 14 minutes
E. 18 minutes
F. 60 minutes
Answer: A
Q. You create a new table named DEPARTMENTS by issuing this statement:
CREATE TABLE departments(
department_id NUMBER(4),
department_name VARCHAR2(30),
manager_id NUMBER(6),
location_id NUMBER(4))
STORAGE(INITIAL 200K NEXT 200K
PCTINCREASE 0 MINEXTENTS 1 MAXEXTENTS 5);
You realize that you failed to specify a tablespace for the table. You issue these queries:
SQL> SELECT username, default_tablespace,
temporary tablespace
2> FROM user_users;
In which tablespace was your new DEPARTMENTS table created?
A. TEMP
B. SYSTEM
C. SAMPLE
D. USER_DATA
Answer: C
Q. Which two statements are true about identifying unused indexes? (Choose two.)
A. Performance is improved by eliminating unnecessary overhead during DML operations.
B. V$INDEX_STATS displays statistics that are gathered when using the MONITORING USAGE keyword.
C. Each time the MONITORING USAGE clause is specified, the V$OBJECT_USAGE view is reset for the specified index.
D. Each time the MONITORING USAGE clause is specified, a new monitoring start time is recorded in the alert log.
Answer: AC
Q. You need to create an index on the SALES table, which is 10 GB in size. You want your index to be spread across many tablespaces, decreasing contention for index lookup, and increasing scalability and manageability. Which type of index would be best for this table?
A. bitmap
B. unique
C. partitioned
D. reverse key
E. single column
F. function-based
Answer: C
Q. The database needs to be shut down for hardware maintenance. All users sessions except one have either voluntarily logged off or have been forcibly killed. The one remaining user session is running a business critical data manipulation language (DML) statement and it must complete prior to shutting down the database. Which shutdown statement prevents new user connections, logs off the remaining user, and shuts down the database after the DML statement completes?
A. SHUTDOWN
B. SHUTDOWN ABORT
C. SHUTDOWN NORMAL
D. SHUTDOWN IMMEDIATE
E. SHUTDOWN TRANSACTIONAL
Answer: E
Q. What provides for recovery of data that has not been written to the data files prior to a failure?
A. redo log
B. undo segment
C. rollback segment
D. system tablespace
Answer: A
Continue.....
