Database Management Systems

Using this option, the oracle server waits for all currently connected users to disconnect their sessions.

Here, the database is responsible for validating user credentials.

Here, the sizes of the library cache and the data dictionary cache are not set individually and are automatically determined by the oracle server.

In the event when a user process is terminated abnormally, the process monitor background process cleans up the resources that were held by the user process.

The data files in a database contain all of the database data that the users of the database save and retrieve.

This option of STARTUP command can be used to abort the running instance and perform a normal startup.

Using this option, the oracle server automatically rolls back all currently active transactions.

Usually complete recovery up to the point of failure is possible if all archive files are possible.

Yes, all the three statements are true.

Concept of data binding is Creating source data base tables for text boxes,drop down list ,radio buttons etc.

Data Binding is the concept supported by ASP.NET which is able to interface with both SQL server .NET and OLEDB.NET .

ADO can be put directly with in ASP for communicating the data base.

User location cannot be opened with SQL server.

OleDb Adapter is set based data access.

This is managed in a manner that free blocks are always made available for new blocks being read into memory.