databases Online Quiz - 184

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

What Type of Encryption Algorithm is used by Oracle

  1. DES


  3. RSA

  4. All the Above

Correct Option: A

The File that contains the server side network parameters





Correct Option: C

Ping when compared to TNS ping is FAST

  1. True

  2. False

Correct Option: B

If the Listener is shutdown while the database is still running, what is the state of existing connection

  1. The Connections also get closed along with listener.

  2. The Connections close as and when the open transaction completes

  3. The Existing connections are left untouched as the listener only initiates the connections

  4. None of the Above

Correct Option: C

AI Explanation

To answer this question, we need to understand the relationship between the Listener and the database connections.

The Listener is responsible for accepting incoming client connections and establishing a connection between the client and the database server. Once the connection is established, the Listener's role is complete, and it does not actively manage or control the existing connections.

Given the scenario where the Listener is shut down while the database is still running, the existing connections will be left untouched. This means that the connections between the client and the database server will remain open and active, even though the Listener is no longer available.

Therefore, the correct answer is:

C. The existing connections are left untouched as the Listener only initiates the connections.

I must access a remote database using the SQLPLUS client executable

  1. I can connect only if there is a TNS entry in the server where the client executable resides

  2. I can connect only if there is a TNS entry in the server where the database resides

  3. No need for a TNS entry at all

  4. The Listener.ora will take care of the connection

Correct Option: A

I am accessing SQLPLUS from a Server SRV01. My database D01 also resides on the same server. I need a TNS entry in that server so that my database is identified

  1. True

  2. False

Correct Option: B

enterprise users can be given access to multiple schemas and databases without having to create an account or schema in each database.

  1. True

  2. False

Correct Option: B

If an User is Identified by OS, he can connect to the database with SQLPLUS -S / as SYSDBA

  1. True

  2. False

Correct Option: B

In Oracle World User is authentication, Schema is authorization

  1. True

  2. False

Correct Option: B




  3. NONE

  4. All the Above

Correct Option: D

Password File Authentication, takes precedence over OS Authentication

  1. True

  2. False

Correct Option: B

What is the Data Dictionary view that will show the details of Initialization Parameters

  1. V$database

  2. V$parameter

  3. V$parameter2

  4. v$instance

Correct Option: B

A user U01 is logging in with his ID What data dictionary view will give details on available system privileges for him





Correct Option: B

what is the use of hibernate.cfg.xml in Hibernate?

  1. To create the connection pool and setup required environment

  2. To configure bean management setup environment

  3. To talk to the database directly with out this configuration file

  4. To create an object and map the data with corresponding object

Correct Option: A

__________ allows application to create the Hibernate Sesssion by reading the configuration from hibernate.cfg.xml file

  1. Session

  2. ApplicationContext

  3. SessionFactory

  4. Hibernate Object

Correct Option: C

How to create SessionFactory instance, which one is correct in the below.

  1. SessionFactory sessionFactory = new Configuration().configure();

  2. SessionFactory sessionFactory = new Configuration().configure().buildSessionFactory();

  3. SessionFactory sessionFactory = new Configuration().configure().sessionFactory();

  4. SessionFactory sessionFactory = new Configuration().buildSession();

Correct Option: B

Wich one is the first or root element of hibernate mapping document ______________

  1. element

  2. element

  3. element

  4. element

Correct Option: A

Identify the list of some commonly used generators in hibernate

  1. increment, identity, sequence, hilo, uuid

  2. decrement, identify, sequence, hilote, uuid

  3. generator, factory, series

  4. incrementObject, sequence, hilote, uuids

Correct Option: A

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

  1. org.hibernate.cfg.configuration

  2. org.hibernate.cfg.configuration.Session

  3. org.hibernate.Configuration

  4. org.hibernate.cfg.Configuration

Correct Option: D
- Hide questions