COMPUTER 9

Which HTML element is used to create a text input field in a form?

• a)

• b)

• c)

• d)

What does the type="password" attribute do in an HTML form?

• Encrypts the input

• Displays characters normally

• Masks the characters for security

• Converts input to uppercase

What is the function of the tag in HTML?

• Defines a section title

• Provides a user-readable description for form elements

• Creates a text input field

• Links an input field to a database

The for attribute in a tag is used to:

• Specify the input field it is associated with

• Define a loop in JavaScript

• Style the label

• Add a tooltip to the label

Which SQL keyword is used to combine rows from multiple tables?

• COMBINE

• JOIN

• LINK

• UNION

What type of SQL join returns only matching rows from both tables?

• LEFT JOIN

• RIGHT JOIN

• INNER JOIN

• CROSS JOIN

A FULL OUTER JOIN in SQL returns:

• Only matching rows

• All rows from both tables, filling missing values with NULL

• Only unique rows

• Rows with at least one NULL value

In SQL, which clause is used to filter query results based on conditions?

• SELECT

• ORDER BY

• WHERE

• GROUP BY

What does SELECT DISTINCT * FROM table_name; do?

• Retrieves all records

• Filters out duplicate records

• Deletes duplicate records

• Sorts records in ascending order

What does the SQL statement SELECT * FROM employees WHERE salary != 50000; return?

• Employees earning 50,000

• Employees earning less than 50,000

• Employees earning more than 50,000

• Employees with a salary not equal to 50,000