Tag: databases

Questions Related to databases

Which of the following views provides all the grants on all the objects in the database?
technology databases

  1. DBA_SYS_PRIVS

  2. DBA_COL_PRIVS

  3. DBA_OBJ_PRIVS

  4. DBA_TAB_PRIVS

Show answer
Correct Option: A

Which of the following denote the type of streams used in Java?
technology databases

  1. character streams

  2. byte streams

  3. Both (A) and (B)

  4. None of the Above

Show answer
Correct Option: C

In order to initialize a servlet the initialization code is placed in

technology databases

  1. service() method

  2. init() method

  3. constructor for HttpServlet()

  4. None of the Above

Show answer
Correct Option: B

Which of the following statement is False?

technology databases

  1. out is a PrintStream object

  2. Java support pointers

  3. AWT components are heavy-weight

  4. An abstract class has to be sub-classed

Show answer
Correct Option: B

Which of the following are valid table-partitioning methods
technology databases

  1. Key based

  2. Freelist

  3. Hash

  4. Index

Show answer
Correct Option: C

Which two parameters can be set to tell the Oracle to use OMF (Oracle Managed Files)?

technology databases

  1. DB_CREATE_FILE_DEST

  2. DB_CREATE_ONLINE_LOG_n

  3. USER_DUMP_DEST

  4. LOG_ARCHIVE_DEST

Show answer
Correct Option: A

User-defined application exception classes are derived from which class?
technology databases

  1. SystemException

  2. ApplicationException

  3. Both (A) and (B)

  4. None of the Above

Show answer
Correct Option: B

Which is Microsoft’s open source project hosting web site?

technology databases

  1. CodeSite

  2. CodePlex

  3. A & B

  4. None of the Above

Show answer
Correct Option: B

What is one of the disadvantages of database mirroring?

technology databases

  1. You need to have the same hardware.

  2. The database you mirror to will be in an unused standby state.

  3. You cannot have automatic failover.

  4. You need to have at minimum three servers.

Show answer
Correct Option: B

When you add a float, int and byte the result will be
technology databases

  1. float

  2. int

  3. byte

  4. double

Show answer
Correct Option: A