67 MySQL MCQ Questions in english

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

MCQ Subjects