CS521 Quiz 4 by Shahid and Ziddi

Q1. In SQL if we want to fetch data from multiple tables in a database we use the concept of

1. Aggregation
2. Join
3. Collection
4. Arrays

Correct answer: Join

Q2. Which visibility keyword is used when a property should only be accessible within its own class?

1. Protected
2. Static
3. Private
4. Public

Correct answer: Private

Q3. Which PHP function is used to validate an email address using a filter?

1. filter_var()
2. validate_email()
3. filter_input()
4. sanitize_email()

Correct answer: filter_var()

Q4. What are regular expressions in PHP?

1. Patterns used to search, match, and manipulate strings
2. Built-in PHP functions used for database operations
3. Special characters used to concatenate strings
4. Predefined functions used to handle errors in PHP

Correct answer: Patterns used to search, match, and manipulate strings

Q5. Following is the name of a PHP MySQL API

1. phpMyAdmin
2. phpExtend
3. JavaScript
4. mysqli

Correct answer: mysqli

Q6. Which keyword is used to define a class in PHP?

1. define
2. class
3. new
4. object

Correct answer: class

Q7. We want to execute a group of statements such that if one statement fails then other statements should also not execute. Which databases feature is suitable for this scenario?

1. Normalization
2. Join
3. Backup
4. Transactions

Correct answer: Transactions

Q8. When performing a database update, which SQL statement is commonly used?

1. UPDATE
2. INSERT
3. SELECT
4. DELETE

Correct answer: UPDATE

Q9. How can you access a static property of a class in PHP?

1. By using the static keyword
2. By using the parent keyword
3. By using the self-keyword
4. By using the object of the class

Correct answer: By using the self-keyword

Q10. Following is the SQL keyword for adding a new record in a table.

1. Add
2. Insert
3. Update
4. Select

Correct answer: Insert