@gautam-sarswat
Questions
When a "one" table's primary key field is added to a related "many" table in order to create the common field which relates the two tables, it is called a…
View Question
A primary key is a column whose values uniquely identify every row in a table. Primary key values can never be reused. If a row is deleted from the table,…
View Question
Properties of the transaction can be summarized as ACID Properties. 1. Atomicity A transaction consists of many steps. When all the steps in a transaction gets completed, it will get…
View Question
Primary keys are the unique identifiers for each row. They must contain unique values and cannot be null. Due to their importance in relational databases, Primary keys are the most…
View Question
A stored procedure is like a function that contains a set of operations compiled together. It contains a set of operations that are commonly used in an application to do…
View Question
A Trigger is a code that associated with insert, update or delete operations. The code is executed automatically whenever the associated query is executed on a table. Triggers can be…
View Question
1. Views can represent a subset of the data contained in a table; consequently, a view can limit the degree of exposure of the underlying tables to the outer world:…
View Question
A view is a virtual table based on the result-set of an SQL statement. We can create using create view syntax. CREATE VIEW view_name AS SELECT column_name(s) FROM table_name WHERE…
View Question
Primary key cannot have NULL value, the unique constraints can have NULL values. There is only one primary key in a table, but there can be multiple unique constrains.
View Question
A super key is a set of attributes of a relation schema upon which all attributes of the schema are functionally dependent. No two rows can have the same value…
View Question