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