|
Question:
1. Which of the following events would not
be a good candidate for a pager alert?
A. Tablespace is growing beyond 95% full.
B. Buffer hit ratio is at 65%
C. A table has reached maximum extents.
D. The redo log file system is at 95%
full.
Correct Answer:
The correct answer is B. Buffer hit ratio
is at 65%.
Explanation:
The correct answer is B. Buffer hit ratio
is at 65%. This is because the remedy is increasing db_block_buffers, and
this cannot be done without stopping and re-starting the database.
Which of the following events would not be a good candidate for a pager
alert? A, C, and D are incorrect because these are excellent
opportunities to fix a looming problem before the database experiences a
problem.
Question:
2. Which of the following is not a
function of the event manager window of the OEM console?
A. Defining events and thresholds.
B. Defining corrective actions for alerts.
C. Associating events with remote
databases.
D. defining a new index for a table.
Correct Answer:
D. defining a new index for a table.
Explanation:
The correct answer is D. Defining a new
index for a table. Which of the following is not a function of the event
manager window of the OEM console? A is incorrect because event
definition is a major function of the event manager. B is incorrect
because corrective actions are an option within the event manager. C
is incorrect because
Question:
3. Which statement is false about the
intelligent agent?
A. You must define one agent for each
remote database on your server.
B. The agent runs as an independent server
process on each remote node.
C. The agent can be used to facilitate job
scheduling through the OEM console job schedule window.
D. The agent uses the SNMP protocol to
communicate with the OEM console.
Correct Answer:
A. You must define one agent for each
remote database on your server.
Explanation:
The correct answer is A. You must define
one agent for each remote database on your server. Which statement is false
about the intelligent agent? B is incorrect because the agent is
indeed an independent server process. C is incorrect because agents are
used for job scheduling. D is incorrect because agents use SNMP to
communicate with the OEM console.
Question:
4. Prior to the OEM console, the Remote
DBAs continued to perform the OEM functions. Which tool is not an
alternative to OEM functionality?
A. Using the UNIX crontab to schedule
database maintenance
B. Using Unix mail to send the Remote DBA
alerts about database problems
C. Using Schema manager to display the
database tables names.
D. Using SQL*Plus to start and stop the
database.
Correct Answer:
D. Using SQL*Plus to start and stop the
database.
Explanation:
The correct answer is D, Using SQL*Plus to
start and stop the database. This is because SQL*Plus cannot issue
“startup” or “shutdown” commands. Prior to the OEM console, the Remote
DBA’s continued to perform the OEM functions. Which tool is not an
alternative to OEM functionality? A is incorrect because the Unix crontab
is a very good non-centralized job scheduler for Oracle. B is
incorrect because Unix mail has been used for year to send alerts to Remote
DBA’s. C is incorrect because the Schema Manager is almost identical
in functionality to the OEM navigator window.
Question:
5. Which is not a function available from
the OEM console?
A. Maintaining the Oracle*Net topology
B. Displaying the indexes for a
table
C. Displaying a list of databases
D. Displaying a list of all maintenance
tasks.
Correct Answer:
A. Maintaining the Oracle*Net topology
Explanation:
The correct answer is A, maintaining the
Oracle*Net topology. This is because the Oracle*Net assistant the Oracle*Net
Easy are used for these tasks. Which is not a function available from the
OEM console? B is incorrect because indexes can be displayed from the
navigator. C is incorrect because a list of database is available
from the navigator. D is incorrect because lists of maintenance tasks
can be displayed in the job scheduler.
Question:
6. Which is false about the ops$
Oracle user?
A. ops$ allows Oracle users to connect
from PC clients without supplying a password.
B. ops$ was used before Oracle supported
the “identified externally” clause.
C. ops$ allows OS authentication from any
UNIX Oracle*Net client.
D. ops$ requires that the
os_authent_prefix be set in the init.ora.
Correct Answer:
A. ops$ allows Oracle users to connect
from PC clients without supplying a password.
Explanation:
The correct answer is A. ops$ allows
Oracle users to connect from PC clients without supplying a password. Which
is false about the ops$ Oracle user? B is incorrect because ops$ did
precede external identification. C is incorrect because ops$ does
allow OS authentication from UNIX, just like external identification.
D is incorrect because the os_authent_prefix must be set to ops$.
Question:
7.
How would you define an Oracle user who wants OS authentication on the
server, but wants also to connect from a PC client?
A. create user fred identified
externally;
B. create use fred identified by ops$.
C create user ops$fred identified
externally.
D. create user ops$fred identified by
fredpass;
Correct Answer:
D. create user ops$fred identified by
fredpass;
Explanation:
The correct answer is D. create user
ops$fred identified by fredpass;. How would you define an Oracle user who
wants OS authentication on the server, but wants also to connect from a PC
client? A and C are incorrect because all Oracle*Net PC clients cannot
allow connections from externally identified users. B is incorrect
because it is silly.
Question:
8.
If you want to completely disable OS password authentication, which
init.ora parameters values would you choose?
A. os_authent_prefix=””
B. remote_os_authent=false
C. remote_os_authent=true
D. os_authent_prefix=”ops$”
Correct Answer:
B. remote_os_authent=false
Explanation:
The correct answer is B.
remote_os_authent=false. If you want to completely disable OS password
authentication, which init.ora parameters values would you choose? A
and D are incorrect because os_authent_prefix does not control external
access. C is incorrect because a value of “true” will enable access,
not disable it.
Question:
9.
Which is false about the IDENTIFIED EXTERNALLY clause?
A. Remote users that have external
identification will be able to connect to the local database regardless of
any init.ora settings.
B. UNIX users with external identification
may connect to SQL*Plus without either a user ID or a password.
C. External users are not allowed to have
an Oracle password, and cannot connect via PC GUI tools such as Oracle*Net
Assistant.
D. External users have fewer passwords to
remember.
Correct Answer:
A. Remote users that have external
identification will be able to connect to the local database regardless of
any local init.ora settings.
Explanation:
The correct answer is A. Remote
users that have external identification will be able to connect to the
local database regardless of any local init.ora settings. Which is false
about the IDENTIFIED EXTERNALLY clause? B is incorrect because
external ID’s are gathered from UNIX. C is incorrect because external
users cannot use Oracle*Net assistant. D is incorrect because it is
true that externally identified user have less passwords to remember.
Question:
10.
Which is not a feature of the Advanced Networking Option?
A. The use of third-party security tools
such as Kerberos.
B. The use of data encryption.
C. The remote validation of Oracle*Net
user password.
D. The use of single user sign-on.
Correct Answer:
C. The remote validation of Oracle*Net
user password.
Explanation:
The correct answer is C. The remote
validation of Oracle*Net user password. Which is not a feature of the
Advanced Networking Option? A is incorrect because third-party tools
are used for encryption. B is incorrect because data encryption is the
most important feature of the advanced networking option. D is
incorrect because advanced networking can enforce single sign-on.
Question:
11.
Which Oracle*Net parameter file would not contain information for the
Advanced Networking Option?
A. init.ora
B. listener.ora
C. sqlnet.ora
D. tnsnames.ora
Correct Answer:
D. tnsnames.ora
Explanation:
The correct answer id D. tnsnames.ora.
Which Oracle*Net parameter file would not contain information for the
Advanced Networking Option? A is incorrect because the init.ora
parameter remote_os_authent must be set to false. B is incorrect
because the listener.ora needs SQLNET.AUTHENTICATION_SERVICES=(NONE).
C is incorrect because the SQLNET.AUTHENTICATION_SERVICES parameter must be
set.
Question:
12.
Which is not a possible security exposure within Oracle*Net?1
A. Public database links.
B. Granting access on remote tables to
“public”.
C. Using the ops$ user prefix.
D. Connecting to SQL*Plus with your user
ID and password on the command line.
Correct Answer:
C. Using the ops$ user prefix.
Explanation:
The correct answer is C. Using the ops$
user prefix. Which is not a possible security exposure within
Oracle*Net? A is incorrect because public database links can use used
by anyone who knows the link name. B is incorrect because public
tables can be viewed by all database links. D is incorrect because
ops$ users can be supplied with a password.
Question:
13.
Which is not a reason why Oracle requires a password for remote PC-based
Oracle*Net clients, but not for UNIX-based Oracle*Net clients?
A. Because there are not user ID’s within
Windows 98 clients.
B. Because PC’s are subject to hacking by
unauthorized users.
C. Because Windows NT allows the
administrator to create “imposters” to connect to Oracle.
D. Because ops$ prefixes are not supported
by any of the Oracle PC GUI tools.
Correct Answer:
D. Because ops$ prefixes are not supported
by any of the Oracle PC GUI tools.
Explanation:
The correct answer is D. Because ops$
prefixes are not supported by any of the Oracle PC GUI tools. Which is not
a reason why Oracle requires a password for remote PC-based Oracle*Net
clients, but not for UNIX-based Oracle*Net clients? A is incorrect
because it is true that Windows 98 does not have USER ID’s, and hence no OS
level authentication. B is incorrect because PC’s can easily be
“hacked”. C is incorrect because Windows NT administrators could gain
access to an entire enterprise if they created “imposter” Oracle ID’s.
Question:
14. Which is not an advantage of an
externally identified user?
A. Fewer Oracle passwords to remember.
B. Password checking by both the OS and by
Oracle.
C. Better management of password security
D. No requirement to specify either the
Oracle ID or the password.
Correct Answer:
B. Password checking by both the OS and by
Oracle.
Explanation:
The correct answer is B. Password checking
by both the OS and by Oracle. Which is not an advantage of an externally
identified user? A is incorrect because external identification does
mean that there will be fewer passwords since they only exist within
UNIX. C is incorrect because UNIX will manage all passwords, and they
will not be duplicated within Oracle. D is incorrect because an
externally identified does not have to specify either their user ID or a
password when entering an Oracle utility such as SQL*Plus.
|
No comments:
Post a Comment