The condition of integrity constraints are defined on database __________.
The condition of integrity constraints are defined on database __________.
A Subprogram that returns a value is known as _________
A Subprogram that returns a value is known as _________
____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
____ 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
______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 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
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
With _________ feature of SQL, users can execute the queries at run-time
With _________ feature of SQL, users can execute the queries at run-time
__________ 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.
.______ 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.
_________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
An ________ is used to retrieve all columns from the table
An ________ is used to retrieve all columns from the table
_________ language is used to define the structure of the table
_________ language is used to define the structure of the table
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.
The two most common query languages available are ______and________ with RDBMS.
The two most common query languages available are ______and________ with RDBMS.
_________ uses SELECT, INSERT, DELETE and UPDATE command to modify the data.
_________ uses SELECT, INSERT, DELETE and UPDATE command to modify the data.
________ 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
_____ 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
.________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