_________ 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
______ 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
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.
_________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)
________ integrity is also called 'attribute' integrity.
________ integrity is also called 'attribute' integrity.
_________ integrity is placing aprimary key (PK) constraint on particular column.
_________ integrity is placing aprimary key (PK) constraint on particular column.
In database language a ________ is group of allowed values for a column
In database language a ________ is group of allowed values for a 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 ___________
.__________ 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
________ 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
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
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 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
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
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.
The________ of a relational table uniquely identifies each record in the Table
The________ of a relational table uniquely identifies each record in the Table
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.