MCQOPTIONS
Saved Bookmarks
MCQOPTIONS
This section includes 1294 Mcqs, each offering curated multiple-choice questions to sharpen your Computer Science Engineering (CSE) knowledge and support exam preparation. Choose a topic below to get started.
| 1051. |
Html document must always be saved with: |
| A. | .html |
| B. | .htm |
| C. | .doc |
| D. | both .html & .htm |
| Answer» E. | |
| 1052. |
Html code contains: |
| A. | tags |
| B. | attributes |
| C. | elements |
| D. | all of the mentioned |
| Answer» E. | |
| 1053. |
Which of the following is not true about HTML ? |
| A. | <meta>…</meta> |
| B. | <meta…./> |
| C. | <metadata>…</metadata> |
| D. | <metadata name=â€â€ /> |
| Answer» C. <metadata>…</metadata> | |
| 1054. |
This extra information is usually maintained in the form of a                    at the client. |
| A. | cookie |
| B. | history |
| C. | remainder |
| D. | none of the mentioned |
| Answer» B. history | |
| 1055. |
The application program typically communicates with a database server, through                        or other protocols, in order to get or store data. |
| A. | jdbc |
| B. | odbc |
| C. | all of the mentioned |
| D. | none of the mentioned |
| Answer» D. none of the mentioned | |
| 1056. |
A Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â is a program running on the server machine, which accepts requests from a Web browser and sends back results in the form of HTML documents. |
| A. | html |
| B. | http |
| C. | web server |
| D. | web browser |
| Answer» D. web browser | |
| 1057. |
HTTP deï¬nes two ways in which values entered by a user at the browser can be sent to the Web server. The            method encodes the values as part of the URL. |
| A. | post |
| B. | get |
| C. | read |
| D. | argument |
| Answer» C. read | |
| 1058. |
Which of the following is a valid uniform resource locator? |
| A. | http://www.acm.org/sigmod |
| B. | www.google.com |
| C. | www.ann.in |
| D. | http:/www.acm.org/sigmod/ |
| Answer» B. www.google.com | |
| 1059. |
A graphical or text depiction of the relationship between different groups of content on a website is a: |
| A. | page template |
| B. | wireframe |
| C. | site map |
| D. | cascading style sheet (css) |
| Answer» D. cascading style sheet (css) | |
| 1060. |
Storyboards are intended to: |
| A. | indicate the structure of a site during site design and as a user feature |
| B. | prototype of the screen layout showing navigation and main design elements |
| C. | integrate consistently available components on the webpage (e.g. navigation, search boxes) |
| D. | prototype typical customer journeys or click streams through a website |
| Answer» E. | |
| 1061. |
Which of the following occupies boot record of hard and floppy disks and activated during computer startup? |
| A. | worm |
| B. | boot sector virus |
| C. | macro virus |
| D. | virus |
| Answer» C. macro virus | |
| 1062. |
Blueprints are intended to: |
| A. | prototype of the screen layout showing navigation and main design elements |
| B. | show the grouping of pages and user journeys |
| C. | indicate the structure of a site during site design and as a user feature |
| D. | prototype typical customer journeys or clickstreams through a website |
| Answer» D. prototype typical customer journeys or clickstreams through a website | |
| 1063. |
Also known as schematics, a way of illustrating the layout of an individual webpage is a: |
| A. | wireframe |
| B. | sitemap |
| C. | card sorting |
| D. | blueprint |
| Answer» B. sitemap | |
| 1064. |
A graphical or text depiction of the relationship between different groups of content on a website is referred to as a: |
| A. | wireframe |
| B. | blueprint |
| C. | sitemap |
| D. | card sorting |
| Answer» D. card sorting | |
| 1065. |
Information architecture influences: |
| A. | answer choice |
| B. | site structure |
| C. | labeling |
| D. | navigation design |
| Answer» C. labeling | |
| 1066. |
A method of modelling and describing user tasks for an interactive application is referred to as: |
| A. | customer journey |
| B. | primary persona |
| C. | use case |
| D. | web design persona |
| Answer» D. web design persona | |
| 1067. |
An approach to website design with the emphasis on converting visitors to outcomes required by the owner is referred to as: |
| A. | web usability |
| B. | persuasion |
| C. | web accessibility |
| D. | none of the mentioned |
| Answer» C. web accessibility | |
| 1068. |
Thus a                of course data gives the values of all attributes, such as title and department, of all courses at a particular point in time. |
| A. | instance |
| B. | snapshot |
| C. | both instance and snapshot |
| D. | all of the mentioned |
| Answer» C. both instance and snapshot | |
| 1069. |
Representations such as the in the dept year relation, with one column for each value of an attribute, are called                they are widely used in spreadsheets and reports and in data analysis tools. |
| A. | cross-tabs |
| B. | snapshot |
| C. | both cross-tabs and snapshot |
| D. | all of the mentioned |
| Answer» B. snapshot | |
| 1070. |
Relation dept year(dept name, total inst 2007, total inst 2008, total inst 2009). Here the only functional dependencies are from dept name to the other attributes. This relation is in |
| A. | fourth nf |
| B. | bcnf |
| C. | third nf |
| D. | second nf |
| Answer» C. third nf | |
| 1071. |
Designers use which of the following to tune the performance of systems to support time-critical operations? |
| A. | denormalization |
| B. | redundant optimization |
| C. | optimization |
| D. | realization |
| Answer» B. redundant optimization | |
| 1072. |
What is the best way to represent the attributes in a large database? |
| A. | relational-and |
| B. | concatenation |
| C. | dot representation |
| D. | all of the mentioned |
| Answer» C. dot representation | |
| 1073. |
In which of the following, a separate schema is created consisting of that attribute and the primary key of the entity set. |
| A. | a many-to-many relationship set |
| B. | a multivalued attribute of an entity set |
| C. | a one-to-many relationship set |
| D. | all of the mentioned |
| Answer» C. a one-to-many relationship set | |
| 1074. |
Which of the following has each related entity set has its own schema and there is an additional schema for the relationship set. |
| A. | a many-to-many relationship set |
| B. | a multivalued attribute of an entity set |
| C. | a one-to-many relationship set |
| D. | all of the mentioned |
| Answer» B. a multivalued attribute of an entity set | |
| 1075. |
                           can help us detect poor E- R design. |
| A. | database design process |
| B. | e-r design process |
| C. | relational scheme |
| D. | functional dependencies |
| Answer» E. | |
| 1076. |
In 2NF |
| A. | no functional dependencies (fds) exist |
| B. | no multivalued dependencies (mvds) exist |
| C. | no partial fds exist |
| D. | no partial mvds exist |
| Answer» D. no partial mvds exist | |
| 1077. |
Fifth Normal form is concerned with |
| A. | functional dependency |
| B. | multivalued dependency |
| C. | join dependency |
| D. | domain-key |
| Answer» D. domain-key | |
| 1078. |
Which of the following has each related entity set has its own schema and there is an additional schema for the relationship set? |
| A. | a many-to-many relationship set |
| B. | a multivalued attribute of an entity set |
| C. | a one-to-many relationship set |
| D. | none of the mentioned |
| Answer» B. a multivalued attribute of an entity set | |
| 1079. |
If a multivalued dependency holds and is not implied by the corresponding functional dependency, it usually arises from one of the following sources. |
| A. | a many-to-many relationship set |
| B. | a multivalued attribute of an entity set |
| C. | a one-to-many relationship set |
| D. | both a many-to-many relationship set and a multivalued attribute of an entity set |
| Answer» E. | |
| 1080. |
Which of the normal form is based on multivalued dependencies? |
| A. | first |
| B. | second |
| C. | third |
| D. | fourth |
| Answer» E. | |
| 1081. |
Which normal form is considered adequate for normal relational database design? |
| A. | 2nf |
| B. | 5nf |
| C. | 4nf |
| D. | 3nf |
| Answer» E. | |
| 1082. |
Which forms has a relation that possesses data about an individual entity? |
| A. | 2nf |
| B. | 3nf |
| C. | 4nf |
| D. | 5nf |
| Answer» D. 5nf | |
| 1083. |
The algorithm that takes a set of dependencies and adds one schema at a time, instead of decomposing the initial schema repeatedly is |
| A. | bcnf algorithm |
| B. | 2nf algorithm |
| C. | 3nf synthesis algorithm |
| D. | 1nf algorithm |
| Answer» D. 1nf algorithm | |
| 1084. |
Relation R with an associated set of functional dependencies, F, is decomposed into BCNF. The redundancy (arising out of functional dependencies) in the resulting set of relations is |
| A. | zero |
| B. | more than zero but less than that of an equivalent 3nf decomposition |
| C. | proportional to the size of f+ |
| D. | indeterminate |
| Answer» C. proportional to the size of f+ | |
| 1085. |
R (A,B,C,D) is a relation. Which of the following does not have a lossless join dependency preserving BCNF decomposition? |
| A. | a->b, b->cd |
| B. | a->b, b->c, c->d |
| C. | ab->c, c->ad |
| D. | a->bcd |
| Answer» E. | |
| 1086. |
What are the desirable properties of a decomposition |
| A. | partition constraint |
| B. | dependency preservation |
| C. | redundancy |
| D. | security |
| Answer» C. redundancy | |
| 1087. |
A relation is in                          if an attribute of a composite key is dependent on an attribute of other composite key. |
| A. | 2nf |
| B. | 3nf |
| C. | bcnf |
| D. | 1nf |
| Answer» C. bcnf | |
| 1088. |
Which is a bottom-up approach to database design that design by examining the relationship between attributes: |
| A. | functional dependency |
| B. | database modeling |
| C. | normalization |
| D. | decomposition |
| Answer» D. decomposition | |
| 1089. |
Functional Dependencies are the types of constraints that are based on |
| A. | key |
| B. | key revisited |
| C. | superset key |
| D. | none of the mentioned |
| Answer» B. key revisited | |
| 1090. |
Tables in second normal form (2NF): |
| A. | eliminate all hidden dependencies |
| B. | eliminate the possibility of a insertion anomalies |
| C. | have a composite key |
| D. | have all non key ï¬elds depend on the whole primary key |
| Answer» B. eliminate the possibility of a insertion anomalies | |
| 1091. |
A table on the many side of a one to many or many to many relationship must: |
| A. | be in second normal form (2nf) |
| B. | be in third normal form (3nf) |
| C. | have a single attribute key |
| D. | have a composite key |
| Answer» E. | |
| 1092. |
In the                      normal form, a composite attribute is converted to individual attributes. |
| A. | first |
| B. | second |
| C. | third |
| D. | fourth |
| Answer» B. second | |
| 1093. |
A dependency exist between two columns when |
| A. | together they constitute a composite key for the table |
| B. | knowing the value in one column determines the value stored in another column |
| C. | the table is in 3nf |
| D. | together they constitute a foreign key |
| Answer» B. knowing the value in one column determines the value stored in another column | |
| 1094. |
A data type that creates unique numbers for key columns in Microsoft Access is: |
| A. | autonumber |
| B. | boolean |
| C. | sequential key |
| D. | sequential number |
| Answer» B. boolean | |
| 1095. |
If every non-key attribute is functionally dependent primary key, then the relation will be in |
| A. | first normal form |
| B. | second normal form |
| C. | third form |
| D. | fourth normal form |
| Answer» C. third form | |
| 1096. |
The term for information that describes what type of data is available in a database is: |
| A. | data dictionary |
| B. | data repository |
| C. | index data |
| D. | metadata |
| Answer» E. | |
| 1097. |
If a relation is in BCNF, then it is also in |
| A. | 1 nf |
| B. | 2 nf |
| C. | 3 nf |
| D. | all of the mentioned |
| Answer» E. | |
| 1098. |
Which one is based on multi-valued dependency: |
| A. | first |
| B. | second |
| C. | third |
| D. | fourth |
| Answer» E. | |
| 1099. |
Identify the composite attributes |
| A. | salary |
| B. | credits |
| C. | section_id |
| D. | none of the mentioned |
| Answer» E. | |
| 1100. |
A domain is              if elements of the domain are considered to be indivisible units. |
| A. | atomic |
| B. | subatomic |
| C. | substructure |
| D. | subset |
| Answer» B. subatomic | |