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
_________ integrity is placing aprimary key (PK) constraint on particular column.
_________ integrity is placing aprimary key (PK) constraint on particular column.
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 ___________
_________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)
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.
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.
________ 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
_________ 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______ 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
_______ language is thelanguage in which the SQl queries are embedded
_______ language is thelanguage in which the SQl queries are embedded
______ command is used to delete row from the table
______ command is used to delete row from the table
The________ of a relational table uniquely identifies each record in the Table
The________ of a relational table uniquely identifies each record in the 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
.__________ 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
________ integrity is also called 'attribute' integrity.
________ integrity is also called 'attribute' integrity.
______ command is used to insert record in table
______ command is used to insert record in 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
In database language a ________ is group of allowed values for a column
In database language a ________ is group of allowed values for a column
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.
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
__________ 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