MCQ 1 The father of MySql is

(A) Bill Joy (B) Michael Widenius (C) Sigmund Velin (D) Stephanie Wall

MCQ 2 MySQL supports the complete SQL99 standard

(A) True (B) False (C) Can't say (D) None of the above

MCQ 3 What is a candidate key?

(A) Alias for primary key (B) Used to identify a column (C) Used to uniquely identify a row (D) Alias for foreign key

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

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

MCQ 5 Which SQL statement is used to update data in a database?

(A) Modify (B) Select (C) Update (D) Save

MCQ 6 With SQL, how do you select all the columns from a table named "Persons"?

(A) SELECT Persons (B) SELECT [all] FROM Persons (C) SELECT * FROM Persons (D) SELECT *.Persons

MCQ 7 Function cannot be used for ________________ statement.

(A) Create (B) Drop (C) Insert (D) Select

MCQ 8 USE keyword is used to select a ____________________

(A) table (B) database (C) column (D) All of the above

MCQ 9 Can I define multiple unique constraints on a table?

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

MCQ 10 Storing same data in many places is called.

(A) Iteration (B) Concurrency (C) Enumeration (D) Redundancy

MCQ 11 To use MySQL on your computer, you will need

(A) Perl, PHP or Java (B) A Browser (C) FTP and Telnet (D) Some sort of client program to access the databases

MCQ 12 Which databases mostly supported PHP language almost since the beginning?

(A) Oracle Database (B) SQL (C) SQL+ (D) MySQL

MCQ 13 Which version of MySQL introduced the prepared statements?

(A) MySQL 4.0 (B) MySQL 4.1 (C) MySQL 4.2 (D) MySQL 4.3

MCQ 14 Which SQL statement is used to create a table in a database?

(A) CREATE TABLE (B) CREATE DATABASE TABLE (C) CREATE DB (D) CREATE DATABASE

MCQ 15 What is the most common type of join?

(A) JOINED (B) INNER JOIN (C) INSIDE JOIN (D) JOINED TABLE

MCQ 16 The SQL used by front-end application programs to request data from the DBMS is called ______________

(A) DML (B) DDL (C) VDL (D) SDL

MCQ 17 Which of the following is a sql AGGREGATE Function

(A) LEFT (B) AVG (C) JOIN (D) LEN

MCQ 18 data types in SQL Server are organized into how many categories?

(A) 4 (B) 6 (C) 8 (D) 10

MCQ 19 All aggregate functions except __________ ignore null values in their input collection.

(A) Sum (B) Count(attribute) (C) Count(*) (D) Avg

MCQ 20 How many Primary key a table can max have?

(A) Depends on no of Columns (B) Only 2 (C) Only 1 (D) Depends on DBA

MCQ 21 Which of the following is not Constraint in SQL?

(A) Primary Key (B) Not Null (C) Check (D) Union

MCQ 22 Which statement in SQL allows us to change the definition of a table is?

(A) CREATE (B) ALTER (C) SELECT (D) UPDATE

MCQ 23 Which method is used to retrieve the number of rows affected by an INSERT, UPDATE, or DELETE query?

(A) num_rows() (B) affected_rows() (C) changed_rows() (D) new_rows()

MCQ 24 How can you delete the records where the "FirstName" is "Rajiv" in the records Table?

(A) DELETE ROW FirstName='Rajiv' FROM records (B) DELETE FirstName='Rajiv' FROM records (C) DELETE FROM records WHERE FirstName = 'Rajiv' (D) DELETE FROM records and FirstName = 'Rajiv'

MCQ 25 How can you insert a new record into the "records" table?

(A) INSERT INTO records VALUES ('Rajiv', 'Sharma') (B) INSERT records VALUES ('Rajiv', 'Sharma') (C) INSERT records VALUES Into ('Rajiv', 'Sharma') (D) INSERT ('Rajiv', 'Sharma') Into records