What is the purpose of creating an edit form in a CRUD application?

To update existing data in the database

What is the purpose of joins in a database?

To combine data from more tables based on a related column between them

How do you display fetched data from a database in a table using HTML and PHP?

Using PHP to generate HTML table tags and insertin fetched data within them

What is a Primary Key in a database table?

A unique identifier for each row in the table

What is a Foreign Key in a database table?

A key that references the primary key in another table

How do you add data into a database using HTML forms and PDO in PHP?

By sending form data to a PHP script that uses PDO to insert it into the DB

What is typically included in an edit form in a CRUD application?

All data fields related to the record being edited along with submit button

What are sessions used for in web development?

To temporarily store user data across multiple pages

What does the include_once() function do in PHP?

It includes and evaluates the specified file during the execution

What is the primary purpose of a GET request in HTTP?

To retrieve data from the server

What is the syntax for a for loop in PHP?

for (initialization; condition; increment) { // code }

studbud

Duplicate of Php

27 termsStudBud Administration

Imported from external platform

Flashcards27 cardsFPractice quizPHost liveL

Questions 27

Answers

1
Which SQL statement is used to delete a table from a MySQL database using PDO?
REMOVE TABLE
DROP TABLE
DELETE TABLE
ERASE TABLE
2
Which SQL statement is used to insert new data into a table?
ADD DATA
CREATE DATA
INSERT INTO
NEW DATA
3
What is the purpose of creating an edit form in a CRUD application?
To delete data from the database
To display data in a readable format
To insert new data into the database
To update existing data in the database
4
Which PHP function is used to concatenate two strings?
join()
concat()
merge()
. (dot operator)
5
What does PHP stand for?
PHP: Hypertext Preprocessor
Pretext Hypertext Processor
None of the above
Hypertext Preprocessor
6
What is the purpose of joins in a database?
To rearrange the data in a table
To split a table into multiple smaller tables
To encrypt data in the database
To combine data from more tables based on a related column between them
7
How do you display fetched data from a database in a table using HTML and PHP?
Using PHP to generate HTML table tags and insertin fetched data within them
By using JS to dynamically create a table and populate it with fetched data
By embedding SQL queries within HTML <table> tags
By directly echoing the fetched data within <table> tags
8
What is a Primary Key in a database table?
A unique identifier for each row in the table
A key that points to another table
A key used for accessing the database
A key used for encryption
9
Which HTTP method is typically used to submit form data securely?
POST
DELETE
GET
PUT
10
What is the correct way to declare a variable in PHP?
variable = 10;
$variable = 10;
$10 = variable;
var variable = 10;
11
How do you delete a column from a table in a MySQL database using PDO?
REMOVE COLUMN
DROP COLUMN
DELETE TABLE COLUMN
DELETE COLUMN
12
What is the backend?
The design and styling elements of a website or application.
The user interface of a website or application.
None of the above.
13
Which of the following is a reason why we should learn PHP?
It's open-source and free to use.
It's a server-side scripting language used for web development.
All of the above.
14
What is a Foreign Key in a database table?
A key that is generated automatically by the database
A key that references the primary key in another table
A key that encrypts data in the table
A key that is used for accessing the database remotely
15
How do you add data into a database using HTML forms and PDO in PHP?
By embedding SQL queries directly into the HTML form
By sending form data to a PHP script that uses PDO to insert it into the DB
By using JavaScript to directly manipulate the database
16
What is typically included in an edit form in a CRUD application?
A delete button to remove the data
Only the data to be edited
All data fields related to the record being edited along with submit button
A submit button to update the data
17
What are sessions used for in web development?
To store data permanently in the database
To track user activity during a browsing session
To temporarily store user data across multiple pages
To display advertisements on a webpage
18
What is the data type of the variable $num = 5.5 in PHP?
integer
boolean
string
float
19
Which SQL statement is used to fetch data from a MySQL database?
SELECT
FETCHALL
GET
FETCH
20
What does the include_once() function do in PHP?
It includes and evaluates the specified file during the execution
It includes a file multiple times in the script
It executes a function only once in the script
It includes a file and suppresses errors if the file is not found
21
Which HTTP method does not display form data in the URL?
PUT
POST
GET
DELETE
22
Which PHP function is used to convert a string to uppercase?
upper_case()
str_upper()
to_uppercase()
strtoupper()
23
What is the primary purpose of a GET request in HTTP?
To retrieve data from the server
To delete data from the server
To update data on the server
To submit form data securely
24
Which of the following is a popular PHP framework?
All of the above
CodeIgniter
Symfony
Laravel
25
Which of the following is not a valid way to access elements of an array in PHP?
$array->index
$array['index']
$array[index]
$array{index}
26
What is the syntax for a for loop in PHP?
for [initialization; condition; increment] // code
for {initialization; condition; increment} // code
for (initialization; condition; increment) { // code }
for (condition; increment; initialization) { // code }
27
What SQL statement is used to create a table in a MySQL database?
MAKE TABLE
DEFINE TABLE
CREATE TABLE
NEW TABLE

Duplicate of Php Flashcards | StudBud