The __________unit of database processing is defined by mechanism provided by transaction processing.
The __________unit of database processing is defined by mechanism provided by transaction processing.
.__________ key is a column or even a group of columns in a table that accept its values from the primary key (PK) from another table
.__________ key is a column or even a group of columns in a table that accept its values from the primary key (PK) from another table
A ______ is a subschema in which logical tables are generated from more than one base table
A ______ is a subschema in which logical tables are generated from more than one base table
_______ language is thelanguage in which the SQl queries are embedded
_______ language is thelanguage in which the SQl queries are embedded
The __________ property of a transaction makes sure that either every operation is executed in a successful manner or none of them is executed at all.
The __________ property of a transaction makes sure that either every operation is executed in a successful manner or none of them is executed at all.
________ integrity is also called 'attribute' integrity.
________ integrity is also called 'attribute' integrity.
The______ is used for identifying a query in an open statement and also helps in query evaluation
The______ is used for identifying a query in an open statement and also helps in query evaluation
________ command is used to deletes all the information of a dropped relation from database
________ command is used to deletes all the information of a dropped relation from database
__________ can be used in thehost program to determine the place for inserting the special variable by the pre-processor
__________ can be used in thehost program to determine the place for inserting the special variable by the pre-processor
The________ of a relational table uniquely identifies each record in the Table
The________ of a relational table uniquely identifies each record in the Table
To preserve the ________integrity, the foreign key in the 'child' table can only take values that are inthe primary key of 'parent' table
To preserve the ________integrity, the foreign key in the 'child' table can only take values that are inthe primary key of 'parent' table
_________integrity is formed with the combination of Primary Key (PK) and Foreign Key (FK)
_________integrity is formed with the combination of Primary Key (PK) and Foreign Key (FK)
When any error occurs in the execution of SQL query then the error report is stored inside a special variable. These special variables are called as ___________
When any error occurs in the execution of SQL query then the error report is stored inside a special variable. These special variables are called as ___________
The ________ statement is another embedded SQL statement, which is used for deleting the temporary relation that stores the query result.
The ________ statement is another embedded SQL statement, which is used for deleting the temporary relation that stores the query result.
______ command is used to insert record in table
______ command is used to insert record in table
______ command is used to delete row from the table
______ command is used to delete row from the table
In database language a ________ is group of allowed values for a column
In database language a ________ is group of allowed values for a column
_________ integrity is placing aprimary key (PK) constraint on particular column.
_________ integrity is placing aprimary key (PK) constraint on particular column.
_________ command is used for updating a single value without updating all the values in tupple
_________ command is used for updating a single value without updating all the values in tupple
The term _______ defines those properties that must be related with transactions in order that the reliability of the database is assured
The term _______ defines those properties that must be related with transactions in order that the reliability of the database is assured