MySQL Online Test

1. There isn’t a program just called mysql

2. A wrapper through which Java clients must connect to the databases

3. A client program that lets you send SQL commands to the database engine

4. The database engine

5. A program that starts up and shuts down the database engine

Correct Answer : C

1. Fixed length string

2. Variable length string

3. Either Fixed or Variable length string

4. None of the mentioned

Correct Answer : C

1. true

2. false

Correct Answer : B

1. Alter

2. Add

3. Insert

4. Create

5. Update

6. Commit

Correct Answer : C

1. LIKE ton$

2. LIKE ^.*ton$

3. LIKE %ton

4. LIKE *ton

5. LIKE .*ton

Correct Answer : C

1. Far

2. Near

3. To

4. From

Correct Answer : B

1. FLOAT

2. DOUBLE

3. INT

4. BIGINT

Correct Answer : A

1. Many Value Dependency

2. More Value Dependency

3. Multi Value Dependency

4. All of the Above

Correct Answer : C

1. BDB

2. Isam99

3. MyIsam

4. Hash

5. Isam

6. InnoDb

Correct Answer : B

1. Numeric data type

2. Text data type

3. Temporal data type

4. Char/Varchar

Correct Answer : C

1. Char

2. Varchar

3. Both Char and Varchar

4. None of the above

Correct Answer : A

1. mysql_drop_database

2. mysql_drop_entiredb

3. mysql_drop_db

4. mysql_drop_dbase

Correct Answer : C

1. longblob

2. tinytext

3. mediumtext

4. longtext

5. tinyblob

Correct Answer : B

1. char binary

2. nchar binary

3. text

4. blob

Correct Answer : D

1. MySQL login accounts, and priveliges set for each account

2. The ID that the user logged into the server through, and priveliges set up for that account.

3. A table of valid IP addresses, and priveliges set up for each IP address

4. The normal login security is sufficient for MySQL, and it does not have any extra controls of its own.

Correct Answer : A

1. Perl, PHP or Java

2. Some sort of client program to access the databases

3. A Browser

4. FTP and Telnet

Correct Answer : B

1. 55

2. 72

3. 64

4. 40

Correct Answer : C

1. C Only

2. Java Only

3. Both Java and C

4. Perl, PHP and C

5. C, C# and the .NET environment, Java and Python

Correct Answer : A

1. Michael Widenius

2. Bill Joy

3. Bill Gates

4. Stephanie Wall

Correct Answer : A

1. False

2. True

Correct Answer : A

1. REVOKE

2. FETCH

3. LIKE

4. JOIN

5. SELECT

Correct Answer : B

1. Multiple-master replication

2. Master to slave replication

3. Single file based clustering

4. MySQL doesn’t support replication

Correct Answer : B

1. can be duplicated

2. can be null

3. cannot be null

4. none of these

Correct Answer : C

1. Temporary (Hash) Tables

2. Table Joining

3. Stored Procedures

4. Regular Expression Matching

Correct Answer : C