Question - 1
Attributes of Primary key should be recommended as ______?
- BINARY
- UNSIGNED
- UNSIGNED ZEROFILL
- Nothing
Solutions
Answer- B
Question - 2
When we are creating table and column name created_date and updated date,then what kind od data type is recommended?
- current_timestamp
- datetime
- date
- none of the above
Solutions
Answer- A
Question - 3
Maximum Size varchar ___?
Answer- B
Question - 4
- Multiple Interface Mail Extension
- Multipurpose Internet Mail Extensions
- Multipurpose Interface Mail Extension
- None of the above
Solutions
Answer- B
Question - 5
Maximun how many table can created mysql database?
Answer- D
Question - 6
application/octet-stream is MIME Type of which extension?
Answer- B
Question - 7
Maximun how many column can be created in a table in myql database?
Answer- A
Question - 8
which is the default storage engine in mysql?
Answer- B
Question - 9
Which point is correct for TRUNCATE TABLE statement
- used to remove all records from a table in MySQL
- reset auto increment value
- it wont role back
- all the above
Solutions
Answer- D
Question - 10
How to Delete Indexes from a Table?
- DROP INDEX indexName ON tableName
- ALTER INDEX indexName ON tableName
- DELETE INDEX indexName ON tableName
- None of these
Solutions
Answer- A
Question - 11
In BLOB data type which type of data is being stored?
- Intiger
- character
- BINARY
- datetime
Solutions
Answer- C
Question - 12
Which Storage Enginee supports FOREIGN KEY referential-integrity constraints?
Answer- B
Question - 13
InnoDB Storage Enginee supports which level locking?
- Row level locking
- Table level locking
- Page level locking
- None of the above
Solutions
Answer- A
Question - 14
Which format support when exporting tables from database in phpymyadmin?
- XML
- CSV
- PDF
- All the above
Solutions
Answer- D
Question - 15
Which format support when Importing data to database in phpymyadmin?
- JSON
- CSV
- SQL
- All the above
Solutions
Answer- D
Question - 16
Which below option is not DDL ?
- CREATE
- ALTER
- SELECT
- COMMENT
Solutions
Answer- C
Question - 17
Which below option is not Transaction Control Language (TCL)?
- COMMENT
- ROLLBACK
- SAVEPOINT
- SET TRANSACTION
Solutions
Answer- A
Question - 18
Which Of These Is Not A Valid Name For A Column
Answer- B
Question - 19
How Much Character Are Allowed To Create Database Name?
Answer- A
Question - 20
- Upto 65, 256 Bytes
- Upto 65, 535 Bytes
- Upto 64, 535 Bytes
- None of the above
Solutions
Answer- B
Practice more set questions