Databases - Upwork

Question: What is the default value for the OPTIMIZER_MODE initialization parameter?
A
FIRST_ROWS

B
ALL_ROWS

C
CHOOSE

D
COST

Note: Not available
1. Report
Question: Which view provides the names of all the data dictionary views?
A
DBA_NAMES

B
DBA_TABLES

C
DICTIONARY

D
DBA_DICTIONARY

Note: not sure
1. Report
Question: How is the SQL profile used?
A
In the tuning mode of the optimizer only

B
In the normal mode of the optimizer

C
In neither the tuning nor the normal mode of the optimizer

D
Along with existing statistics, to get better SQL execution plans

Note: not sure
1. Report
Question: 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 of the tablespace will be of a uniform size of 1 MB?
A
Extent

B
Segment

C
Oracle block

D
Operating system block

Note: not sure
1. Report
Question: 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

Note: not sure
1. Report
Question: 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?
A
The instance will not start

B
SGA_TARGET will become equal to the SGA_MAX_SIZE value

C
The database will ignore the SGA_TARGET parameter

D
SGA_MAX_SIZE is automatically raised, so it is equal to the SGA_TARGET value

Note: not sure
1. Report
Question: Which of the following is mandatory when using the easy connect naming method?
A
Host name

B
Database name

C
Service name

D
Port number

Note: not sure
1. Report
Question: For which two types of tablespaces can proactive tablespace alerts be set?
A
Locally managed

B
Dictionary-managed

C
Read-only

D
Online

Note: not sure
1. Report
Question: Which of the following is true if the alter tablespace statement is used and the TEMPORARY clause is specified?
A
Oracle no longer performs any checkpoint for the online datafiles in the tablespace

B
Oracle performs a checkpoint for all online datafiles in the tablespace

C
Oracle does not ensure that all files are written

D
The offline files may require media recovery before the tablespace is brought online

E
The offline files may require media recovery after the tablespace is brought online

Note: not sure
1. Report
Question: Where can a SQL Tuning Set(STS) be created from?
A
Several SQLs statements from the AWR

B
One or more other STSs

C
A single SQL statement

D
Only the most high-load SQL statements in the database

Note: not sure
1. Report

First Prev 72 73 74 75 76 Next Last

Question: What is the default value for the OPTIMIZER_MODE initialization parameter?

Question: Which view provides the names of all the data dictionary views?

Question: How is the SQL profile used?

Question: 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 of the tablespace will be of a uniform size of 1 MB?

Question: What should be confirmed before changing the CURSOR_SPACE_FOR_TIME parameter in the initialization file to TRUE?

Question: 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?

Question: Which of the following is mandatory when using the easy connect naming method?

Question: For which two types of tablespaces can proactive tablespace alerts be set?

Question: Which of the following is true if the alter tablespace statement is used and the TEMPORARY clause is specified?

Question: Where can a SQL Tuning Set(STS) be created from?