Qinterview.com

Most Commonly Asked Job Interview Questions And Answers

125,000+ Member

our android app in store



How can we know the number of days between two given dates usingMySQL?


sql database interview questions and answers

common interview question for fresher and experiences.prepare your job interview with us. get your dream job.most frequently asked interview questions.best interview questions. sql database for interview questions and answers for fresher and experience. improve interview skills.improve interview confidence.sql database best interview questions. start your sql database job interview right now and get your dream jobs. preparation job interview any place and any time.also our android application available here. top sql database interview questions. best and top asking questions sql database interview questions with answers.





Note: any question and answer correct or incorrect give you vote. also you know correct answer then you can post your answer or give vote in answer.

my favorites

add to favorite


How can we know the number of days between two given dates usingMySQL?

How can we know the number of days between two given dates usingMySQL?

interview question fresher.
jayvik 0 0


More Answer

Post your Answer



sql database popular interview questions and answers


favorite 0
votes 0
answers 1
views 1383

How can we know the number of days between two given dates usingMySQL?

How can we know the number of days between two given dates usingMySQL?interview question fresher.... view more
submited by :- on 2013-07-08 18:04:02

favorite 0
votes 0
answers 0
views 1226

What is the difference between char and varchar data types?

Set char to occupy n bytes and it will take n bytes even if u r storing a value of n-m bytesSet varchar to occupy n bytes and it will take only the required space and will not use the n byteseg. name char(15) will waste 10 bytes if we store 'romharsh... view more
submited by :- on 2013-07-08 18:00:04

favorite 0
votes 0
answers 0
views 999

What is the difference between GROUP BY and ORDER BY in Sql?

ORDER BY [col1],[col2],…,[coln]; Tels DBMS according to what columns it should sort the result. If two rows will hawe the same value in col1 it will try to sort them according to col2 and so on.GROUP BY [col1],[col2],…,[coln]; Tels DBMS t... view more
submited by :- on 2013-07-08 17:59:11

favorite 0
votes 0
answers 0
views 986
submited by :- on 2013-04-30 17:45:23

favorite 0
votes 0
answers 0
views 944

Explain Normalization concept?

The normalization process involves getting our data to conform to three progressive normal forms, and a higher level of normalization cannot be achieved until the previous levels have been achieved (there are actually five normal forms, but the last ... view more
submited by :- on 2013-07-05 07:06:31

favorite 0
votes 0
answers 1
views 887

Which date function is used to find the difference between two dates?

datedifffor Eg: select datediff (dd,'7-08-2013','13-08-2013')output is 5SQL Database Interview Question.... view more
submited by :- on 2013-05-04 11:19:48

favorite 0
votes 0
answers 0
views 852

What is the difference between Primary Key and Unique key?

Primary Key: A column in a table whose values uniquely identify the rows in the table. A primary key value cannot be NULL.Unique Key: Unique Keys are used to uniquely identify each row in the table. There can be one and only one row for each unique k... view more
submited by :- on 2013-07-08 17:55:28

favorite 0
votes 0
answers 0
views 816

what is garbage collection? default time ? refresh time?

Garbage Collection is an automated part of PHP , If the Garbage Collection process runs, it then analyzes any files in the /tmp for any session files that have not been accessed in a certain amount of time and physically deletes them. Garbage Collect... view more
submited by :- on 2013-07-08 17:57:12

favorite 0
votes 0
answers 0
views 810

What are the advantages and disadvantages of primary key and foreign key in SQL?

Primary keyAdvantages1) It is a unique key on which all the other candidate keys are functionally dependentDisadvantage1) There can be more than one keys on which all the other attributes are dependent on.Foreign KeyAdvantage1)It allows refrencing an... view more
submited by :- on 2013-05-04 11:18:56

favorite 0
votes 0
answers 6
views 803

How many ways we can we find the current date using MySQL?

SELECT CURDATE();CURRENT_DATE() = CURDATE()for time useSELECT CURTIME();CURRENT_TIME() = CURTIME()best mysql interview question.... view more
submited by :- on 2013-07-05 07:10:46

favorite 0
votes 0
answers 0
views 802

What is difference between DBMS and RDBMS?

The main difference of DBMS & RDBMS isRDBMS have Normalization. Normalization means to refining the redundant and maintain the stablization. the DBMS hasn't normalization concept.SQL Database Interview Question.... view more
submited by :- on 2013-05-04 11:18:22

favorite 0
votes 0
answers 0
views 789

What are the advantages/disadvantages of MySQL and PHP?

Both of them are open source software (so free of cost), support cross platform. php is faster then ASP and JSP.php interview question fresher.... view more
submited by :- on 2013-07-08 17:57:57

favorite 0
votes 0
answers 0
views 778

Difference between Store Procedure and Trigger?

we can call stored procedure explicitly.but trigger is automatically invoked when the action defined in trigger is done.ex: create trigger after Insert onthis trigger invoked after we insert something on that table.Stored procedure can't be inactive ... view more
submited by :- on 2013-05-01 18:24:50

favorite 0
votes 0
answers 0
views 771

What is cluster.cluster index and non cluster index ?

Clustered Index:- A Clustered index is a special type of index that reorders the way records in the table are physically stored. Therefore table may have only one clustered index.Non-Clustered Index:- A Non-Clustered index is a special type of index ... view more
submited by :- on 2013-05-04 11:17:46

favorite 0
votes 0
answers 1
views 770

How can we find the number of rows in a table using MySQL?

Use this for mysql>SELECT COUNT(*) FROM table_name;best mysql interview question.... view more
submited by :- on 2013-07-05 07:09:21

favorite 0
votes 0
answers 0
views 766

Give the syntax of Grant and Revoke commands?

The generic syntax for grant is as following> GRANT [rights] on [database/s] TO [username@hostname] IDENTIFIED BY[password]now rights can bea) All privilegesb) combination of create, drop, select, insert, update and delete etc.We can grantrights o... view more
submited by :- on 2013-07-05 07:05:18

favorite 0
votes 0
answers 0
views 754

What is maximum size of a database in MySQL?

If the operating system or filesystem places a limit on the number of files in a directory, MySQL is bound by that constraint.The efficiency of the operating system in handling large numbers of files in a directory can place a practical limit on the ... view more
submited by :- on 2013-07-05 07:02:31

favorite 0
votes 0
answers 0
views 736

How many tables will create when we create table, what are they?

The '.frm' file stores the table definition.The data file has a '.MYD' (MYData) extension.The index file has a '.MYI' (MYIndex) extension,best mysql interview question.... view more
submited by :- on 2013-07-05 06:56:52

favorite 0
votes 0
answers 0
views 726

What is the difference between SQL and SQL Server ?

SQLServer is an RDBMS just like oracle,DB2 from Microsoftwhereas Structured Query Language (SQL), pronounced sequel, is a language that provides an interface to relational database systems. It was developed by IBM in the 1970s for use in System R. ... view more
submited by :- on 2013-05-04 11:13:24

favorite 0
votes 0
answers 0
views 691

What is database?

A database is a collection of data that is organized so that itscontents can easily be accessed, managed and updated.SQL Database Interview Question.... view more
submited by :- on 2013-05-04 11:17:13


sql database best Interview Questions have been designed especially to get you acquainted with the nature of questions you may encounter during your interview for the subject of sql database Programming Language. here some questions that helpful for your interview.