______________ is mandatory for using the easy connect naming method.
Host name 50.0%
Database name 0.0%
Service name 50.0%
Port number 0.0%
________________ shows the free space available in a certain tablespace.
DBA_EXTENTS 0%
V$FREESPACE 0%
DBA_FREE_SPACE 0%
DBA_TABLESPACFS 0%
ASM disk groups provide:
Redundancy through striping 0.0%
Performance through mirroring. 33.0%
Redundancy through mirroring 33.0%
Performance through striping 33.0%
Consider the following 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 100.0%
Log Writer (LGWR) writes the redo log buffer entries to the redo log files and data files 0.0%
The user process notifies the server process that the transaction is complete 0.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...
Select from a table 0.0%
Create and drop a materialized view 0.0%
Alter a materialized view that you created 0.0%
Grant and revoke the role to and from other users 100.0%
Enable the role and exercise any privileges in the role's privilege domain 0.0%
Examine the following 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 ...
Extent 0%
Segment 0%
Oracle block 0%
Operating system block 0%
In an Oracle database environment, SGA is created:
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%
The initialization parameter UNDO_RETENTION is used:
To specify the length of time for which Oracle must retain undo data in the undo tablespace 50.0%
To specify the length of time for which Oracle must retain undo data in the flash recovery area 0.0%
To specify the length of time for which Oracle must retain undo data in the data files 50.0%
To specify the length of time for which Oracle will retain undo data in the flashback database logs 0.0%
The RMAN CATALOG command:
Helps create the image copies of datafiles 0%
Helps create the image copies of current control files 0%
Helps catalog the new files that are not a part of the recovery catalog 0%
Helps catalog only the old files 0%
The SQL Access Advisor is managed:
Through the DBMS_SQLTUNE package 0.0%
Through the DBMS_ADVISOR package 100.0%
Through the SQL_TUNE package 0.0%
Through the DBA_ADVISOR package 0.0%
The utility SQL*Loader should not be used:
While loading selected rows into each table 0%
While loading data from an export dump file 0%
While loading data from disk, tape, or named pipes 0%
While the data is NOT being inserted from a flat file 0%
User Smith created indexes on some tables owned by user John. You need to display the following: Index names Index types Which data dictionary view(s) would you query?
DBA_INDEXES only 0%
DBA_IND_COLUMNS only 0%
DBA_INDEXES and DBA_USERS 0%
DBA_IND COLUMNS and DBA_USERS 0%
What are two main advantages of using bitmap indexes?
Bitmap indexes use less storage space 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%
None of the above 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 happens when 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%
None of the above 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 purpose of the flashback technology in Oracle Database 10g?
Recovery from physical corruption of a data file 0%
Recovery from physical and logical corruption of a data file 0%
Recovery from logical corruption of a data file 0%
Recovery from a problem brought on by a damaged disk drive 0%
What should you confirm before changing the CURSOR_SPACE_FOR_TIME parameter (in your 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 will happen if you set the value of the SGA_TARGET parameter 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%
Where can you find the non default parameters 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 trace file generated when a deadlock shutdown is detected by Oracle?
SQL_TRACE 0%
TRACE_DEST 0%
USER_DUMP_DEST 0%
CORE_DUMP_DEST 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 DBMS_LOGMNR feature facilitates the automatic addition of the redo log files for mining?
REMOVE_LOGFILE 0%
CONTINUOUS_MINE 0%
NO_ROWID_IN_STMT 0%
AUTOMATIC_LOGFILE 0%
Which of the following commands are 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 commands revokes the ROLE_DATA role from all the 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 of the following conditions must be met to make tablespace 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 of the following constitute 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%
Which of the following constitute the 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 data dictionary views should be used to get a list of object privileges for all the database users?
DBA_TAB_PRIVS 0%
ALL_TAB_PRIVS 0%
USER_TAB_PRIVS 0%
ALL_TAB_PRIVS_MADE 0%
Which of the following graphical DBA administration tools is used to tune an Oracle database?
SQL*Plus 0%
Oracle Enterprise Manager 0%
Oracle Universal Installer 0%
Oracle Database Configuration Assistant 0%
Which of the following helps you identify your 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 belong to the basic group of parameters?
SHARED_POOL 0%
CURSOR_SPACE_FOR_TIME 0%
DB_NAME 0%
CURSOR_SHARING 0%
Which of the following initialization parameters 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 of the following is a new initialization parameter for Oracle Database 10g?
UNDO_SUPPRESS_ERRORS 0%
PARALLEL_AUTOMATIC_TUNING 0%
RESUMABLE_TIMEOUT 0%
SHARED_SERVER 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 physical structures constitute the Oracle database?
Segment 0%
Data file 0%
Log file 0%
Tablespace 0%
Control file 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 of the following statements are correct for 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 new indexes in their respective tablespaces 0%
Which of the following statements are correct for using the RESETLOGS option?
You don't need to back up the database 0%
You must back up the database right away 0%
You can use archive redo logs from an older incarnation of the database 0%
You cannot use archive redo logs from an older incarnation of the database 0%
Which of the following statements are correct with regard to 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 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 0%
Which of the following statements is correct with regard to 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 of the following statements is correct with regard to LOG_BUFFER initialization parameter?
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 of the following types of commands is used to copy ASM files?
RMAN Commands 0%
OMF Commands 0%
Operating System Commands 0%
Logical Volume Manager Commands 0%
Which of the following views provides the names of all the data dictionary views?
DBA_NAMES 0%
DBA_TABLES 0%
DICTIONARY 0%
DBA_DICTIONARY 0%
Which tablespace is used as a temporary tablespace if 'TEMPORARY TABLESPACE' is not specified for a user?
TEMP 0%
DATA 0%
SYSTEM 0%
ROLLBACK 0%
You want to find the following information about a user: - The expiry date of the user's account - The user's default tablespace name - The user's profile name Which data dictionary view should be...
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%