The information about table index characteristics is stored in which table of INFORMATION_SCHEMA?

  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:
The information about table index characteristics is stored in which table of INFORMATION_SCHEMA?

1.FILES

2.STATISTICS

3.SCHEMATA

4.VIEWS

Posted Date:-2021-07-18 21:20:38

More MCQS Questions and answers

  1. CROSS JOIN and JOIN are similar to __________
  2. In which join all the rows from the left table appear in the output irrespective of the content of the other table?
  3. MySQL stores the database character set and collation attributes in the file _________
  4. Post MySQL 6.0, utf8 was ___________
  5. Prior to MySQL 6.0, utf8 was ___________
  6. SELECT select_list FROM table_list WHERE row_constraint GROUP BY grouping_columns; Which of these is not optional?
  7. The ALL subquery performs which operation?
  8. The clause that filters JOIN results is called _________
  9. The command which lists databases managed by the server is _____________
  10. The default index type for MEMORY tables is __________
  11. The default storage engine used is ____________
  12. The facility that allows nesting one select statement into another is called __________
  13. The file created by the server to store the database attributes is __________
  14. The general term for information about databases and the objects in MySQL is _________
  15. The information about table index characteristics is stored in which table of INFORMATION_SCHEMA?
  16. The join in which all the rows from the right table appear in the output irrespective of the content of the other table is ___________
  17. The join where all possible row combinations are produced is called _________
  18. The left and right joins are also known as __________
  19. The option in mysqlshow to show information about indexes in a table is _________
  20. The statement to change the table name is __________
  21. To combine multiple retrievals, we write several SELECT statements and put the keyword between them. What is the keyword?
  22. To create a database only if it doesn’t already exist, which clause is used?
  23. What does UTF stand for int utf8?
  24. What is ‘xyz’ in the following SQL statement?
  25. What is generally used as a synonym for CHARACTER SET?
  26. What is joining a table to itself called?
  27. What is the name of the format file for a table named my_tbl?
  28. Which collations does this MySQL statement list?
  29. Which disk data does FILES table in INFORMATION_SCHEMA store?
  30. Which keyword is the synonym for DATABASE?
  31. Which keyword is used to create a database?
  32. Which keyword is used to create a table as a temporary copy of itself?
  33. Which keyword used with UNION does not retain duplicate rows?
  34. Which MySQL statement is used to find out which character sets are available?
  35. Which of these operators does not perform relative-value comparisons?
  36. Which of these operators perform similar operations like ALL and ANY?
  37. Which operators are used when a subquery returns multiple rows to be evaluated in comparison to the outer query?
  38. Which operators test whether a subquery returns any rows?
  39. Which statement is used to determine the storage engine for individual tables?
  40. Which statement is used to remove indexes on tables?
  41. Which statement is used to see the definition for an existing database?
  42. Which statement is used to select a default database?
  43. Which statement is used to show the server’s current character set and collation settings?
  44. Which statement makes changes to the database’s global attributes?
  45. Which storage engine enables to access tables from a MySQL server managed by another server?
  46. Which storage engine is not available in MySQL 5.0?
  47. Which subquery cannot be executed by itself as a separate statement?
  48. Which subquery returns a single value?
  49. Which table in INFORMATION_SCHEMA stores information about storage engines and server plugins?
  50. Which table stores information about the threads executing within the server?

Question :- CROSS JOIN and JOIN are similar to __________

1.INNER JOIN

2.NATURAL JOIN

3.OUTER JOIN

4.CARTESIAN JOIN

Answer 1

Question :- In which join all the rows from the left table appear in the output irrespective of the content of the other table?

1.RIGHT JOIN

2.LEFT JOIN

3.INNER JOIN

4.OUTER JOIN

Answer 2

Question :- MySQL stores the database character set and collation attributes in the file _________

1.dp.opt

2.db.opt

3.db.sv

4.db.zip

Answer 2

Question :- Post MySQL 6.0, utf8 was ___________

1.3 bytes

2.4 bytes

3.5 bytes

4.6 bytes

Answer 2

Question :- Prior to MySQL 6.0, utf8 was ___________

1.3 bytes

2.4 bytes

3.8 bytes

4.9 bytes

Answer 1

Question :- SELECT select_list FROM table_list WHERE row_constraint GROUP BY grouping_columns; Which of these is not optional?

1.select_list

2.table_list

3.row_constraint

4.grouping_columns

Answer 1

Question :- The ALL subquery performs which operation?

1.row

2.column

3.table

4.database

Answer 2

Question :- The clause that filters JOIN results is called _________

1.WHERE

2.SORT

3.GROUP

4.GROUP BY

Answer 1

Question :- The command which lists databases managed by the server is _____________

1.mysqld

2.mysqlshow

3.mysqllist

4.mysqldb

Answer 2

Question :- The default index type for MEMORY tables is __________

1.HASH

2.SPATIAL

3.FULLTEXT

4.UNIQUE

Answer 1

Question :- The default storage engine used is ____________

1.EXAMPLE

2.ARCHIVE

3.MyISAM

4.NDB

Answer 3

Question :- The facility that allows nesting one select statement into another is called __________

1.nesting

2.binding

3.subquerying

4.encapsulating

Answer 3

Question :- The file created by the server to store the database attributes is __________

1.db.otp

2.dp.zip

3.db.opt

4.db.cls

Answer 3

Question :- The general term for information about databases and the objects in MySQL is _________

1.datum

2.info

3.record

4.metadata

Answer 4

Question :- The information about table index characteristics is stored in which table of INFORMATION_SCHEMA?

1.FILES

2.STATISTICS

3.SCHEMATA

4.VIEWS

Answer 2

Question :- The join in which all the rows from the right table appear in the output irrespective of the content of the other table is ___________

1.CARTESIAN JOIN

2.CROSS JOIN

3.INNER JOIN

4.RIGHT JOIN

Answer 4

Question :- The join where all possible row combinations are produced is called _________

1.INNER JOIN

2.OUTER

3.NATURAL

4.CARTESIAN

Answer 4

Question :- The left and right joins are also known as __________

1.INNER JOIN

2.NATURAL JOIN

3.OUTER JOIN

4.CARTESIAN JOIN

Answer 3

Question :- The option in mysqlshow to show information about indexes in a table is _________

1.–no-data

2.–indexes

3.–keys

4.–flag

Answer 3

Question :- The statement to change the table name is __________

1.CHANGE

2.CHANGENAME

3.CHANGENM

4.RENAME

Answer 4

Question :- To combine multiple retrievals, we write several SELECT statements and put the keyword between them. What is the keyword?

1.COMBINE

2.CONCAT

3.JOIN

4.UNION

Answer 4

Question :- To create a database only if it doesn’t already exist, which clause is used?

1.IF EXISTS

2.IF NOT EXISTS

3.CREATE EXISTS

4.EXISTS IF

Answer 2

Question :- What does UTF stand for int utf8?

1.Universal Transformation Format

2.Unicode Transformation Format

3.Universal Transformation Formula

4.Unicode Transformation Formula

Answer 2

Question :- What is ‘xyz’ in the following SQL statement?

1.row name

2.column name

3.table name

4.database name

Answer 2

Question :- What is generally used as a synonym for CHARACTER SET?

1.CSET

2.CHSET

3.CHARSET

4.CHCSET

Answer 3

Question :- What is joining a table to itself called?

1.COMPLETE

2.SELF

3.OBSOLETE

4.CROSS

Answer 2

Question :- What is the name of the format file for a table named my_tbl?

1.my_tbl.fmt

2.my_tbl.frm

3.my_tbl.fmr

4.my_tbl.ftm

Answer 2

Question :- Which collations does this MySQL statement list?

1.names beginning with utf8

2.names ending with utf8

3.names containing utf8% anywhere

4.names ending in utf8%

Answer 1

Question :- Which disk data does FILES table in INFORMATION_SCHEMA store?

1.NDB

2.NBD

3.NBK

4.NCD

Answer 1

Question :- Which keyword is the synonym for DATABASE?

1.TABLE

2.OBJECT

3.DB

4.SCHEMA

Answer 4

Question :- Which keyword is used to create a database?

1.CREATE

2.SET

3.SETUP

4.LINK

Answer 1

Question :- Which keyword is used to create a table as a temporary copy of itself?

1.TEMP

2.TEMPO

3.TEMPR

4.TEMPORARY

Answer 4

Question :- Which keyword used with UNION does not retain duplicate rows?

1.ALL

2.NARROW

3.STRICT

4.DISTINCT

Answer 4

Question :- Which MySQL statement is used to find out which character sets are available?

1.SHOW CHARACTER SET

2.SHOW COLLATION

3.SHOW CHARACTER SETS

4.SHOW COLLATIONS

Answer 1

Question :- Which of these operators does not perform relative-value comparisons?

1.=

2.==

3.<=

4.>=

Answer 2

Question :- Which of these operators perform similar operations like ALL and ANY?

1.SOME

2.MANY

3.SELECT

4.GROUP

Answer 1

Question :- Which operators are used when a subquery returns multiple rows to be evaluated in comparison to the outer query?

1.IN and NOT IN

2.EXISTS and NOT EXISTS

3.OUTER JOIN and INNER JOIN

4.LEFT JOIN and RIGHT JOIN

Answer 1

Question :- Which operators test whether a subquery returns any rows?

1.IN and NOT IN

2.EXISTS and NOT EXISTS

3.PRESENT

4.ABSENT

Answer 2

Question :- Which statement is used to determine the storage engine for individual tables?

1.SHOW STATUS OF TABLE

2.SHOW STATUS TABLE

3.SHOW TABLE STATUS

4.SHOW DEFAULT STATUS

Answer 3

Question :- Which statement is used to remove indexes on tables?

1.DROP INDEX

2.DELETE INDEX

3.REMOVE INDEX

4.FLUSH INDEX

Answer 1

Question :- Which statement is used to see the definition for an existing database?

1.SHOW CREATE DATABASE

2.SHOW DATABASE

3.SHOW CREATE

4.SHOW CREATE DATABASE TABLE

Answer 1

Question :- Which statement is used to select a default database?

1.USE

2.CREATE

3.DROP

4.SCHEMA

Answer 1

Question :- Which statement is used to show the server’s current character set and collation settings?

1.SHOW CONSTANTS

2.SHOW CONSTRAINTS

3.SHOW VARIABLES

4.DISP VARIABLES

Answer 3

Question :- Which statement makes changes to the database’s global attributes?

1.CHANGE

2.ALTER

3.ALTERNATE

4.UPDATE

Answer 2

Question :- Which storage engine enables to access tables from a MySQL server managed by another server?

1.InnoDB

2.EXAMPLE

3.MyISAM

4.FEDERATED

Answer 4

Question :- Which storage engine is not available in MySQL 5.0?

1.InnoDB

2.ARCHIVE

3.Falcon

4.NDB

Answer 3

Question :- Which subquery cannot be executed by itself as a separate statement?

1.Correlated

2.Uncorrelated

3.EXISTS

4.NOT EXISTS

Answer 1

Question :- Which subquery returns a single value?

1.scalar

2.column

3.row

4.table

Answer 1

Question :- Which table in INFORMATION_SCHEMA stores information about storage engines and server plugins?

1.ENGINES, PLUGINS

2.FILES, PLUGINS

3.ENGINES, FILES

4.PLUGINS, STATISTICS

Answer 1

Question :- Which table stores information about the threads executing within the server?

1.PROCESS

2.PROCESSLIST

3.LIST

4.THREADSLIST

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