-
PL/SQL Block output
begin For i in 1..5 loop insert into A values(i); savepoint 1; end loop; rollback to savepoint 1; commitend;--initially there are no data in table A. So my question is after execution of this block what should be the data present in table A?
-
-
What are the differences between physical and logical data model?
The main important aspect is physical data model is created after logical data model. For designing a logical data model one need not have through knowledge in any specific RDBMS like oracle, Informix and so on. This is because logical data model is created after having through study of the business entities which would be involved in the application. The same can be represented by using E-R diagram...
-
-
-
-
-
-
-
-
-
-
-
What are the components of a PL/SQL Block ?
Declarative part, Executable part and Exception part. Datatypes PL/SQL
-
What is an Index ? How it is implemented in Oracle Database ?
An index is a database structure used by the server to have direct access of a row in a table. An index is automatically created when a unique of primary key constraint clause is specified in create table comman (Ver 7.0)
-
What is a Schema ?
The set of objects owned by user account is called the schema.
-
What is Parallel Server ?
Multiple instances accessing the same database (Only In Multi-CPU environments)
-
What is a Database instance ? Explain
A database instance (Server) is a set of memory structure and background processes that access a set of database files. The process can be shared by all users. The memory structure that are used to store most queried data from database. This helps up to improve database performance by decreasing the...
-
What is the use of Redo Log Information ?
The Information in a redo log file is used only to recover the database from a system or media failure prevents database data from being written to a database's data files.
-
What is the function of Redo Log ?
The Primary function of the redo log is to record all changes made to data.
-
What is a Redo Log ?
The set of Redo Log files for a database is collectively known as the database's redo log.
-
What are the Characteristics of Data Files ?
A data file can be associated with only one database. Once created a data file can't change size.One or more data files form a logical unit of database storage called a tablespace.
-
What is a deadlock and Explain
A deadlock is a condition where two or more users are waiting for data locked by each other. Oracle automatically detects a deadlock and resolves them by rolling back one of the statements involved in the deadlock, thus releasing one set of data locked by that statement. Statement rolled back is usually the one which detects the deadlock. Deadlocks are mostly caused by explicit locking because oracle...