Login
Register
All Activity
Questions
Unanswered
Tags
Users
Ask a Question
About Us
986
Questions
785
Answers
Interview Preparation mode
beta
Funny Facebook Status
Enter your email address
Recent questions tagged mysql-interview-question
Recent questions tagged mysql-interview-question
Nice?
Vote!
1
answer
If I created a column with data type VARCHAR(3), what would I expect to see in MySQL table?
asked
1 year
ago
in
MySQL Interview Questions and Answers
by
R
(
19,530
points)
mysql
mysql-interview-question
datatype
Nice?
Vote!
1
answer
Explain TIMESTAMP DEFAULT ‘2006:09:02 17:38:44′ ON UPDATE CURRENT_TIMESTAMP.
asked
1 year
ago
in
MySQL Interview Questions and Answers
by
R
(
19,530
points)
mysql-interview-question
mysql
timestamp
datatype
Nice?
Vote!
1
answer
What does TIMESTAMP ON UPDATE CURRENT_TIMESTAMP data type do?
asked
1 year
ago
in
MySQL Interview Questions and Answers
by
R
(
19,530
points)
mysql
mysql-interview-question
timestamp
datatype
Nice?
Vote!
1
answer
Explain data type TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
asked
1 year
ago
in
MySQL Interview Questions and Answers
by
R
(
19,530
points)
mysql-interview-question
mysql
timestamp
Nice?
Vote!
1
answer
What if you really want to store the timestamp data, such as the publication date of the article?
asked
1 year
ago
in
MySQL Interview Questions and Answers
by
R
(
19,530
points)
mysql-interview-question
mysql
timestamp
Nice?
Vote!
1
answer
What happens if a table has one column defined as TIMESTAMP?
asked
1 year
ago
in
MySQL Interview Questions and Answers
by
R
(
19,530
points)
mysql
mysql-interview-question
timestamp
Nice?
Vote!
2
answers
If you specify the data type as DECIMAL (5,2), what’s the range of values that can go in this table?
asked
1 year
ago
in
MySQL Interview Questions and Answers
by
R
(
19,530
points)
mysql
mysql-interview-question
datatype
Nice?
Vote!
1
answer
Explain the difference between FLOAT, DOUBLE and REAL.
asked
1 year
ago
in
MySQL Interview Questions and Answers
by
R
(
19,530
points)
mysql
mysql-interview-question
datatype
Nice?
Vote!
1
answer
Explain the difference between BOOL, TINYINT and BIT.
asked
1 year
ago
in
MySQL Interview Questions and Answers
by
R
(
19,530
points)
mysql-interview-question
mysql
datatype
Nice?
Vote!
1
answer
What happens when the column is set to AUTO INCREMENT and you reach the maximum value for that table?
asked
1 year
ago
in
MySQL Interview Questions and Answers
by
R
(
19,530
points)
mysql
mysql-interview-question
increment
Nice?
Vote!
1
answer
What is SERIAL data type in MySQL?
asked
1 year
ago
in
MySQL Interview Questions and Answers
by
R
(
19,530
points)
mysql
mysql-interview-question
serial
Nice?
Vote!
1
answer
Explain federated tables.
asked
1 year
ago
in
MySQL Interview Questions and Answers
by
R
(
19,530
points)
my
mysql
mysql-interview-question
federated
Nice?
Vote!
1
answer
What are CSV tables?
asked
1 year
ago
in
MySQL Interview Questions and Answers
by
R
(
19,530
points)
mysql-interview-question
mysql
csv
Nice?
Vote!
1
answer
How do you control the max size of a HEAP table?
asked
1 year
ago
in
MySQL Interview Questions and Answers
by
R
(
19,530
points)
mysql-interview-question
mysql
heap
Nice?
Vote!
1
answer
What are HEAP tables in MySQL?
asked
1 year
ago
in
MySQL Interview Questions and Answers
by
R
(
19,530
points)
mysql
mysql-interview-question
heap
Nice?
Vote!
1
answer
Explain advantages of MyISAM over InnoDB?
asked
1 year
ago
in
MySQL Interview Questions and Answers
by
R
(
19,530
points)
mysql-interview-question
mysql
myisam
innodb
Nice?
Vote!
1
answer
Explain advantages of InnoDB over MyISAM?
asked
1 year
ago
in
MySQL Interview Questions and Answers
by
R
(
19,530
points)
mysql-interview-question
mysql
innodb
myisam
Nice?
Vote!
1
answer
What does myisamchk do?
asked
1 year
ago
in
MySQL Interview Questions and Answers
by
R
(
19,530
points)
mysql-interview-question
mysql
myisamchk
Nice?
Vote!
1
answer
Explain the difference between MyISAM Static and MyISAM Dynamic.
asked
1 year
ago
in
MySQL Interview Questions and Answers
by
R
(
19,530
points)
mysql-interview-question
mysql
Nice?
Vote!
1
answer
What are some good ideas regarding user security in MySQL?
asked
1 year
ago
in
MySQL Interview Questions and Answers
by
R
(
19,530
points)
mysql-interview-question
mysql
Page:
1
2
next »