Sql Interview Question and Answers:
97. What is De-normalization?
De-normalization is the process of attempting to optimize the performance of a database by adding redundant data.
De-normalization is a technique to move from higher to lower normal forms of database modeling in order to speed up database access.
98. What is referential integrity?
Referential integrity refers to the consistency that must be maintained between primary and foreign keys, i.e. every foreign key value must have a corresponding primary key value.
99. What is the difference between static and dynamic SQL?
Static SQL is hard-coded in a program when the programmer knows the statements to be executed.
For dynamic SQL the program must dynamically allocate memory to receive the query results.
100. Define Unique Key?
Unique key is a one or more column that must be unique for each row of the table.
It is similar to primary key. Primary key column will not accept a null. Whereas the unique key column will accept a null values.
101. Define Synonym?
Synonym is an alternative method to creating a view that includes the entire table or view from another user it to create a synonym.
A synonym is a name assigned to a table or view that may thereafter be used to refer to it.
97. What is De-normalization?
De-normalization is the process of attempting to optimize the performance of a database by adding redundant data.
De-normalization is a technique to move from higher to lower normal forms of database modeling in order to speed up database access.
98. What is referential integrity?
Referential integrity refers to the consistency that must be maintained between primary and foreign keys, i.e. every foreign key value must have a corresponding primary key value.
99. What is the difference between static and dynamic SQL?
Static SQL is hard-coded in a program when the programmer knows the statements to be executed.
For dynamic SQL the program must dynamically allocate memory to receive the query results.
100. Define Unique Key?
Unique key is a one or more column that must be unique for each row of the table.
It is similar to primary key. Primary key column will not accept a null. Whereas the unique key column will accept a null values.
101. Define Synonym?
Synonym is an alternative method to creating a view that includes the entire table or view from another user it to create a synonym.
A synonym is a name assigned to a table or view that may thereafter be used to refer to it.
This is no longer true. Unlike the artistic visionaries of inter- war Europe, who interpreted the last breath of a dying world-order through their brazen art, we see no such aesthetic effort today when the world is teetering on the brink of another geopolitical crisis of equal gravitas, when there is every indication of a tectonic shift in the post-Cold war balance of power.
ReplyDeletekizi car games
free game 2019
a10 free