MySQL and general database interview questions

  1. What is MySQL?
  2. What is Postgres?
  3. What are the basic steps in setting up an Oracle system?
  4. What is a stored procedure, and which databases support it?
  5. What is RMAN?
  6. What is the TDS protocol?
  7. What is required to connect to an oracle system remotely?
  8. In MySQL, how do I create a database?
  9. In MySQL, how do I grant access to a user to a specific database with read only permissions?
  10. In MySQL, what table type is required for foreign keys to work?
This entry was posted in Database, Unix/Linux. Bookmark the permalink. Post a comment or leave a trackback: Trackback URL.

9 Comments on MySQL and general database interview questions

  1. Kishor
    Posted 9/14/2005 at 7:33 am | Permalink

    MySql is a Relational database management system, provided from open source community. Currently fast growing and hight used RDBMS. MySql Developed by MySql AB.

  2. Dhaval
    Posted 10/24/2005 at 7:04 am | Permalink

    Recovery Manager (or RMAN) is an Oracle provided utility for backing-up, restoring and recovering Oracle Databases. RMAN ships with the database server and doesn’t require a separate installation. The RMAN executable is located in your ORACLE_HOME/bin directory.

  3. Dhaval
    Posted 10/24/2005 at 7:07 am | Permalink

    I don’t know about TDS in detail
    But Here is a link of it’s documentation
    http://www.freetds.org/tds.html

  4. Mohnish
    Posted 1/11/2006 at 9:26 pm | Permalink

    Answer Q 8 .
    create database database_name;

  5. Chris Mc
    Posted 11/6/2006 at 6:08 pm | Permalink

    RE #10:

    http://dev.mysql.com/doc/refman/5.0/en/innodb-foreign-key-constraints.html

    Foreign keys definitions are subject to the following conditions:
    Both tables must be InnoDB tables and they must not be TEMPORARY tables.

    In the referencing table, there must be an index where the foreign key columns are listed as the first columns in the same order. Such an index is created on the referencing table automatically if it does not exist.

    In the referenced table, there must be an index where the referenced columns are listed as the first columns in the same order.

    Index prefixes on foreign key columns are not supported. One consequence of this is that BLOB and TEXT columns cannot be included in a foreign key, because indexes on those columns must always include a prefix length.

    If the CONSTRAINT symbol clause is given, the symbol value must be unique in the database. If the clause is not given, InnoDB creates the name automatically.

  6. Chris Mc
    Posted 11/6/2006 at 6:25 pm | Permalink

    RE #4

    See: http://dev.mysql.com/doc/refman/5.0/en/stored-procedures.html

    Stored routines (procedures and functions) are supported in MySQL 5.0. A stored procedure is a set of SQL statements that can be stored in the server. Once this has been done, clients don’t need to keep reissuing the individual statements but can refer to the stored procedure instead.

    Some situations where stored routines can be particularly useful:

    When multiple client applications are written in different languages or work on different platforms, but need to perform the same database operations.

    When security is paramount. Banks, for example, use stored procedures and functions for all common operations. This provides a consistent and secure environment, and routines can ensure that each operation is properly logged. In such a setup, applications and users would have no access to the database tables directly, but can only execute specific stored routines.

    Stored routines can provide improved performance because less information needs to be sent between the server and the client. The tradeoff is that this does increase the load on the database server because more of the work is done on the server side and less is done on the client (application) side. Consider this if many client machines (such as Web servers) are serviced by only one or a few database servers.

    Stored routines also allow you to have libraries of functions in the database server. This is a feature shared by modern application languages that allow such design internally (for example, by using classes). Using these client application language features is beneficial for the programmer even outside the scope of database use.

    MySQL follows the SQL:2003 syntax for stored routines, which is also used by IBM’s DB2.

  7. Manish Kothari
    Posted 2/15/2007 at 4:34 am | Permalink

    TDS(Tabular Data Stream) is a protocol,basically it used to connect the Data Base Server(SQL Server,MySql etc) to your application.

  8. venkat
    Posted 5/21/2007 at 5:47 am | Permalink

    re 10
    Innodb type requid for foreign keys

  9. nikhil
    Posted 7/12/2007 at 1:59 am | Permalink

    What is MySQL?
    What is Postgres?
    What are the basic steps in setting up an Oracle system?
    What is a stored procedure, and which databases support it?
    What is RMAN?

    What is the TDS protocol?
    What is required to connect to an oracle system remotely?
    In MySQL, how do I create a database?
    In MySQL, how do I grant access to a user to a specific database with read only permissions?
    In MySQL, what table type is required for foreign keys to work? with example

Post a Comment

Your email is never published nor shared. Required fields are marked *

*
*