Question :- Find the odd one out in terms of scheduling policies.

1.MyISAM

2.InnoDB

3.MEMORY

4.MERGE

Question :- For a table having 4 columns, the number of columns to which hash function is applied when using hash indexes is _____

1.1

2.2

3.3

4.4

Question :- If a column contains 7 values and 6 distinct values, the cardinality is _____

1.7

2.6

3.13

4.1

Question :- In a single table (with 10 columns) join query the number of values needed to examine per column is _____

1.1

2.10

3.0

4.2

Question :- In MySQL, the default size of the key buffer in MB is _____

1.4

2.8

3.16

4.32

Question :- IP numbers can be represented as ______

1.both integers and a string

2.a string but not integers

3.integers but not a string

4.neither a string nor integers

Question :- Is duplicate entry of other attributes are allowed in SQL?

1.Yes

2.No

3.Depends

4.None of the mentioned

Question :- Is duplicate entry of primary key is allowed in SQL?

1.Yes

2.No

3.Depends

4.None of the mentioned

Question :- Query Mechanism performs the following functions?

1.Syntax correction

2.Checking permission for executing the query

3.Checking permission for accessing the desired data

4.All of the mentioned

Question :- The data rows of a MyISAM table are stored in _______

1.data file

2.index file

3.log file

4.error file

Question :- The maximum number of indexes on MyISAM table is _____

1.0

2.1

3.2

4.more than 1

Question :- The option which delays index flushing for slave server is ______

1.delay-write-key=ALL

2.delay-key-write=ALL

3.key-write-delay=NONE

4.key-delay-write=NONE

Question :- The slow query log is written as ____

1.numbers

2.text

3.image

4.graph

Question :- The system variable to maintain InnoDB log buffer size is ____

1.innodb_log_buffer_size

2.innodb_buffer_log_size

3.buffer_log_innodb_size

4.log_buffer_innodb_size

Question :- To check how MySQL would execute a SELECT query, which statement is used?

1.TELL

2.SHOW

3.DISPLAY

4.EXPLAIN

Question :- To convert a string to an int, the function is ______

1.INET_ATON()

2.INET_NTOA()

3.INET_ITOS()

4.INET_STOI()

Question :- To convert an int to string, the function is _____

1.INET_ATON()

2.INET_NTOA()

3.INET_ITOS()

4.INET_STOI()

Question :- To determine whether query cache is supported by the server the variable is _____

1.have_query_cache

2.have_cache_query

3.query_cache_have

4.cache_query_have

Question :- TO enable the compressed client/server protocol the option is ______

1.enable

2.compress

3.reduce

4.restrict

Question :- To maintain performance of tables having variable length rows, which statement is used?

1.MAINTAIN TABLE

2.BALANCE TABLE

3.ADJUST TABLE

4.OPTIMIZE TABLE

Question :- To perform analysis of key values by the server, the statement used is ______

1.ANALYZE KEYS

2.ANALYZE TABLE

3.PERFORM ANALYSIS

4.PERFORM TABLE ANALYSIS

Question :- To reactivate indexes the command used is ____

1.DISABLE KEYS

2.DISABLE INDEXES

3.ENABLE KEYS

4.ENABLE INDEXES

Question :- What jobs Query Optimizer perform in Mysql?

1.Determine the efficient way to execute a query

2.Syntax errors

3.Permissions

4.All of the mentioned

Question :- Which among the following tags belong to Data definition language?

1.SELECT

2.FROM

3.WHERE

4.All of the mentioned

Question :- Which among the following tags belong to Data Manipulation language?

1.UPDATE

2.ALTER

3.MODIFY

4.All of the mentioned

Question :- Which are the two languages used in Mysql?

1.DML/DDL

2.DDL/DCL

3.DML/DDM

4.None of the mentioned

Question :- Which command is used to display all the existing tables in a database?

1.SHOW TABLES

2.SHOW TABLE

3.SHOW

4.None of the mentioned

Question :- Which command is used to remove existing tables or database?

1.DROP TABLE

2.DELETE

3.Either DROP TABLE or DELETE

4.None of the mentioned

Question :- Which compiler is used to execute the structured query language?

1.DCL

2.DDL

3.DML

4.None of the mentioned

Question :- Which is more efficient?

1.LOAD DATA

2.INSERT

3.Same

4.Indeterminate

Question :- Which is the correct format to store date in the SQL?

1.DEC-01-1991

2.01-1991-11

3.01-DEC-12

4.01-11-1991

Question :- Which Key is used to link two tables in Mysql?

1.Primary Key

2.Foreign Key

3.Both Primary and Foreign Key

4.None of the mentioned

Question :- Which line of the following statements will produce error?

1.SELECT * FROM person WHERE person_id=1;

2.SELECT pname FROM person;

3.SELECT pname, lname, person_id FROM person;

4.None of the mentioned

Question :- Which mode tells cache queries that begin with SELECT SQL_CACHE?

1.0

2.1

3.2

4.3

Question :- Which mode tells not to cache query results?

1.0

2.1

3.2

4.3

Question :- Which of the following are the valid database datatypes in Mysql?

1.Numerical

2.Temporal

3.Text

4.All of the mentioned

Question :- Which of these can be used to generate hash values?

1.MS5()

2.MA5()

3.MF5()

4.MD5()

Question :- Which of these comparisons is slowest?

1.INT/INT

2.INT/BIGINT

3.BIGINT/BIGINT

4.All are of same speed

Question :- Which option repairs MyISAM tables automatically after they open?

1.myisam-recover=FORCE

2.myisam-recover=STOP

3.recover-myisam=FORCE

4.recover-myisam=STOP

Question :- Which option turns on the extended-insert?

1.opt

2.opti

3.op

4.optimize

Question :- Which statement is used to force the optimizer to use tables in a particular order?

1.FORCE INDEX

2.USE INDEX

3.IGNORE INDEX

4.STRAIGHT_JOIN

Question :- Which statement is used to verify optimizer operation?

1.ANALYZE

2.VERIFY

3.EXPLAIN

4.SHOW

Question :- Which statement issues a lock on tables?

1.ISSUE LOCK

2.LOCK ISSUE

3.LOCK TABLES

4.ISSUE LOCKS

Question :- Which status indicator assesses how effective the table cache is?

1.Open_tables

2.Opened_tables

3.Close_tables

4.Closed_tables

Question :- Which system variable controls the size of the table cache?

1.table_cache

2.cache_table

3.open_cache

4.cache_open

Question :- Which system variable tells how far into the rest of each incomplete plan the optimizer should look to evaluate whether it should be expanded further?

1.optimizer_prune_level

2.optimizer_search_depth

3.optimizer_search

4.optimizer_prune

Question :- Which system variable tells the optimizer to skip certain plans based on estimates of the number of rows accessed for each table?

1.optimizer_prune_level

2.optimizer_search_depth

3.optimizer_search

4.optimizer_prune

Question :- Which table is preferred when there are many updates?

1.MyISAM

2.InnoDB

3.MEMORY

4.MERGE

Question :- Which table option for MyISAM tables reduces index flushing?

1.DELAY_KEY_WRITE

2.DELAY_WRITE_KEY

3.KEY_WRITE_DELAY

4.WRITE_KEY_DELAY

Question :- Without LOCAL, LOAD DATA is ______

1.more efficient

2.Less efficient

3.same speed

4.arbitrary