If the explicit value of attributes is not provided in SQL then the value included in new tuple in such situation is called____________
If the explicit value of attributes is not provided in SQL then the value included in new tuple in such situation is called____________
The referential triggered action clause in Standard Query Language is attached to constraint called ________________
The referential triggered action clause in Standard Query Language is attached to constraint called ________________
If the concatenation operator is applied to two strings such as [ 'ABCD' || 'wxyz' ] then the resultant string will be _____________
If the concatenation operator is applied to two strings such as [ 'ABCD' || 'wxyz' ] then the resultant string will be _____________
In varying length character string CHAR(n), the 'n' represents ___________________
In varying length character string CHAR(n), the 'n' represents ___________________
Foreign key is the one in which the ________ of one relation is referenced in another relation.
Foreign key is the one in which the ________ of one relation is referenced in another relation.
The clause used in CREATE TABLE statement in SQL to specify secondary keys is called______________
The clause used in CREATE TABLE statement in SQL to specify secondary keys is called______________
The types of bit-string data type are______________
The types of bit-string data type are______________
The command used in SQL which deletes the table definition as well as all the records available in the table is called______________
The command used in SQL which deletes the table definition as well as all the records available in the table is called______________
In SQL, the type of character string value which is padded with blank characters to the right side of string is called_____________
In SQL, the type of character string value which is padded with blank characters to the right side of string is called_____________
Domain constraints, functional dependency and referential integrity are special forms of _________
Domain constraints, functional dependency and referential integrity are special forms of _________
In Standard Query Language, the data types included are ______________
In Standard Query Language, the data types included are ______________
The relations that are declared in SQL through CREATE TABLES statements are classified as ____________
The relations that are declared in SQL through CREATE TABLES statements are classified as ____________
The data type in SQL which includes various size integers and floating point numbers are classified as______________
The data type in SQL which includes various size integers and floating point numbers are classified as______________
In SQL, the constraints, constructs, views, domains and tables are classified as its______________
In SQL, the constraints, constructs, views, domains and tables are classified as its______________
The module in the SQL which is used to identify elements in the schema is classified as_____________
The module in the SQL which is used to identify elements in the schema is classified as_____________
In standard query language, the rows and columns are called respectively _________________
In standard query language, the rows and columns are called respectively _________________
The data type DATE consists of ten positions where as the data type TIME consists of____________
The data type DATE consists of ten positions where as the data type TIME consists of____________
In the statement DECIMAL () to specify numeric data type, the number of decimal digits is called____________
In the statement DECIMAL () to specify numeric data type, the number of decimal digits is called____________
The concatenation operator in SQL which can concatenate two strings is_______________
The concatenation operator in SQL which can concatenate two strings is_______________
If the referential integrity constraint is violated then the specific action clause attached by the database designers other than by default action is classified as ______________
If the referential integrity constraint is violated then the specific action clause attached by the database designers other than by default action is classified as ______________