Consider you have a composite index of three columns. Now, you have to provide the value of two columns in the where clause of a select query. Do you think index can be used for the operation?
- 0 Answers
- 665 Views
- I also Faced
- E-Mail Answers
More MySQL Interview Questions
Which datatype is used for email in mysql?
How many columns can a table have?
What is sqlyog?
How to Recover a MySQL root password. Stop the MySQL server process. Start again with no grant tables. Login to MySQL as root. Set new password. Exit MySQL and restart MySQL server.
What is field in mysql?
What are the functions in mysql?
Can we store files in mysql?
What is database url for mysql?
What is database in php mysql?
Why to use char instead of varchar in the database?
What are the drivers in MySQL?
What is cast in mysql?
Categories
-
Oracle (3258) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3328)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
