Question 1

Using NVL(),TO_DATE (), TO_NUMBER () functions in 'where' clause on non-indexed columns does improve performance

technology databases

True
False

Answer

Correct Option: A

Question 2

Which View helps in querying high I/O statements?

technology databases

V$SQLSTATS.DISK_READS
V$DISK_READS
V$SQL_STATS
V$SYS_STAT

Answer

Correct Option: A

Question 3

Which of the following generates the PLAN for SQL statements?

technology databases

PLAN
EXPLAIN PLAN
TKPROF
V$PLAN

Answer

Correct Option: B

Question 4

In which version of Oracle is AWR Introduced ?

technology databases

11g
9i
8i
10g

Answer

Correct Option: D

Question 5

Is Statspack available in Oracle 11g?

technology databases

True
False

Answer

Correct Option: A

Question 6

Which user owns all the package of STATSPACK?

technology databases

PERFMON
PERFSTAT
SYSTEM
SCOTT

Answer

Correct Option: B

Question 7

Which of the following is not a schema object?

technology databases

Indexes
Tables
Public Synonyms
Triggers and Packages

Answer

Correct Option: C

Question 8

If commission is null then the text “Not Applicable” must be displayed, instead of blank space. How do I write the query?

technology databases

select nvl(to_char(comm),'NA') from emp;
select nvl(comm,'NA') from emp;
select nvl(comm,NA) from emp;
None of the above

Answer

Correct Option: A

Question 9

Which data dictionary object is used to retrieve the information about the tables from a given schema?

technology databases

USER_TABLES
USER_TABS
Both 1 & 2
None of the above

Answer

Correct Option: A

Question 10

A transaction is a set of SQL statements between any two COMMIT and ROLLBACK statements.

technology databases

True
False

Answer

Correct Option: A

Question 11

What are the min.extents allocated to a rollback extent ?

technology databases

One
Two
Three
None of the above

Answer

Correct Option: B

Question 12

What is the maximum no.of columns a table can have ?

technology databases

254
216
Alloted size
None of the above

Answer

Correct Option: A

Question 13

Data Dictionary in oracle is used to store information about various physical and logical Oracle structures e.g.Tables, Tablespaces, datafiles, etc

technology databases

True
False

Answer

Correct Option: A

Question 14

Can Check constraint be used for self referential integrity ?

technology databases

Yes
No
Not in Oracle
None of the above

Answer

Correct Option: A

Question 15

What are the states of a rollback segment ?

technology databases

ONLINE
OFFLINE
PARTLY AVAILABLE
NEEDS RECOVERY
INVALID

Answer

Correct Option: A,B,C,D,E

Question 16

What components of the IT environment can Oracle Enterprise Manager Grid Control manage?

technology databases

The server machines
Oracle application servers
Oracle databases
Third-party products
All of the above

Answer

Correct Option: E

Question 17

Is the below query allowed?Select sal, ename Into x From emp Where ename = 'KING' (Where x is a record of Number(4) and Char(15));

technology databases

Yes
No
Not in Oracle
None of the above

Answer

Correct Option: A

Question 18

A table has the following data : [[5, Null, 10]].What will the average function return ?

technology databases

10
5.5
5
7.5

Answer

Correct Option: A

Question 19

Consider a sequence whose currval is 1 and gets incremented by 1 by using the nextval reference we get the next number 2.Suppose at this point we issue an rollback and again issue a nextval.What will the output be ?

technology databases

2
3
4
1

Answer

Correct Option: B

Question 20

Which of these following features are correct if SQL is a set-oriented language?

technology databases

Individual rows must have a unique identifier
Sets of users can be managed in groups
One statement can affect multiple rows
SQL statements can be placed within blocks of code
All the above

Answer

Correct Option: C

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

databases Online Quiz - 39

Find more quizzes from top tags