McqMate
These multiple-choice questions (MCQs) are designed to enhance your knowledge and understanding in the following areas: Computer Science Engineering (CSE) .
| 151. |
Which of the following is not a fundamental quantity? |
| A. | length |
| B. | angle |
| C. | time |
| D. | luminous intensity |
| Answer» B. angle | |
| Explanation: derived units are those expressed in terms of fundamental units. primary or | |
| 152. |
Which standard is fixed and used for industrial laboratories? |
| A. | international standard |
| B. | primary standard |
| C. | secondary standard |
| D. | working standard |
| Answer» C. secondary standard | |
| Explanation: secondary standards are fixed and used in industrial laboratories. working standards as its name suggests is used for day to day measurements. international standards are accepted internationally and primary standards are used in different parts of world which will not be accessible outside for calibration. | |
| 153. |
Which of the following error is caused by poor calibration of the instrument? |
| A. | random error |
| B. | gross error |
| C. | systematic error |
| D. | precision error |
| Answer» C. systematic error | |
| Explanation: systematic errors are caused by poor calibration of instruments. | |
| 154. |
How systematic errors are eliminated? |
| A. | frequent measurement |
| B. | replacement of instrument |
| C. | finding mean of reading |
| D. | finding variance of reading |
| Answer» B. replacement of instrument | |
| Explanation: the possible way of eliminating systematic error is the replacement of instruments. systematic errors are caused by poor instrument calibration. | |
| 155. |
Which of the following represents an SI unit of luminous intensity? |
| A. | lumen |
| B. | candela |
| C. | dioptre |
| D. | none of the mentioned |
| Answer» B. candela | |
| Explanation: si unit of luminous intensity is candela represented by cd. luminous intensity is a photometric quantity. | |
| 156. |
Starting position of an object is represented as x=5.1±0.2m and finishing position as y=6.9±0.3m. What will be the displacement and error in displacement? |
| A. | displacement = 1m, error = 0.5m |
| B. | displacement = 2m, error = 0.36m |
| C. | displacement = 1.8m, error = 0.36m |
| D. | displacement = 1.5m, error = 0.4m |
| Answer» C. displacement = 1.8m, error = 0.36m | |
| Explanation: displacement between two positions represented as x±Δx and y±Δy is iy-xi and error in displacement is (Δx2 +Δy2)1/2. | |
| 157. |
The maximum number of indexes on MyISAM table is |
| A. | 0 |
| B. | 1 |
| C. | 2 |
| D. | more than 1 |
| Answer» D. more than 1 | |
| Explanation: in mysql, for a myisam table, there can be more than one indexes. the data rows of the myisam table are stored in a data file and the index values are stored in a separate index file. | |
| 158. |
The data rows of a MyISAM table are stored in |
| A. | data file |
| B. | index file |
| C. | log file |
| D. | error file |
| Answer» A. data file | |
| Explanation: the data rows of the myisam table are stored in a data file and the index values are stored in a separate index file. in mysql, for a myisam table, there can be more than one indexes. | |
| 159. |
In a single table (with 10 columns) join query the number of values needed to examine per column is |
| A. | 1 |
| B. | 10 |
| C. | 0 |
| D. | 2 |
| Answer» B. 10 | |
| Explanation: for indexing in the context of performing joins, in a single table query, the number of values that are needed to be examined per column is the number of rows in the table. | |
| 160. |
FROM tbl_1 INNER JOIN tbl_2 WHERE tbl_1.i1 = tbl_2.i2; |
| A. | 14 |
| B. | 2 |
| C. | 1 |
| D. | 48 |
| Answer» D. 48 | |
| Explanation: in mysql, when the tables are unindexed, the searches are run through all the possible combinations. in this case, the search space is 8 x 6 = 48, the product of the number of rows. | |
| 161. |
MyISAM, InnoDB, TRANSACTION |
| A. | 0 |
| B. | 1 |
| C. | 2 |
| D. | 3 |
| Answer» B. 1 | |
| Explanation: in mysql, all the myisam tables shared tablespace files size if bound by the operating system file size limits. for innodb tables shared tablespaces, it is not bound by this factor. | |
| 162. |
If a column contains 7 values and 6 distinct values, the cardinality is |
| A. | 7 |
| B. | 6 |
| C. | 13 |
| D. | 1 |
| Answer» B. 6 | |
| Explanation: in mysql, the cardinality of a column is the number of distinct values that it contains. a column that contains the values 1, 2, 3, 4, 4, 5, 6 has a cardinality of six and not seven. | |
| 163. |
For a table having 4 columns, the number of columns to which hash function is applied when using hash indexes is |
| A. | 1 |
| B. | 2 |
| C. | 3 |
| D. | 4 |
| Answer» D. 4 | |
| Explanation: in mysql, for the hash indexes, a hash function is applied to each of the column values. the resulting hash values are stored in the index and used to perform lookups on it. | |
| 164. |
The slow query log is written as |
| A. | numbers |
| B. | text |
| C. | image |
| D. | graph |
| Answer» B. text | |
| Explanation: in mysql, the slow query log is written as text, so it is viewable with any file display program. the mysqldumpslow utility can also be used to summarize the contents of the same. | |
| 165. |
In ordered indices the file containing the records is sequentially ordered, a is an index whose search key also defines the sequential order of the file. |
| A. | clustered index |
| B. | structured index |
| C. | unstructured index |
| D. | nonclustered index |
| Answer» A. clustered index | |
| Explanation: clustering index are also called primary indices; the term primary index may appear to denote an index on a primary key, but | |
| 166. |
Indices whose search key specifies an order different from the sequential order of the file are called indices. |
| A. | nonclustered |
| B. | secondary |
| C. | all of the mentioned |
| D. | none of the mentioned |
| Answer» C. all of the mentioned | |
| Explanation: nonclustering index is also called secondary indices. | |
| 167. |
An consists of a search-key value and pointers to one or more records with that value as their search-key value. |
| A. | index entry |
| B. | index hash |
| C. | index cluster |
| D. | index map |
| Answer» A. index entry | |
| Explanation: the pointer to a record consists of the identifier of a disk block and an offset within the disk block to identify the record within the block. | |
| 168. |
In a clustering index, the index record contains the search-key value and a pointer to the first data record with that search- key value and the rest of the records will be in the sequential pointers. |
| A. | dense |
| B. | sparse |
| C. | straight |
| D. | continuous |
| Answer» A. dense | |
| Explanation: in a dense nonclustering index, the index must store a list of pointers to all records with the same search-key value. | |
| 169. |
Incase the indices values are larger, index is created for these values of the index. This is called |
| A. | pointed index |
| B. | sequential index |
| C. | multilevel index |
| D. | multiple index |
| Answer» C. multilevel index | |
| Explanation: indices with two or more levels are called multilevel indices. | |
| 170. |
A search key containing more than one attribute is referred to as a search key. |
| A. | simple |
| B. | composite |
| C. | compound |
| D. | secondary |
| Answer» B. composite | |
| Explanation: the structure of the index is the same as that of any other index, the only difference being that the search key is not a single attribute, but rather is a list of attributes. | |
| 171. |
In B+ tree the node which points to another node is called |
| A. | leaf node |
| B. | external node |
| C. | final node |
| D. | internal node |
| Answer» D. internal node | |
| Explanation: nonleaf nodes are also referred to as internal nodes. | |
| 172. |
appears for only some of the search-key values. |
| A. | dense |
| B. | sparse |
| C. | straight |
| D. | continuous |
| Answer» A. dense | |
| Explanation: sparse indices can be used only if | |
| 173. |
return index; |
| A. | o(nlogn) |
| B. | o(logn) |
| C. | o(n) |
| D. | o(1) |
| Answer» C. o(n) | |
| Explanation: worst case is when the desired | |
| 174. |
OLAP stands for |
| A. | online analytical processing |
| B. | online analysis processing |
| C. | online transaction processing |
| D. | online aggregate processing |
| Answer» A. online analytical processing | |
| Explanation: olap is the manipulation of information to support decision making. | |
| 175. |
data. |
| A. | multidimensional |
| B. | singledimensional |
| C. | measured |
| D. | dimensional |
| Answer» A. multidimensional | |
| Explanation: given a relation used for data analysis, we can identify some of its attributes | |
| 176. |
The generalization of cross-tab which is represented visually is which is also called as data cube. |
| A. | two dimensional cube |
| B. | multidimensional cube |
| C. | n-dimensional cube |
| D. | cuboid |
| Answer» A. two dimensional cube | |
| Explanation: each cell in the cube is identified for the values for the three dimensional attributes. | |
| 177. |
The process of viewing the cross-tab (Single dimensional) with a fixed value of one attribute is |
| A. | slicing |
| B. | dicing |
| C. | pivoting |
| D. | both slicing and dicing |
| Answer» A. slicing | |
| Explanation: the slice operation selects one particular dimension from a given cube and provides a new sub-cube. dice selects two or more dimensions from a given cube and provides a new sub-cube. | |
| 178. |
The operation of moving from finer- granularity data to a coarser granularity (by means of aggregation) is called a |
| A. | rollup |
| B. | drill down |
| C. | dicing |
| D. | pivoting |
| Answer» A. rollup | |
| Explanation: the opposite operation—that of moving fromcoarser-granularity data to finer- granularity data—is called a drill down. | |
| 179. |
In SQL the cross-tabs are created using |
| A. | slice |
| B. | dice |
| C. | pivot |
| D. | all of the mentioned |
| Answer» A. slice | |
| Explanation: pivot (sum(quantity) for color in (’dark’,’pastel’,’white’)). | |
| 180. |
This can be achieved by using which of the following ? |
| A. | group by rollup |
| B. | group by cubic |
| C. | group by |
| D. | none of the mentioned |
| Answer» D. none of the mentioned | |
| Explanation: ‘group by cube’ is used . | |
| 181. |
What do data warehouses support? |
| A. | olap |
| B. | oltp |
| C. | olap and oltp |
| D. | operational databases |
| Answer» A. olap | |
| Explanation: none. 9. | |
| 182. |
How many grouping is possible in this rollup? |
| A. | 8 |
| B. | 4 |
| C. | 2 |
| D. | 1 |
| Answer» B. 4 | |
| Explanation: { (item name, color, clothes size), (item name, color), (item name), () }. | |
| 183. |
Which one of the following is the right syntax for DECODE? |
| A. | decode (search, expression, result [, search, result]… [, default]) |
| B. | decode (expression, result [, search, result]… [, default], search) |
| C. | decode (search, result [, search, result]… [, default], expression) |
| D. | decode (expression, search, result [, search, result]… [, default]) |
| Answer» D. decode (expression, search, result [, search, result]… [, default]) | |
| Explanation: none. | |
| 184. |
A piece of icon or image on a web page associated with another webpage is called |
| A. | url |
| B. | hyperlink |
| C. | plugin |
| D. | extension |
| Answer» B. hyperlink | |
| Explanation: urls are locators for resources present on the world wide web. a plugin provides extra functionality to the webpage. an extension provides modification allowance for the core functionality of a webpage. hyperlink is piece of icon or image on a web page associated with another webpage. | |
| 185. |
Dynamic web page |
| A. | is same every time whenever it displays |
| B. | generates on demand by a program or a request from browser |
| C. | both is same every time whenever it displays and generates on demand by a program or a request from browser |
| D. | is different always in a predefined order |
| Answer» B. generates on demand by a program or a request from browser | |
| Explanation: a dynamic web page provides different content every time the user opens it based on some events like new additions or time of the day. languages such as javascript are used to respond to client-side events while languages such as php as used to respond to server-side events. | |
| 186. |
What is a web browser? |
| A. | a program that can display a web page |
| B. | a program used to view html documents |
| C. | it enables user to access the resources of internet |
| D. | all of the mentioned |
| Answer» D. all of the mentioned | |
| Explanation: a web browser is an application program that is used to access the world wide web resources, applications and websites. some examples of web browsers are google chrome, internet explorer and safari. | |
| 187. |
Common gateway interface is used to |
| A. | generate executable files from web content by web server |
| B. | generate web pages |
| C. | stream videos |
| D. | download media files |
| Answer» A. generate executable files from web content by web server | |
| Explanation: cgi is an interface through servers can run execute console-based executable files on a web server that generates dynamic web pages. a cgi script executes only when a request is made. the script then generates html. | |
| 188. |
URL stands for |
| A. | unique reference label |
| B. | uniform reference label |
| C. | uniform resource locator |
| D. | unique resource locator |
| Answer» C. uniform resource locator | |
| Explanation: the uniform resource locator is a locator for the resource to be located by http on the world wide web. the url is derived from the uniform resource identifier. | |
| 189. |
A web cookie is a small piece of data that is |
| A. | sent from a website and stored in user’s web browser while a user is browsing a website |
| B. | sent from user and stored in the server while a user is browsing a website |
| C. | sent from root server to all servers |
| D. | sent from the root server to other root servers |
| Answer» A. sent from a website and stored in user’s web browser while a user is browsing a website | |
| Explanation: a web cookie is a small piece of data sent from a website and stored in user’s web browser while a user is browsing the website and is used to remember stateful information about the user’s operations on the website. this can help the website provide a better browsing experience to the user. | |
| 190. |
Which one of the following is not used to generate dynamic web pages? |
| A. | php |
| B. | asp.net |
| C. | jsp |
| D. | css |
| Answer» D. css | |
| Explanation: css alone cannot be used to generate dynamic web pages as it does not provide many event handling functions. it can be used along with javascript to generate dynamic web pages which are visually compelling. | |
| 191. |
An alternative to JavaScript on windows platform is |
| A. | vbscript |
| B. | asp.net |
| C. | jsp |
| D. | php |
| Answer» A. vbscript | |
| Explanation: vbscript is a general-purpose, | |
| 192. |
The set of loosely connected computers are called as |
| A. | lan |
| B. | wan |
| C. | workstation |
| D. | cluster |
| Answer» D. cluster | |
| Explanation: in a computer cluster all the participating computers work together on a particular task. | |
| 193. |
What is document object model (DOM)? |
| A. | convention for representing and interacting with objects in html documents |
| B. | application programming interface |
| C. | hierarchy of objects in asp.net |
| D. | scripting language |
| Answer» A. convention for representing and interacting with objects in html documents | |
| Explanation: dom is a hierarchical model i.e. a tree used to represent an html or xml document. every node of the tree an object that represents a part of the document. | |
| 194. |
AJAX stands for |
| A. | asynchronous javascript and xml |
| B. | advanced jsp and xml |
| C. | asynchronous jsp and xml |
| D. | advanced javascript and xml |
| Answer» A. asynchronous javascript and xml | |
| Explanation: ajax is a group of technologies that works on the client-side to create asynchronous web applications. it is used to modify only a part of a webpage and not the whole webpage whenever some event occurs. | |
| 195. |
TOPIC 4.2 SEARCH ENGINE ARCHITECTURES |
| A. | utp |
| B. | rj-45 |
| C. | stp |
| D. | coaxial cable |
| Answer» B. rj-45 | |
| Explanation: the computers are connected to each other using a lan connector cable. | |
| 196. |
The computer cluster architecture emerged as a result of |
| A. | isa |
| B. | workstation |
| C. | super computers |
| D. | distributed systems |
| Answer» D. distributed systems | |
| Explanation: a distributed system is a computer system spread out over a geographic area. | |
| 197. |
The software which governs the group of computers is |
| A. | driver rd45 |
| B. | interface ui |
| C. | clustering middleware |
| D. | distributor |
| Answer» C. clustering middleware | |
| Explanation: the software helps to project a single system image to the user. | |
| 198. |
approach. |
| A. | beowolf |
| B. | sequoia |
| C. | stone |
| D. | none of the mentioned |
| Answer» A. beowolf | |
| Explanation: none. | |
| 199. |
The cluster formation in which the work is divided equally among the systems is |
| A. | load-configuration |
| B. | load-division |
| C. | light head |
| D. | both load-configuration and load-division |
| Answer» A. load-configuration | |
| Explanation: this approach the work gets divided among the systems equally. | |
| 200. |
approach is used. |
| A. | load configuration |
| B. | fifo |
| C. | bankers algorithm |
| D. | round robin |
| Answer» D. round robin | |
| Explanation: by using this approach the performance of the cluster can be enhanced. | |
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.