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:
SQL stands for ______.
A
Structured Query Language
B
Structured Queue Language
C
Standard Query Language
D
Structured Query Level
Note:
Not available
Show answer
Show Note
Report
Question:
Which of the following are MySql Features?
A
Replication
B
Query Caching
C
Storage
D
Security
Note:
Not available
Show answer
Show Note
Report
Question:
What are the MySql License Options?
A
MySql Open Source License
B
MySql Personal Edition License
C
Commercial License
D
Enterprise Edition License
Note:
Not available
Show answer
Show Note
Report
Question:
Which of the following are MySql 5.0 Features?
A
Complete Foreign key Support
B
Stored Procedure Support
C
Integrated Report support
D
Batch Query Support
Note:
Not available
Show answer
Show Note
Report
Question:
What are the storage engine of MySql?
A
HDD
B
InnoDB
C
MyISM
D
Backup
Note:
Not available
Show answer
Show Note
Report
Question:
How to set the administrator password?
A
SET ADMINISTRATOR FOR root@localhost=PASSWORD('secret');
B
SET ROOT PASSWORD FOR root@localhost=PASSWORD('secret');
C
SET PASSWORD FOR root@localhost=PASSWORD('secret');
D
SET PASSWORD FOR Admininstrator@localhost=PASSWORD('secret');
Note:
Not available
Show answer
Show Note
Report
Question:
Which of the following are true about MySqL Client?
A
capable of managing almost every conceivable aspect of a MySQL server, including creating, modifying, and deleting tables and databases
B
Capable of Database backup, Restore etc
C
Viewing Configuration Variables and System Status
D
none
Note:
Not available
Show answer
Show Note
Report
Question:
Where is the greatest use of mysql server?
A
Full text indexing and searching
B
Query caching
C
Replication
D
Security
Note:
Not available
Show answer
Show Note
Report
Question:
Which is the correct coding for executing variables of mysql?
A
mysql>show variable "table_type"
B
mysql>show variables like "table_type"
C
mysql>show stats
D
None
Note:
Not available
Show answer
Show Note
Report
Question:
Which of the following are not data type?
A
ENUM()
B
SET()
C
BINARY
D
NATIONAL
Note:
Not available
Show answer
Show Note
Report
First
Prev
1
2
3
Next
Last
/16
Go
Schools
App Store
Whiteboard
Blogs
Quiz
Test
Apply Course
Games
Freelancers
Professionals
Newspapers
Terms
Privacy
Copyright © 2024. Powered by
Intellect Software Ltd