Font size
Worksheets314 REVIEW EXAM
Total questions: 40
Worksheet time: 38mins
A command that is used to modify the existing records in a table.
(a)
A student with ID = 2 transferred schools. You need to remove only that record from the STUDENT table. Which SQL statement is correct?
DELETE FROM STUDENT WHERE ID = 2;
DROP FROM STUDENT WHERE ID = 2;
DELETE STUDENT WHERE ID = 2;
DELETE FROM STUDENT ID = 2;
It is used to specify a condition while fetching the data from a single table or by joining multiple tables.
(a)
A significant feature of CRUD operations is that they enable application scalability and allow developers to efficiently handle large volumes of data.
(a)
The (a) command is used to completely delete a database and all of its objects, such as tables, indexes, views and other dependent objects.
It is a set of SQL commands to manage database security and control user access to database objects.
(a)
It refers to the set of SQL commands that can create and manipulate the structures of a database.
(a)
To simplify complex queries involving joins, you can break the query into manageable pieces by using (a) or temporary tables.
A command that is used to remove the existing records from a table.
(a)
It has a set of commands that is used to perform queries on the data and find information.
(a)
A command that is used to add new data rows to a database table.
(a)
It provides a timeout before closing the connection.
(a)
It is a family of computer languages, including commands permitting users to manipulate data in a database.
(a)
It uniquely identifies a row/record in any other database table.
(a)
The (a) command is used to invalidate privileges from a user for a database object.
All the string values should not be enclosed in single quotes
TRUE
FALSE
To control a JOIN operation precisely, the (a) statement specifies the condition for how tables connect.
It ensures that all values in a column satisfy certain conditions.
(a)
A significant feature of CRUD operations allows developers to create, read, update, and delete data in the database, enabling them to manage the data effectively.
(a)
What is the syntax for connecting to MYSQL using PHP Script?
mysql_connection (server, user, password, new_link, client_flag);
connect_mysql (server, user, password, new_link, client_flag);
mysql_connect (server, user, password);
connection mysql_connect (server, user, password, new_link, client_flag);
All numeric values should be supplied directly without enclosing them in single or double quotes.
TRUE
FALSE
A command that can be used to prevent unauthorized access to sensitive data or to restrict access to certain users or groups.
(a)
It uniquely identifies each row/record in a database table.
(a)
The (a) parameters specify the names of the columns of the table.
CODE ANALYSIS: Analyze the given code and supply what is missing.
(a) "db_connection.php";
It defines the nature of the data that can be stored in a particular table column.
(a)
It ensures the accuracy and reliability of the data in the database.
(a)
You need to add a new student but only know their ID, LASTNAME, and FIRSTNAME. The table has NOT NULL constraints on ADDRESS and ALLOWANCE -- what happens if you run: INSERT INTO STUDENT (ID, LASTNAME, FIRSTNAME) VALUES (6, 'Dela Rosa', 'Eve');
The row is inserted; ADDRESS and ALLOWANCE default to NULL
The row fails insertion due to NOT NULL constraint violation.
The missing columns AUTO-GENERATE default values.
The row is inserted but AGE defaults to zero and others is NULL.
What word is missing from the following SQL statement? SELECT * table_name
(a)
CODE ANALYSIS: Analyze the given code and supply what is missing.
if ($result -> num_rows > 0) { while ($row = $result -> (a) ) {
A function that disconnects you from the MySQL database server using PHP.
(a)
It ensures that all the values in a column are different
(a)
It is used to specify a condition while fetching the data from a single table or by joining multiple tables.
(a)
This operation refers to the retrieval of records from the database.
(a)
An SQL command adds a new column to an existing table.
(a)
In a LEFT JOIN, if there is no matching row in the right table, the (a) value will appear in the result for that row's columns from the right table.
It is a command that is used to delete complete data from an existing table.
(a)
It is used to give users or groups access to specific database objects such as tables, views, or stored procedures.
(a)
It is a computer language for storing, manipulating, and retrieving data in a relational database.
(a)
CODE ANALYSIS: Analyze the given code and supply what is missing.
if (isset($_GET['id'])) {
$stu_id = (a) ['id'];
