| Other MySQL Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| Give the syntax of GRANT commands? | | 1 |
| How can we change the name and data type of a column of a
table? | Google | 3 |
| Please suggest me any course and institute which provide
training on the below skills.
• Knowledge of data extraction concepts and tools
• QMF (query management facility)queries
• Experience and expertise in QMF queries
• Excellent ability to write, read, and interpret QMF
queries against the Source Data Warehouse base level (daily
and monthly) and month-end affinity comp tables
• RDBMS & ER
• Knowledge of Relational Databases (RDBMS) and
Entity Relationship (ER) Diagrams
• SOURCE Data Warehouse
• Experience and expertise in Source Data Warehouse
or data warehouses on the mainframe.
• MS SQL Server
• Experience in MS SQL Server
• Excellent skill in writing/interpreting SQL queries
and running Data Transformation Services (DTS) or open
query packages.
• Knowledge of writing/interpreting Visual Basic code.
| | 1 |
| how to repair a table in mysql? | | 1 |
| If we create a column with data type VARCHAR(3), what would
we expect to see in MySQL table? | | 1 |
| Give the syntax of Grant and Revoke commands? | | 1 |
| A company wants to store their invoices in a database. They
already have their customers and articles in that database.
Both customer and article are each identified by an unique
integer value. Please create the SQL statements for
creating the necessary table(s) for storing the invoices in
a MySQL database. An invoice should hold information like
invoice number, customer, date, article(s) and quantity
etc. | | 1 |
| Explain MySQL locks? | | 1 |
| suppose server is running Suddenly down . what can you do?
but i want do not down the server? | | 3 |
| How to see the database architecture in MySQL?? | | 2 |
| If you specify the data type as DECIMAL (5,2), what?s the
range of values that can go in this table? | | 2 |
| Use mysqldump to create a copy of the database? | | 1 |
| Explain advantages of MyISAM over InnoDB? | | 1 |
| What does myisamchk do? | | 1 |
| Explain the difference between BOOL, TINYINT and BIT? | | 1 |
| how many ways we can get the current date in mysql? | | 1 |
| I have two sql database at different PC.how can link b/w
database and database tables. | | 1 |
| Explain Normalization concept? | Inuva | 1 |
| How can we store binary data in mysql? | HP | 2 |
| about foregine | | 2 |
| |
| For more MySQL Interview Questions Click Here |
Did you received any Funny E-Mails from your Friends and like to share with rest of our friends? Yeah!! you can post that stuff 
Site Map
