A Subprogram that returns a value is known as _________
A Subprogram that returns a value is known as _________
When all rows in the column have unique identifier it means each row is different from other it is known as _________ integrity
When all rows in the column have unique identifier it means each row is different from other it is known as _________ integrity
____ function or Average function is written with column name and returns the AVG value of that column
____ function or Average function is written with column name and returns the AVG value of that column
With _________ feature of SQL, users can execute the queries at run-time
With _________ feature of SQL, users can execute the queries at run-time
The condition of integrity constraints are defined on database __________.
The condition of integrity constraints are defined on database __________.
_________ language is used to define the structure of the table
_________ language is used to define the structure of the table
The two most common query languages available are ______and________ with RDBMS.
The two most common query languages available are ______and________ with RDBMS.
When database instance fulfils all the integrity constraints -defined on the database schema, it is then known as ______ instance
When database instance fulfils all the integrity constraints -defined on the database schema, it is then known as ______ instance
________ function contains a column name and returns the count of tupple in that column
________ function contains a column name and returns the count of tupple in that column
_________command is used to lock a table or view, limiting access to it by other users
_________command is used to lock a table or view, limiting access to it by other users
__________ are the actions that are run by DBMS whenever some event related to the database occurs.
__________ are the actions that are run by DBMS whenever some event related to the database occurs.
______function or Minimum value function written with column name returns the minimum value present in that column
______function or Minimum value function written with column name returns the minimum value present in that column
When __________command is used then it will return only the COUNT of unique tupple or distinct values of the column
When __________command is used then it will return only the COUNT of unique tupple or distinct values of the column
DBMS maintains the data ________ to avoid the wrong information to enter in database.
DBMS maintains the data ________ to avoid the wrong information to enter in database.
_____ function is written with column name and gives the sum of all tupples present in that column
_____ function is written with column name and gives the sum of all tupples present in that column
An ________ is used to retrieve all columns from the table
An ________ is used to retrieve all columns from the table
.______ was developed in mid 70s at IBM research simultaneously with the development of SQL.
.______ was developed in mid 70s at IBM research simultaneously with the development of SQL.
.________is a standard relational database language used for creation, deletion and modification of database tables
.________is a standard relational database language used for creation, deletion and modification of database tables
____function or Maximum value function written with column name returns the maximum value present in that column
____function or Maximum value function written with column name returns the maximum value present in that column
_________ uses SELECT, INSERT, DELETE and UPDATE command to modify the data.
_________ uses SELECT, INSERT, DELETE and UPDATE command to modify the data.