Tag: databases

Questions Related to databases

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

  1. True

  2. False

Show answer
Correct Option: A

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

  1. One

  2. Two

  3. Three

  4. None of the above

Show answer
Correct Option: B

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

  1. 254

  2. 216

  3. Alloted size

  4. None of the above

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

technology databases

  1. True

  2. False

Show answer
Correct Option: A

Can Check constraint be used for self referential integrity ?
technology databases

  1. Yes

  2. No

  3. Not in Oracle

  4. None of the above

Show answer
Correct Option: A

What are the states of a rollback segment ?
technology databases

  1. ONLINE

  2. OFFLINE

  3. PARTLY AVAILABLE

  4. NEEDS RECOVERY

  5. INVALID

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

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

  1. The server machines

  2. Oracle application servers

  3. Oracle databases

  4. Third-party products

  5. All of the above

Show answer
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));
technology databases

  1. Yes

  2. No

  3. Not in Oracle

  4. None of the above

Show answer
Correct Option: A

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

technology databases

  1. 10

  2. 5.5

  3. 5

  4. 7.5

Show answer
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 ?
technology databases

  1. 2

  2. 3

  3. 4

  4. 1

Show answer
Correct Option: B