MCQ 1 Which one of the following methods is responsible for sending the query to the database?

(A) query() (B) send_query() (C) sendquery() (D) query_send()

MCQ 2 Which one of the following methods recuperates any memory consumed by a result set?

(A) destroy() (B) remover() (C) alloc() (D) free()

MCQ 3 Which one of the following statements is used to create a table?

(A) CREATE TABLE table_name (column_name column_type); (B) CREATE table_name (column_type column_name); (C) CREATE table_name (column_name column_type); (D) CREATE TABLE table_name (column_type column_name);

MCQ 4 Which of the following can add a row to a table?

(A) Alter (B) Insert (C) Update (D) Create

MCQ 5 Which of the following is NOT available in MySQL

(A) FETCH (B) SELECT (C) REVOKE (D) JOIN

MCQ 6 How many distinct, different values can you hold in an enum field?

(A) 7 (B) 255 (C) 10258 (D) 65535

MCQ 7 When do we use a HAVING clause?

(A) To limit the output of a query (B) To limit the output of a query using an aggregate function only (C) When GROUP by is used (D) Both B and C

MCQ 8 Insert into instructor values (1001, 'Rajiv Sharma', 'PHP Language', 101); What type of statement is this?

(A) Query (B) DML (C) DDL (D) Relational

MCQ 9 Which one of the following provides the ability to query information from the database and to insert tuples into, delete tuples from, and modify tuples in the database ?

(A) Relational Schema (B) Query (C) DDL(Data Definition Langauge) (D) DML(Data Manipulation Language)

MCQ 10 SQL Select statement to retrieve unique record from a table is

(A) SELECT DISTINCT (B) SELECT UNIQUE (C) SELECT UNION ALL (D) SELECT UNION

MCQ 11 Which one is the correct declaration for choosing the character set other than default?

(A) Varchar(20) character set; (B) Varchar(20); (C) Varchar character set (20); (D) Varchar(20) character set utf8;

MCQ 12 The value of primary key

(A) can be duplicated (B) can be null (C) cannot be null (D) None of the above

MCQ 13 The primary key is selected from the __________________.

(A) composite keys (B) foreign keys (C) candidate keys (D) determinants

MCQ 14 Drop table structure is

(A) DML Statement (B) Query Statement (C) DDL Statement (D) None of the above

MCQ 15 Correct SQL query to delete a column from a table in SQL Server database

(A) ALTER TABLE tablename, DROP COLUMN columnName (B) DROP COLUMN columnName FROM table name (C) DELETE columnName FROM tableName (D) None of the above

MCQ 16 Which of the following is not a User defined function?

(A) Max() (B) Scalar Function (C) Multi-Statement Table-Valued Function (D) Inline Table-Valued Function

MCQ 17 Which SQL statement is used to extract data from a database?

(A) SELECT (B) GET (C) INSERT (D) EXTRACT

MCQ 18 Which SQL statement is used to insert new data in a database?

(A) ADD NEW (B) INSERT INTO (C) INSERT NEW (D) Add new Record

MCQ 19 Which one of the following statements instantiates the mysqli class?

(A) mysqli = new mysqli() (B) $mysqli = new mysqli() (C) $mysqli -> new.mysqli() (D) mysqli -> new.mysqli()

MCQ 20 Which one of the following statements can be used to select the database? Use database name is 'knowledge'.

(A) mysqli = select_db('knowledge'); (B) $mysqli = select_db('knowledge'); (C) $mysqli -> select_db('knowledge'); (D) mysqli -> select_db('knowledge');

MCQ 21 Which one of the following methods can be used to diagnose and display information about a MySQL connection error?

(A) connect_errno() (B) connect_error() (C) mysqli_connect_error() (D) mysqli_connect_errno()

MCQ 22 MySQL Access security is controlled through

(A) A table of valid IP addresses, and priveliges set up for each IP address (B) The normal login security is sufficient for MySQL, and it does not have any extra controls of its own. (C) The ID that the user logged into the server through, and priveliges set up for that account. (D) MySQL login accounts, and priveliges set for each account

MCQ 23 MySQL runs on which operating systems?

(A) Linux and Mac OS-X only (B) Unix, Linux, Windows and other (C) Unix and Linux only (D) None of the above

MCQ 24 The number of attributes in relation is called as its

(A) Cardinality (B) Tuples (C) Degree (D) Key

MCQ 25 Which among the following have the maximum bytes?

(A) Varchar (B) Char (C) Text type (D) Both Varchar and Char