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.
Question:- Whether JQuery HTML Work For HTML And XML Documents?
Answer:- No, the jQuery HTML works only for HTML documents, and not for XML Documents.
Question:- Differentiate Between JavaScript And JQuery?
Answer:- JavaScript: • JavaScript is a language for programming. • Here, we have to write an extra code or move around to have cross-browser compatibility. • It is verbose as one has to write own scripting code, which is often time-consuming. jQuery: • It is a JavaScript library, a framework that will help us to use JavaScript to simplify common web tasks. • It has an inbuilt feature of cross-browser compatibility. • It is concise, and there is no need to write much code as scripting already exists.
Question:- Can We Say That JQuery Is A Replacement For JavaScript?
Answer:- Since jQuery is only a library of JavaScript, it cannot replace JavaScript. All the jQuery code is JavaScript, but jQuery does not include all the JavaScript code. jQuery is only optimized to do common scripting functions with lesser lines of code.
Question:- Can You Differentiate Between .Empty(), .Remove() And, .Detach() In JQuery?
Answer:- • empty(): It removes all the content and the child elements from the selected element. This method will not remove the selected elements. • detach(): It removes all child elements with the selected elements. However, it keeps all the data and the event handlers of the removed elements. This method is only preferred when we want to remove elements but to keep a copy of the removed elements, which can be reused later. • remove(): It removes all child elements with the selected element. In this method, one can restore all the data but not the event handlers of the removed elements from DOM. All data and events related to elements will be removed.
