Tag: databases

Questions Related to databases

By default, how long will database statistics be retained in the AWR?

technology databases

  1. 7 days

  2. 30 days

  3. 7 hours

  4. Indefinitely

Show answer
Correct Option: A

Which of the following is not one of the three primary sources of performance metric information in the EM Database Control Performance screen?

technology databases

  1. Host

  2. Session

  3. Instance

  4. Network

Show answer
Correct Option: D

Which of the following is a performance metric that could be defined as “the amount of work that a system can perform in a given amount of time”?

technology databases

  1. Response time

  2. Uptime

  3. Throughput

  4. Runtime

Show answer
Correct Option: C

You have just created a database using scripts that you wrote. Now you notice that the automatic collection of database statistics by the EMD_MAINTENANCE.EXECUTE_EM_DBMS_JOB_ PROCS procedure is not running. What might be the cause?
technology databases

  1. The PFILE/SPFILE parameter GATHER_STATS=FALSE.

  2. Only databases created using Database Configuration Assistant have automatic statistics

  3. The SYSMAN user who owns the AWR is not logged in.

  4. The operating system does not support automatic statistics collection.

Show answer
Correct Option: B

Using EM Database Control, you discover that two application PL/SQL functions and a view are currently invalid. Which of the following might you use to fix these objects?

technology databases

  1. Shut down and restart the database.

  2. Use EM Database Control to recompile the object.

  3. Export the invalid objects, drop them, and then import them.

  4. Use the ALTER FUNCTION … COMPILE and ALTER VIEW … COMPILE commands.

Show answer
Correct Option: B,D

Multiple baseline metrics can be gathered and stored in the AWR. Why might you want more than one metrics baseline?

technology databases

  1. You might want a separate baseline metric for each user.

  2. You might want a separate baseline metric for daytime usage versus off-hours usage.

  3. You might want a separate baseline metric for each schema.

  4. You would never want more than one baseline metric, even though it is possible to gather

Show answer
Correct Option: B

When you configure an alert, which of the following types of alert thresholds can you use to monitor a tablespace for diminishing free space?

technology databases

  1. Warning threshold

  2. Critical threshold

  3. Both A and B

  4. Neither A or B

Show answer
Correct Option: C

If no e-mail address is specified, where will alert information be displayed?
technology databases

  1. In the DBA_ALERTS data dictionary view

  2. In the V$ALERTS dynamic performance view

  3. In the EM Database Control main screen

  4. No alert information is sent or displayed.

Show answer
Correct Option: C

If Product is a table name than a) RENAME product to PRO; b) ALTER TABLE product RENAME TO pro;

technology databases

  1. a is ture

  2. b is fasle

  3. b is false a is ture

  4. a is false b is ture

Show answer
Correct Option: D

NULLIF(12, 13) would return 12 ?

technology databases

  1. True

  2. False

Show answer
Correct Option: B