0

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

  2. KERBEROS

  3. RSA

  4. All the Above


Correct Option: A
  1. INIT.ORA

  2. SQLNET.ORA

  3. LISTENER.ORA

  4. TNSNAMES.ORA


Correct Option: C

Ping when compared to TNS ping is FAST

  1. True

  2. False


Correct Option: B
  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
  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

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

REMOTE_LOGIN_PASSWORDFILE parameter can have

  1. SHARED

  2. EXCLUSIVE

  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

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