Database interview preparation Quiz 4 Welcome to your Fresher Interview Preparation - Database Skills - 1 Name Email Phone Number 1. A _________ index means that two rows cannot have the same index value.speednoneuniquefunctions2. An ____________ in a database resembles an index at the back of a book.functionsnonedataIndex3. A ____________ is a separate application that stores a collection of data.deltabasedatabasenonemetabase4. If a failure occurs, a ______________ command should be issued to return every tablereferenced in the transactions to its previous state.Rollbacknonesubmitcommit5. ____________ lists out the databases that are accessible by the MYSQL DBMS.noneSHOW DATABASESDATABASESSHOW6. A ________________ is a software that enables you to implement a database with tables,columns and indexes.DBMSCDMSnoneRDBMS ( Relational database management system)7. PHP provides various _______________ to access the mysql database and to manipulate thedata records inside the MYSQL database.memoryfunctionsdatanone8. We can use ___________ in the select , update and delete statements to join the MYSQL tables.jointjoijoinsnone9. ____________ ensures that the database properly changes states upon a successfully committedtransaction.consistencyatomicitynonesolation10. if you want to run the Mysql server at boot time, then make sure you have the following entryin the /etc/_________nonebc.localrc.localdc.local11. How to verify whether mysql is running or not ?ps -ef | grep mysqlps -ef | grep mysqldps -efnone12. A _________ is the linking pin between two tablesForiegnnonesecondaryprimary13. There are ________ keywords are mainly used for MYSQL transactions.nonecommitrollbacksubmit14. MYSQL provides ____________ operators to handle null values.4none5315. If you want to delete a record from any Mysql table, then you can use the SQL command________.delete fromfromnonedelete16. ____________ compares values ,which is true even for two null values.<=>none=>17. What is the syntax to drop the table in the mysql ?DROP table table-name ;noneDROPDrop table-name18. _____________ will be used to select a database in the MYSQL workarea.!noneUSEUSE databasenameMUSE19. _________________ presents the details of all indexes on the table.noneSHOW INDEXSHOW INDEX FROM tablenameSHOW20. _____________ is the operator returns true, if the column value is not NULL.noneIS NOT NULLNULLEDIS NULL21. ______________ is the php function which can be used to fetch all the selected data.!nonemysql_fetch_array()data()function()22. Mysql is developed.marketed and supported by ______________Mysql DCMysql BCMysql ABnone23. A _____________ is a matrix with data.nonecabletablenetwork24. What is the syntax to create the table in Mysql ?noneCreate tabletableCREATE TABLE TABLE_NAME (column_name column_type);25. Transaction have the _______ standard properties are :143none26. PHP uses _____________ function to create or delete a MYSQL database.mysql_querymysqlquerynone27. A ____________ is a sequential group of database manipulation operations, which isperformed as if it were one single work unit.sectionnoneTransaction28. To change a column definition use __________ clause along with the alter command.changedmodify or changemodnone29. A _________key is a key that consists of multiple columns, because one column is notsufficiently unique.teraboundsetboundcompoundnone30. _________________ makes sure that a foreign key value always points to an existing row.IntegritynonedataReferential Integrity31. ____________ shows the tables in the database once a database has been selected with the usecommand.SHOW TABLESnoneDSHOWTABLES32. ______________ is the benchmark and performance testing tools for the mysql database server.noneMysql-graphMysql-dataMySQL-bench33. Mysql uses _________ data types:543none34. PHP provides _____________ function to open a database connection.noneconnectmysqlmysql_connect ()35. The _______________ could be very useful in some cases to keep temporary data.nonerowstemporary tablescolumns36. A ___________ is a group of related data.datanonerowfunction37. ____________ ensures that all operations within the work unit are completed successfully.atomicityconsistencyisolationnone38. 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.noneInnoALTERDelta39. A database __________ is a data structure that improves the speed of operations in a table.functionsnoneindexspeed40. There are ________ keywords are mainly used for MYSQL transactions.none43241. ____________ is the popular table which support transactionsinnodbnoneinnodb42. ______________ enables transactions to operate independently on and transparent to eachotherisolationconsistencyatomicitynone43. A _________ key value cannot occur twice in one table.primaryteritarysecondarynone44. We can sort a result set by adding an ___________ clause that names the column or columnswhich you want to sort.noneDATA BYFUNCTION BYORDER BY45. _____________ is the operator returns true, if the column value is NULL.noneNULLEDIS NULLNULL46. To rename a table, use the __________ option of the ALTER TABLE statement!nonevaluedatarename47. A _________ clause will not work if the column is the only one left in the table.nonedropdownpure48. SQL _________ command is used to update the data in the mysql table.modifiednoneupdatedupdate49. We can use the _____________ command to list out all the indexes associated with a table.indexnoneSHOW INDEXshow50. ______________ ensures that the result or effect of a command transaction persists in case of asystem failure.consistencyisolationnoneDurabilityPlease fill in the comment box below. Time is Up!