Question 1

Which of the following objects could not be modified using ALTER statement

technology databases

Tablespace
Sequence
Views
Index

Answer

Correct Option: C

Question 2

Load utility will rebuild the index of the table that is loaded?

technology databases

True
False

Answer

Correct Option: A

Question 3

Pick the odd one out

technology databases

AVG
SUM
STDDEV
ABS

Answer

Correct Option: D

Question 4

Which of the following contains Database Descriptors(DBD)

technology databases

DB2 Directory
DB2 Catalog
Optimizer
Data Manager

Answer

Correct Option: A

Question 5

Which table gives access path information for a plan/query when EXPLAIN command is used

technology databases

DSN_STATEMNT_TABLE
PLAN_TABLE
SYSPLAN
SYSPACKAGE

Answer

Correct Option: B

Question 6

Which of the following functions can be used to determine whether a column value is NULL

technology databases

SUBSTR
VALUE
COALESCE
NULLIF

Answer

Correct Option: B,C

Question 7

Which of the following groups allows its members to connect to a 9i database using the SYSDBA privilege?

technology databases

9iDBA
OSADM
OSDBA
OSOPER

Answer

Correct Option: C

Question 8

Which of the following are NOT the authorized operations of SYSOPER

technology databases

CREATE SPFILE
CREATE DATABASE
ALTER DATABASE OPEN
STARTUP

Answer

Correct Option: B

Question 9

According to the Oracle recommended prioritized approach for designing, implementing, and maintaining an Oracle Database, which of the following is the task for the DBA to perform before tuning the database?

technology databases

Install the Oracle Software
Plan the Database
Implement the Database Design
Back Up the Fully Functional Database

Answer

Correct Option: D

Question 10

According to the Oracle recommended prioritized approach for designing, implementing, and maintaining an Oracle Database, which of the following is the first task for the DBA to perform?

technology databases

Install the Oracle Software
Evaluate the Database Server Hardware
Implement the Database Design
Plan the Database

Answer

Correct Option: B

Question 11

The initial password of CHANGE_ON_INSTALL is used by which of the following user accounts?

technology databases

SYSTEM
SYS
SYSOPER
MANAGER

Answer

Correct Option: B

Question 12

What environment variable can have direct influence towards the output of the date command?

technology databases

TZ
TMP
TMPDIR
SHLIB_PATH

Answer

Correct Option: A

Question 13

Which of the following are the functions of the oraenv script

technology databases

It provides a security scan against all user accounts
It provides a SID scan against all rows
It provides a central means of updating all user accounts
It provides a mechanism for switching between Oracle9i databases with ease

Answer

Correct Option: C

Question 14

A directory name can be a valid value for which of the following parameters?

technology databases

DB_CACHE_SIZE
DB_FILES
BACKGROUND_DUMP_DEST
DB_BLOCK_SIZE

Answer

Correct Option: C

Question 15

How do you change the block size specified by DB_BLOCK_SIZE?

technology databases

modify the parameter, backup the init file and the database, and restart the instance
modify the parameter and restart the instance
re-create the database
modify the parameter, backup the init file and restart the instance

Answer

Correct Option: C

Question 16

What is used in Oracle 9i to represent the value of the ORACLE_HOME environment variable?

technology databases

#
&
!
?

Answer

Correct Option: D

Question 17

Abbreviation of SQL

technology databases

Sequel query language
Structured query language
Shortened query language
Simplified query language

Answer

Correct Option: C

Question 18

What is necessary in the SQL query when we are using aggregate functions?

technology databases

Group by
Order by
Where
Update

Answer

Correct Option: D

Question 19

Which is NOT the single-row functions??

technology databases

sinh()
to_number()
sqrt()
round()

Answer

Correct Option: B

Question 20

What is the default character for specifying substitution variables in select statements?

technology databases

Ellipses
Quotation marks
Ampersand
Asterisk

Answer

Correct Option: C

Description: databases Online Quiz - 135
Number of Questions: 20
Created by: Aliensbrain Bot
Tags: databases

databases Online Quiz - 135

Find more quizzes from top tags