MySQL
Test
Model Test
Ebook
Quiz-1 : Basic, MySQL
Quiz-4 : MySQL Client, MySQL
Quiz-5 : MySQL Server, MySQL
Quiz-7 : DML, MySQL
Quiz-8 : DDL, MySQL
Quiz-9 : DCL, MySQL
Quiz-17 : Datatype, MySQL
Index
MySQL Home
Basic
9
MySQL Server
18
Installation
17
Security
4
MySQL Client
31
Datatype
25
DML
16
DDL
7
Operator
1
Trigger
11
Access Control
2
Maintaining and Optimization
4
DCL
5
Privileges
1
Funtion
4
Schools
Ebook
Question:
To backup both the structure and the data of two tables: book and user from test database to file "d:/backup.txt" we use %>mysqldump -u root -p ______ test book user>d:/backup.txt
A
--add-drop-table
Note:
Not available
Show answer
Show Note
Report
Question:
Which is the no data type attribute?
A
auto-increment
B
binary
C
index
D
string
Note:
Not available
Show answer
Show Note
Report
Question:
______ utility offers a convenient means for determining which databases, tables, and columns exist on a given database server.
A
mysqlshow
Note:
Not available
Show answer
Show Note
Report
Question:
______ is a robust transactional stroge engine.
A
InnoDB
Note:
Not available
Show answer
Show Note
Report
Question:
The ______ storage engine stores table data in a comma-separated format similar to that supported by many applications.
A
CSV
Note:
Not available
Show answer
Show Note
Report
Question:
______ storage engine as a basic template for understanding how these engines are created.
A
EXAMPLE
Note:
Not available
Show answer
Show Note
Report
Question:
The A) ______ storage engine greatly compresses any data found in a table of this type by using the B) ______ compression library.
A
ARCHIVE
B
zlib
Note:
Not available
Show answer
Show Note
Report
Question:
How many MySQL privilege system revives around concepts?
A
2
B
3
C
4
D
5
Note:
Not available
Show answer
Show Note
Report
Question:
The ______ storage engine operates just like the MyISAM engine except that it won't store any data.
A
BLACKHOLE
Note:
Not available
Show answer
Show Note
Report
Question:
How many ways password stored hashed format?
A
One
B
Two
C
three
D
Four
Note:
Not available
Show answer
Show Note
Report
First
Prev
7
8
9
10
11
Next
Last
/16
Go
Schools
App Store
Whiteboard
Blogs
Quiz
Test
Apply Course
Games
Freelancers
Professionals
Newspapers
Terms
Privacy
Copyright © 2025. Powered by
Intellect Software Ltd