MCQOPTIONS
Saved Bookmarks
This section includes 88 Mcqs, each offering curated multiple-choice questions to sharpen your Structured Query Language (SQL) knowledge and support exam preparation. Choose a topic below to get started.
| 51. |
30 nm wide helix with five or six nucleosomes per helix is known as |
| A. | solenoid |
| B. | halonoid |
| C. | kinoplast |
| D. | none of these |
| Answer» B. halonoid | |
| 52. |
Nucleosome is |
| A. | an octamer of four histones with H1 protein |
| B. | an hexamer of three histones with H1 protein |
| C. | an hexamer of three histones without H1 protein |
| D. | an octamer of four histones without H1 protein |
| Answer» E. | |
| 53. |
The packing ratio of nucleosomes is about |
| A. | 6 |
| B. | 8 |
| C. | 7 |
| D. | 9 |
| Answer» D. 9 | |
| 54. |
The DNA is negatively super coiled, complexes to histone, |
| A. | HU |
| B. | HSP-1 |
| C. | H-NS |
| D. | All of these |
| Answer» E. | |
| 55. |
DNA with a G-C content of 50% will melt at approximately |
| A. | 60°C |
| B. | 70 °C |
| C. | 90 °C |
| D. | 100 °C |
| Answer» D. 100 °C | |
| 56. |
In DNA, nucleotides are covalently joined together by |
| A. | 3', 5' phosphodiester bonds to form a repetitive sugar-phosphate chain |
| B. | 2', 5' phosphodiester bonds to form a repetitive sugar-phosphate chain |
| C. | 2', 3' phosphodiester bonds to form a repetitive sugar-phosphate chain |
| D. | 3', 4' phosphodiester bonds to form a repetitive sugar-phosphate chain |
| Answer» B. 2', 5' phosphodiester bonds to form a repetitive sugar-phosphate chain | |
| 57. |
Which of the following is not a structural motif in DNA binding proteins? |
| A. | bZIP |
| B. | helix-turn-helix |
| C. | TFIID |
| D. | zinc finger |
| Answer» D. zinc finger | |
| 58. |
TM refers to the temperature at which |
| A. | membranes are 50% fluid |
| B. | 50% of a DNA molecule is denatured |
| C. | 50% of a protein molecules are denatured |
| D. | all of the above |
| Answer» E. | |
| 59. |
The B-DNA structure found in solution is a |
| A. | left-handed double helix of antiparallel chains (10 bp/turn) |
| B. | right-handed double helix of antiparallel chains (∼10 bp/turn) |
| C. | left-handed zig-zag helix of antiparallel chains (10 bp/turn) |
| D. | right-handed double helix of parallel chains (∼10 bp/turn) |
| Answer» C. left-handed zig-zag helix of antiparallel chains (10 bp/turn) | |
| 60. |
What is the approximate percentage of repetitive DNA sequences in human DNA? |
| A. | 10 to 20% |
| B. | 20 to 30% |
| C. | 30 to 40% |
| D. | 40 to 50% |
| Answer» C. 30 to 40% | |
| 61. |
Which of the following enzyme adds complementary bases during replication? |
| A. | Helicase |
| B. | Synthesase |
| C. | Replicase |
| D. | Polymerase |
| Answer» E. | |
| 62. |
The higher order structure of DNA shows symmetry, whereas the higher order structures of most proteins do not. Why isn't protein shape more regular like DNA? |
| A. | DNA has one main function in cells whereas proteins have many. |
| B. | The many different amino acid R groups on proteins confer many different shapes. |
| C. | Some S amino acids cause proteins to bend; others cause protein to flatten. |
| D. | All of the above |
| Answer» E. | |
| 63. |
Number of times the two DNA strands are interwined in circular DNA and is known as |
| A. | helix frequency |
| B. | linking number |
| C. | twisting number |
| D. | none of these |
| Answer» C. twisting number | |
| 64. |
What is the exact name of the classical Watson-Crick double helix DNA? |
| A. | A-DNA |
| B. | B-DNA |
| C. | Z-DNA |
| D. | X-DNA |
| Answer» C. Z-DNA | |
| 65. |
Who's X-ray work aided Watson and Crick in their discovery of the double helix? |
| A. | W.H. Bragg |
| B. | R. Franklin |
| C. | L. Pauling |
| D. | Leaderberg |
| Answer» C. L. Pauling | |
| 66. |
In an agarose gel, DNA is moving from |
| A. | cathode to anode |
| B. | left to right |
| C. | anode to cathode |
| D. | A to B |
| Answer» B. left to right | |
| 67. |
First evident that DNA is genetic material comes from the experiment of Griffith is |
| A. | transduction |
| B. | transformation |
| C. | replication |
| D. | translation |
| Answer» C. replication | |
| 68. |
When a replica set has one and only one primary, reads from that primary provide ______ consistency. |
| A. | strict |
| B. | partial |
| C. | weak |
| D. | all of the mentioned |
| Answer» B. partial | |
| 69. |
When a primary does not communicate with the other members of the set for more than ____ seconds, the replica set will attempt to select another member to become the new primary. |
| A. | 10 |
| B. | 20 |
| C. | 30 |
| D. | None of the mentioned |
| Answer» B. 20 | |
| 70. |
An arbiter will always be an arbiter whereas a primary may step down and become a secondary and a _________ may become the primary during an election. |
| A. | center |
| B. | secondary |
| C. | primary |
| D. | none of the mentioned |
| Answer» C. primary | |
| 71. |
You may add an extra mongod instance to a replica set as an __________ |
| A. | arbiter |
| B. | replicator |
| C. | additor |
| D. | all of the mentioned |
| Answer» B. replicator | |
| 72. |
To support replication, the primary records all changes to its data sets in its _______ |
| A. | oplog |
| B. | adlog |
| C. | log |
| D. | none of the mentioned |
| Answer» B. adlog | |
| 73. |
A _______ set is a group of mongod instances that host the same data set. |
| A. | copy |
| B. | sorted |
| C. | radii |
| D. | replica |
| Answer» E. | |
| 74. |
WHEN_A_PRIMARY_DOES_NOT_COMMUNICATE_WITH_THE_OTHER_MEMBERS_OF_THE_SET_FOR_MORE_THAN______SECONDS,_THE_REPLICA_SET_WILL_ATTEMPT_TO_SELECT_ANOTHER_MEMBER_TO_BECOME_THE_NEW_PRIMARY.?$ |
| A. | 10 |
| B. | 20 |
| C. | 30 |
| D. | None of the mentioned |
| Answer» B. 20 | |
| 75. |
WHICH_OF_THE_FOLLOWING_MAKES_DATA_AVAILABLE_FOR_REPLICATION??$ |
| A. | Article |
| B. | Publisher |
| C. | Distributor |
| D. | Subscription |
| Answer» C. Distributor | |
| 76. |
When_a_replica_set_has_one_and_only_one_primary,_reads_from_that_primary_provide________consistency.$ |
| A. | strict |
| B. | partial |
| C. | weak |
| D. | all of the mentioned |
| Answer» B. partial | |
| 77. |
Two_types_of_subscriptions_present_for_replication_is_:$ |
| A. | push and pull |
| B. | throw and pull |
| C. | push and throw |
| D. | none of the mentioned |
| Answer» B. throw and pull | |
| 78. |
An arbiter will always be an arbiter whereas a primary may step down and become a secondary and a _________ may become the primary during an election? |
| A. | center |
| B. | secondary |
| C. | primary |
| D. | none of the mentioned |
| Answer» C. primary | |
| 79. |
How many types of replication components are present in SQL Server? |
| A. | 6 |
| B. | 7 |
| C. | 8 |
| D. | 9 |
| Answer» D. 9 | |
| 80. |
You may add an extra mongod instance to a replica set as an : |
| A. | arbiter |
| B. | replicator |
| C. | additor |
| D. | all of the mentioned |
| Answer» B. replicator | |
| 81. |
Which of the following stored procedure provide replication support for AlwaysOn? |
| A. | sp_validate_replica_publishers |
| B. | sp_validate_hosts_as_publishers |
| C. | sp_validate_replica_hosts_as_publishers |
| D. | all of the mentioned |
| Answer» D. all of the mentioned | |
| 82. |
To support replication, the primary records all changes to its data sets in its _______. |
| A. | oplog |
| B. | adlog |
| C. | log |
| D. | none of the mentioned |
| Answer» B. adlog | |
| 83. |
Which of the following is disadvantage of replication? |
| A. | Improved performance |
| B. | To move data closer to the user |
| C. | Easy maintenance |
| D. | None of the mentioned |
| Answer» E. | |
| 84. |
A replica set can have only ________ primary. |
| A. | One |
| B. | Two |
| C. | Three |
| D. | All of the mentioned |
| Answer» B. Two | |
| 85. |
Replication in SQL Server is used to overcome : |
| A. | Performance problems |
| B. | Availability problems |
| C. | Maintenance problems |
| D. | All of the mentioned |
| Answer» E. | |
| 86. |
All other instances, secondaries, apply operations from the _________ so that they have the same data set. |
| A. | center |
| B. | secondary |
| C. | primary |
| D. | none of the mentioned |
| Answer» D. none of the mentioned | |
| 87. |
How many types of replication is provided by SQL Server? |
| A. | 2 |
| B. | 3 |
| C. | 4 |
| D. | 5 |
| Answer» C. 4 | |
| 88. |
___________ is a set of technologies for copying and distributing data and database objects from one database to another. |
| A. | Replication |
| B. | Database Mirroring |
| C. | Log Shipping |
| D. | None of the mentioned |
| Answer» B. Database Mirroring | |