Use LEFT and RIGHT arrow keys to navigate between flashcards;
Use UP and DOWN arrow keys to flip the card;
H to show hint;
A reads text to speech;
13 Cards in this Set
- Front
- Back
You issue the URL https://127.0.0.1:5500/em and receive an error. What could be the problem?
(Choose all correct answers.) |
B. You have not started the dbconsole.
C. The dbconsole is running on a different port. D. You are not logged on to the database server node. |
|
Which files must be synchronized for a database to open? (Choose the best answer.)
|
A. Datafiles, online redo log files, and controlfile
|
|
During the transition from NOMOUNT to MOUNT mode, which files are required? (Choose
the best answer.) |
B. Controlfiles
|
|
4. You shut down your instance with SHUTDOWN IMMEDIATE. What will happen on the next
startup? (Choose the best answer.) |
D. The database will open without recovery.
|
|
5. You have created two databases on your computer and want to use Database Control to manage them. Which if the following statements are correct? (Choose all correct answers.)
|
C. You can use Database Control, if you contact it on different ports for each database. D. You must set the ORACLE_SID variable appropriately before starting each Database Control console.
|
|
6. You issue the command SHUTDOWN; and it seems to hang. What could be the reason?
|
B. There are other sessions logged on.
|
|
7. What action should you take after terminating the instance with SHUTDOWN ABORT?
|
E. None—recovery will be automatic.
|
|
8. What will be the setting of the OPTIMIZER_MODE parameter for your session after the next
startup if you issue these commands: alter system set optimizer_mode=all_rows scope=spfile; alter system set optimizer_mode=rule; alter session set optimizer_mode= |
rule
|
|
9. The LOG_BUFFER parameter is a static parameter. How can you change it? (Choose the
|
D. You can change it in the parameter file, but the new value will only come into effect at the next startup.
|
|
10. Which of these actions will not be recorded in the alert log? (Choose all correct answers.)
|
B. ALTER SESSION commands
F. Creating a user |
|
11. Which parameter controls the location of background process trace files? (Choose the best answer.)
|
A. BACKGROUND_DUMP_DEST
|
|
12. Which of these views can be queried successfully in nomount mode? (Choose all correct answers.)
|
E. V$INSTANCE F. V$SESSION
|
|
13. Which view will list all tables in the database? (Choose the best answer.)
|
B. DBA_TABLES
|