0

databases Online Quiz - 39

Description: databases Online Quiz - 39
Number of Questions: 20
Created by:
Tags: databases
Attempted 0/20 Correct 0 Score 0

Which View helps in querying high I/O statements?

  1. V$SQLSTATS.DISK_READS

  2. V$DISK_READS

  3. V$SQL_STATS

  4. V$SYS_STAT


Correct Option: A

Which of the following generates the PLAN for SQL statements?

  1. PLAN

  2. EXPLAIN PLAN

  3. TKPROF

  4. V$PLAN


Correct Option: B

In which version of Oracle is AWR Introduced ?

  1. 11g

  2. 9i

  3. 8i

  4. 10g


Correct Option: D

Which user owns all the package of STATSPACK?

  1. PERFMON

  2. PERFSTAT

  3. SYSTEM

  4. SCOTT


Correct Option: B
  1. Indexes

  2. Tables

  3. Public Synonyms

  4. Triggers and Packages


Correct Option: C

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

  1. select nvl(to_char(comm),'NA') from emp;

  2. select nvl(comm,'NA') from emp;

  3. select nvl(comm,NA) from emp;

  4. None of the above


Correct Option: A

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

  1. USER_TABLES

  2. USER_TABS

  3. Both 1 & 2

  4. None of the above


Correct Option: A

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

  1. True

  2. False


Correct Option: A
  1. 254

  2. 216

  3. Alloted size

  4. None of the above


Correct Option: A

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

  1. True

  2. False


Correct Option: A

Can Check constraint be used for self referential integrity ?

  1. Yes

  2. No

  3. Not in Oracle

  4. None of the above


Correct Option: A

What are the states of a rollback segment ?

  1. ONLINE

  2. OFFLINE

  3. PARTLY AVAILABLE

  4. NEEDS RECOVERY

  5. INVALID


Correct Option: A,B,C,D,E
  1. The server machines

  2. Oracle application servers

  3. Oracle databases

  4. Third-party products

  5. All of the above


Correct Option: E

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));

  1. Yes

  2. No

  3. Not in Oracle

  4. None of the above


Correct Option: A

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

  1. 10

  2. 5.5

  3. 5

  4. 7.5


Correct Option: A

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 ?

  1. 2

  2. 3

  3. 4

  4. 1


Correct Option: B

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

  1. Individual rows must have a unique identifier

  2. Sets of users can be managed in groups

  3. One statement can affect multiple rows

  4. SQL statements can be placed within blocks of code

  5. All the above


Correct Option: C
- Hide questions