C2090-619 Free Practice Test

Consider the following statements: DBSPACETEMP=tempdbs1, tempdbs2, tempdbs3; CREATE DATABASE mydb WITH LOG IN datadbs1; CREATE TEMP TABLE temp1 (col1
int); Which statement is true?

1. A. The temp table will be created in datadbs1.
2. B. The temp table will be created in root dbspace.
3. C. The temp table will be careated in one of the dbspaces listed in DBSPACTEMP.
4. D. The temp table will be created round-robin across the dbspaces in DBSPACETEMP.

Correct Answer: B

Which two actions can you perform with ontape? (Choose two.)

1. A. Backup to cloud
2. B. Restartable restore
3. C. Backup specific storage spaces
4. D. Restore specific storage spaces
5. E. Parallel backup of storage spaces

Correct Answer: AD

Which parameter can automatically adjust other configuration parameters that are not present in the configuration file?

1. A. AUTO_PERF
2. B. AUTO_TUNE
3. C. AUTO_CONFIG
4. D. AUTO_ENABLE

Correct Answer: B

Which HDR configuration parameter provides three synchronization modes to control when transaction commits are returned to client applications?

1. A. DELAY_APPLY
2. B. HDR_TXN_SCOPE
3. C. LOG_INDEX_BUILDS
4. D. FAILOVER_TX_TIMEOUT

Correct Answer: B

Which SQL statement is valid to monitor database server sessions?

1. A. EXECUTE FUNCTION task ("onstat","-g ses");
2. B. EXECUTE FUNCTION task ("view sessions","all");
3. C. EXECUTE FUNCTION task ("check sessions","all");
4. D. EXECUTE FUNCTION task ("check server","sessions");

Correct Answer: A