Question:- Is MySQL Query Case Sensitive?
Answer:- No, its not. • SELECT VERSION(), CURRENT_DATE; • seleCt vErsion(), current_DATE; • SeLect version(), current_date; All these examples are the same. It is not case sensitive.
Question:- What Is The Difference Between The LIKE And REGEXP Operators?
Answer:- LIKE and REGEXP operators are used to express ^ and %. • SELECT * FROM employee WHERE emp_name REGEXP “^b”; • SELECT * FROM employee WHERE emp_name LIKE “%b”.
Question:- What Is The Difference Between Mysql_fetch_array And Mysql_fetch_object?
Answer:- Following are the differences between mysql_fetch_array and mysql_fetch_object: • mysql_fetc_array() – Returns a result row as an associated array or a regular array from the database. • Mysql_fetch_object – Returns as a result row as object from database.
Question:- How Can We Run Batch Mode In MySQL?
Answer:- Following commands are used to run in batch mode: Mysql; Mysql mysql.out
Question:- Where Will MyISAM Tables Be Stored And Also Give Their Formats Of Storage?
Answer:- Each MyISAM table is stored on disk in three formats: • The .frm file stores the table definition • The data file has a .MYD (MYData) extension • The index file has a .MYI (MYIndex) extension
Question:- What Is ISAM?
Answer:- ISAM is abbreviated as Indexed Sequential Access Method. It was developed by IBM to store and retrieve data on secondary storage systems like tapes.
Question:- What Is InnoDB?
Answer:- InnoDB is a transaction-safe storage engine developed by innobase, which is an Oracle Corporation now.
Question:- How MySQL Optimizes DISTINCT?
Answer:- DISTINCT is converted to a GROUP BY on all columns and it will be combined with the ORDER BY clause. SELECT DISTINCT t1.a FROM t1,t2 where t1.a=t2.a;
Question:- How To Enter Characters As HEX Numbers?
Answer:- If you want to enter characters as HEX numbers, you can enter HEX numbers with single quotes and a prefix of (X), or just prefix HEX numbers with (OX). A HEX number string will be automatically converted into a character string if the expression context is a string.
Question:- Define JQuery?
Answer:- JQuery is the JavaScript library that is designed to simplify HTML DOM tree manipulation and traversal, as well as event handling, Ajax, and CSS animation.
Question:- List Some Of The Advantages Of JQuery?
Answer:- 1. Ease of use: It is easier to use when compared to the standard javascript and other libraries. 2. It has the ability to keep the code clear, simple, readable, and reusable. 3. Large library: It has a lot of functions when compared to javascript. 4. Great documentation and tutorials: the jQuery website has a lot of tutorials that are required for beginners. 5. It has JavaScript enhancement without the overhead of learning new syntaxes. 6. Ajax support: It lets us develop the templates easily.
Question:- Define JQuery Selectors?
Answer:- jQuery selectors will allow us to select and manipulate HTML elements. We use the jQuery selectors to find or select the HTML elements that are based on the id, name, types, classes, attributes, values of attributes, and many more. It is usually based on the existing CSS Selectors, and it has some custom selectors also.
Question:- Is JQuery A Programming Language?
Answer:- jQuery is not a programming language; instead, we can say it is a cross-platform JavaScript library. There are many JavaScript libraries available such as MooTools, Knockout, or Angular, and jQuery is one of the most popular among them.
Question:- Is JQuery A JavaScript Or A JSON Library File?
Answer:- We can say that jQuery is a library of JavaScript files, and it contains DOM event effects and Ajax functions.