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
  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 of the following is not a schema object?

  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

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

  1. True

  2. False


Correct Option: A

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

  1. One

  2. Two

  3. Three

  4. None of the above


Correct Option: B

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

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

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