Question

Design Of Database System

True or False

4. PyMySQL supports parametrized queries.

5. In SQL, the function COUNT is not a group function.

6. The “Create Table” command in SQL allows programmers to declare the primary key of a table.

Answer 1

4.) TRUE

PyMySQL for Python's MySQL Library(to run parameterized queries in PyMySQL we can execute MySQLcursorprepared class and get the desired value in return)

5.) FALSE

COUNT function can be used with a GROUP By function to get aggregate results of columns, hence it is definitely a group function.

6.) TRUE.

The " Create Table" command is used to create a table, and SQL CREATE TABLE command can be modified in the query to define one of the column names in the table as primary key.