Example & Tutorial understanding programming in easy ways.
-
Home
What is the default port number for MySql ?
Read More →
What are the purposes of using ENUM and SET data types?
Read More →
Difference between Primary key and foreign Key ?
Read More →
What is the use of CHAR and VARCHAR in MySQL?
Read More →
Difference between CHAR and VARCHAR in MySQL ?
Read More →
What is the difference between mysql_fetch_array() and mysql_fetch_objec() ?
Read More →
How can you filter the duplicate data while retrieving records from the table?
Read More →
What is the difference between NOW() and CURRENT_DATE()?
Read More →
Which statement is used in a select query for partial matching?
Read More →
Which MySQL function is used to concatenate string?
Read More →
How can you change the name of any existing table by using the SQL statement?
Read More →
How can you retrieve a portion of any column value by using a select query?
Read More →
What is an index? How can an index be declared in MySQL?
Read More →
How can you change the password of a MySQL user?
Read More →
What are the technical specifications of MySQL?
Read More →
first function in MYSQL is done by which function?
Read More →
How many type of Normalization is possible?
Read More →
What is partial dependency in database table?
Read More →
Difference between prime and non prime attribute?
Read More →
What is prime and non attribute in table attribute?
Read More →
What we called the attribute which is part of the candidate key?
Read More →
What we called the attribute which is not part of the candidate key?
Read More →
What do you understand by the key in database?
Read More →
Difference between Superkey and candidate key?
Read More →
Difference between candidate key and primary key?
Read More →
What is the Difference between Primary key and Unique key?
Read More →
What is the Difference between Primary key and foreign Key?
Read More →
What is the purpose of the Normalization in database?
Read More →
In which Normal Form, the chance of data lose is their?
Read More →
In there is no partial dependency in the table then table is in which Normal Form?
Read More →
If there is no transitive dependency in the table then table is in which normal form?
Read More →
If there is only two column or 2 attribute in the table then table is in which Normal form?
Read More →
We any Non prime attribute defines the Another non prime attribute of the same table then this dependency is called as?
Read More →
If we delete the primary of one table then what about the foreign key which refer to that primary key?
Read More →
What is the use of the select statement in the SQL?
Read More →
Write query to add new column in the table.
Read More →
How we delete the existing column from the table?
Read More →
How we change the name of the column of the table in SQL?
Read More →
How we change the name of the table in the SQL?
Read More →
What is the difference between the Truncate, DROP, delete?
Read More →
If we have a two table of same structure and same column and we want to fetch common record from both the table then what we do?
Read More →
How we get the maximum value of the column of the table?
Read More →
How find the MAX and Second max value from the database table?
Read More →
How fetch the data from the table which do not have duplicate data.
Read More →