Note: Thanks for your visit. We have uploaded all latest Upwork Oracle 10g Database Administration questions. We are trying to solve these questions and answers will be updated soon. For updates, please keep visting this site and also share it with your friends. Thanks & Regards
What should be confirmed before changing the CURSOR_SPACE_FOR_TIME parameter in the initialization file to TRUE?
a. The TIMED_STATISTICS parameter is set to TRUE
b. The hit percentage in the buffer cache is at least 95%
c. The OPEN_CURSOR parameter is set to at least twice the default value
d. The value in the RELOADS column of V$LIBRARYCACHE is consistently zero
Which statement about the LOG_BUFFER initialization parameter is true?
a. The LOG_BUFFER parameter can be changed dynamically
b. The minimum value for the LOG_FILE parameter is 512KB
c. The LOG_BUFFER parameter value must be a multiple of the database block size
d. The LOG_BUFFER parameter value must be a multiple of the operating system block size
Which two statements are true about rebuilding an index?
a. The resulting index may contain deleted entries
b. A new index is built using an existing index as the data source
c. Queries cannot use the existing index while the new index is being built
d. During a rebuild, sufficient space is needed to accommodate both the old and the new index in their respective tablespaces
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 1MB?
c. Oracle block
d. Operating system block
For which two constraints are indexes created when the constraint is added?
c. Not null
d. Primary key
Who will be the owner of the job, if you create a job in user SCOTT’s schema?
a. SYS will be the owner of the job
b. You will be the owner of the job
c. PUBLIC will be the owner of the job
d. SCOTT will be the owner of the job
Which three out of the following are the physical structures that constitute the Oracle database?
b. Data file
c. Log file
e. Control file
What happens once the DBA disables the flash recovery area?
a. The RMAN will continue to be able to access the files in the flash recovery area
b. The RMAN will be unable to access the files in the flash recovery area
c. The RMAN will be unable to access the automatic space management features of the flash recovery area
d. The RMAN can use only the automatic space management features of the flash recovery area
Which of the following commands are used to copy ASM files?
a. RMAN commands
b. OMF commands
c. Operating system commands
d. Logical Volume Manager commands