Tag: databases

Questions Related to databases

Identify the list of some commonly used generators in hibernate

technology databases

  1. increment, identity, sequence, hilo, uuid

  2. decrement, identify, sequence, hilote, uuid

  3. generator, factory, series

  4. incrementObject, sequence, hilote, uuids

Show answer
Correct Option: A

____________ represents an entire set of mappings of an application's Java types to an SQL database.
technology databases

  1. org.hibernate.cfg.configuration

  2. org.hibernate.cfg.configuration.Session

  3. org.hibernate.Configuration

  4. org.hibernate.cfg.Configuration

Show answer
Correct Option: D

Hibernate works best if these classes follow some simple rules, also known as the ___________ programming model.
technology databases

  1. Perform Object Java Oriented

  2. Plain Object Java Old

  3. Platform Oriented Java Object

  4. Plain Old Java Object

Show answer
Correct Option: D

Examine this TRUNCATE TABLE command: - 68 - TRUNCATE TABLE departments; Which statements are true about the command?
technology databases

  1. All extents are released.

  2. All rows of the table are deleted.

  3. Any associated indexes are truncated.

  4. No undo data is generated for the table's rows.

Show answer
Correct Option: B,C,D

You are logged on to a client. You do not have a secure connection from your client to the host where your Oracle database is running. Which authentication mechanism allows you to connect to the database using the SYSDBA privilege?

technology databases

  1. Control file authentication

  2. Password file authentication

  3. Data dictionary authentication

  4. Operating system authentication

Show answer
Correct Option: B

Which two statements are true about rebuilding an index?
technology databases

  1. The resulting index may contain deleted entries.

  2. A new index is built using an existing index as the data source.

  3. Queries cannot use the existing index while the new index is being built.

  4. During a rebuild, sufficient space is needed to accommodate both the old and the new

Show answer
Correct Option: B,D

Which method is correct for starting an instance to create a database?
technology databases

  1. STARTUP

  2. STARTUP OPEN

  3. STARTUP MOUNT

  4. STARTUP NOMOUNT

Show answer
Correct Option: D

Which data dictionary view shows the available free space in a certain tablespace?

technology databases

  1. DBA_EXTENTS

  2. V$FREESPACE

  3. DBA_FREE_SPACE

  4. DBA_FREE_EXTENTS

Show answer
Correct Option: C

what are the three main components in Hibernate architecture?

technology databases

  1. Connection Management

  2. Bean Management

  3. Transaction Management

  4. Object relational mapping

  5. Relational Management

Show answer
Correct Option: A,C,D

Can a query defining the 'view' include the ORDER BY clause?

technology databases

  1. True

  2. False

Show answer
Correct Option: A