Explore topic-wise MCQs in Structured Query Language (SQL).

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