Loading...
August 21, 2008
Home
Sign-In
My Interview Questions
User Name:
detech2
Url:
Not Specified
Activity Score:
485
See Just Questions
See Questions & Answers
59
UPs
Can we use more than one Primary key in a single tabe?
Comments (
0
)
|
Email
|
Inappropriate
|
Asked By: detech2
|
See Answer
Edit
Your Name:
To Email:
Subject:
Note to go along with the question:
(Optional, no more than 1,000 characters)
Single table can't have more than one Primary key.
Create Date
:
Sunday, March 09, 2008
Tags
:
MySQL
,
Primarykey
Asked At
:
Systematix
Job Positions
:
database
Click here
to improve the Interview Question, Answer and other fields.
Comments (
0
) :
62
UPs
What are the optimization techniques for Querying, performance and faster execution of queries?
Comments (
0
)
|
Email
|
Inappropriate
|
Asked By: detech2
|
See Answer
Edit
Your Name:
To Email:
Subject:
Note to go along with the question:
(Optional, no more than 1,000 characters)
Optimization techniques are -
1.litmit
2.keys
3. indexing
Create Date
:
Sunday, March 09, 2008
Tags
:
optimization
,
performance
,
MySQL
,
querying
,
faster
Asked At
:
None
Job Positions
:
database
Click here
to improve the Interview Question, Answer and other fields.
Comments (
0
) :
54
UPs
What are the differences between MySQL_fetch_array, MySQL_fetch_object, MySQL_fetch_row?
Comments (
0
)
|
Email
|
Inappropriate
|
Asked By: detech2
|
See Answer
Edit
Your Name:
To Email:
Subject:
Note to go along with the question:
(Optional, no more than 1,000 characters)
When u r using mysql_fetch_object i will first matching record. You can access the result set by column name of that record.
When u r using mysql_fetch_array i will fetch all the matching records from the table.
You can access the result set by index as well as colum name of that record.
Create Date
:
Sunday, March 09, 2008
Tags
:
Object
,
array
,
row
,
MySQL
Asked At
:
None
Job Positions
:
database
Click here
to improve the Interview Question, Answer and other fields.
Comments (
0
) :
66
UPs
How can you improve the speed when you query the large table?
Comments (
0
)
|
Email
|
Inappropriate
|
Asked By: detech2
|
See Answer
Edit
Your Name:
To Email:
Subject:
Note to go along with the question:
(Optional, no more than 1,000 characters)
We can improve the speed by creating the index on necessary fields.
Create Date
:
Sunday, March 09, 2008
Tags
:
index
,
speed
,
MySQL
Asked At
:
None
Job Positions
:
database
Click here
to improve the Interview Question, Answer and other fields.
Comments (
0
) :
43
UPs
What is the Syntax to change the column name and data type in a table?
Comments (
0
)
|
Email
|
Inappropriate
|
Asked By: detech2
|
See Answer
Edit
Your Name:
To Email:
Subject:
Note to go along with the question:
(Optional, no more than 1,000 characters)
To Change Name of Column:
Sy: Alter Table <Table Name> Change <Old ColumnName> <NewColumnName>;
To Change DataType of Column:
Sy: Alter Table <Table Name> Modify <ColumnName> <DataType>;
Create Date
:
Sunday, March 09, 2008
Tags
:
MySQL
,
Column name change
,
data type change
Asked At
:
None
Job Positions
:
database
Click here
to improve the Interview Question, Answer and other fields.
Comments (
0
) :
73
UPs
What is the difference between GROUP BY and ORDER BY ?
Comments (
0
)
|
Email
|
Inappropriate
|
Asked By: detech2
|
See Answer
Edit
Your Name:
To Email:
Subject:
Note to go along with the question:
(Optional, no more than 1,000 characters)
Groupby --> It is a way to sub-total your results,or perform some other 'aggregate' functions on them.
Orderby --> It is a simply a way to sort your results. It doesn't affect what shows up in your result set,only
what order it is displayed
Create Date
:
Sunday, March 09, 2008
Tags
:
GROUP BY
,
ORDER BY
,
MySQL
Asked At
:
None
Job Positions
:
database
Click here
to improve the Interview Question, Answer and other fields.
Comments (
0
) :
85
UPs
What is maximum size of a database in MySQL?
Comments (
0
)
|
Email
|
Inappropriate
|
Asked By: detech2
|
See Answer
Edit
Your Name:
To Email: