SQL/SQL MCQ SET 2 Sample Test,Sample questions

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

1.MyISAM

2.InnoDB

3.MEMORY

4.MERGE


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


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

1.7

2.6

3.13

4.1


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


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

1.4

2.8

3.16

4.32


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


Question:
Is duplicate entry of other attributes are allowed in SQL?

1.Yes

2.No

3.Depends

4.None of the mentioned


Question:
Is duplicate entry of primary key is allowed in SQL?

1.Yes

2.No

3.Depends

4.None of the mentioned


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


Question:
The data rows of a MyISAM table are stored in _______

1.data file

2.index file

3.log file

4.error file


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

1.0

2.1

3.2

4.more than 1


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


Question:
The slow query log is written as ____

1.numbers

2.text

3.image

4.graph


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


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

1.TELL

2.SHOW

3.DISPLAY

4.EXPLAIN


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

1.INET_ATON()

2.INET_NTOA()

3.INET_ITOS()

4.INET_STOI()


Question:
To convert an int to string, the function is _____

1.INET_ATON()

2.INET_NTOA()

3.INET_ITOS()

4.INET_STOI()


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


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

1.enable

2.compress

3.reduce

4.restrict


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


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


Question:
To reactivate indexes the command used is ____

1.DISABLE KEYS

2.DISABLE INDEXES

3.ENABLE KEYS

4.ENABLE INDEXES


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


Question:
Which among the following tags belong to Data definition language?

1.SELECT

2.FROM

3.WHERE

4.All of the mentioned


Question:
Which among the following tags belong to Data Manipulation language?

1.UPDATE

2.ALTER

3.MODIFY

4.All of the mentioned


Question:
Which are the two languages used in Mysql?

1.DML/DDL

2.DDL/DCL

3.DML/DDM

4.None of the mentioned


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


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


Question:
Which compiler is used to execute the structured query language?

1.DCL

2.DDL

3.DML

4.None of the mentioned


Question:
Which is more efficient?

1.LOAD DATA

2.INSERT

3.Same

4.Indeterminate


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


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


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


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

1.0

2.1

3.2

4.3


Question:
Which mode tells not to cache query results?

1.0

2.1

3.2

4.3


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

1.Numerical

2.Temporal

3.Text

4.All of the mentioned


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

1.MS5()

2.MA5()

3.MF5()

4.MD5()


Question:
Which of these comparisons is slowest?

1.INT/INT

2.INT/BIGINT

3.BIGINT/BIGINT

4.All are of same speed


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


Question:
Which option turns on the extended-insert?

1.opt

2.opti

3.op

4.optimize


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


Question:
Which statement is used to verify optimizer operation?

1.ANALYZE

2.VERIFY

3.EXPLAIN

4.SHOW


Question:
Which statement issues a lock on tables?

1.ISSUE LOCK

2.LOCK ISSUE

3.LOCK TABLES

4.ISSUE LOCKS


Question:
Which status indicator assesses how effective the table cache is?

1.Open_tables

2.Opened_tables

3.Close_tables

4.Closed_tables


Question:
Which system variable controls the size of the table cache?

1.table_cache

2.cache_table

3.open_cache

4.cache_open


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


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


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

1.MyISAM

2.InnoDB

3.MEMORY

4.MERGE


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


Question:
Without LOCAL, LOAD DATA is ______

1.more efficient

2.Less efficient

3.same speed

4.arbitrary


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!