

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
51. |
HTTP stands for ___________. |
A. | Hyper text transfer protocol |
B. | hyper text mark protocol |
C. | File transfer protocol |
D. | none of these |
Answer» A. Hyper text transfer protocol |
52. |
Get and ________ are two HTTP methods that a client use to pass from data server. |
A. | get |
B. | Post |
C. | Server |
D. | Client |
Answer» B. Post |
53. |
______ tag is used for multiple selections. |
A. | select tag |
B. | text tag |
C. | list tag |
D. | none of these |
Answer» A. select tag |
54. |
To upload the file ________ array is used. |
A. | $Files |
B. | $load |
C. | $New |
D. | none of these |
Answer» A. $Files |
55. |
PHP was designed as a ________ scripting language. |
A. | Sever side |
B. | client slide |
C. | compiler |
D. | none of these |
Answer» A. Sever side |
56. |
____________is about communication between web clients and servers |
A. | WWW |
B. | HTML |
C. | TCP |
D. | FTP |
Answer» A. WWW |
57. |
Communication between client computers and web servers is done by sending _________________. |
A. | HTTP request & HTTP Responses |
B. | GET & POST |
C. | TCP & FTP |
D. | none of these |
Answer» A. HTTP request & HTTP Responses |
58. |
A ______is a small file that the server embeds on the user's computer. Each time the same computer requests a page with a browser, it will send the ________ too. |
A. | Cookie & cookie |
B. | FTP & TCP |
C. | GET & POST |
D. | HTTP request & HTTP Responses |
Answer» A. Cookie & cookie |
59. |
_______ statements reduce parsing time as the preparation on the query is done only once (although the statement is executed multiple times) |
A. | Prepared |
B. | fetch |
C. | array |
D. | SSL |
Answer» A. Prepared |
60. |
The MySQLi functions allows you to access______ database servers. |
A. | Mysql |
B. | SSL |
C. | Fetch |
D. | none of these |
Answer» A. Mysql |
61. |
The____ function fetches a result row as an associative array, a numeric array, or both. |
A. | fetch array() |
B. | Cookie() |
C. | S_Array() |
D. | D_array() |
Answer» A. fetch array() |
62. |
The ssl_set()function is used to establish secure connections using _____ |
A. | secure socket layer (SSL) |
B. | Mysql |
C. | http |
D. | none of these |
Answer» A. secure socket layer (SSL) |
63. |
__________ function is used to change the default database for the connection. |
A. | fetch_array() |
B. | Cookie() |
C. | S_Array() |
D. | mysqli_select_db() |
Answer» D. mysqli_select_db() |
64. |
An inherited class is defined by using the ______ keyword. |
A. | extends |
B. | constructor |
C. | object |
D. | none of these |
Answer» A. extends |
65. |
Abstract classes and methods are when the parent class has a named method, but need its child class(es) to fill out the tasks. |
A. | true |
B. | false |
C. | both a and b |
D. | none of these |
Answer» A. true |
66. |
An abstract class is a class that contains at least one abstract method. An abstract method is a method that is declared, but not implemented in the code. |
A. | true |
B. | false |
C. | both a and b |
D. | none of these |
Answer» A. true |
67. |
When inheriting from an abstract class, the child class method must be defined with the same name, and the same or a less restricted access modifier. |
A. | true |
B. | false |
C. | both a and b |
D. | none of these |
Answer» A. true |
68. |
Interfaces allow you to specify what methods a class should implement. |
A. | true |
B. | false |
C. | both a and b |
D. | none of these |
Answer» A. true |
69. |
Interfaces are declared with the ________ keyword: |
A. | interface |
B. | abstract class |
C. | implements |
D. | None of these |
Answer» A. interface |
70. |
Interface are similar to abstract classes. The difference between interfaces and abstract classes are Interfaces cannot have properties, while abstract classes can have. |
A. | interface |
B. | abstract class |
C. | implements |
D. | None of these |
Answer» A. interface |
71. |
To implement an interface, a class must use the______ keyword. |
A. | interface |
B. | abstract class |
C. | implements |
D. | None of these |
Answer» C. implements |
72. |
In PHP, there are three types of arrays one is not type of array in php which one: |
A. | Indexed arrays - |
B. | Associative arrays - |
C. | Multidimensional arrays - |
D. | polygamy array |
Answer» D. polygamy array |
73. |
An inherited class is defined by using the extends keyword. |
A. | true |
B. | false |
C. | both a and b |
D. | none of these |
Answer» A. true |
74. |
Classes and objects are the two main aspects of __________________ |
A. | object oriented programming |
B. | constructor and destructor |
C. | object and array |
D. | none of these |
Answer» A. object oriented programming |
75. |
A constructor allows you to initialize an object's properties upon creation of the object. |
A. | true |
B. | false |
C. | both a and b |
D. | none of these |
Answer» A. true |
76. |
If you create a _______function, PHP will automatically call this function when you create an object from a class. |
A. | __construct() |
B. | ___destruct() |
C. | both a and b |
D. | none of these |
Answer» A. __construct() |
77. |
A destructor is called when the object is destructed or the script is stopped or exited. |
A. | true |
B. | false |
C. | both a and b |
D. | none of these |
Answer» A. true |
78. |
A cookie is a small file that the server embeds on the user's computer. Each time the same computer requests a page with a browser, it will send the cookie too. With PHP, you can both create and retrieve cookie values. |
A. | true |
B. | false |
C. | both a and b |
D. | none of these |
Answer» A. true |
79. |
A session is a way to store information (in variables) to be used across multiple pages. |
A. | true |
B. | false |
C. | both a and b |
D. | none of these |
Answer» A. true |
80. |
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 |
81. |
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); |
82. |
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() |
83. |
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 |
84. |
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’; |
85. |
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() |
86. |
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() |
87. |
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() |
88. |
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() |
89. |
Which is the comment symbol in mysql? |
A. | && |
B. | /*….*/ |
C. | # |
D. | % |
Answer» C. # |
90. |
A ________ consists of one or more tables. |
A. | database |
B. | command |
C. | Query |
D. | none of these |
Answer» A. database |
91. |
________ 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 |
92. |
_____ 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 |
93. |
A _______ is a server that manages data for user. |
A. | Wamp |
B. | World |
C. | Excel |
D. | none of these |
Answer» A. Wamp |
94. |
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 |
95. |
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 |
96. |
mysql_close() is use to ________database(wamp) in php . |
A. | create |
B. | close |
C. | connect |
D. | none of these |
Answer» B. close |
97. |
______ is use to create the web page . |
A. | Word press |
B. | Lotus |
C. | Word star |
D. | none of these . |
Answer» A. Word press |
98. |
die(mySQL_error()) is used to show _______ message . |
A. | error |
B. | Connect |
C. | create |
D. | none of these |
Answer» A. error |
99. |
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 |
100. |
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 |
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.