Once a constant is defined in PHP, can its value be changed later in the script?
- Yes
- No
- Only within functions
- Only within classes
In PHP, once a constant is defined, its value cannot be changed later in the script. Constants are intended to hold values that do not change during the script's execution.
Imagine you are creating a login system for a web application. To ensure the security of user credentials, which of the following methods would be the best practice?
- Use HTTPS with Secure Cookies
- Store Passwords in Plain Text Files
- Apply Weak Encryption
- Implementing User-Friendly Passwords
Using HTTPS with secure cookies ensures data transmission security, protecting user credentials. Storing passwords in plain text files is highly insecure. Weak encryption is also insufficient. User-friendly passwords, while a good practice, do not directly ensure security; the infrastructure does.
If a transaction encounters an issue and needs to be terminated without saving the changes, it should be ________.
- Rolled Back
- Committed
- Saved
- Isolated
To terminate a transaction without saving any changes, you should use the 'Rollback' operation. This undoes all changes made within the transaction, ensuring data consistency and integrity. 'Committed' is the opposite, indicating that the changes should be saved.
When uploading a file in PHP, which array key of the $_FILES superglobal gives the temporary location of the uploaded file?
- tmp_name
- name
- temp_location
- uploaded_file
The 'tmp_name' key in the $_FILES superglobal array contains the temporary location of the uploaded file on the server. This is important for processing and moving the file.
In the context of password hashing in PHP, what does "salting" mean?
- Adding salt to food
- Increasing the password length
- Mixing a unique value with the password
- Encrypting the password using SHA-256
"Salting" in password hashing involves mixing a unique value with the user's password before hashing to enhance security and prevent rainbow table attacks.
In the context of form validation, what does the term "sanitization" refer to?
- Removing malicious code
- Validating user credentials
- Cleaning and formatting data
- Authenticating the user
Sanitization in form validation involves cleaning and formatting user input data to remove harmful or unwanted characters, ensuring it's safe for processing.
Consider a scenario where you're building a CMS and you want to log errors to a specific file. Which PHP functions would be most suitable to open and write to this file?
- fopen() and fwrite()
- readfile() and copy()
- file_get_contents() and file_put_contents()
- file() and fwrite()
To open and write to a specific file in PHP, you should use fopen() to open the file and fwrite() to write to it. These functions offer fine-grained control over file handling, crucial for logging errors.
Which type of JOIN returns only the rows where there is a match in both tables?
- INNER JOIN
- LEFT JOIN
- RIGHT JOIN
- FULL OUTER JOIN
An INNER JOIN returns only the rows where there is a match in both tables. It combines records from two tables based on a common column and includes only the rows with matching values in both tables. Rows with no matching values are excluded from the result set.
PHP provides a function named ________ to get the current date and time.
- current_datetime()
- time_now()
- date_time_now()
- date()
PHP's date() function is used to get the current date and time. It allows you to format the date and time in various ways as per your requirements.
Why is it recommended to avoid using the @ error suppression operator in PHP?
- It enhances code readability
- It prevents the error from occurring
- It improves error handling
- It makes code execute faster
The '@' operator suppresses error messages, making it hard to diagnose issues. It's best to handle errors explicitly for better debugging and code quality.