McqMate
These multiple-choice questions (MCQs) are designed to enhance your knowledge and understanding in the following areas: Bachelor of Computer Applications (BCA) , Bachelor of Business Administration in Computer Applications (BBA [CA]) .
Chapters
| 1. |
Which one of the following databases has PHP supported almost since the beginning? |
| A. | Oracle Database |
| B. | SQL |
| C. | SQL+ |
| D. | MySQL |
| Answer» D. MySQL | |
| 2. |
Which one of the following statements is used to create a table? |
| A. | CREATE TABLE table_name (column_namecolumn_type); |
| B. | CREATE table_name (column_typecolumn_name); |
| C. | . CREATE table_name (column_namecolumn_type); |
| D. | . CREATE TABLE table_name (column_typecolumn_name); |
| Answer» A. CREATE TABLE table_name (column_namecolumn_type); | |
| 3. |
Which method returns the error code generated from the execution of the last MySQL function? |
| A. | errno() |
| B. | . errnumber() |
| C. | . errorno() |
| D. | errornumber() |
| Answer» A. errno() | |
| 4. |
If there is no error, then what will the error() method return? |
| A. | . TRUE |
| B. | . FALSE |
| C. | . Empty String |
| D. | . non of these |
| Answer» C. . Empty String | |
| 5. |
Which one of the following statements should be used to include a file? |
| A. | . #include ‘filename’; |
| B. | include ‘filename’; |
| C. | include <filename> |
| D. | none of these |
| Answer» B. include ‘filename’; | |
| 6. |
Which one of the following methods recuperates any memory consumed by a result set? |
| A. | destroy() |
| B. | remover() |
| C. | alloc() |
| D. | free() |
| Answer» D. free() | |
| 7. |
Which one of the following methods can be used to diagnose and display information about a MySQL connection error? |
| A. | . connect_errno() |
| B. | connect_error() |
| C. | mysqli_connect_errno() |
| D. | . mysqli_connect_error() |
| Answer» C. mysqli_connect_errno() | |
| 8. |
Which method retrieves each row from the prepared statement result and assigns the fields to the bound results? |
| A. | get_row() |
| B. | . fetch_row() |
| C. | . fetch() |
| D. | row() |
| Answer» C. . fetch() | |
| 9. |
Which one of the Following methods is responsible for sending the query to Database |
| A. | query() |
| B. | send_query( ) |
| C. | sendquery() |
| D. | query_send() |
| Answer» A. query() | |
| 10. |
Which is the comment symbol in mysql? |
| A. | && |
| B. | /*….*/ |
| C. | # |
| D. | % |
| Answer» C. # | |
| 11. |
A ________ consists of one or more tables. |
| A. | database |
| B. | command |
| C. | Query |
| D. | none of these |
| Answer» A. database | |
| 12. |
________ is used to uniquely identify the rows in table. |
| A. | primary key |
| B. | Database |
| C. | not null |
| D. | none of these |
| Answer» A. primary key | |
| 13. |
_____ returns the last error description for the most recent function call |
| A. | Error no |
| B. | Zero no |
| C. | no error |
| D. | none of these |
| Answer» A. Error no | |
| 14. |
A _______ is a server that manages data for user. |
| A. | Wamp |
| B. | World |
| C. | Excel |
| D. | none of these |
| Answer» A. Wamp | |
| 15. |
RDBMS stands for __________. |
| A. | Relation data base management |
| B. | reletives data base management |
| C. | Random data base management |
| D. | none of these |
| Answer» A. Relation data base management | |
| 16. |
In PHP $Icon=mySQL_connect("localhost","root","") is used to ____ to the data base . |
| A. | create |
| B. | close |
| C. | connect |
| D. | none of these |
| Answer» C. connect | |
| 17. |
mysql_close() is use to ________database(wamp) in php . |
| A. | create |
| B. | close |
| C. | connect |
| D. | none of these |
| Answer» B. close | |
| 18. |
______ is use to create the web page . |
| A. | Word press |
| B. | Lotus |
| C. | Word star |
| D. | none of these . |
| Answer» A. Word press | |
| 19. |
die(mySQL_error()) is used to show _______ message . |
| A. | error |
| B. | Connect |
| C. | create |
| D. | none of these |
| Answer» A. error | |
| 20. |
The long form of SQL is __________. |
| A. | Structural query language |
| B. | Structural question language |
| C. | System Query Language |
| D. | None of these |
| Answer» A. Structural query language | |
| 21. |
the switch statement is used to perform different actions based on different conditions |
| A. | true |
| B. | false |
| C. | both a and b |
| D. | none of these |
| Answer» A. true | |
| 22. |
In PHP, we have the following loop types: |
| A. | while loop |
| B. | for loop |
| C. | foreach |
| D. | all the these. |
| Answer» D. all the these. | |
| 23. |
PHP recognize constructors by the name. |
| A. | ) class name() |
| B. | _construct() |
| C. | function _construct() |
| D. | function __construct( |
| Answer» B. _construct() | |
| 24. |
Which version of PHP introduced the instance of keyword? |
| A. | PHP 4 |
| B. | . PHP 5 |
| C. | . PHP 5.3 |
| D. | . PHP 6 |
| Answer» B. . PHP 5 | |
| 25. |
Which one of the following functions is used to determine whether a class exists? |
| A. | exist() |
| B. | exist_class() |
| C. | class_exist() |
| D. | txist() |
| Answer» A. exist() | |
| 26. |
Which one of the following functions is used to determine object type? |
| A. | ) obj_type() |
| B. | type() |
| C. | is_a() |
| D. | is_obj() |
| Answer» A. ) obj_type() | |
| 27. |
Which one of the following keyword is used to inherit our subclass into a super class? |
| A. | . extends |
| B. | . implements |
| C. | . inherit |
| D. | . include |
| Answer» A. . extends | |
| 28. |
Which keyword is used to refer to properties or methods within the class itself? |
| A. | . private |
| B. | public |
| C. | protected |
| D. | . $this |
| Answer» A. . private | |
| 29. |
Which keyword allows class members (methods and properties) to be used without needing to instantiate a new instance of the class? |
| A. | protected |
| B. | . final |
| C. | static |
| D. | private |
| Answer» B. . final | |
| 30. |
HTTP stands for ___________. |
| A. | Hyper text transfer protocol |
| B. | hyper text mark protcol |
| C. | File transfer protocol |
| D. | none of these |
| Answer» A. Hyper text transfer protocol | |
| 31. |
To upload the file ________ array is used. |
| A. | $Files |
| B. | $load |
| C. | $New |
| D. | none of these |
| Answer» B. $load | |
| 32. |
PHP was designed as a ________ scripting language. |
| A. | Sever side |
| B. | client slide |
| C. | c++ |
| D. | none of these |
| Answer» A. Sever side | |
| 33. |
mysql_close() is use to ________database(wamp) in php . |
| A. | create |
| B. | close |
| C. | connect |
| D. | none of these |
| Answer» A. create | |
Done Studing? Take A Test.
Great job completing your study session! Now it's time to put your knowledge to the test. Challenge yourself, see how much you've learned, and identify areas for improvement. Don’t worry, this is all part of the journey to mastery. Ready for the next step? Take a quiz to solidify what you've just studied.