Quiz 4 - ITEDEV - Final

What function is used to get the current date in PHP?

• now()
• date()
• time()
• getDate()

Answer explanation

The date() function formats and returns the current date.

Which format displays the date as '2025-05-17'?

• d/m/Y
• Y.m.d
• Y-m-d
• m/d/Y

Answer explanation

Y-m-d is the ISO format for dates.

What does the 'L' format character in date() represent?

• Leap year
• Language
• Location
• Length of month

Answer explanation

L returns 1 if it's a leap year, 0 otherwise.

What PHP function returns the current time in seconds?

• now()
• timestamp()
• microtime()
• time()

Answer explanation

time() returns Unix timestamp (seconds since 1970).

Which SQL command imports CSV data efficiently?

• INSERT BULK
• LOAD DATA INFILE
• IMPORT CSV
• READ FILE

Answer explanation

LOAD DATA INFILE is used to quickly import large datasets.

What clause defines the file path in LOAD DATA INFILE?

• FROM FILE
• FILEPATH
• INFILE
• SOURCE

Answer explanation

INFILE specifies the CSV file path.

Which HTML input type supports multiple file uploads?

• file
• multiple
• checkbox
• submit

Answer explanation

<input type='file' multiple> allows selecting many files.

What function encrypts text in PHP?

• md5()
• password_hash()
• openssl_encrypt()
• crypt()

Answer explanation

openssl_encrypt() is used for encryption with a method and key.

What is the corresponding decryption function for openssl_encrypt()?

• decrypt()
• openssl_decrypt()
• base64_decode()
• reverse_encrypt()

Answer explanation

openssl_decrypt() reverses the encryption using the same key and method.

What does pagination improve in web applications?

• Security
• Speed
• User experience with large data
• Image rendering

Answer explanation

Pagination divides large datasets for easier navigation.