Font size
WorksheetsQUIZ SA 314
Total questions: 40
Worksheet time: 40mins
It is used in application development language to enable a programmer to work with the data.
(a)
A function that needs five parameters and returns the MySQL link identifier when the connection becomes successful.
(a)
A parameter that provides space after function names.
(a)
How many parameters are needed in the MYSQL_Connect function?
(a)
It handles all the non-SQL queries, but a SQL query engine won't handle logical files.
(a)
A computer science facility that allows the user to connect with the database server software.
(a)
This function returns true when the connection is closed successfully.
(a)
It uniquely identifies a row/record in any other database table.
(a)
It ensures that all values in a column satisfy certain conditions.
(a)
It uniquely identifies each row/record in a database table.
(a)
It ensures that all the values in a column are different
(a)
It is a set of SQL commands used to create, modify, and delete database structures but not data.
(a)
An SQL command that adds, deletes, or modifies columns in an existing table
(a)
It is an SQL command that removes a table definition and all the data, constraints, and permission specifications for that table.
(a)
It is an SQL command that is used to delete complete data from an existing table.
(a)
It ensures the accuracy and reliability of the data in the database.
(a)
It defines the nature of the data that can be stored in a particular table column.
(a)
The (a) command removes one or more records from the database.
It consists of SQL commands that deal with the manipulation of data present in the database.
(a)
The (a) command adds a new row of records in the table.
The (a) command modifies the existing record from the table.
It extracts data from a database table and returns it as a result set.
(a)
It is used to extract data from a database table and return it as a result set.
(a)
CMS is stands for (a)
It involves changing the data that is already stored in the database.
(a)
To connect to a MySQL database in PHP, you can use the (a) function.
The (a) function in PHP is used to display error messages returned by MySQL.
(a) are used to control access and permissions in a database management system.
The (a) command is used to allow privileges to a user for a database object.
The (a) command is used to lift privileges from a user for a database object.
The (a) command explicitly refuses access to a database object, even if the user has been granted permission by other means.
It is the level of access being denied,
(a)
It is the name of the database object being accessed.
(a)
It is the name of the user or group being granted access.
(a)
CRUD operations are essential for maintaining (a) .
It refers to the retrieval of records from the database. It involves selecting data from the database based on a certain criteria.
(a)
Provides a default value for a column when none is specified.
(a)
Retrieves certain records from one or more tables.
(a)
All the numeric values should be enclosed in single quotes.
TRUE
FALSE
The (a) function is used to execute the SQL statement.
