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
Answer:1
Posted Date:-2021-07-18 04:52:26
1.MyISAM
2.InnoDB
3.MEMORY
4.MERGE
Answer 21.1
2.2
3.3
4.4
Answer 41.7
2.6
3.13
4.1
Answer 21.1
2.10
3.0
4.2
Answer 21.4
2.8
3.16
4.32
Answer 21.both integers and a string
2.a string but not integers
3.integers but not a string
4.neither a string nor integers
Answer 11.Yes
2.No
3.Depends
4.None of the mentioned
Answer 11.Yes
2.No
3.Depends
4.None of the mentioned
Answer 21.Syntax correction
2.Checking permission for executing the query
3.Checking permission for accessing the desired data
4.All of the mentioned
Answer 41.data file
2.index file
3.log file
4.error file
Answer 11.0
2.1
3.2
4.more than 1
Answer 41.delay-write-key=ALL
2.delay-key-write=ALL
3.key-write-delay=NONE
4.key-delay-write=NONE
Answer 21.numbers
2.text
3.image
4.graph
Answer 21.innodb_log_buffer_size
2.innodb_buffer_log_size
3.buffer_log_innodb_size
4.log_buffer_innodb_size
Answer 11.TELL
2.SHOW
3.DISPLAY
4.EXPLAIN
Answer 41.INET_ATON()
2.INET_NTOA()
3.INET_ITOS()
4.INET_STOI()
Answer 11.INET_ATON()
2.INET_NTOA()
3.INET_ITOS()
4.INET_STOI()
Answer 21.have_query_cache
2.have_cache_query
3.query_cache_have
4.cache_query_have
Answer 11.enable
2.compress
3.reduce
4.restrict
Answer 21.MAINTAIN TABLE
2.BALANCE TABLE
3.ADJUST TABLE
4.OPTIMIZE TABLE
Answer 41.ANALYZE KEYS
2.ANALYZE TABLE
3.PERFORM ANALYSIS
4.PERFORM TABLE ANALYSIS
Answer 21.DISABLE KEYS
2.DISABLE INDEXES
3.ENABLE KEYS
4.ENABLE INDEXES
Answer 31.Determine the efficient way to execute a query
2.Syntax errors
3.Permissions
4.All of the mentioned
Answer 11.SELECT
2.FROM
3.WHERE
4.All of the mentioned
Answer 41.UPDATE
2.ALTER
3.MODIFY
4.All of the mentioned
Answer 41.DML/DDL
2.DDL/DCL
3.DML/DDM
4.None of the mentioned
Answer 11.SHOW TABLES
2.SHOW TABLE
3.SHOW
4.None of the mentioned
Answer 11.DROP TABLE
2.DELETE
3.Either DROP TABLE or DELETE
4.None of the mentioned
Answer 11.DCL
2.DDL
3.DML
4.None of the mentioned
Answer 31.LOAD DATA
2.INSERT
3.Same
4.Indeterminate
Answer 11.DEC-01-1991
2.01-1991-11
3.01-DEC-12
4.01-11-1991
Answer 41.Primary Key
2.Foreign Key
3.Both Primary and Foreign Key
4.None of the mentioned
Answer 21.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
Answer 41.0
2.1
3.2
4.3
Answer 31.0
2.1
3.2
4.3
Answer 11.Numerical
2.Temporal
3.Text
4.All of the mentioned
Answer 41.MS5()
2.MA5()
3.MF5()
4.MD5()
Answer 41.INT/INT
2.INT/BIGINT
3.BIGINT/BIGINT
4.All are of same speed
Answer 21.myisam-recover=FORCE
2.myisam-recover=STOP
3.recover-myisam=FORCE
4.recover-myisam=STOP
Answer 11.opt
2.opti
3.op
4.optimize
Answer 11.FORCE INDEX
2.USE INDEX
3.IGNORE INDEX
4.STRAIGHT_JOIN
Answer 41.ANALYZE
2.VERIFY
3.EXPLAIN
4.SHOW
Answer 31.ISSUE LOCK
2.LOCK ISSUE
3.LOCK TABLES
4.ISSUE LOCKS
Answer 31.Open_tables
2.Opened_tables
3.Close_tables
4.Closed_tables
Answer 21.table_cache
2.cache_table
3.open_cache
4.cache_open
Answer 11.optimizer_prune_level
2.optimizer_search_depth
3.optimizer_search
4.optimizer_prune
Answer 21.optimizer_prune_level
2.optimizer_search_depth
3.optimizer_search
4.optimizer_prune
Answer 11.MyISAM
2.InnoDB
3.MEMORY
4.MERGE
Answer 21.DELAY_KEY_WRITE
2.DELAY_WRITE_KEY
3.KEY_WRITE_DELAY
4.WRITE_KEY_DELAY
Answer 11.more efficient
2.Less efficient
3.same speed
4.arbitrary
Answer 1