MySql - Study24x7
Social learning Network
mysqlprogramming Cover image
mysqlprogramming
MySql
  • Followers
  • Latest Feeds
  • Articles
  • Question
  • Course
  • About
  • Review
Interests
Databases Web Development BCA PHP
Articles
Question
Course
About
Review
Gallery
MySql
4 followers study24x7 03 Jan 2025 09:48 AM study24x7 study24x7

Which utility is used to monitor MySQL performance?

A

mysqladmin

B

mysqldump

C

performance_schema

D

mysqloptimize

Web Development PHP
Like Comment Share
study24x7
Write a comment
MySql
4 followers study24x7 03 Jan 2025 09:47 AM study24x7 study24x7

What is the purpose of the mysql_secure_installation script?

A

Backup the database

B

Secure the MySQL installation

C

Update MySQL configuration files

D

None of the above

Web Development PHP
Like Comment Share
study24x7
Write a comment
MySql
4 followers study24x7 03 Jan 2025 09:46 AM study24x7 study24x7

Which command grants privileges to a user?

A

GRANT

B

ALLOW

C

PERMIT

D

AUTHORIZE

Web Development PHP
Like Comment Share
study24x7
Write a comment
MySql
4 followers study24x7 02 Jan 2025 11:35 AM study24x7 study24x7

How do you create a user in MySQL?

A

CREATE NEW USER 'username'@'host';

B

CREATE USER 'username'@'host';

C

USER ADD 'username'@'host';

D

ADD USER 'username'@'host';

Web Development PHP
Like Comment Share
study24x7
Write a comment
MySql
4 followers study24x7 02 Jan 2025 11:34 AM study24x7 study24x7

What is the default port for MySQL?

A

1433

B

3306

C

1521

D

5432

Web Development PHP
Like Comment Share
study24x7
Write a comment
MySql
4 followers study24x7 02 Jan 2025 11:34 AM study24x7 study24x7

Which statement creates a recursive CTE?

A

WITH RECURSIVE cte_name AS

B

RECURSIVE TABLE

C

LOOP RECURSION

D

None of the above

Web Development PHP
Like Comment Share
study24x7
Write a comment
MySql
4 followers study24x7 31 Dec 2024 10:50 AM study24x7 study24x7

What does the CTE stand for in MySQL 8.x?

A

Common Table Expression

B

Current Table Extension

C

Column Type Extraction

D

None of the above

Web Development PHP
Like Comment Share | 1
study24x7
Write a comment
MySql
4 followers study24x7 31 Dec 2024 10:50 AM study24x7 study24x7

Which new index type is introduced in MySQL 8.x?

A

Invisible Index

B

Primary Index

C

Secondary Index

D

None of the above

Web Development PHP
Like Comment Share
study24x7
Write a comment
MySql
4 followers study24x7 31 Dec 2024 10:49 AM study24x7 study24x7

Which of the following is a new JSON function in MySQL 8.x?

A

JSON_ARRAYAGG()

B

JSON_OBJECT()

C

JSON_VALUE()

D

All of the above

Web Development PHP
Like Comment Share
study24x7
Write a comment
MySql
4 followers study24x7 30 Dec 2024 10:29 AM study24x7 study24x7

What is the new collation introduced in MySQL 8.x?

A

utf8mb4_0900_ai_ci

B

utf8_general_ci

C

utf16_ai_ci

D

None of the above

Web Development PHP
Like Comment Share
study24x7
Write a comment
MySql
4 followers study24x7 30 Dec 2024 10:29 AM study24x7 study24x7

Which command is used to import a MySQL dump file?

A

IMPORT FILE

B

LOAD DATABASE

C

mysql < dumpfile.sql

D

EXPORT DATABASE

Web Development PHP
Like Comment Share
study24x7
Write a comment
MySql
4 followers study24x7 30 Dec 2024 10:28 AM study24x7 study24x7

What is a common use of the GROUP BY clause?

A

To sort data

B

To group rows that share a property

C

To delete duplicate rows

D

None of the above

Web Development PHP
Like Comment Share
study24x7
Write a comment
MySql
4 followers study24x7 27 Dec 2024 10:57 AM study24x7 study24x7

Which index type does MySQL use for full-text searches?

A

BTREE

B

HASH

C

FULLTEXT

D

None of the above

Web Development PHP
Like Comment Share
study24x7
Write a comment
MySql
4 followers study24x7 27 Dec 2024 10:56 AM study24x7 study24x7

In MySQL, what does ACID stand for?

A

Atomicity, Consistency, Isolation, Durability

B

Automatic, Control, Isolation, Data

C

Access, Create, Insert, Delete

D

None of the above

Web Development PHP
Like Comment Share
study24x7
Write a comment
MySql
4 followers study24x7 27 Dec 2024 10:56 AM study24x7 study24x7

What is the use of the CHARSET keyword?

A

Defines storage engine

B

Specifies character set of the database

C

Sets auto increment values

D

None of the above

Web Development PHP
Like Comment Share
study24x7
Write a comment
MySql
4 followers study24x7 26 Dec 2024 11:25 AM study24x7 study24x7

How do you add a new column to an existing table?

A

ALTER TABLE ADD COLUMN

B

ADD COLUMN TO TABLE

C

MODIFY TABLE ADD

D

UPDATE TABLE STRUCTURE

Web Development PHP
Like Comment Share
study24x7
Write a comment
MySql
4 followers study24x7 26 Dec 2024 11:23 AM study24x7 study24x7

Which command is used to remove a table from the database?

A

DELETE TABLE

B

DROP TABLE

C

REMOVE TABLE

D

TRUNCATE TABLE

Web Development PHP
Like Comment Share
study24x7
Write a comment
MySql
4 followers study24x7 26 Dec 2024 11:23 AM study24x7 study24x7

Which JOIN returns all records from both tables, even if there is no match?

A

INNER JOIN

B

LEFT JOIN

C

RIGHT JOIN

D

FULL OUTER JOIN

Web Development PHP
Like Comment Share
study24x7
Write a comment
MySql
4 followers study24x7 24 Dec 2024 12:27 PM study24x7 study24x7

Which function is used to get the current date and time in MySQL?

A

GET_DATE()

B

NOW()

C

CURRENT_TIMESTAMP()

D

Both B and C

Web Development PHP
Like Comment Share
study24x7
Write a comment
MySql
4 followers study24x7 24 Dec 2024 12:26 PM study24x7 study24x7

What does the AUTO_INCREMENT keyword do?

A

Automatically updates data

B

Increments the primary key value automatically

C

Creates a backup

D

None of the above

Web Development PHP
Like Comment Share
study24x7
Write a comment
Ratings
0.0
out of 5 0 Ratings
5 study24x7
 
0.0
4 study24x7
 
0.0
3 study24x7
 
0.0
2 study24x7
 
0.0
1 study24x7
 
0.0
Related Pages
❮ ❯