Olete.in – MCQs, Mock Tests & Government Job Prep

The maximum number of indexes on MyISAM table is _____

1. 0
2. 1
3. 2
4. more than 1

✅ Correct Answer: 4

The data rows of a MyISAM table are stored in _______

1. data file
2. index file
3. log file
4. error file

✅ Correct Answer: 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

✅ Correct Answer: 2

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

1. 7
2. 6
3. 13
4. 1

✅ Correct Answer: 2

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

✅ Correct Answer: 4

The slow query log is written as ____

1. numbers
2. text
3. image
4. graph

✅ Correct Answer: 2

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

1. TELL
2. SHOW
3. DISPLAY
4. EXPLAIN

✅ Correct Answer: 4

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

✅ Correct Answer: 2

Which statement is used to verify optimizer operation?

1. ANALYZE
2. VERIFY
3. EXPLAIN
4. SHOW

✅ Correct Answer: 3

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

✅ Correct Answer: 4

Which of these comparisons is slowest?

1. INT/INT
2. INT/BIGINT
3. BIGINT/BIGINT
4. All are of same speed

✅ Correct Answer: 2

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

✅ Correct Answer: 1

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

✅ Correct Answer: 2

To convert an int to string, the function is _____

1. INET_ATON()
2. INET_NTOA()
3. INET_ITOS()
4. INET_STOI()

✅ Correct Answer: 2

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

1. INET_ATON()
2. INET_NTOA()
3. INET_ITOS()
4. INET_STOI()

✅ Correct Answer: 1

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

✅ Correct Answer: 4

Which of these can be used to generate hash values?

1. MS5()
2. MA5()
3. MF5()
4. MD5()

✅ Correct Answer: 4

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

✅ Correct Answer: 1

Which is more efficient?

1. LOAD DATA
2. INSERT
3. Same
4. Indeterminate

✅ Correct Answer: 1

Without LOCAL, LOAD DATA is ______

1. more efficient
2. Less efficient
3. same speed
4. arbitrary

✅ Correct Answer: 1

Which option turns on the extended-insert?

1. opt
2. opti
3. op
4. optimize

✅ Correct Answer: 1

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

✅ Correct Answer: 1

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

✅ Correct Answer: 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

✅ Correct Answer: 2

TO enable the compressed client/server protocol the option is ______

1. enable
2. compress
3. reduce
4. restrict

✅ Correct Answer: 2

To reactivate indexes the command used is ____

1. DISABLE KEYS
2. DISABLE INDEXES
3. ENABLE KEYS
4. ENABLE INDEXES

✅ Correct Answer: 3

Which statement issues a lock on tables?

1. ISSUE LOCK
2. LOCK ISSUE
3. LOCK TABLES
4. ISSUE LOCKS

✅ Correct Answer: 3

Find the odd one out in terms of scheduling policies.

1. MyISAM
2. InnoDB
3. MEMORY
4. MERGE

✅ Correct Answer: 2

Which table is preferred when there are many updates?

1. MyISAM
2. InnoDB
3. MEMORY
4. MERGE

✅ Correct Answer: 2

Which system variable controls the size of the table cache?

1. table_cache
2. cache_table
3. open_cache
4. cache_open

✅ Correct Answer: 1

Which status indicator assesses how effective the table cache is?

1. Open_tables
2. Opened_tables
3. Close_tables
4. Closed_tables

✅ Correct Answer: 2

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

1. 4
2. 8
3. 16
4. 32

✅ Correct Answer: 2

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

✅ Correct Answer: 1

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

✅ Correct Answer: 1

Which mode tells not to cache query results?

1. 0
2. 1
3. 2
4. 3

✅ Correct Answer: 1

Which mode tells cache queries that begin with SELECT SQL_CACHE?

1. 0
2. 1
3. 2
4. 3

✅ Correct Answer: 3

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

✅ Correct Answer: 1

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

✅ Correct Answer: 1

Is duplicate entry of primary key is allowed in SQL?

1. Yes
2. No
3. Depends
4. None of the mentioned

✅ Correct Answer: 2

Is duplicate entry of other attributes are allowed in SQL?

1. Yes
2. No
3. Depends
4. None of the mentioned

✅ Correct Answer: 1

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

✅ Correct Answer: 4

Which of the following are the valid database datatypes in Mysql?

1. Numerical
2. Temporal
3. Text
4. All of the mentioned

✅ Correct Answer: 4

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

✅ Correct Answer: 2

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

✅ Correct Answer: 4

Which compiler is used to execute the structured query language?

1. DCL
2. DDL
3. DML
4. None of the mentioned

✅ Correct Answer: 3

Which among the following tags belong to Data definition language?

1. SELECT
2. FROM
3. WHERE
4. All of the mentioned

✅ Correct Answer: 4

Which among the following tags belong to Data Manipulation language?

1. UPDATE
2. ALTER
3. MODIFY
4. All of the mentioned

✅ Correct Answer: 4

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

✅ Correct Answer: 4

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

✅ Correct Answer: 1

Which are the two languages used in Mysql?

1. DML/DDL
2. DDL/DCL
3. DML/DDM
4. None of the mentioned

✅ Correct Answer: 1

🧪 SQL MCQ Quiz Hub

SQL MCQ SET 2