Database interview preparation Quiz 4 Welcome to your Fresher Interview Preparation - Database Skills - 1 Name Email Phone Number 1. A _________ clause will not work if the column is the only one left in the table.downnonedroppure2. ____________ is the popular table which support transactionsnoneinnodbinnodb3. We can sort a result set by adding an ___________ clause that names the column or columnswhich you want to sort.ORDER BYDATA BYFUNCTION BYnone4. The _______________ could be very useful in some cases to keep temporary data.columnsnonerowstemporary tables5. What is the syntax to create the table in Mysql ?tablenoneCREATE TABLE TABLE_NAME (column_name column_type);Create table6. if you want to run the Mysql server at boot time, then make sure you have the following entryin the /etc/_________nonerc.localbc.localdc.local7. We can use ___________ in the select , update and delete statements to join the MYSQL tables.joijoinsnonejoint8. SQL _________ command is used to update the data in the mysql table.noneupdatedupdatemodified9. ______________ ensures that the result or effect of a command transaction persists in case of asystem failure.isolationnoneconsistencyDurability10. _____________ will be used to select a database in the MYSQL workarea.!USEnoneMUSEUSE databasename11. A _____________ is a matrix with data.cablenonenetworktable12. A ___________ is a group of related data.functionnonedatarow13. There are ________ keywords are mainly used for MYSQL transactions.34none214. _____________ is the operator returns true, if the column value is NULL.IS NULLnoneNULLEDNULL15. ____________ shows the tables in the database once a database has been selected with the usecommand.TABLESSHOW TABLESnoneDSHOW16. To change a column definition use __________ clause along with the alter command.modify or changemodchangednone17. Transaction have the _______ standard properties are :341none18. A ____________ is a separate application that stores a collection of data.deltabasemetabasenonedatabase19. ______________ enables transactions to operate independently on and transparent to eachotherisolationconsistencynoneatomicity20. If a failure occurs, a ______________ command should be issued to return every tablereferenced in the transactions to its previous state.commitsubmitnoneRollback21. To rename a table, use the __________ option of the ALTER TABLE statement!nonerenamevaluedata22. ______________ is the php function which can be used to fetch all the selected data.!data()function()nonemysql_fetch_array()23. A ____________ is a sequential group of database manipulation operations, which isperformed as if it were one single work unit.sectionnoneTransaction24. There are ________ keywords are mainly used for MYSQL transactions.rollbackcommitnonesubmit25. PHP provides various _______________ to access the mysql database and to manipulate thedata records inside the MYSQL database.datamemorynonefunctions26. _________________ presents the details of all indexes on the table.SHOW INDEX FROM tablenameSHOWSHOW INDEXnone27. ____________ ensures that the database properly changes states upon a successfully committedtransaction.noneconsistencyatomicitysolation28. ____________ ensures that all operations within the work unit are completed successfully.atomicitynoneconsistencyisolation29. Mysql uses _________ data types:none43530. A _________ key value cannot occur twice in one table.primarysecondarynoneteritary31. MYSQL provides ____________ operators to handle null values.none35432. ______________ is the benchmark and performance testing tools for the mysql database server.MySQL-benchnoneMysql-dataMysql-graph33. A ________________ is a software that enables you to implement a database with tables,columns and indexes.DBMSnoneCDMSRDBMS ( Relational database management system)34. We can use the _____________ command to list out all the indexes associated with a table.noneindexshowSHOW INDEX35. The _________ command is very useful when you want to change a name of your table, anytable field or if you want to add or delete an existing column in a table.InnononeDeltaALTER36. _________________ makes sure that a foreign key value always points to an existing row.Referential IntegritydataIntegritynone37. Mysql is developed.marketed and supported by ______________Mysql DCnoneMysql ABMysql BC38. A _________ index means that two rows cannot have the same index value.speeduniquenonefunctions39. How to verify whether mysql is running or not ?noneps -ef | grep mysqlps -ef | grep mysqldps -ef40. If you want to delete a record from any Mysql table, then you can use the SQL command________.deletenonedelete fromfrom41. _____________ is the operator returns true, if the column value is not NULL.IS NOT NULLNULLEDnoneIS NULL42. PHP uses _____________ function to create or delete a MYSQL database.querynonemysqlmysql_query43. PHP provides _____________ function to open a database connection.noneconnectmysql_connect ()mysql44. An ____________ in a database resembles an index at the back of a book.Indexnonedatafunctions45. A _________ is the linking pin between two tablesprimarynonesecondaryForiegn46. A _________key is a key that consists of multiple columns, because one column is notsufficiently unique.teraboundcompoundsetboundnone47. What is the syntax to drop the table in the mysql ?DROPnoneDrop table-nameDROP table table-name ;48. ____________ compares values ,which is true even for two null values.><=>none=49. A database __________ is a data structure that improves the speed of operations in a table.speedindexfunctionsnone50. ____________ lists out the databases that are accessible by the MYSQL DBMS.noneSHOWDATABASESSHOW DATABASESPlease fill in the comment box below. Time is Up!