A table is stored in a data dictionary managed tablespace. Which two columns are required from DBA_TABLES to determine the size of the extent when it extends?
BLOCKS 33.0%
PCT_FREE 0.0%
NEXT_EXTENT 50.0%
PCT_INCREASE 16.0%
An index on the PASSPORT_RECORDS table has to be created. It contains 10 million rows of data. The key columns have low cardinality. The queries generated against this table use a combination of mu...
Bitmap 50.0%
Unique 0.0%
Partitioned 50.0%
Reverse key 0.0%
Consider this SQL statement: UPDATE employees SET first_name = 'John' WHERE emp_id = 1009; COMMIT; What happens when a user issues the COMMIT in the above SQL statement?
The server process places the commit record in the redo log buffer 0.0%
Log Writer (LGWR) writes the redo log buffer entries to the redo log files and data files 50.0%
The user process notifies the server process that the transaction is complete 50.0%
The user process notifies the server process that the resource locks can be released 0.0%
Evaluate the following SQL: CREATE USER sam IDENTIFIED BY sam; GRANT CREATE ANY MATERIALIZED VIEW, CREATE ANY DIMENSION, DROP ANY DIMENSION, QUERY REWRITE, GLOBAL QUERY REWRITE TO dw_manager WITH A...
Select from a table 0.0%
Create and drop a materialized view 33.0%
Alter a materialized view that was created 16.0%
Grant and revoke the role to and from other users 33.0%
Enable the role and exercise any privileges in the role's privilege domain 16.0%
Examine the following SQL statement: CREATE TABLESPACE userdata DATAFILE '/oracle/oradata/userdata_0l.dbf' SIZE 100M LOCALLY MANAGED UNIFORM SIZE 1M AUTOMATIC SEGMENT SPACE MANAGEMENT; Which part o...
Extent 100.0%
Segment 0.0%
Oracle block 0.0%
Operating system block 0.0%
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 table...
Extent 100.0%
Segment 0.0%
Oracle block 0.0%
Operating system block 0.0%
For what purpose is the initialization parameter UNDO_RETENTION used?
To specify the length of time Oracle must retain undo data in the undo tablespace 50.0%
To specify the length of time Oracle must retain undo data in the flash recovery area 50.0%
To specify the length of time Oracle must retain undo data in the data files 0.0%
To specify the length of time Oracle will retain undo data in the flashback database logs 0.0%
For which two constraints are indexes created when the constraint is added?
Check 0.0%
Unique 50.0%
Not null 0.0%
Primary key 50.0%
For which two tasks would it be best not to use the utility SQL*Loader?
When loading selected rows into each table 0.0%
When loading data from an export dump file 50.0%
When loading data from disk, tape, or named pipes 0.0%
When data is not being inserted from a flat file 50.0%
For which two types of tablespaces can proactive tablespace alerts be set?
Locally managed 50.0%
Dictionary-managed 0.0%
Read-only 0.0%
Online 50.0%
How can the SQL Access Advisor be managed?
Through the DBMS_SQLTUNE package 0%
Through the DBMS_ADVISOR package 0%
Through the SQL_TUNE package 0%
Through the DBA_ADVISOR package 0%
How is the SQL profile used?
In the tuning mode of the optimizer only 0%
In the normal mode of the optimizer 0%
In neither the tuning nor the normal mode of the optimizer 0%
Along with existing statistics, to get better SQL execution plans 0%
If the DBCA is used to create a new database, when is the creation of the new flash recovery area mandatory?
Always 0%
Only if the automatic backup using the OEM is configured 0%
Only if user-managed backups is configured 0%
Only if the database is run in the archive log mode 0%
To grant a system privilege with the GRANT statement, one should:
Have been granted the GRANT ROLE PRIVILEGE system privilege 0%
Have been granted the system privilege with the ADMIN OPTION 0%
Have been granted the GRANT ANY PRIVILEGE system privilege 0%
Have been granted the system privilege with the GRANT OPTION 0%
User Smith created indexes on some tables owned by user John. The following has to be displayed: 1.Index names 2.Index types Which data dictionary view(s) should be queried?
DBA_INDEXES only 0%
DBA_IND_COLUMNS only 0%
DBA_INDEXES and DBA_USERS 0%
DBA_IND COLUMNS and DBA_USERS 0%
What are the functions of an ASM instance?
Managing disk groups and communicating file metadata to the Oracle database using ASM files 0%
Managing database files and communicating file metadata to the ASM instance using ASM files 0%
Managing disk groups and communicating file metadata to the RMAN 0%
Protecting disk groups 0%
What are the two main advantages of using bitmap indexes?
Bitmap indexes use less storage space 0%
Bitmap indexes are easy to maintain when DML statements are issued 0%
Bitmap segments are updated upon COMMIT, at the end of the transaction 0%
Bitmap indexes work very fast with multiple predicates that are combined with AND, OR, and NOT operators 0%
What do ASM disk groups provide?
Redundancy through striping 0%
Performance through mirroring 0%
Redundancy through mirroring 0%
Performance through striping 0%
What does the ARBn background process do in an ASM instance?
Coordinates disk activity 0%
Performs disk rebalance work 0%
Coordinates disk rebalance work 0%
Manages the RBAL process 0%
What does the RMAN CATALOG command do?
Helps create image copies of datafiles 0%
Helps create image copies of current control files 0%
Helps catalog any new files that aren't a part of the recovery catalog 0%
Helps catalog only the old files 0%
What happens once the DBA disables the flash recovery area?
The RMAN will continue to be able to access the files in the flash recovery area 0%
The RMAN will be unable to access the files in the flash recovery area 0%
The RMAN will be unable to access the automatic space management features of the flash recovery area 0%
The RMAN can use only the automatic space management features of the flash recovery area 0%
What is the default value for the OPTIMIZER_MODE initialization parameter?
FIRST_ROWS 0%
ALL_ROWS 0%
CHOOSE 0%
COST 0%
What is the priority level for a job in a job class?
From 1 to 5 0%
From 1 to 999 0%
From 1 to 10 0%
A job can only take a value of HIGH or LOW. 0%
What is the purpose of the flashback technology in Oracle Database 10g?
Recovery of a data file from physical corruption 0%
Recovery of a data file from physical and logical corruption 0%
Recovery of a data file from logical corruption 0%
Recovery from a problem brought on by a damaged disk drive 0%
What should be confirmed before changing the CURSOR_SPACE_FOR_TIME parameter in the initialization file to TRUE?
The TIMED_STATISTICS parameter is set to TRUE 0%
The hit percentage in the buffer cache is at least 95% 0%
The OPEN_CURSOR parameter is set to at least twice the default value 0%
The value in the RELOADS column of V$LIBRARYCACHE is consistently zero 0%
What statistics will Oracle collect If LIST subpartitioning is used, and the value of the GRANULARITY argument is specified as AUTO?
Global statistics only 0%
Global and partition statistics only 0%
Global, partition, and subpartition statistics 0%
No partitioned table statistics 0%
What will happen if the value of the SGA_TARGET parameter is set higher than the value of the SGA_MAX_SIZE parameter at instance startup?
The instance will not start 0%
SGA_TARGET will become equal to the SGA_MAX_SIZE value 0%
The database will ignore the SGA_TARGET parameter 0%
SGA_MAX_SIZE is automatically raised, so it is equal to the SGA_TARGET value 0%
What will the command EXECUTE DBMS_SCHEDULER.PURGE_LOG(); do?
Purge only all the window logs 0%
Purge only all the job logs 0%
Purge all window and job logs 0%
Purge only yesterday's job logs 0%
When a deadlock shutdown is detected by Oracle, where is the trace file generated?
SQL_TRACE 0%
TRACE_DEST 0%
USER_DUMP_DEST 0%
CORE_DUMP_DEST 0%
When is SGA created in an Oracle database environment?
When the database is created 0%
When the instance is started 0%
When the database is mounted 0%
When a user process is started 0%
When there is a monotonically increasing sequence number as an indexed column, which of the following is true?
Hash-partitioned global indexes are useful 0%
Range-partitioned global indexes are better 0%
Hash-partitioned local indexes are better 0%
Range-partitioned local indexes are better 0%
Where can a SQL Tuning Set(STS) be created from?
Several SQLs statements from the AWR 0%
One or more other STSs 0%
A single SQL statement 0%
Only the most high-load SQL statements in the database 0%
Where can the nondefault parameters be found when the instance is started?
Alert log 0%
Online redo log 0%
Archiver redo log 0%
SYSTEM user's trace file 0%
Where is the free space managed, for a tablespace created with automatic segment-space management?
In the extent 0%
In the control file 0%
In the data dictionary 0%
In the undo tablespace 0%
Which background process performs a checkpoint in the database,by writing modified blocks from the database buffer cache in the SGA to the data files?
LGWR 0%
SMON 0%
DBWn 0%
CKPT 0%
Which command would revoke the ROLE_DATA role from all users?
REVOKE role_data FROM ALL; 0%
REVOKE role_data FROM PUBLIC; 0%
REVOKE role_data FROM default; 0%
REVOKE role_data FROM ALL_USERS; 0%
Which conditions among the following must be met, if the tablespace is to be made read only?
The tablespace must contain an active rollback segments 0%
The tablespace must be online 0%
The tablespace must not contain any active rollback segments 0%
The tablespace must not be involved in an open backup 0%
The tablespace must be involved in an open backup 0%
Which data dictionary view should be queried to find the following information about a user? 1.Whether the user's account has expired 2.The user's default tablespace name 3.The user's profile name
DBA_USERS only 0%
DBA_USERS and DBA_PROFILES 0%
DBA_USERS and DBA_TABLESPACES 0%
DBA_USERS, DBA_TS_QUOTAS, and DBA_PROFILES 0%
Which data dictionary view should be used to get a list of object privileges for all database users?
DBA_TAB_PRIVS 0%
ALL_TAB_PRIVS 0%
USER_TAB_PRIVS 0%
ALL_TAB_PRIVS_MADE 0%
Which data dictionary view shows the available free space in a certain tablespace?
DBA_EXTENTS 0%
V$FREESPACE 0%
DBA_FREE_SPACE 0%
DBA_TABLESPACFS 0%
Which DBMS_LOGMNR feature facilitates the automatic adding of redo log files for mining?
REMOVE_LOGFILE 0%
CONTINUOUS_MINE 0%
NO_ROWID_IN_STMT 0%
AUTOMATIC_LOGFILE 0%
Which graphical DBA administration tool should be used to tune an Oracle database?
SQL*Plus 0%
Oracle Enterprise Manager 0%
Oracle Universal Installer 0%
Oracle Database Configuration Assistant 0%
Which initialization parameter specifies the location of the alert log file?
UTL_FILE_DIR 0%
USER_DUMP_DEST 0%
LOG_ARCHIVE_DEST 0%
BACKGROUND_DUMP_DEST 0%
Which memory structure contains the information used by the server process to validate user privileges?
Buffer cache 0%
Library cache 0%
Data dictionary cache 0%
Redo log buffer cache 0%
Which of the following are considered types of segments?
Only LOBS 0%
Only nested tables 0%
Only index-organized tables 0%
Only LOBS and index-organized tables 0%
Nested tables, LOBS, index-organized tables, and boot straps 0%
Which of the following commands are used to copy ASM files?
RMAN commands 0%
OMF commands 0%
Operating system commands 0%
Logical Volume Manager commands 0%
Which of the following commands must be used to apply incremental backups?
RECOVER BACKUP OF DATABASE 0%
RECOVER DATAFILE 0%
RECOVER COPY OF DATAFILE 0%
RECOVER COPY OF DATABASE 0%
Which of the following helps the user identify his statement in the DBA_TUNE_MVIEW view?
The STATEMENT variable 0%
The STATEMENT_ID column 0%
The VIEW_ID column 0%
The TASK_NAME variable 0%
Which of the following initialization parameters would belong to the basic group of parameters?
SHARED_POOL 0.0%
CURSOR_SPACE_FOR_TIME 0.0%
DB_NAME 100.0%
CURSOR_SHARING 0.0%
Which of the following is a new initialization parameter for Oracle Database 10g?
UNDO_SUPPRESS_ERRORS 0.0%
PARALLEL_AUTOMATIC_TUNING 0.0%
RESUMABLE_TIMEOUT 100.0%
SHARED_SERVER 0.0%
Which of the following is mandatory when using the easy connect naming method?
Host name 0%
Database name 0%
Service name 0%
Port number 0%
Which of the following is true if the alter tablespace statement is used and the TEMPORARY clause is specified?
Oracle no longer performs any checkpoint for the online datafiles in the tablespace 0%
Oracle performs a checkpoint for all online datafiles in the tablespace 0%
Oracle does not ensure that all files are written 0%
The offline files may require media recovery before the tablespace is brought online 0%
The offline files may require media recovery after the tablespace is brought online 0%
Which of the following is true when John uses the RESETLOGS option?
He doesn't need to back up the database 0%
He must back up the database right away 0%
He can use archive redo logs from an older incarnation of the database 0%
He can't use archive redo logs from an older incarnation of the database 0%
Which of the following items are stored in the flash recovery area?
Datafiles 0%
Undo segments 0%
Datafile copies 0%
Archived redo log files 0%
Which of the following sets of tablespaces is mandatory for any Oracle 10g database?
SYSTEM, SYSAUX, and UNDOTBS 0%
SYSTEM and UNDOTBS 0%
SYSAUX and UNDOTBS 0%
SYSTEM and SYSAUX 0%
Which option lists the correct hierarchy of storage structures, from largest to smallest?
Segment, extent, tablespace, data block 0%
Data block, extent, segment, tablespace 0%
Tablespace, extent, data block, segment 0%
Tablespace, segment, extent, data block 0%
Which statement about the LOG_BUFFER initialization parameter is true?
The LOG_BUFFER parameter can be changed dynamically 0%
The minimum value for the LOG_FILE parameter is 512KB 0%
The LOG_BUFFER parameter value must be a multiple of the database block size 0%
The LOG_BUFFER parameter value must be a multiple of the operating system block size 0%
Which statement is true when connecting to the Oracle instance using the multithreaded server configuration?
The User Global Area (UGA) may only contain sort areas 0%
The User Global Area (UGA) may be accessible to dedicated servers 0%
The User Global Area (UGA) components may reside in the large pool 0%
The User Global Area (UGA) components may reside in the buffer cache 0%
Which statement is valid regarding index clusters?
Index clusters can only be used for tables with low cardinality columns 0%
Index clusters are generally well suited for tables that have many full table scans 0%
Normal B-Tree indexes do not store null key values, whereas cluster indexes store null keys 0%
A cluster index always takes up much more storage space than a normal index for the same set of key values 0%
Which tablespace is used as the temporary tablespace if 'TEMPORARY TABLESPACE' is not specified for a user?
TEMP 0%
DATA 0%
SYSTEM 0%
ROLLBACK 0%
Which three among the following dynamic performance views obtain information from the control file?
V$LOG 0%
V$SGA 0%
V$THREAD 0%
V$VERSION 0%
V$DATAFILE 0%
Which three major tuning areas does OEM Database Control provide information about?
Most-used objects 0%
Top SQL statements 0%
Memory usage 0%
Top sessions affecting the instance 0%
CPU and wait classes 0%
Which three out of the following are the physical structures that constitute the Oracle database?
Segment 0%
Data file 0%
Log file 0%
Tablespace 0%
Control file 0%
Which three statements among the following are true about rebuilding indexes?
The ALTER INDEX REBUILD command is used to change the storage characteristics of an index 0%
Using the ALTER INDEX REBUILD is usually faster than dropping and recreating an index because it uses the fast full scan feature 0%
Oracle8i allows for the creation of an index or re-creation of an existing index while allowing concurrent operations on the base table 0%
When building an index, the NOLOGGING and UNRECOVERABLE keywords can be used concurrently to reduce the time it takes to rebuild itself 0%
Which two statements are true about rebuilding an index?
The resulting index may contain deleted entries 0%
A new index is built using an existing index as the data source 0%
Queries cannot use the existing index while the new index is being built 0%
During a rebuild, sufficient space is needed to accommodate both the old and the new index in their respective tablespaces 0%
Which view provides the names of all the data dictionary views?
DBA_NAMES 0%
DBA_TABLES 0%
DICTIONARY 0%
DBA_DICTIONARY 0%
Who will be the owner of the job, if you create a job in user SCOTT's schema?
SYS will be the owner of the job 0%
You will be the owner of the job 0%
PUBLIC will be the owner of the job 0%
SCOTT will be the owner of the job 0%