Databases - Upwork

Question: What are two main advantages of using bitmap indexes?
A
Bitmap indexes use less storage space

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

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

D
None of these

Note: not sure
1. Report
Question: Which of the following data dictionary views should be used to get a list of object privileges for all the 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 of the following sets of tablespaces is mandatory for any Oracle 10g database?
A
SYSTEM, SYSAUX, and UNDOTBS

B
SYSTEM and UNDOTBS

C
SYSAUX and UNDOTBS

D
SYSTEM and SYSAUX

Note: not sure
1. Report
Question: Which tablespace is used as a temporary tablespace if 'TEMPORARY TABLESPACE' is not specified for a user?
A
TEMP

B
DATA

C
SYSTEM

D
ROLLBACK

Note: not sure
1. Report
Question: Which of the following graphical DBA administration tools is 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: In an Oracle database environment, SGA is created:
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: A query that uses the BETWEEN syntax for two numbers is identical to:
A
>= and <=

B
> and <

C
>= and <

D
> and <=

E
No such syntax

Note: Not available
1. Report
Question: How can the duplicate data on a report be hidden?
A
By Setting the HideDuplicates property to Yes

B
By Setting the DuplicateRecords property to No

C
By Setting the DuplicateRecords property to No and setting the GrpKeepTogether property to Per Page

D
Duplicate Data should be handled at the time of data entry and cannot be controlled while reporting

Note: Not available
1. Report
Question: Which of the following is the easiest and fastest method to manipulate records on a subform?
A
Using a RecordsetType Property

B
Using a RecordSetClone Property

C
Using a RecordSelectors Property

D
Using a References Property

Note: Not available
1. Report
Question: How do you start an Access application so that the user can't see or use the database container?
A
Set the Access Option to hide the navigation pane, and press CTRL+F11 special keys.

B
Set the Access Option to hide the navigation pane, and press ALT+F1 special keys.

C
Set the Access Option to hide the navigation pane, and turn off special keys to prevent F11.

D
Set the Access Option to hide the navigation pane, and press CTRL+G special keys .

Note: Not available
1. Report

First Prev 77 78 79 80 81 Next Last

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

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

Question: Which of the following sets of tablespaces is mandatory for any Oracle 10g database?

Question: Which tablespace is used as a temporary tablespace if 'TEMPORARY TABLESPACE' is not specified for a user?

Question: Which of the following graphical DBA administration tools is used to tune an Oracle database?

Question: In an Oracle database environment, SGA is created:

Question: A query that uses the BETWEEN syntax for two numbers is identical to:

Question: How can the duplicate data on a report be hidden?

Question: Which of the following is the easiest and fastest method to manipulate records on a subform?

Question: How do you start an Access application so that the user can't see or use the database container?