Databases - Upwork

Question: Which memory structure contains the information used by the server process to validate user privileges?
A
Buffer cache

B
Library cache

C
Data dictionary cache

D
Redo log buffer cache

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

B
Segment

C
Oracle block

D
Operating system block

Note: not sure
1. Report
Question: What are the two main advantages of using bitmap indexes?
A
Bitmap indexes use less storage space

B
Bitmap indexes are easy to maintain when DML statements are issued

C
Bitmap segments are updated upon COMMIT, at the end of the transaction

D
Bitmap indexes work very fast with multiple predicates that are combined with AND, OR, and NOT operators

Note: not sure
1. Report
Question: What statistics will Oracle collect If LIST subpartitioning is used, and the value of the GRANULARITY argument is specified as AUTO?
A
Global statistics only

B
Global and partition statistics only

C
Global, partition, and subpartition statistics

D
No partitioned table statistics

Note: not sure
1. Report
Question: Which of the following commands must be used to apply incremental backups?
A
RECOVER BACKUP OF DATABASE

B
RECOVER DATAFILE

C
RECOVER COPY OF DATAFILE

D
RECOVER COPY OF DATABASE

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

Note: not sure
1. Report
Question: Which statement is true when connecting to the Oracle instance using the multithreaded server configuration?
A
The User Global Area (UGA) may only contain sort areas

B
The User Global Area (UGA) may be accessible to dedicated servers

C
The User Global Area (UGA) components may reside in the large pool

D
The User Global Area (UGA) components may reside in the buffer cache

Note: not sure
1. Report
Question: Which three among the following dynamic performance views obtain information from the control file?
A
V$LOG

B
V$SGA

C
V$THREAD

D
V$VERSION

E
V$DATAFILE

Note: not sure
1. Report
Question: Which option lists the correct hierarchy of storage structures, from largest to smallest?
A
Segment, extent, tablespace, data block

B
Data block, extent, segment, tablespace

C
Tablespace, extent, data block, segment

D
Tablespace, segment, extent, data block

Note: not sure
1. Report
Question: What is the priority level for a job in a job class?
A
From 1 to 5

B
From 1 to 999

C
From 1 to 10

D
A job can only take a value of HIGH or LOW.

Note: not sure
1. Report

First Prev 68 69 70 71 72 Next Last

Question: Which memory structure contains the information used by the server process to validate user privileges?

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

Question: What are the two main advantages of using bitmap indexes?

Question: What statistics will Oracle collect If LIST subpartitioning is used, and the value of the GRANULARITY argument is specified as AUTO?

Question: Which of the following commands must be used to apply incremental backups?

Question: Who will be the owner of the job, if you create a job in user SCOTT's schema?

Question: Which statement is true when connecting to the Oracle instance using the multithreaded server configuration?

Question: Which three among the following dynamic performance views obtain information from the control file?

Question: Which option lists the correct hierarchy of storage structures, from largest to smallest?

Question: What is the priority level for a job in a job class?