163
86.7k

180+ Advanced Web Technologies Solved MCQs

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

Chapter: Web Techniques
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
Chapter: DataBases
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.