Find the odd one out in terms of scheduling policies.
1.MyISAM
2.InnoDB
3.MEMORY
4.MERGE
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
If a column contains 7 values and 6 distinct values, the cardinality is _____
1.7
2.6
3.13
4.1
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
In MySQL, the default size of the key buffer in MB is _____
1.4
2.8
3.16
4.32
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
Is duplicate entry of other attributes are allowed in SQL?
1.Yes
2.No
3.Depends
4.None of the mentioned
Is duplicate entry of primary key is allowed in SQL?
1.Yes
2.No
3.Depends
4.None of the mentioned
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
The data rows of a MyISAM table are stored in _______
1.data file
2.index file
3.log file
4.error file
The maximum number of indexes on MyISAM table is _____
1.0
2.1
3.2
4.more than 1
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
The slow query log is written as ____
1.numbers
2.text
3.image
4.graph
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
To check how MySQL would execute a SELECT query, which statement is used?
1.TELL
2.SHOW
3.DISPLAY
4.EXPLAIN
To convert a string to an int, the function is ______
1.INET_ATON()
2.INET_NTOA()
3.INET_ITOS()
4.INET_STOI()
To convert an int to string, the function is _____
1.INET_ATON()
2.INET_NTOA()
3.INET_ITOS()
4.INET_STOI()
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
TO enable the compressed client/server protocol the option is ______
1.enable
2.compress
3.reduce
4.restrict
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
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
To reactivate indexes the command used is ____
1.DISABLE KEYS
2.DISABLE INDEXES
3.ENABLE KEYS
4.ENABLE INDEXES
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
Which among the following tags belong to Data definition language?
1.SELECT
2.FROM
3.WHERE
4.All of the mentioned
Which among the following tags belong to Data Manipulation language?
1.UPDATE
2.ALTER
3.MODIFY
4.All of the mentioned
Which are the two languages used in Mysql?
1.DML/DDL
2.DDL/DCL
3.DML/DDM
4.None of the mentioned
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
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
Which compiler is used to execute the structured query language?
1.DCL
2.DDL
3.DML
4.None of the mentioned
Which is more efficient?
1.LOAD DATA
2.INSERT
3.Same
4.Indeterminate
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
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
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
Which mode tells cache queries that begin with SELECT SQL_CACHE?
1.0
2.1
3.2
4.3
Which mode tells not to cache query results?
1.0
2.1
3.2
4.3
Which of the following are the valid database datatypes in Mysql?
1.Numerical
2.Temporal
3.Text
4.All of the mentioned
Which of these can be used to generate hash values?
1.MS5()
2.MA5()
3.MF5()
4.MD5()
Which of these comparisons is slowest?
1.INT/INT
2.INT/BIGINT
3.BIGINT/BIGINT
4.All are of same speed
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
Which option turns on the extended-insert?
1.opt
2.opti
3.op
4.optimize
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
Which statement is used to verify optimizer operation?
1.ANALYZE
2.VERIFY
3.EXPLAIN
4.SHOW
Which statement issues a lock on tables?
1.ISSUE LOCK
2.LOCK ISSUE
3.LOCK TABLES
4.ISSUE LOCKS
Which status indicator assesses how effective the table cache is?
1.Open_tables
2.Opened_tables
3.Close_tables
4.Closed_tables
Which system variable controls the size of the table cache?
1.table_cache
2.cache_table
3.open_cache
4.cache_open
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
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
Which table is preferred when there are many updates?
1.MyISAM
2.InnoDB
3.MEMORY
4.MERGE
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
Without LOCAL, LOAD DATA is ______
1.more efficient
2.Less efficient
3.same speed
4.arbitrary