Question - 1
DBMS
RDBMS
NoSQL
None of the above
Answer- B
Question - 2
Which below option is not table in MySQL?
MyISAM
INNODB
Merge
INdex
Answer- D
Question - 3
How to get current MySQL version?
GET VERSION ();
SELECT VERSION ();
SELECT VER();
GET_VER();
Answer- B
Question - 4
Which is the driver used in MySQL?
PHP Driver
JDBC Driver
PYTHON Driver
All the above
Answer- D
Question - 5
It compress the MyISAM tables
It check the errors the MyISAM tables
It parse the MyISAM tables
None of the above
Answer- A
Question - 6
How can you see all indexes defined for a table?
LS INDEX FROM
SHOW INDEX FROM
GET INDEX FROM
FIND INDEX FROM
Answer- B
Question - 7
How to display top 50 rows?
SELECT * FROM TABLE_NAME LIMIT 0,50;
SELECT * FROM TABLE_NAME LIMIT 1,50;
SELECT * FROM TABLE_NAME LIMIT 50;
None of the above
Answer- A
Question - 8
How many columns can be used for creating Index?
Maximum 6
Maximum 10
Maximum 12
Maximum 16
Answer- D
Question - 9
InnoDB supports ____locking?
row locks
table locks
row locks and table locks
None of the above
Answer- C
Question - 10
MyISAM supports ____locking?
table-level-locking
row-level-locking
Both A & B
None of the above
Answer- A
Question - 11
How many TRIGGERS are allowed in MySql table?
Answer- C
Question - 12
What is the default port for MySQL Server?
Answer- A
Question - 13
Which is the default storage engine in mysql
InnoDB
MyISAM
Heap
None of the above
Answer- A
Question - 14
In Below options which is not DML?
Answer- D
Question - 15
In Below options which is not DDL?
ALTER
DROP
LOCK TABLE
COMMENT
Answer- C
Question - 16
In Below options which is a DCL?
GRANT
INSERT
RENAME
TRUNCATE
Answer- A
Question - 17
Which Program Copies The Databases From One Server To Another?
Mysqlcopydb
Mysqldbcopy
CopyMysqldb
None of the above
Answer- B
Question - 18
To Use 'mysqldbcopy' Which Privileges Are Required On The Source Server?
CREATE
INSERT
SELECT
UPDATE
Answer- C
Question - 19
Which Function Returns Reference To Array Of Row Values?
Fetchrow_array()
Fetchrow_arrayref()
Fetchrow_hashref()
None of the above
Answer- B
Question - 20
Which Among The Following Have The Maximum Bytes?
Answer- C
Practice more set questions
