MCQ 1 Array_flip ( ) function changes the keys of an array into

(A) Integers (B) Characters (C) Values (D) Boolean

MCQ 2 What type of bugs are difficult to fix?

(A) Compile time bugs (B) index error (C) Logical bugs (D) Runtime bugs

MCQ 3 Who invoke the exception class?

(A) throws new Exception(); (B) new Exception(); (C) new throws Exception(); (D) throw new Exception();

MCQ 4 The updated MySQL extension released with PHP 5 is typically referred to as _____________.

(A) MySQL (B) mysql (C) mysqli (D) mysqly

MCQ 5 Which method returns the error code generated from the execution of the last MySQL function?

(A) errornumber() (B) errorno() (C) errnumber() (D) errno()

MCQ 6 asort( ) function same as arsort( ) but

(A) It sorts values in descending order (B) It sorts values in ascending order (C) It start sorting values from middle (D) None of the above

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

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

MCQ 8 In a LIKE clause, you can could ask for any value ending in 'abc' by writing

(A) LIKE %abc (B) LIKE abc$ (C) LIKE .*abc (D) LIKE ^.*abc$

MCQ 9 Commands passed to the MySQL daemon are written in

(A) Swedish (B) English (C) the Structured Query Language (D) Your choice from Perl, PHP, Java or some other languages

MCQ 10 Which of these commands will delete a table called AAAA if you have appropriate authority

(A) DROP AAAA (B) DELETE AAAA WHERE confirm = 'Yes' (C) DROP AAAA WHERE confirm = 'Yes' (D) DROP TABLE AAAA

MCQ 11 Which of these commands will delete all data from books if you have appropriate authority

(A) TRUNCATE TABLE books; (B) DELETE books (C) DROP books WHERE confirm = 'All' (D) DROP TABLE books

MCQ 12 Can DISTINCT command be used for more than one column?

(A) No (B) Yes (C) Can't say (D) None of the above

MCQ 13 If you want to undo a GRANT, you should use

(A) DELETE (B) REVOKE (C) UNGRANT (D) ROLLBACK

MCQ 14 Which of the following is available in MySQL

(A) CREATE TRIGGER (B) CREATE VIEW (C) CREATE SCHEMA (D) CREATE DATABASE

MCQ 15 How can we get the number of records or rows in a table?

(A) Using COUNT (B) Using COUNT Number (C) Using NUM (D) Using NUMBER

MCQ 16 How can we get the number of records or rows in a table?

(A) Using COUNT (B) Using COUNT Number (C) Using NUM (D) Using NUMBER

MCQ 17 Which is the default order of sort in ORDER BY clause?

(A) Randomly (B) Ascending (C) Descending (D) Nome of the above

MCQ 18 Drop Table cannot be used to drop a table referenced by a ___________ constraint.

(A) Primary Key (B) Sub Key (C) Super Key (D) Foreign Key

MCQ 19 Which of the following is used to delete an entire MYSQL database?

(A) drop entiredb dbname (B) drop database dbname (C) drop db dbname (D) drop dbase dbname

MCQ 20 The term attribute refers to a ___________ of a table.

(A) Column (B) Key (C) Entity (D) Tuple

MCQ 21 We use the ________________command to remove a relation from an SQL database.

(A) Drop table (B) Remove (C) Delete (D) Purge

MCQ 22 If there is more than one key for relation schema in DBMS then each key in relation schema is classified as ________________.

(A) Prime key (B) Super key (C) Candidate key (D) Primary key

MCQ 23 __________ is an Aggregate function in SQL.

(A) SELECT (B) AVG (C) MODIFY (D) CREATE

MCQ 24 Create table employee (name varchar, id integer, address text) What type of statement is this ?

(A) DML Statement (B) View (C) DDL (D) Integrity constraint

MCQ 25 A relational database consists of a collection of

(A) Keys (B) Records (C) Fields (D) Table