SQL/SQL MCQ SET 2 Sample Test,Sample questions

  1. Home
  2. Back

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

1.MyISAM

2.InnoDB

3.MEMORY

4.MERGE

Posted Date:-2021-07-18 11:52:26

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

Posted Date:-2021-07-18 11:52:26

Question: 
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 11:52:26

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

Posted Date:-2021-07-18 11:52:26

Question: 
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 11:52:26

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

Posted Date:-2021-07-18 11:52:26

Question: 
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 11:52:26

Question: 
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 11:52:26

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

Posted Date:-2021-07-18 11:52:26

Question: 
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 11:52:26

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

1.0

2.1

3.2

4.more than 1

Posted Date:-2021-07-18 11:52:26

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

Posted Date:-2021-07-18 11:52:26

Question: 
The slow query log is written as ____

1.numbers

2.text

3.image

4.graph

Posted Date:-2021-07-18 11:52:26

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

Posted Date:-2021-07-18 11:52:26

Question: 
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 11:52:26

Question: 
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 11:52:26

Question: 
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 11:52:26

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

Posted Date:-2021-07-18 11:52:26

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

1.enable

2.compress

3.reduce

4.restrict

Posted Date:-2021-07-18 11:52:26

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

Posted Date:-2021-07-18 11:52:26

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

Posted Date:-2021-07-18 11:52:26

Question: 
To reactivate indexes the command used is ____

1.DISABLE KEYS

2.DISABLE INDEXES

3.ENABLE KEYS

4.ENABLE INDEXES

Posted Date:-2021-07-18 11:52:26

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

Posted Date:-2021-07-18 11:52:26

Question: 
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 11:52:26

Question: 
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 11:52:26

Question: 
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 11:52:26

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

Posted Date:-2021-07-18 11:52:26

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

Posted Date:-2021-07-18 11:52:26

Question: 
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 11:52:26

Question: 
Which is more efficient?

1.LOAD DATA

2.INSERT

3.Same

4.Indeterminate

Posted Date:-2021-07-18 11:52:26

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

Posted Date:-2021-07-18 11:52:26

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

Posted Date:-2021-07-18 11:52:26

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

Posted Date:-2021-07-18 11:52:26

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

1.0

2.1

3.2

4.3

Posted Date:-2021-07-18 11:52:26

Question: 
Which mode tells not to cache query results?

1.0

2.1

3.2

4.3

Posted Date:-2021-07-18 11:52:26

Question: 
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 11:52:26

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

1.MS5()

2.MA5()

3.MF5()

4.MD5()

Posted Date:-2021-07-18 11:52:26

Question: 
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 11:52:26

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

Posted Date:-2021-07-18 11:52:26

Question: 
Which option turns on the extended-insert?

1.opt

2.opti

3.op

4.optimize

Posted Date:-2021-07-18 11:52:26

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

Posted Date:-2021-07-18 11:52:26

Question: 
Which statement is used to verify optimizer operation?

1.ANALYZE

2.VERIFY

3.EXPLAIN

4.SHOW

Posted Date:-2021-07-18 11:52:26

Question: 
Which statement issues a lock on tables?

1.ISSUE LOCK

2.LOCK ISSUE

3.LOCK TABLES

4.ISSUE LOCKS

Posted Date:-2021-07-18 11:52:26

Question: 
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 11:52:26

Question: 
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 11:52:26

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

Posted Date:-2021-07-18 11:52:26

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

Posted Date:-2021-07-18 11:52:26

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

1.MyISAM

2.InnoDB

3.MEMORY

4.MERGE

Posted Date:-2021-07-18 11:52:26

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

Posted Date:-2021-07-18 11:52:26

Question: 
Without LOCAL, LOAD DATA is ______

1.more efficient

2.Less efficient

3.same speed

4.arbitrary

Posted Date:-2021-07-18 11:52:26

Posted on by R4R Team

More MCQS

  1. SQL MCQ SET 1
  2. SQL MCQ SET 2
  3. SQL MCQ SET 3
  4. SQL MCQ SET 4
  5. SQL MCQ SET 5
  6. SQL MCQ SET 6
  7. SQL MCQ SET 7
  8. SQL MCQ SET 8
  9. SQL MCQ SET 9
  10. SQL MCQ SET 10
  11. SQL MCQ SET 11
  12. SQL MCQ SET 12
  13. SQL MCQ SET 13
  14. SQL MCQ SET 14
  15. SQL MCQ SET 15
  16. SQL MCQ SET 16
  17. SQL MCQ SET 17
  18. SQL MCQ SET 18
  19. MCQ | SQL Basics
  20. MCQ | SQL Data Types
  21. SQL Server DBA Multiple Choice Questions
Search
R4R Team
R4Rin Top Tutorials are Core Java,Hibernate ,Spring,Sturts.The content on R4R.in website is done by expert team not only with the help of books but along with the strong professional knowledge in all context like coding,designing, marketing,etc!