| Other MySQL Interview Questions |
|| Asked @
|What is Inner Joints and Outer Joints ?
What is right outer joints,left outer joints,right inner
joints , left inner joints ,
|What does TIMESTAMP ON UPDATE CURRENT_TIMESTAMP data type
|I have two sql database at different PC.how can link b/w
database and database tables.
|Explain TIMESTAMP DEFAULT ?2006:09:02 17:38:44′ ON UPDATE
|what is the querry for all managers salary?
|how many table created when we create a table in mysql?
|What are some good ideas regarding user security in MySQL?
|For the database from the previous question, please give an
SQL query which returns the invoice number of all invoices
which contain the article with the number ?1234?. The query
should be able to run under a MySQL 4.0 database.
|What is maximum size of a database in MySQL?
|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
• Knowledge of writing/interpreting Visual Basic code.
|What is the difference between mysql_connect() and
|how to display only 4 records from a table based on a
i have a table called products
in that nid,prodname are fields
i want to display only any 4 records of perticular product
plz tell me
|For more MySQL Interview Questions Click Here |