Quizzes – EduHub

Question 1

Which SQL statement is used to update data in a database?

SAVE UPDATE MODIFY SAVE AS

Question 2

Which jQuery method is used to hide selected elements?

hidden() hide() display(none) visible(false)

Question 3

Which of the following statement would be used if you want to show the structure of the Product table in your inventory?

DISTINCT Product STRUCTURE Product DESCRIBE Product None of the above

Question 4

Which of the following method can be used to get the current offset of the first matched element?

offset() position() offsetParent() outerHeight([margin])

Question 5

Which SQL clause is used to restrict the rows returned by a query?

AND WHERE FROM HAVING

Question 6

Which of the following selector selects all checked boxes in a form?

$(':checked') $('input[checked]') $('checked') $('input[checked=checked]')

Question 7

Which of the following method retrieves the total number of rows affected by an INSERT, UPDATE, or DELETE operation?

affected_rows() num_rows() Both a & b None of the above

Question 8

Which of the following method can be used to apply multiple CSS properties using a single jQuery method?

css() jQuery() style() map()

Question 9

Which SQL statement is used to extract data from a database?

EXTRACT OPEN SELECT GET

Question 10

Which of the following method can be used to locate all the descendant elements of a particular type?

find(selector) filter(selector) children(selector) next(selector)

Question 11

How do you view all tables in MySQL?

VIEW TABLES SHOW TABLES SELECT TABLES ALTER TABLES

Question 12

Which event type occurs when an element loses focus?

Blur Load Focus Change

Question 13

What does the SQL GROUP BY clause do?

Sorts rows in ascending order Filters rows based on a condition Groups rows that have the same values in specified columns Joins two or more tables

Question 14

Which of the following method gets the HTML contents (innerHTML) of the first matched element in jQuery?

replaceWith(content) jQuery() text(val) html()

Question 15

Which command deletes both the table data and the table structure?

DROP DELETE TRUNCATE REMOVE

Question 16

Which jQuery function is used to prevent code from running before the document is fully loaded?

$(document).load() $(window).load() $(body).onload() $(document).ready()

Question 17

Which SQL statement is used to retrieve unique values from a column?

SELECT DISTINCT column_name FROM table_name; SELECT UNIQUE column_name FROM table_name; SELECT DIFFERENT column_name FROM table_name; SELECT SINGLE column_name FROM table_name;

Question 18

Which of the following method can be used to either fetch or set the value of an attribute from the first element?

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

Question 19

What is jQuery?

JavaScript Language JavaScript Library JavaScript Method PHP Method

Question 20

Which constraint ensures that a column cannot have NULL values?

PRIMARY KEY NOT NULL CHECK UNIQUE

Question 21

Which of the following method can be used to filter out elements from the set of matched elements?

filter_out() add() filter(selector) select()

Question 22

What is the purpose of using the .bind() method in jQuery?

To apply CSS properties using jQuery To filter out all elements from the matched set To attach standard JavaScript events to elements To reduce the matched set to a single element

Question 23

How do you convert ISAM tables to MyISAM tables?

CHANGE TABLE table_name TYPE=MYISAM; ALTER TABLE table_name TYPE=MYISAM; MODIFY TABLE table_name TYPE=MYISAM; ADD TABLE table_name TYPE=MYISAM;

Question 24

Which of the following selector is used to select only form elements?

$('input') $('form') $(':input') $('input[type=*]')

Question 25

Which method removes all matched elements from the DOM?

remove(expr) removeAll(selector) empty() remove()

Question 26

Which command is used to remove an existing table or database?

DELETE DROP TABLE Either DROP TABLE or DELETE None of the above

Question 27

Which jQuery utility function parses the returned JSON string?

getJSON() parseJSON() getScript() get()

Question 28

Which utilities are used to export data from a MySQL server?

mysqlhotcopy mysqlshow mysqldump A & C

Question 29

Which jQuery function is used to set the plain text contents of all matched elements?

$(selector).add(val) $(selector).wrap(val) $(selector).text(val) $(selector).html(val)

Question 30

Which of the following method can be used to replace an element?

replace() replaceAll() replaceWith(content) change()

Question 31

How can we get a set of elements containing the unique next siblings?

find(selector) next([selector]) children([selector]) nextAll(selector)

Question 32

What do you mean by sanitizing input?

How to interact with data files None of the above Preventing users from passing harmful data How to perform file system operations

Question 33

Which file is responsible for configuring MySQL on the Windows platform?

my.cnf my.ini mysql.ini php.ini

Question 34

Which of the following method can be used to remove event handlers?

delete() empty() remove() die()

Question 35

Which SQL statement is used to process the rows in a cursor?

None of the above READ GET FETCH

Question 36

Which of the following method can be used to wrap the inner child contents of each matched DOM element?

wrap(html) wrapInner(elem) wrapInner(html) wrapAll(html)

Question 37

Which command should be used to connect as the anonymous user of a MySQL server running on localhost?

mysql -u anon mysql -u mysql -u anonymous mysql

Question 38

Which symbol always starts a jQuery statement?

Equal sign = Parentheses () Plus sign + Dollar sign and parentheses $()

Question 39

How can we bind multiple events in jQuery?

getbind() bindparam() bind() param()

Question 40

With SQL, how do you select all the columns from a table named "Persons"?

SELECT [all] FROM Persons SELECT * FROM Persons SELECT *. Persons SELECT Persons