Databases - Upwork

Question: Where is the free space managed, for a tablespace created with automatic segment-space management?
A
In the extent

B
In the control file

C
In the data dictionary

D
In the undo tablespace

Note: not sure
1. Report
Question: Which three out of the following are the physical structures that constitute the Oracle database?
A
Segment

B
Data file

C
Log file

D
Tablespace

E
Control file

Note: not sure
1. Report
Question: When there is a monotonically increasing sequence number as an indexed column, which of the following is true?
A
Hash-partitioned global indexes are useful

B
Range-partitioned global indexes are better

C
Hash-partitioned local indexes are better

D
Range-partitioned local indexes are better

Note: Not available
1. Report
Question: When is SGA created in an Oracle database environment?
A
When the database is created

B
When the instance is started

C
When the database is mounted

D
When a user process is started

Note: not sure
1. Report
Question: Which data dictionary view should be used to get a list of object privileges for all database users?
A
DBA_TAB_PRIVS

B
ALL_TAB_PRIVS

C
USER_TAB_PRIVS

D
ALL_TAB_PRIVS_MADE

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

Note: not sure
1. Report
Question: Which of the following is true when John uses the RESETLOGS option?
A
He doesn't need to back up the database

B
He must back up the database right away

C
He can use archive redo logs from an older incarnation of the database

D
He can't use archive redo logs from an older incarnation of the database

Note: not sure
1. Report
Question: Which graphical DBA administration tool should be used to tune an Oracle database?
A
SQL*Plus

B
Oracle Enterprise Manager

C
Oracle Universal Installer

D
Oracle Database Configuration Assistant

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

B
DBA_USERS and DBA_PROFILES

C
DBA_USERS and DBA_TABLESPACES

D
DBA_USERS, DBA_TS_QUOTAS, and DBA_PROFILES

Note: not sure
1. Report
Question: Which three major tuning areas does OEM Database Control provide information about?
A
Most-used objects

B
Top SQL statements

C
Memory usage

D
Top sessions affecting the instance

E
CPU and wait classes

Note: not sure
1. Report

First Prev 67 68 69 70 71 Next Last

Question: Where is the free space managed, for a tablespace created with automatic segment-space management?

Question: Which three out of the following are the physical structures that constitute the Oracle database?

Question: When there is a monotonically increasing sequence number as an indexed column, which of the following is true?

Question: When is SGA created in an Oracle database environment?

Question: Which data dictionary view should be used to get a list of object privileges for all database users?

Question: Which statement about the LOG_BUFFER initialization parameter is true?

Question: Which of the following is true when John uses the RESETLOGS option?

Question: Which graphical DBA administration tool should be used to tune an Oracle database?

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

Question: Which three major tuning areas does OEM Database Control provide information about?