picture picture

What is an Open source software ?


Open source doesn’t just mean access to the source code.
1. Free Redistribution

January 27, 2012 Interview Questions, MySQL 0 Comments 17,641 views

MySQL Interview Questions – Part 3

67) Explain Database Basics
Databases are managed by a relational database management system (RDBMS). An RDBMS supports a database language to create and delete databases and to manage and search data. The database language used in almost all DBMSs is SQL, a set of statements that define and manipulate data. After creating a database, the most common SQL statements used are INSERT, UPDATE, DELETE, and SELECT, which add, change, remove, and search data in a database, respectively.

68) what is Database?
A repository to store data.

69) What is Table?
The part of a database that stores the data. A table has columns or attributes, and the data stored in rows.

70) Define Attributes?
The columns in a table. All rows in table entities have the same attributes. For example, a customer table might have the attributes name, address, and city. Each attribute has a data type such as string, integer, or date.

January 2, 2012 Interview Questions, MySQL 1 Comments 7,696 views

MySQL Interview Questions – Part 2

31) How are ENUMs and SETs represented internally?

32) How do you start and stop MySQL on Windows?
net start MySQL, net stop MySQL

33) How do you start MySQL on Linux?
/etc/init.d/mysql start

34) Explain the difference between mysql and mysql interfaces in PHP?
mysqli is the object-oriented version of mysql library functions.
What’s the default port for MySQL Server?

35) What does tee command do in MySQL?

December 24, 2011 MySql, MySQL 0 Comments 3,164 views

MySQL Interview Questions – Part 1

1) What’s MySQL ?

2) What is DDL, DML and DCL ?


