67 MySQL MCQ Questions in english

Home
Subjects
MySQL

Subjectwise MCQ

English Hindi General Knowledge Mathematics History Geography Science Reasoning Economics Business Computer Government Scheme 1st CM List Biology Invention Environment Science Polity Sports GK JavaScript C And C++HTML and CSS MS Word MS Excel MS PowerPoint Bootstrap Python PHP MySQL

Select Subject

Statewise Prepration

Andaman Nicobar Andhra Pradesh Arunchal Pradesh Assam Bihar Chandigarh Chhatisgarh Dadra & Nagar Haveli and Daman & Diu Delhi Goa Gujarat Haryana Himachal Pradesh Jammu & Kashmir Jharkhand Karnatka Kerala Laddakh Lakshadweep Madhya Pradesh Maharashtra Manipur Meghalaya Mizoram Nagaland Odisha Pondicherry Punjab Rajasthan Sikkim Tamil Nadu Telangana Tripura Uttar Pradesh Uttarakhand West Bengal

Select State

Govt. Examwise MCQ

Group C IAS PCS Lower PCS Railway SSC Bank UKPSC Police Group D FCI LIC CAT MAT GMAT TET CTET CUET B. Ed Bank PO Bank Special Officer

Select Examination

Group C IAS PCS Lower PCS Railway SSC Bank UKPSC Police Group D FCI LIC CAT MAT GMAT TET CTET CUET B. Ed Bank PO Bank Special Officer

67 MySQL MCQ Questions in english हिन्दी

67. Using Perl, the DBI API is

A. database interface

B. database integrity

C. database id

D. database

66. For how many of the following do interfaces exist for implementing direct native client-server protocol? Java, PHP, Ruby

A. 0

B. 1

C. 2

D. 3

65. How many of these languages support MySQL's C API through interfaces? Perl, PHP, Python

A. 0

B. 1

C. 2

D. 3

64. Which command in the Mysql command line tool is used to display the current date and time?

A. select now()

B. select now()

C. SELECT now();

D. None of the mentioned

63. Which kind of authentication are necessary to access the MySQL command-line tool?

A. Password

B. Both Username and Password

C. Username

D. Only Username

62. Which of the following formats does the "Mysql command line tool" use to format the outcomes?

A. Square

B. Sphere

C. None of the mentioned

D. Rectangle

61. In order to access an existing database, which statement should be used?

A. Use

B. use database.name

C. USE databasename

D. None of the mentioned

60. An organizational view of a MySQL database is represented by the following structure :

A. Schema

B. View

C. Instance

D. Table

59. In its client/server architecture, MySQL is used

A. mysqla

B. mysqlc

C. mysqlb

D. mysqld

58. Data processing is performed by which MySQL instance?

A. a) MySQL client

B. Server daemon program

C. SQL

D. MySQL server

57. In the following SQL code snippet, what does 'name' mean? CREATE TABLE student ( name CHAR(30), roll_num INT, address CHAR(30), phone CHAR(12) );

A. A column

B. A row

C. An object

D. A table

56. What is the process of establishing communication with MySQL?

A. APIs

B. Network calls

C. A programming language like C++

D. SQL

55. In relational databases, what are 'tuples'?

A. Column

B. Table

C. Row

D. Object

54. In a relational database, what is an 'attribute'?

A. Row

B. Object

C. Table

D. Column

53. In addition to being open source, MySQL is free.

A. True

B. False

52. What categories does a MySQL database's data fall under?

A. File systems

B. Objects

C. Networks

D. Tables

51. What kind of database management system does MySQL belong to?

A. Relational

B. Object-oriented

C. Network

D. Hierarchical

50. The DISTINCT keyword used along with the SELECT keyword retrieves ______ ?

A. Duplicate data depending on the column list

B. Unique data depending on the column list

C. Sorted data depending on the column list

D. None of the above

49. Which statement should I use in MySQL's shell editor to import data from a text file?

A. shell> mysql -host host_name -u user_name -p password db_name < text_file

B. shell> mysql -host host_name -u user_name -p password db_name > text_file

C. shell> mysql < text_file

D. All the above

48. Which command is used in the MySQL editor to import data from a text file?

A. mysql> source text_file_path;

B. mysql> \. text_file_path

C. None of the above

D. A and B Both

47. The query result can be displayed vertically by terminating the query____?

A. With \V instead of a semicolon

B. With \G instead of a semicolon

C. With \M instead of a semicolon

D. All the above

46. Which statement should you use to insert numerous records?

A. INSERT INTO job_question VALUES ('col1', 'col2'), ('col1', 'col2'), ...

B. INSERT INTO job_question VALUES ('col1', 'col2'), VALUES ('col1', 'col2'), ...

C. A and B Both

D. None of the above

45. DML is used for _______?

A. Control access to data stored in a database

B. Defining database schema

C. Inserting, Deleting and Updating data

D. None of the above

44. DDL is used for _______?

A. Manage the changes made by DML statements

B. Defining database schema

C. Control access to data stored in a database

D. None of the above

43. DCL is used to _______?

A. Manage the changes made by DML statements

B. Inserting, Deleting and Updating data

C. Control access to data stored in a database

D. None of the above

42. TCL is used for _______?

A. Manage the changes made by DML statements

B. Defining database schema

C. Control access to data stored in a database

D. None of the above

41. Storing the same data in many places is called.

A. Iteration

B. Concurrency

C. Redundancy

D. Enumeration

40. What is Granularity?

A. The size of data items

B. The size of database

C. The size of record

D. The size of file

« Previous
Next »

Showing 1 to 28 of 67 results

Latest Jobs

AIIMS Non Faculty Group A, B & C Recruitment 202 ...

Apr 13, 2024

High Court of Kerala Recruitment

Last Date: Apr 26

Recruitment In Staff Selection Commission

Last Date: Apr 18

SSC

Deputy Collector Recruitment In Tamil Nadu Publi ...

Last Date: Apr 27

TNPSC

Kurnool District Court Jobs Notification for the ...

Last Date: Apr 11

Latest Blogs

Subjectwise MCQ

Statewise Prepration

Govt. Examwise MCQ

67 MySQL MCQ Questions in english हिन्दी

67. Using Perl, the DBI API is

66. For how many of the following do interfaces exist for implementing direct native client-server protocol? Java, PHP, Ruby

65. How many of these languages support MySQL's C API through interfaces? Perl, PHP, Python

64. Which command in the Mysql command line tool is used to display the current date and time?

63. Which kind of authentication are necessary to access the MySQL command-line tool?

62. Which of the following formats does the "Mysql command line tool" use to format the outcomes?

61. In order to access an existing database, which statement should be used?

60. An organizational view of a MySQL database is represented by the following structure :

59. In its client/server architecture, MySQL is used

58. Data processing is performed by which MySQL instance?

57. In the following SQL code snippet, what does 'name' mean? CREATE TABLE student ( name CHAR(30), roll_num INT, address CHAR(30), phone CHAR(12) );

56. What is the process of establishing communication with MySQL?

55. In relational databases, what are 'tuples'?

54. In a relational database, what is an 'attribute'?

53. In addition to being open source, MySQL is free.

52. What categories does a MySQL database's data fall under?

51. What kind of database management system does MySQL belong to?

50. The DISTINCT keyword used along with the SELECT keyword retrieves ______ ?

49. Which statement should I use in MySQL's shell editor to import data from a text file?

48. Which command is used in the MySQL editor to import data from a text file?

47. The query result can be displayed vertically by terminating the query____?

46. Which statement should you use to insert numerous records?

45. DML is used for _______?

44. DDL is used for _______?

43. DCL is used to _______?

42. TCL is used for _______?

41. Storing the same data in many places is called.

40. What is Granularity?

Latest Jobs

Latest Blogs

for Latest Updates