If both assertion and reason are true and reason is the correct explanation of assertion.
If both assertion and reason are true, but reason is not the correct explanation of assertion.
If the assertion is true, but the reason is false.
If the assertion is false, but the reason is true.
1 . Assertion When a test charge moves through the magnetic field, its momentum changes but kinetic energy remains same.
Reason The magnetic force acts as a centripetal force, which is perpendicular to the instantaneous velocity and so does no work.
1 . (1)
Kinetic energy of the charged particle remains same in the circular path while velocity and momentum of the particle changes because of continous change in the direction of motion.
2. Assertion Magnetic field interacts with a moving charge.
Reason A moving charge produces a magnetic field.
2. (1)
A moving charge experience a force in magnetic field. It is because of interaction of two magnetic fields, one which is produced due to the motion of charge and other in which charge is moving.
3. Assertion Free electron always keeps on moving in a conductor even then no magnetic force act on them in magnetic field unless a current is passed through it.
Reason The average velocity of free electron is zero.
3. (1)
In the absence of electric field, the free electron in a conductor are in a state of random motion, like molecules in a gas. Their average velocity is zero, i.e, they do not have any net magnetic force on the free electrons in the magnetic field. On passing the current, the free electrons acquire drift velocity in a definite direction, hence magnetic force acts on them, unless the field has no perpendicular component.
4. Assertion Two beam of electrons traveling in the same direction repel each other.
Reason The electrostatic interaction is less than the magnetic interaction.
4. (3)
Two beams of electron traveling in the same direction repel each other because the electrostatic interaction is more that the magnetic interaction.
5. Assertion If the current in a solenoid is reversed in direction while keeping the same magnitude, the magnetic field energy stored in the solenoid decreases.
Reason Magnetic field energy density is proportional to square of current.
5. (4)
Reversing the direction of the current reverses the direction of magnetic field. However, it has no effect on the magnetic field energy density, which is proportional to the square of the magnitude interaction.
6. Assertion The magnetic field produced by a current carrying solenoid is independent of its length and cross-sectional area.
Reason The magnetic field inside the solenoid is uniform.
6. (2)
The earth’s magnetic field is towards north and the velocity of electron is vertically downward. Applying Fleming’s left hand rule, the direction of force is towards west. Therefore, an electron coming from outer space will be deflected toward west.
7. Assertion If two long wire, hanging freely an connected to a battery in series, they come closer to each other.
Reason Force of attraction acts between the two wires carrying current.
7. (4)
When two long parallel wires, are connected to a battery in series. They carry current in opposite directions, hence they repel each other.
8. Assertion In a shunted galvanometer only 10% current passes through the galvanometer. The resistance of the galvanometer is G. Then resistance of the shunt in G/9.
Reason If S is the resistance of the shunt, then voltage across S and G is same.
8. (2)
IgG = (I-Ig)S
S = (Ig / I – Ig) G
Ig = I / 10
S = G / 9
9. Assertion To convert a galvanometer into an ammeter a small resistance is connected in parallel with it.
Reason The small resistance increases the combined resistance of the combination.
9. (3)
An ammeter should have a low resistance which we get when we connect low resistance in parallel with galvanometer.
10. Assertion An ammeter is always connected in series whereas a voltmeter is connected in parallel.
Reason An ammeter is a low resistance galvanometer while a voltmeter is high resistance galvanometer.
10. (1)
An ammeter is a low resistance device and is connected in series so as the whole circuit current flows through it for an accurate measurement. A voltmeter is a device having a high resistance. So, if we connect it in series, it would hinder the current flow in the circuit hence open circuit results.
Directions: These questions consist of two statements, each printed as Assertion and Reason. While answering these questions, you are required to choose any one of the following four responses. (a) If both Assertion and Reason are correct and the Reason is a correct explanation of the Assertion. (b) If both Assertion and Reason are correct but Reason is not a correct explanation of the Assertion. (c) If the Assertion is correct but Reason is incorrect. (d) If both the Assertion and Reason are incorrect.
Q.1. Assertion : In a simple battery circuit, the point of the lowest potential is positive terminal of the battery. Reason : The current flows towards the point of the higher potential, as it does in such a circuit from the negative to the positive terminal.
Answer-d
Q.2. Assertion : A larger dry cell has higher emf. Reason : The emf of a dry cell is proportional to its size.
Answer-d
Q.3. Assertion : A current continues to flow in superconducting coil even after switch is off. Reason : Superconducting coils show Meissner effect.
Answer-b
Q.4. Assertion : Voltmeter is connected in parallel with the circuit. Reason : Resistance of a voltmeter is very large.
Answer-b
Q.5. Assertion : Ohm’s law is applicable for all conducting elements. Reason : Ohm’s law is a fundamental law.
Answer-c
Q.6. Assertion : An electric bulb becomes dim, when the electric heater in parallel circuit is switched on. Reason : Dimness decreases after sometime.
Directions: These questions consist of two statements, each printed as Assertion and Reason. While answering these questions, you are required to choose any one of the following four responses. (a) If both Assertion and Reason are correct and the Reason is a correct explanation of the Assertion. (b) If both Assertion and Reason are correct but Reason is not a correct explanation of the Assertion. (c) If the Assertion is correct but Reason is incorrect. (d) If both the Assertion and Reason are incorrect.
Q.1. Assertion : If the distance between parallel plates of a capacitor is halved and dielectric constant is three times, then the capacitance becomes 6 times. Reason : Capacity of the capacitor does not depend upon the nature of the material.
Answer-c
Q.2. Assertion : A parallel plate capacitor is connected across battery through a key. A dielectric slab of dielectric constant K is introduced between the plates. The energy which is stored becomes K times. Reason : The surface density of charge on the plate remains constant or unchanged.
Answer-c
Q.3. Assertion : The total charge stored in a capacitor is zero. Reason : The field just outside the capacitor is σ/ε0 . (σ is the charge density).
Answer-c
Q.4. Assertion : The electrostatic force between the plates of a charged isolated capacitor decreases when dielectric fills whole space between plates. Reason : The electric field between the plates of a charged isolated capacitance increases when dielectric fills whole space between plates.
Answer-d
Q.5. Assertion : Two concentric charged shells are given. The potential difference between the shells depends on charge of inner shell. Reason : Potential due to charge of outer shell remains same at every point inside the sphere.
Answer-a
Q.6. Assertion : Two equipotential surfaces cannot cut each other. Reason : Two equipotential surfaces are parallel to each other.
Answer-c
Q.7. Assertion: The potential difference between any two points in an electric field depends only on initial and final position. Reason: Electric field is a conservative field so the work done per unit positive charge does not depend on path followed.
Answer-a
Q.8. Assertion : Electric field inside a conductor is zero. Reason: The potential at all the points inside a conductor is same.
Answer-b
Q.9. Assertion : Electric field is discontinuous across the surface of a spherical charged shell. Reason : Electric potential is continuous across the surface of a spherical charged shell.
Answer-b
Q.10. Assertion : Work done in moving a charge between any two points in an electric field is independent of the path followed by the charge, between these points. Reason: Electrostatic force is a non conservative force.
Answer-c
Q.11. Assertion : Two adjacent conductors of unequal dimensions, carrying the same positive charge have a potential difference between them. Reason : The potential of a conductor depends upon the charge given to it.
Answer-b
Q.12. Assertion : Electric potential and electric potential energy are different quantities. Reason : For a system of positive test charge and point charge electric potential energy = electric potential.
Answer(c) Potential and potential energy are different quantities and cannot be equated.
Q.13. Assertion : For a non-uniformly charged thin circular ring with net charge is zero, the electric field at any point on axis of the ring is zero. Reason : For a non-uniformly charged thin circular ring with net charge zero, the electric potential at each point on axis of the ring is zero.
Answer(d) For a non-uniformly charged thin circular ring with net zero charge, electric potential at each point on its axis is zero. Hence electric field at each point on its axis must be perpendicular to the axis. Therefore Assertion is false and Reason is true.
Q.14. Assertion : For a charged particle moving from point P to point Q, the net work done by an electrostatic field on the particle is independent of the path connecting point P to point Q. Reason : The net work done by a conservative force on an object moving along a closed loop is zero.
Answer-a
Q.15. Assertion : Polar molecules have permanent dipole moment. Reason : In polar molecules, the centres of positive and negative charges coincide even when there is no external field.
Answer-c
Q.16. Assertion : Dielectric polarisation means formation of positive and negative charges inside the dielectric. Reason: Free electrons are formed in this process.
Answer-c
Q.17. Assertion : In the absence of an external electric field, the dipole moment per unit volume of a polar dielectric is zero. Reason : The dipoles of a polar dielectric are randomly oriented.
Answer-a
Q.18. Assertion : For a point charge, concentric spheres centered at a location of the charge are equipotential surfaces. Reason : An equipotential surface is a surface over which potential has zero value.
Answer-c
Q.19. Assertion : Electric energy resides out of the spherical isolated conductor. Reason : The electric field at any point inside the conductor is zero.
Answer(a) As these is no electric field inside the conductor, and so no energy inside it.
Q.20. Assertion : Two equipotential surfaces cannot cut each other. Reason : Two equipotential surfaces are parallel to each other.
Answer(c) Reason is false because the work done in bringing a unit positive charge from infinity to a point in equatorial plane is equal and opposite for the two charges of the dipole.
Q.21. Assertion: Two equipotential surfaces can be orthogonal. Reason: Electric field lines are normal to the equipotential surface.
Answer(d) Two equipotential surfaces never intersect each other so they cannot be orthogonal.
Q.22. Assertion: The equatorial plane of a dipole is an equipotential surface. Reason: The electric potential at any point on equatorial plane is zero.
Answer-b
Q.23. Assertion: The electric potential at any point on the equatorial plane of a dipole is zero. Reason: The work done in bringing a unit positive charge from infinity to a point in equatorial plane is equal for the two charges of the dipole.
Answer-d
Q.24. Assertion : A parallel plate capacitor is connected across battery through a key. A dielectric slab of dielectric constant k is introduced between the plates. The energy stored becomes k times. Reason : The surface density of charge on the plate remains constant.
Answer-c
Q.25. Assertion : Two metal plates having charges Q, –Q face each other at some separation and are dipped into an oil tank. If the oil is pumped out, the electric field between the plates increases. Reason : Electric field between the plates, Emed = Eair/K
Answer-c
Q.26. Assertion : When a dielectric slab is gradually inserted between the plates of an isolated parallel-plate capacitor, the energy of the system decreases. Reason : The force between the plates decreases.
Answer-c
Q.27. Assertion : A dielectric is inserted between the plates of a battery connected capacitor. The energy of the capacitor increases. Reason : Energy of the capacitor, U=CV2/2
Directions: These questions consist of two statements, each printed as Assertion and Reason. While answering these questions, you are required to choose any one of the following four responses. (a) Both Assertion and Reason are correct and the Reason is a correct explanation of the Assertion. (b) Both Assertion and Reason are correct but Reason is not a correct explanation of the Assertion. (c) Assertion is correct, Reason is incorrect (d) Both Assertion and Reason are correct.
Q.1. Assertion: Electron move away from a region of lower potential to a region of higher potential. Reason: An electron has a negative charge.
Answer-a
Q.2. Assertion : A metallic shield in form of a hollow shell may be built to block an electric field. Reason : In a hollow spherical shield, the electric field inside it is zero at every point.
Answer-a
Q.3. Assertion : Electric lines of force never cross each other. Reason : Electric field at a point superimpose to give one resultant electric field.
Answer-b
Q.4.Assertion : The Coulomb force is the dominating force in the universe. Reason : The Coulomb force is weaker than the gravitational force.
Answer-d
Q.5. Assertion : In a cavity within a conductor, the electric field is zero. Reason : Charges in a conductor reside only at its surface.
Answer-a
Q.6. Assertion : When bodies are charged through friction, there is a transfer of electric charge from one body to another, but no creation or destruction of charge. Reason : This follows from conservation of electric charges.
Answer(a) Conservation of electric charge states that the total charge of an isolated system remains unchanged with time
Q.7. Assertion : The tyres of aircraft are slightly conducting. Reason : If a conductor is connected to ground, the extra charge induced on conductor will flow to ground.
Answer(b) Both the statements are independently correct.
Q.8. Assertion : Some charge is put at the centre of a conducting sphere. It will move to the surface of the sphere. Reason : Conducting sphere has no free electrons at the centre.
Answer(a) Because of repulsion, the free electrons will mole to the outer surface.
Q.9. Assertion : Coulomb force and gravitational force follow the same inverse-square law. Reason : Both laws are same in all aspects.
Answer(c) Coulomb force and gravitational force follow the same inverse-square law. But gravitational force has only one sign which is always attractive, while coulomb force can be of both signs which are attractive and repulsive.
Q.10. Assertion : The coulomb force is the dominating force in the universe. Reason : The coulomb force is weaker than the gravitational force.
Answer(d) Gravitational force is the dominating force in nature and not coulomb’s force. Gravitational force is the weakest force. Also, Coulomb’s force > > gravitational force.
Q.11. Assertion : If there exists coulomb attraction between two bodies, both of them may not be charged. Reason : In coulomb attraction two bodies are oppositely charged.
Answer(b) Coulomb attraction exists even when one body is charged, and the other is uncharged.
Q.12. Assertion : A deuteron and an -particle are placed in an electric field. If F1 and F2 be the forces acting on them and a1 and a2 be their accelerations respectively then, a1 = a2. Reason : Forces will be same in electric field.
Answer-c
Q.13. Assertion : The property that the force with which two charges attract or repel each other are not affected by the presence of a third charge. Reason : Force on any charge due to a number of other charge is the vector sum of all the forces on that charge due to other charges, taken one at a time.
Answer(b) Force on any charge due to a number of other charges is the vector sum of all the forces on that charge due to the other charges, taken one at a time. The individual force are unaffected due to the presence of other charges. This is the principle of superposition of charges.
Q.14. Assertion : A metallic shield in form of a hollow shell may be built to block an electric field. Reason : In a hollow spherical shield, the electric field inside it is zero at every point.
Answer(a) The electrostatic shielding is possible by metallic conductor.
Q.15. Assertion : A point charge is brought in an electric field, the field at a nearby point will increase or decrease, depending on the nature of charge. Reason : The electric field is independent of the nature of charge.
Answer(c) The electric field will increase if positive charge is brought in an electric field.
Q.16. Assertion : Consider two identical charges placed distance 2d apart, along x-axis.
The equilibrium of a positive test charge placed at the point O midway between them is stable for displacements along the x-axis. Reason: Force on test charge is zero.
Answer(b) If +ve charge is displaced along x-axis, then net force will always act in a direction opposite to that of displacement and the test charge will always come back to its original position.
Q.17. Assertion : When a conductor is placed in an external electrostatic field, the net electric field inside the conductor becomes zero after a small instant of time. Reason : It is not possible to set up an electric field inside a conductor.
Answer(c) Statement-1 is correct. The induced field cancels the external field. Statement-2 is false. When a current is set up in a conductor, there exists an electric field inside it.
Q.18. Assertion : A uniformly charged disc has a pin hole at its centre. The electric field at the centre of the disc is zero. Reason : Disc can be supposed to be made up of many rings. Also electric field at the centre of uniformly charged ring is zero.
Answer(a) The electric field due to disc is superposition of electric field due to its constituent ring as given in Reason.
Q.19. Assertion : Electric lines of field cross each other. Reason : Electric field at a point superimpose to give one resultant electric field.
AnswerAssertion is Incorrect, Reason is correct. (d) Two field lines never intersect.
Q.20. Assertion : On bringing a positively charged rod near the uncharged conductor, the conductor gets attracted towards the rod. Reason : The electric field lines of the charged rod are perpendicular to the surface of conductor.
Answer(b) Though the net charge on the conductor is still zero but due to induction negatively charged region is nearer to the rod as compared to the positively charged region. That is why the conductor gets attracted towards the rod
Q.21. Assertion : Four point charges q1, q2, q3 and q4 are as shown in figure. The flux over the shown Gaussian surface depends only on charges q1 and q2.
Reason : Electric field at all points on Gaussian surface depends only on charges q1 and q2.
Answer(d) Electric field at any point depends on presence of all charges.
Q.22. Assertion : On disturbing an electric dipole in stable equilibrium in an electric field, it returns back to its stable equilibrium orientation. Reason : A restoring torque acts on the dipole on being disturbed from its stable equilibrium.
Answer(a) The restoring torque brings it back to its stable equilibrium.
Q.23. Assertion : On going away from a point charge or a small electric dipole, electric field decreases at the same rate in both the cases. Reason : Electric field is inversely proportional to square of distance from the charge or an electric dipole.
Answer(d)
Q.24. Assertion : The electric flux of the electric field ∮ E.dA is zero. The electric field is zero everywhere on the surface. Reason : The charge inside the surface is zero.
Answer(d)
Q.25. Assertion : On moving a distance two times the initial distance away from an infinitely long straight uniformly charged wire the electric field reduces to one third of the initial value. Reason : The electric field is inversely proportional to the distance from an infinitely long straight uniformly charged wire.
Answer(a)
Q.26. Assertion (A): No two electric lines of force can intersect each other. Reason (R) : Tangent at any point of electric line of force gives the direction of electric field.
Answer(a)
Q.27. Assertion (A): Electric force acting on a proton and an electron, moving in a uniform electric field is same, where as acceleration of electron is 1836 times that of a proton. Reason (R): Electron is lighter than proton.
Answer(a)
Q.28. Assertion (A): As force is a vector quantity, hence electric field intensity is also a vector quantity Reason (R): The unit of electric field intensity is newton per coulomb.
Answer(b)
Q.29. Assertion (A) : Sharper is the curvature of spot on a charged body lesser will be the surface charge density at that point Reason (R): Electric field is non-zero inside a charged conductor.
Answer(d)
Q.30. Assertion (A): The surface densities of two spherical conductors of different radii are equal. Then the electric field intensities near their surface are also equal. Reason (R) : Surface density is equal to charge per unit area.
Answer(b)
Q.31. Assertion (A): Three equal charges are situated on a circle of radius r such that they form on equilateral triangle, then the electric field intensity at the centre is zero. Reason (R): The force on unit positive charge at the centre, due to the three equal charges are represented by the three sides of a triangle taken in the same order. Therefore, electric field intensity at centre is zero.
Answer(a)
Q.32. Assertion (A): The electric lines of forces diverges from a positive charge and converge at a negative charge. Reason (A): A charged particle free to move in an electric field always move along an electric line of force.Answer(c)
Q.33. Assertion (A): Charging is due to transfer of electrons. Reason (R): Mass of a body decreases slightly when it is negatively charged.
Answer(c)
Q.34. Assertion (A): Range of Coulomb force is infinite. Reason (R): Coulomb force acts between two charged particles.
Answer(b)
Q.35. Assertion (A): A small metal ball is suspended in a uniform electric field with an insulated thread. If high energy X-ray beam falls on the ball, the ball will be deflected in the electric field. Reason (R): X-rays emits photoelectron and metal becomes negatively charged.
Answer(c)
Q.36. Assertion (A): If a point charge be rotated in a circle around a charge, the work done will be zero. Reason (R): Work done is equal to dot product of force and distance
Direction: In the following questions, a statement of Assertion (A) is followed by a statement of Reason (R). Mark the correct choice as: (a) Both Assertion (A) and Reason (R) are true and Reason (R) is the correct explanation of Assertion (A). (b) Both Assertion (A) and Reason (R) are true but Reason (R) is not the correct explanation of Assertion (A). (c) Assertion (A) is true but Reason (R) is false. (d) Assertion (A) is false but Reason (R) is true.
1.) Assertion : the decimal expansion of 22/7 is non terminating and repeating
Reason: 22/7 = 3.1428
Ans: a) both Assertion and reason are correct and reason is correct explanation for Assertion
2.) Assertion: for some integer n the odd integer is represented in the form of 2n+1
Reason: 2n represent the even number and 2n+1 will represent odd
Ans: a) both Assertion and reason are correct and reason is correct explanation for Assertion
3.) Assertion: HCF of 26 and 91 is 13
Reason: the prime factorization of 26 = 2*13 and 91=7*13
Ans: a) both Assertion and reason are correct and reason is correct explanation for Assertion
4.) Assertion: the addition of rational number and irrational number is equal to irrational number
Reason: the sum of irrational number and rational number is always rational number
Ans: c) Assertion is correct but reason is false
5.) Assertion: the multiplication of two irrational no. is may be rational or irrational
Reason: the product of two irrational no.is always rational
Ans: c) Assertion is correct but reason is false
6.) Assertion: if set A={ 1,2,3,4,5—-} is given then it represent natural number
Reason: natural number is always start from 1
Ans: a) both Assertion and reason are correct and reason is correct explanation for Assertion
7.) Assertion:The H.C.F. of two numbers is 16 and their product is 3072. Then their L.C.M. = 162. Reason: If a and b are two positive integers, then H.C.F. × L.C.M. = a × b.
AnswerAnswer: (d) Assetion (A) is false but Reason (R) is true. Explanation: Since HCF × LCM = a × b ⇒ 3072 = 16 × 162 ⇒ 3072 ≠ 2592
8.) Assertion:Denominator of 34.12345. When expressed in the form p/q, q ≠ 0, is of the form 2m × 5n, where m and n are non-negative integers. Reason: 34.12345 is a terminating decimal fraction.
9.) Assertion: 13/3125 is a terminating decimal fraction. Reason: If q = 2n.5m where n and m are non-negative integers, then p/q is a terminating decimal fraction.
AnswerAnswer: (a)
10.) Assertion: 2 is an example of a rational number. Reason: The square roots of all positive integers are irrational numbers.
AnswerAnswer: (c) Explanation: Here, reason is false. As √16 = ±4, which is not an irrational number.
11.) Assertion: For any two positive integers p and q, HCF (p, q) × LCM (p, q) = p × q Reason: If the HCF of two numbers is 5 and their product is 150, then their LCM is 40.
The purpose of the course is to create professionals who are skilled in accounting, banking, finance, and insurance. Some common B.Com Banking and Insurance.
Looking for Banking and Insurance Class 10 Syllabus PDF? Here you can check and FREE Download CBSE Class 10 Banking and Insurance Textbook
class 12th – Open Source Initiative computer science
1. A guideline for the OSS licenses other than the GPL. a) OSI b) OSD c) OSE d) OSL View Answer
Answer: b Explanation: OSS is the open source software. In 1997, OSI or the open source initiative was founded and it developed the OSD (Open Source Definition). OSD is a guideline for OSS licenses other than the GPL.
2. GPL of GNU says that every copy of a program governed by GPL license, even if modified, must be subject to GPL again. a) True b) False View Answer
Answer: a Explanation: The statement is true. GPL is the general public license. In the 90s, GPL+Internet, many new open source projects started.
3. Richard Stallman from MIT, established a special license, the ________ license. a) GNU b) Free c) Package d) Commercial View Answer
Answer: a Explanation: It was called the GNU license. It ensured that software is free and open to anyone. He was from MIT and his main motive was to develop a free alternative to Unix.
4. In 1969 AT&T laboratories developed ______ which supported and worked on different hardware platforms. a) Linux b) Unix c) Windows d) Ubuntu View Answer
Answer: b Explanation: Unix was found in that year. It worked well on different hardware platforms. Commercial users had to pay a license fee.
5. OSS stands for ___________ a) Open System Service b) Open Source Software c) Open System Software d) Open Synchronized Software View Answer
Answer: b Explanation: OSS stands for open source software. OSS allows any user to download, view, modify and redistribute the software. Also, the user can fix bugs according to needs.
6. Public domain software is usually __________ a) System supported b) Source supported c) Community supported d) Programmer supported View Answer
Answer: c Explanation: The public domain software is generally community supported. It is community supported as an author does not support users directly.
7. Set of a program which consists of full documentation. a) Software Package b) System Software c) Utility Software d) File package View Answer
Answer: a Explanation: It is called a software package. Software is nothing but a collection of programs. A software package can solve a specific problem or perform a specific type of job.
8. Interpreter is used as a translator for? a) Low level language b) High Level Language c) COBOL d) C View Answer
Answer: b Explanation: It is generally used to make the code into a machine understandable format. Interpreter is used with the high level languages similarly. Assembler is used in case of low level languages.
9. What do you call a specific instruction designed to do a task? a) Command b) Process c) Task d) Instruction View Answer
Answer: a Explanation: A program is a set of instructions. A command is given to do a specific job. A program in execution is called a process.
10. They normally interact with the system via user interface provided by the application software. a) Programmers b) Developers c) Users d) Testers View Answer
Answer: c Explanation: Users interact with the system via user interface that is given by the application software. Application software is a set of instructions designed to serve a particular purpose.
Which of the following is not an SQL command? a. Create Database b. Create Table c. Create Query d. Show Table
Show Answer
c. Create Query
A table can have __ foreign keys a. 1 b. 2 c. Many d. Depends on RDBMS
Show Answer
c. Many
In which of the following case DML is not executed? a. When new record is added b. When existing record is modified c. When existing attribute is modified d. When records are deleted
Show Answer
c. When existing attribute is modified
Which is the correct difference between Primary key and Foreign key? a. A table can have multiple primary key and single foreign key b. A primary key cannot ignore NULL value but Foreign key can c. A Primary key can have duplicate data but foreign key does not d. None of the above
Show Answer
b. A primary key cannot ignore NULL value but Foreign key can
in SQL ‘FROM’ clause is used to a. Define source table name while retrieving records b. Define Column name while retrieving records c. Define Criteria while retrieving records d. Define values while inserting records
Show Answer
a. Define source table name while retrieving records
Which if the following is not an SQL aggregate function? a. Avg b. Max c. Count d. All are aggregate function
Show Answer
d. All are aggregate function
SQL stands for a. Structured Question Language b. Structured Query Language c. Super Query Language d. System Query Language
Show Answer
b. Structured Query Language
Which of the following is not true about DDL ? a. The retrieval of information stored in database b. The creation of schema object in database c. The deletion of schema object d. All are not True
Show Answer
a. The retrieval of information stored in database
DELETE FROM Book where Price <= 2000; is a _________type of statement a. DDL b. DML c. DCL d. None
Show Answer
b. DML
A table can not have more than one UNIQUE keys. a. True b. False c. Depends upon Primary key d. Depends upon RDBMS
Show Answer
b. False
For given table ‘emp’ with following columns eno, ename, sal, dept, designation Select correct statement to display all records of ‘emp’ in descending order of ename and within ascending order of dept. a. SELECT * FROM emp ORDER BY ename, dept DESC; b. SELECT * FROM emp ORDER BY ename, ORDER BY dept DESC; c. SELECT * FROM emp ORDER BY ename DESC, dept; d. SELECT * FROM emp WHERE ORDER BY ename, dept DESC;
Show Answer
c. SELECT * FROM emp ORDER BY ename DESC, dept;
Which of the following is not an SQL Constraint? a. IS NULL b. Primary Key c. Default d. Check
Show Answer
a. IS NULL
Select correct SQL statement to increase price of books by 10% in book table. a. UPDATE book SET price = price0.1; b. UPDATE book SET price = price + price0.1; c. UPDATE book WHERE price = price0.1; d. UPDATE book WHERE price = price + price0.1;
Show Answer
b. UPDATE book SET price = price + price0.1;
Database Management System MCQ (Multiple Choice Questions)
1. What is the full form of DBMS? a) Data of Binary Management System b) Database Management System c) Database Management Service d) Data Backup Management System View Answer
Answer: b Explanation: DBMS is abbreviated as Database Management System. Database Management System stores the data and allows authorized users to manipulate and modify the data.
2. What is a database? a) Organized collection of information that cannot be accessed, updated, and managed b) Collection of data or information without organizing c) Organized collection of data or information that can be accessed, updated, and managed d) Organized collection of data that cannot be updated View Answer
Answer: c Explanation: It is defined as an organized collection of data or information for easy access, updating, and management in a computer.
3. What is DBMS? a) DBMS is a collection of queries b) DBMS is a high-level language c) DBMS is a programming language d) DBMS stores, modifies and retrieves data View Answer
Answer: d Explanation: DBMS is nothing but a storehouse wherein the authorized user can create a database to store, modify or retrieve the organized data in the table. It can be modified or retrieved by users who have access to DBMS only.
4. Who created the first DBMS? a) Edgar Frank Codd b) Charles Bachman c) Charles Babbage d) Sharon B. Codd View Answer
Answer: b Explanation: Charles Bachman along with his team invented the first DBMS known as Integrated Data Store (IDS).
5. Which type of data can be stored in the database? a) Image oriented data b) Text, files containing data c) Data in the form of audio or video d) All of the above View Answer
Answer: d Explanation: The reason for creating the database management system was to store large data and these data can be of any form image, text, audio, or video files, etc. DBMS allows the users to store and access the data of any format.
advertisement
6. In which of the following formats data is stored in the database management system? a) Image b) Text c) Table d) Graph View Answer
Answer: c Explanation: The data is stored in a table format intended to manage the storage of data and manipulate stored data to generate information.
7. Which of the following is not a type of database? a) Hierarchical b) Network c) Distributed d) Decentralized View Answer
8. Which of the following is not an example of DBMS? a) MySQL b) Microsoft Acess c) IBM DB2 d) Google View Answer
Answer: d Explanation: MySQL, Microsoft Access, IBM DB2 are database management systems while Google is a search engine. MySQL is a Linux-based database management system, Microsoft Access is a tool that is a part of Microsoft Office used to store data, IBM DB2 is a database management system developed by IBM. Google’s Bigtable is the database that runs Google’s Internet search, Google Maps, YouTube, Gmail, and other products.
9. Which of the following is a feature of DBMS? a) Minimum Duplication and Redundancy of Data b) High Level of Security c) Single-user Access only d) Support ACID Property View Answer
Answer: c Explanation: The important features of a database management system are: 1) Minimum Duplication and Redundancy of Data 2) High Level of Security 3) Mulitple-user Access 4) Support ACID Property
10. Which of the following is a feature of the database? a) No-backup for the data stored b) User interface provided c) Lack of Authentication d) Store data in multiple locations View Answer
Answer: b Explanation: The important features are: 1) Provides backup for the data stored by the user and the user can retrieve the data whenever required. 2) Provides User-interface to access the data. 3) Only authorized users can access the stored data. 4) Data is stored in one central location but multiple authorized users can access the data.
11. Which of the following is not a function of the database? a) Managing stored data b) Manipulating data c) Security for stored data d) Analysing code View Answer
Answer: d Explanation: It allows authorized users to update, store, manipulate, or access data. Since data is stored in table format it is easy to access the data and perform the required functions. It also removes duplicate and redundant data.
12. Which of the following is a function of the DBMS? a) Storing data b) Providing multi-users access control c) Data Integrity d) All of the above View Answer
Answer: d Explanation: The purpose of creating DBMS was to store the data. The data stored in the database management system can be can accessed by multiple users if the access is provided. The data stored will be accurate and complete hence providing data integrity
