Which of these comparisons is slowest?

  1. Home
  2. Back

SQL - Online Exam Test Papers | SQL - MCQs[multiple choice questions and answers ] | SQL - Mock Test Papers | SQL - Practice Papers | SQL - Sample Test Papers |

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 04:52:26

More MCQS Questions and answers

  1. Find the odd one out in terms of scheduling policies.
  2. For a table having 4 columns, the number of columns to which hash function is applied when using hash indexes is _____
  3. If a column contains 7 values and 6 distinct values, the cardinality is _____
  4. In a single table (with 10 columns) join query the number of values needed to examine per column is _____
  5. In MySQL, the default size of the key buffer in MB is _____
  6. IP numbers can be represented as ______
  7. Is duplicate entry of other attributes are allowed in SQL?
  8. Is duplicate entry of primary key is allowed in SQL?
  9. Query Mechanism performs the following functions?
  10. The data rows of a MyISAM table are stored in _______
  11. The maximum number of indexes on MyISAM table is _____
  12. The option which delays index flushing for slave server is ______
  13. The slow query log is written as ____
  14. The system variable to maintain InnoDB log buffer size is ____
  15. To check how MySQL would execute a SELECT query, which statement is used?
  16. To convert a string to an int, the function is ______
  17. To convert an int to string, the function is _____
  18. To determine whether query cache is supported by the server the variable is _____
  19. TO enable the compressed client/server protocol the option is ______
  20. To maintain performance of tables having variable length rows, which statement is used?
  21. To perform analysis of key values by the server, the statement used is ______
  22. To reactivate indexes the command used is ____
  23. What jobs Query Optimizer perform in Mysql?
  24. Which among the following tags belong to Data definition language?
  25. Which among the following tags belong to Data Manipulation language?
  26. Which are the two languages used in Mysql?
  27. Which command is used to display all the existing tables in a database?
  28. Which command is used to remove existing tables or database?
  29. Which compiler is used to execute the structured query language?
  30. Which is more efficient?
  31. Which is the correct format to store date in the SQL?
  32. Which Key is used to link two tables in Mysql?
  33. Which line of the following statements will produce error?
  34. Which mode tells cache queries that begin with SELECT SQL_CACHE?
  35. Which mode tells not to cache query results?
  36. Which of the following are the valid database datatypes in Mysql?
  37. Which of these can be used to generate hash values?
  38. Which of these comparisons is slowest?
  39. Which option repairs MyISAM tables automatically after they open?
  40. Which option turns on the extended-insert?
  41. Which statement is used to force the optimizer to use tables in a particular order?
  42. Which statement is used to verify optimizer operation?
  43. Which statement issues a lock on tables?
  44. Which status indicator assesses how effective the table cache is?
  45. Which system variable controls the size of the table cache?
  46. 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?
  47. Which system variable tells the optimizer to skip certain plans based on estimates of the number of rows accessed for each table?
  48. Which table is preferred when there are many updates?
  49. Which table option for MyISAM tables reduces index flushing?
  50. Without LOCAL, LOAD DATA is ______

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

1.MyISAM

2.InnoDB

3.MEMORY

4.MERGE

Answer 2

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

Answer 4

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

1.7

2.6

3.13

4.1

Answer 2

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

Answer 2

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

1.4

2.8

3.16

4.32

Answer 2

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

Answer 1

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

1.Yes

2.No

3.Depends

4.None of the mentioned

Answer 1

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

1.Yes

2.No

3.Depends

4.None of the mentioned

Answer 2

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

Answer 4

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

1.data file

2.index file

3.log file

4.error file

Answer 1

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

1.0

2.1

3.2

4.more than 1

Answer 4

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

Answer 2

Question :- The slow query log is written as ____

1.numbers

2.text

3.image

4.graph

Answer 2

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

Answer 1

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

1.TELL

2.SHOW

3.DISPLAY

4.EXPLAIN

Answer 4

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

1.INET_ATON()

2.INET_NTOA()

3.INET_ITOS()

4.INET_STOI()

Answer 1

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

1.INET_ATON()

2.INET_NTOA()

3.INET_ITOS()

4.INET_STOI()

Answer 2

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

Answer 1

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

1.enable

2.compress

3.reduce

4.restrict

Answer 2

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

Answer 4

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

Answer 2

Question :- To reactivate indexes the command used is ____

1.DISABLE KEYS

2.DISABLE INDEXES

3.ENABLE KEYS

4.ENABLE INDEXES

Answer 3

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

Answer 1

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

1.SELECT

2.FROM

3.WHERE

4.All of the mentioned

Answer 4

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

1.UPDATE

2.ALTER

3.MODIFY

4.All of the mentioned

Answer 4

Question :- Which are the two languages used in Mysql?

1.DML/DDL

2.DDL/DCL

3.DML/DDM

4.None of the mentioned

Answer 1

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

Answer 1

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

Answer 1

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

1.DCL

2.DDL

3.DML

4.None of the mentioned

Answer 3

Question :- Which is more efficient?

1.LOAD DATA

2.INSERT

3.Same

4.Indeterminate

Answer 1

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

Answer 4

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

Answer 2

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

Answer 4

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

1.0

2.1

3.2

4.3

Answer 3

Question :- Which mode tells not to cache query results?

1.0

2.1

3.2

4.3

Answer 1

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

1.Numerical

2.Temporal

3.Text

4.All of the mentioned

Answer 4

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

1.MS5()

2.MA5()

3.MF5()

4.MD5()

Answer 4

Question :- Which of these comparisons is slowest?

1.INT/INT

2.INT/BIGINT

3.BIGINT/BIGINT

4.All are of same speed

Answer 2

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

Answer 1

Question :- Which option turns on the extended-insert?

1.opt

2.opti

3.op

4.optimize

Answer 1

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

Answer 4

Question :- Which statement is used to verify optimizer operation?

1.ANALYZE

2.VERIFY

3.EXPLAIN

4.SHOW

Answer 3

Question :- Which statement issues a lock on tables?

1.ISSUE LOCK

2.LOCK ISSUE

3.LOCK TABLES

4.ISSUE LOCKS

Answer 3

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

1.Open_tables

2.Opened_tables

3.Close_tables

4.Closed_tables

Answer 2

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

1.table_cache

2.cache_table

3.open_cache

4.cache_open

Answer 1

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

Answer 2

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

Answer 1

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

1.MyISAM

2.InnoDB

3.MEMORY

4.MERGE

Answer 2

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

Answer 1

Question :- Without LOCAL, LOAD DATA is ______

1.more efficient

2.Less efficient

3.same speed

4.arbitrary

Answer 1
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!