The Complete Project Source Code Platform
 
 
 
    • Programs Demo Interview Resume Top developers Contact us
    • Projects
    Project Ideas
    Template
    Programs
    Resume Templates
    Create My Resume

    Kashipara.com is a community of ONE million programmers and students, Just like you, Helping each other.Join them. It only takes a minute: Sign Up

    Buy a laptop for coding and programming Buy a programming books
    Java Object oriented programming (oop) Human resources (hr) Objective c (iphone) Android Sql database Electronics and communication (ec) .net Php Cascading Style Sheets(css) Networking Visual basic(vb) Interview tips Python JQuery Unix command Mechanical

    latest sql database Job Interview Questions And Answers


    Why don't preparation your interviews. Best and top asking questions sql database questions and answers. Prepare your job sql database interview with us. Most frequently asked questions in sql database interview. Top 10 most common sql database interview questions and answer to ask. sql database most popular interview question for fresher and experiences. We have good collection of sql database job interview questions and answers. Ask interview questions and answers mnc company.employee ,fresher and student. sql database technical questions asking in interview. Complete placement preparation for major companies tests and sql database interviews,Aptitude questions and answers, technical, interview tips, practice tests, assessment tests and general knowledge questions and answers.

    latest interview
    favorite interview
    most popular interview
    hot interview

    Free Download sql database Questions And Answers Pdf.


    latest sql database FAQ sql database Interview Questions and Answers for Experiences and Freshers.


    How To update info already in a table and Delete a row(s) from a table?

    mysql> UPDATE [table name] SET Select_priv = 'Y',Insert_priv = 'Y',Update_priv = 'Y' where [field name] = 'user'; 
    mysql> DELETE from [table name] where [field name] = 'whatever';

    sql database   2014-01-06 08:18:11

    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.

    sql database   2013-07-08 18:04:02

    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 bytes
    Set varchar to occupy n bytes and it will take only the required space and will not use the n bytes
    eg. name char(15) will waste 10 bytes if we store 'romharshan', if each char takes a byte
    eg. name varchar(15) will just use 5 bytes if we store 'romharshan', if each char takes a byte. rest 10 bytes will be free.

    interview question fresher.

    sql database   2013-07-08 18:00:04

    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 to group results with same value of column col1. You can use COUNT(col1), SUM(col1), AVG(col1) with it, if you want to count all items in group, sum all values or view average

    php interview question fresher.

    sql database   2013-07-08 17:59:11

    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.

    sql database   2013-07-08 17:57:57

    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 Collection process only runs in the default session save directory, which is /tmp. If
    you opt to save your sessions in a different directory, the Garbage Collection process will ignore it. the Garbage Collection process does not differentiate between which sessions belong to whom when run. This is especially important note on shared web servers. If the process is run, it deletes ALL files that have not been accessed in the directory. There are 3 PHP.ini variables, which deal with the garbage collector: PHP ini value name default session.gc_maxlifetime 1440 seconds or 24 minutes session.gc_probability 1 session.gc_divisor 100

    php interview question fresher.

    sql database   2013-07-08 17:57:12

    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 key value. So NULL can be a unique key.There can be only one primary key for a table but there can be more than one unique for a table.

    sql interview question fresher.

    sql database   2013-07-08 17:55:28

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

    SELECT CURDATE();
    CURRENT_DATE() = CURDATE()
    for time use
    SELECT CURTIME();
    CURRENT_TIME() = CURTIME()

    best mysql interview question.

    sql database   2013-07-05 07:10:46

    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.

    sql database   2013-07-05 07:09:21

    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 two are mainly academic and will not be discussed).First Normal FormThe First Normal Form (or 1NF) involves removal of redundant data from horizontal rows. We want to ensure that there is no duplication of data in a given row, and that every column stores the least amount of information possible (making the field atomic).Second Normal FormWhere the First Normal Form deals with redundancy of data across a
    horizontal row, Second Normal Form (or 2NF) deals with redundancy of data in vertical columns. As stated earlier, the normal forms are progressive, so to achieve Second Normal Form, your tables must already
    be in First Normal Form.Third Normal Form I have a confession to make; I do not often use Third Normal Form. In Third Normal Form we are looking for data in our tables that is not fully dependant on the primary key, but dependant on another value in the table

    best mysql interview question.

    sql database   2013-07-05 07:06:31

    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 be
    a) All privileges
    b) combination of create, drop, select, insert, update and delete etc.We can grant
    rights on all databse by using *.* or some specific database by database.* or a specific table by database.table_name
    username@hotsname can be either username@localhost, username@hostname
    and username@%
    where hostname is any valid hostname and % represents any name, the *.* any condition
    password is simply the password of userThe generic syntax for revoke is as following
    > REVOKE [rights] on [database/s] FROM [username@hostname]
    now rights can be as explained above
    a) All privileges
    b) combination of create, drop, select, insert, update and delete etc.
    username@hotsname can be either username@localhost, username@hostname
    and username@%
    where hostname is any valid hostname and % represents any name, the *.*
    any condition

    best mysql interview question.

    sql database   2013-07-05 07:05:18

    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 number of tables in a database. If the time required to open a file in the directory increases significantly as the number of files increases, database performance can be adversely affected.
    The amount of available disk space limits the number of tables. MySQL 3.22 had a 4GB (4 gigabyte) limit on table size. With the MyISAM storage engine in MySQL 3.23, the maximum table size was increased to 65536 terabytes (2567 – 1 bytes). With this larger allowed table size, the maximum effective table size for MySQL databases is usually determined by operating system constraints on file sizes, not by MySQL internal limits.The InnoDB storage engine maintains InnoDB tables within a tablespace that can be created from several files. This allows a table to exceed the maximum individual file size. The tablespace can include raw disk partitions, which allows extremely large tables. The maximum tablespace size is 64TB.
    The following table lists some examples of operating system file-size limits. This is only a rough guide and is not intended to be definitive. For the most up-to-date information, be sure to check the documentation specific to your operating system.Operating System File-size 
    LimitLinux 2.2-Intel 32-bit 2GB (LFS: 4GB) 
    Linux 2.4+ (using ext3 filesystem) 4TB 
    Solaris 9/10 16TB
    NetWare w/NSS filesystem 8TB
    Win32 w/ FAT/FAT32 2GB/4GB
    Win32 w/ NTFS 2TB (possibly larger)
    MacOS X w/ HFS+ 2TB

    best mysql interview question.

    sql database   2013-07-05 07:02:31

    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.

    sql database   2013-07-05 06:56:52

    What are the other commands to know the structure of table using MySQL commands except explain command?

    describe Table-Name;


    best mysql interview question.

    sql database   2013-07-05 05:57:42

    How many values can the SET function of MySQL take?

    MySQL set can take zero or more values but at the maximum it can take 64 values

    mysql interview question for fresher and experiences.

    sql database   2013-07-04 09:36:12

    What is the maximum length of a table name, database name, and fieldname in MySQL?

    The following table describes the maximum length for each type of identifier.
    IdentifierMaximum Length(bytes)
    Database 64
    Table 64
    Column 64
    Index 64
    Alias 255

    There are some restrictions on the characters that may appear in identifiers:

    mysql interview question for fresher and experiences.

    sql database   2013-07-04 09:35:29

    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 5

    SQL Database Interview Question.

    sql database   2013-05-04 11:19:48

    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 another table using the primary key for the other table

    SQL Database Interview Question.

    sql database   2013-05-04 11:18:56

    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.

    sql database   2013-05-04 11:18:22

    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 in which the logical order of the index does not match the physical stored order of the rows in the disk. The leaf nodes of a non-clustered index does not consists of the data pages. instead the leaf node contains index rows.

    SQL Database Interview Question.

    sql database   2013-05-04 11:17:46



    latest sql database questions and answers for experienced


    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. sql database 2024 job interview questions with answers. sql database for employee and fresher. Here we present some more challenging practice sql database interview questions and answers that were asked in a real interview for a sql database developer position. These questions are really good to not just test your sql database skills, but also your general development knowledge. sql database programming learning. we hope this sql database interview questions and answers would be useful for quick glance before going for any sql database job interview.