Quizzes – EduHub

Question 1

Which jQuery method is used to select elements with a specific class name?

$("[attribute=value]") $("tagName") $(".className") $("#idName")

Question 2

In MySQL, what is the primary purpose of the `PRIMARY KEY` constraint?

To ensure unique values in a column and to identify each row uniquely. To define a default value for a column. To enforce a uniqueness constraint on a column, but not for row identification. To create a relationship between two tables.

Question 3

Which jQuery event handler is triggered when an input element's value changes and the element loses focus?

.blur() .click() .change() .submit()

Question 4

What is the SQL statement used to retrieve data from a database table?

UPDATE DELETE INSERT SELECT

Question 5

Which jQuery method is used to insert content at the end of selected elements?

.prepend() .before() .after() .append()

Question 6

In MySQL, which data type is most suitable for storing variable-length strings?

VARCHAR INT CHAR TEXT

Question 7

What does the `$(document).ready()` function in jQuery do?

It waits for a specific element to be ready before executing code. It executes code when the page is fully loaded, including images and other assets. It is used to handle form submissions. It executes code as soon as the DOM is ready, before external resources like images are loaded.

Question 8

Which MySQL clause is used to sort the result set of a query in ascending or descending order?

ORDER BY GROUP BY HAVING WHERE

Question 9

Which jQuery method is used to hide an element?

.fadeIn() .hide() .toggle() .show()

Question 10

What does the `JOIN` clause in SQL do?

It removes duplicate rows from a result set. It combines rows from two or more tables based on a related column. It filters the results based on a condition. It aggregates data from multiple rows.

Question 11

Which jQuery method is used to add a new class to an element?

.addClass() .removeClass() .toggleClass() .attr()

Question 12

In MySQL, what is the purpose of the `FOREIGN KEY` constraint?

To ensure unique values in a column. To set a default value for a column. To restrict values in a column to a specific set of options. To define a relationship between two tables, referencing the `PRIMARY KEY` of another table.

Question 13

What is the jQuery method for sending an asynchronous HTTP request?

.ajax() All of the above .post() .get()

Question 14

Which SQL statement is used to insert new records into a table?

DELETE FROM UPDATE INSERT INTO SELECT

Question 15

Which jQuery method is used to remove an element and its children?

.detach() .hide() .remove() .empty()

Question 16

In MySQL, what does the `DISTINCT` keyword do?

It counts the number of rows. It limits the number of returned rows. It sorts the results in descending order. It returns only unique values for a specified column.

Question 17

Which jQuery method is used to find the parent of a selected element?

.siblings() .children() .closest() .parent()

Question 18

Which SQL clause is used to filter rows based on aggregate function results?

ORDER BY WHERE HAVING GROUP BY

Question 19

Which jQuery method is used to get the content of an element?

.val() .attr() .html() .text()

Question 20

In MySQL, what is the purpose of the `AUTO_INCREMENT` property?

To automatically set the current date and time. To automatically generate a unique sequential number for a column when a new row is inserted. To ensure a column value is never null. To automatically update a column when it is changed.

Question 21

Which jQuery method is used to set or get the HTML content of an element?

.html() .text() .val() .attr()

Question 22

What is an `INNER JOIN` in SQL?

Returns rows that do not have a match in the other table. Returns all rows from the left table and matching rows from the right table. Returns all rows from both tables, with NULL values where there is no match. Returns only the rows where there is a match in both tables.

Question 23

Which jQuery selector is used to select elements based on their attribute?

$("[attributeName]") $("#idName") $(".className") $("tagName")

Question 24

In MySQL, which command is used to create a new database?

CREATE DATABASE USE DATABASE CREATE TABLE ALTER DATABASE

Question 25

Which jQuery method is used to add content to the end of each element in the set of matched elements?

.prepend() .append() .before() .after()

Question 26

What is the SQL statement used to modify existing records in a table?

UPDATE SELECT DELETE FROM INSERT INTO

Question 27

Which jQuery method is used to get the value of the first matched element?

.attr('value') .html() .text() .val()

Question 28

In MySQL, what is the purpose of the `INDEX` keyword?

To define relationships between tables. To automatically generate sequential IDs. To enforce uniqueness on a column. To improve the performance of data retrieval operations.

Question 29

Which jQuery method is used to iterate over a set of matched elements?

.each() .map() .for() .while()

Question 30

Which SQL statement is used to delete records from a table?

SELECT INSERT INTO UPDATE DELETE FROM

Question 31

Which jQuery method is used to filter elements based on a selector or function?

.children() .parent() .find() .filter()

Question 32

In MySQL, what does `TRUNCATE TABLE` do?

Removes duplicate rows from a table. Deletes only specific rows based on a condition. Deletes all rows from a table, including the table structure. Deletes all rows from a table, but keeps the table structure intact, and resets AUTO_INCREMENT values.

Question 33

Which jQuery method is used to add content to the beginning of each element in the set of matched elements?

.prepend() .after() .append() .before()

Question 34

What is a `LEFT JOIN` in SQL?

Returns rows that do not have a match in the other table. Returns all rows from the left table, and the matched rows from the right table. If there is no match, the result is NULL. Returns only rows where there is a match in both tables. Returns all rows from the right table, and the matched rows from the left table. If there is no match, the result is NULL.

Question 35

Which jQuery method is used to animate the opacity of an element?

.slideDown() .hide() .fadeIn() .animate()

Question 36

In MySQL, which clause is used with aggregate functions to group rows that have the same values in specified columns?

WHERE ORDER BY HAVING GROUP BY

Question 37

Which jQuery method is used to create new DOM elements?

$().append() $().prepend() $('<element>') $('selector')

Question 38

What is a `UNION` operator in SQL?

Combines rows from two or more SELECT statements, including duplicates. Merges columns from two tables. Filters rows based on a condition. Combines rows from two or more SELECT statements, removing duplicates.

Question 39

Which jQuery method is used to remove all child elements of the selected element?

.hide() .empty() .detach() .remove()

Question 40

In MySQL, what does the `ALTER TABLE` statement do?

Creates a new table. Inserts data into a table. Modifies the structure of an existing table (e.g., adding, deleting, or modifying columns). Deletes an existing table.

Question 41

Which jQuery method is used to attach an event handler to an element for the 'click' event?

All of the above can be used in different contexts or older jQuery versions .bind('click', handler) .on('click', handler) .click(handler)

Question 42

What is a `CASE` statement in SQL used for?

To define a new function within the database. To handle errors during query execution. To create a temporary table. To perform conditional logic within a SQL statement, returning different values based on conditions.

Question 43

Which jQuery method is used to find descendant elements of the selected element?

.find() .parent() .children() .siblings()

Question 44

In MySQL, what is the purpose of a `VIEW`?

To automatically generate reports. To define a saved query that can be treated like a virtual table, simplifying data access. To enforce data integrity constraints. To physically store data in a separate table.

Question 45

Which jQuery method is used to set or get attributes of elements?

.attr() .html() .css() .text()

Question 46

What is the SQL statement used to create a new table?

INSERT INTO DROP TABLE CREATE TABLE ALTER TABLE

Question 47

Which jQuery method is used to toggle the visibility of an element with a sliding effect?

.fadeToggle() .slideToggle() .toggle() .animate()

Question 48

In MySQL, what is a `JOIN` without a `WHERE` clause typically used for?

To calculate aggregate values. To filter out duplicate rows. To retrieve all possible combinations of rows from the joined tables (a cross join). To sort the entire dataset.

Question 49

Which jQuery method is used to trigger the 'click' event on selected elements?

.bind('click') .on('click') .trigger('click') .click(function(){})

Question 50

What is the SQL statement used to remove a table from the database?

CREATE TABLE DROP TABLE ALTER TABLE DELETE FROM