Home | Contact Us | Log In | Help
HOME New Listing Script NEW LISTING Most Popular Script MOST POPULAR High Rated Script HIGHEST RATED Script SCRIPTS Add Script ADD SCRIPT Download Tutorial DOWNLOADS Forums FORUM
   ASP.Net & C#
   Perl and PHP
   Java Scripts
   C and C++
   Ajax Tutorials
   J2ee, J2Me, Java
   Python & Ruby Rail
   Crystal Report
   Cold Fusion & CFML
   Photoshop/Web Designing
   Tools & Utilities
   Sql Server
   Domain Name Registration
   Remotely Hosting
   Web/Server Application
   Hotel Marketing
   Internet and Law
   Search Engine Optimization/SEO
   Interview Questions
   Site Map

< 1 2 3 4 5 6 > Next

MySql 1
 What MySQL Enterprise Server?

MySQL Enterprise Server software is the most reliable, secure and up-to-date version of MySQL for cost-effectively delivering E-commerce, Online Transaction Processing (OLTP), and multi-terabyte Data Warehousing applications. It is a fully integrated transaction-safe, ACID compliant database with full commit, rollback, crash recovery and row level locking capabilities. MySQL delivers the ease of use, scalability, and performance that has made MySQL the world's most popular open source database.
MySql is a Relational database management system, provided from open source community. Currently fast growing and hight used RDBMS. MySql Developed by MySql AB.

 What is RMAN?

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.

 In MySQL, what table type is required for foreign keys to work?

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.

 What is the TDS protocol?

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

 How to get full name of monthname?

Select date_format(curdate(),'%M') ;

select to_char(sysdate,'Month') from dual

 Explain multi-version concurrency control in MySQL?

Each row has two additional columns associated with it - creation time and deletion time, but instead of storing timestamps, MySQL stores version numbers
Multiversion concurrency control (abbreviated MCC or MVCC), in the database field of computer science, is a concurrency control method commonly used by database management systems to provide concurrent access to the database. MVCC provides each user connected to the database with a "snapshot" of the database for that person to work with. Any changes made will not be seen by other users of the database until the transaction has been committed.

 What is a Function?

Set of statements to perform a particular task.It compute a value and returns it.
if u call 1000 times a function,it has the same effect.It cannot be executed individually.
When u call a function,u must assign a value to the variable.
Note:Returns a single value.

 Data integrity ensures the consistency & correctness of data stored in a Mysql database?

There are five types of constraints:-

1. PRIMARY constraint
2.FOREIGN constraint
3.UNIQUE constraint
4.CHECK constraint
5.DEFAULT constraint


< 1 2 3 4 5 6 > Next

  Copyright 2000-2006 ©, All rights reserved.