Tag: databases

A role can be given to a maximum of 1000 users

A user can have access to a maximum of 10 roles

A role can have a maximum of 100 privileges contained in it

Privileges are given to a role by using the CREATE ROLE statement

A role is a named group of related privileges that can be granted to the user

A user can have access to several roles, and several users can be assigned to the same role

Connection Management

Bean Management

Transaction Management

Object relational mapping

Relational Management

DES

KERBEROS

RSA

All the Above

INIT.ORA

SQLNET.ORA

LISTENER.ORA

TNSNAMES.ORA

True

False

The Connections also get closed along with listener.

The Connections close as and when the open transaction completes

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

None of the Above

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

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

No need for a TNS entry at all

The Listener.ora will take care of the connection

True

False

True

False

True

False