Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

QUESTION 1 Under normal circumstances, which of the following actions or events is not found in the Oracle alert log ? A . Database startup

QUESTION 1
Under normal circumstances, which of the following actions or events is not found in the Oracle alert log?
A.
Database startup and shutdown information
B.
Nondefault initialization parameters
C.
ORA-00600 errors
D.
New columns added to a user table
10 points
QUESTION 2
Which data dictionary view is used to view the current values of parameters?
A.
V$DATABASE
B.
V$SPPARAMETER
C.
V$PARAMETER
D.
V$SYSPARAMETER
10 points
QUESTION 3
The Oracle Universal Installer is started by executing which program?
A.
emct1
B.
runInstaller
C.
ouistart
D.
isqlplusctl
10 points
QUESTION 4
Which initialization parameter cannot be changed after the database is created?
A.
DB_BLOCK_SIZE
B.
DB_NAME
C.
CONTROL_FILES
D.
None. All parameters can be changed as and when required.
10 points
QUESTION 5
Which startup options must be used to start the instance when you create a new database?
A.
STARTUP FORCE
B.
STARTUP MOUNT
C.
STARTUP RESTRICT
D.
STARTUP NOMOUNT
10 points
QUESTION 6
The DIAGNOSTIC_DEST parameter is not set up in the initialization-parameter file. The value of the ORACLE_HOME environment variable is /u01/app/oracle/product/12.1.9, and the value of ORACLE_BASE is /u01/app/oracle. The database and instance name is xyz. What is the location of the text-alert log file for the xyz database?
A.
/u01/app/oracle/product/12.1.0/log/rdbms/xyz/xyz/trace
B.
/u01/app/oracle/diag/rdbms/xyz/xyz/trace
C.
/u01/app/oracle/diag/rdbms/xyz/xyz/alert
D.
/u01/app/oracle/product/12.1.0/diag/rdbms/xyz/xyz/trace
E.
/u01/app/oracle/log/rdbms/xyz/xyz/trace

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Contemporary Issues In Database Design And Information Systems Development

Authors: Keng Siau

1st Edition

1599042894, 978-1599042893

More Books

Students also viewed these Databases questions