Databases - Upwork

Question: Which statement is valid regarding index clusters?
A
Index clusters can only be used for tables with low cardinality columns

B
Index clusters are generally well suited for tables that have many full table scans

C
Normal B-Tree indexes do not store null key values, whereas cluster indexes store null keys

D
A cluster index always takes up much more storage space than a normal index for the same set of key values

Note: not sure
1. Report
Question: Which three statements among the following are true about rebuilding indexes?
A
The ALTER INDEX REBUILD command is used to change the storage characteristics of an index

B
Using the ALTER INDEX REBUILD is usually faster than dropping and recreating an index because it uses the fast full scan feature

C
Oracle8i allows for the creation of an index or re-creation of an existing index while allowing concurrent operations on the base table

D
When building an index, the NOLOGGING and UNRECOVERABLE keywords can be used concurrently to reduce the time it takes to rebuild itself

Note: not sure
1. Report
Question: What do ASM disk groups provide?
A
Redundancy through striping

B
Performance through mirroring

C
Redundancy through mirroring

D
Performance through striping

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

Note: not sure
1. Report
Question: Which initialization parameter specifies the location of the alert log file?
A
UTL_FILE_DIR

B
USER_DUMP_DEST

C
LOG_ARCHIVE_DEST

D
BACKGROUND_DUMP_DEST

Note: not sure
1. Report
Question: What will the command EXECUTE DBMS_SCHEDULER.PURGE_LOG(); do?
A
Purge only all the window logs

B
Purge only all the job logs

C
Purge all window and job logs

D
Purge only yesterday's job logs

Note: not sure
1. Report
Question: Which data dictionary view shows the available free space in a certain tablespace?
A
DBA_EXTENTS

B
V$FREESPACE

C
DBA_FREE_SPACE

D
DBA_TABLESPACFS

Note: not sure
1. Report
Question: What are the functions of an ASM instance?
A
Managing disk groups and communicating file metadata to the Oracle database using ASM files

B
Managing database files and communicating file metadata to the ASM instance using ASM files

C
Managing disk groups and communicating file metadata to the RMAN

D
Protecting disk groups

Note: not sure
1. Report
Question: If the DBCA is used to create a new database, when is the creation of the new flash recovery area mandatory?
A
Always

B
Only if the automatic backup using the OEM is configured

C
Only if user-managed backups is configured

D
Only if the database is run in the archive log mode

Note: Not available
1. Report
Question: What does the ARBn background process do in an ASM instance?
A
Coordinates disk activity

B
Performs disk rebalance work

C
Coordinates disk rebalance work

D
Manages the RBAL process

Note: not sure
1. Report

First Prev 71 72 73 74 75 Next Last

Question: Which statement is valid regarding index clusters?

Question: Which three statements among the following are true about rebuilding indexes?

Question: What do ASM disk groups provide?

Question: What happens once the DBA disables the flash recovery area?

Question: Which initialization parameter specifies the location of the alert log file?

Question: What will the command EXECUTE DBMS_SCHEDULER.PURGE_LOG(); do?

Question: Which data dictionary view shows the available free space in a certain tablespace?

Question: What are the functions of an ASM instance?

Question: If the DBCA is used to create a new database, when is the creation of the new flash recovery area mandatory?

Question: What does the ARBn background process do in an ASM instance?