This section includes 7 InterviewSolutions, each offering curated multiple-choice questions to sharpen your Current Affairs knowledge and support exam preparation. Choose a topic below to get started.
| 1. |
How to close a Database le and Exit from it? |
|
Answer» Step 1 – Click on the File menu Step 2 – Select Close Then the le will be closed. To exit from the Base le, follow these steps: Step 1 – Click on the File menu Step 2 – Select exit LibreOffice |
|
| 2. |
Pick the key which can not be used to uniquely identify a tuple on a relation:(Candidate Key, Primary Key, Alternate Key, Super Key, None of these) |
|
Answer» None of these. |
|
| 3. |
Name an efficient way to provide only required data to users hiding other data from the database. |
|
Answer» View is an efficient way to provide only required data to users hiding other data form the database. |
|
| 4. |
What are the different methods to create Forms in LibreOffice Base? |
|
Answer» 1. Create Form in Design view 2. Use wizard to create Form The second method is the easy way to create Forms in LibreOffice Base |
|
| 5. |
How many distinct tuples and attributes are there in relation with cardinality 22 and degree 7. |
Answer»
|
|
| 6. |
Write an example for relational data model. |
||||||||||||
Answer»
|
|||||||||||||
| 7. |
The time on the watch is quarter to three. If the minute-hand points to North-East, in which direction does the hour hand point? (A) South-West (B) South-East (C) North-West (D) North-East |
| Answer» (A) South-West | |
| 8. |
π (pi) Greek letter is used to denote ______ operation in relational algebra. |
|
Answer» π (pi) Greek letter is used to denote Project operation in relational algebra. |
|
| 9. |
A watch reads 4: 30. If the minute-hand points to East, in which directions does the hour-hand point?(A) North-East (B) South-East (C) North-West (D) North |
| Answer» (A) North-East | |
| 10. |
“Girls you are a good team.” Which team do the girls belong to? (a) Badminton (b) Hockey (c) Relay (d) Volleyball |
|
Answer» Correct answer is (c) Relay |
|
| 11. |
Name a way to uniquely identify a tuple in a relation. |
|
Answer» By using primary key. |
|
| 12. |
Consider the following table and write relational algebra operations for the following DEPOSIT. AccNo. Name Branch Amount1001 Kumar Calicut 10,0001002 Salim Trivandrum 25,000 1003 Fida Kottayam 18,000 1004 John Kannur 30,000 1005 Raju Thrissur 5,0001. To display those tuples from DEPOSIT relation where amount is greater than 25,000.2. To display only AccNo. and Amount to fall depositors. |
|
Answer» 1. σamount >25000 (Deposit) 2. πAccNo, amount (deposit) |
|
| 13. |
Match the followingABa) Relationi) Fieldb) Tupleii) Tablec) Attributeiii) Record |
||||||
Answer»
|
|||||||
| 14. |
A single row in the table is called (a) Attribute (b) Tuple (c) Column (d) Cardinality |
|
Answer» Correct answer is (b) Tuple |
|
| 15. |
Pick the key which can not be used to uniquely identify a tuple on a relation: (Candidate Key, Primary Key, Alternate Key, Super Key, None of these) |
|
Answer» None of these. |
|
| 16. |
Distinguish primary key and alternate key. |
Answer»
|
|
| 17. |
Match the following.AB1. Database Administratora. Not concerned with or even aware of details of the DBMS2. Application programmerb. Person who has central control over definition and DBMS3.Usersc. computer professionals who interact with the DBMS through Application Programs |
|
Answer» 1 – b 2 – c 3 – a. |
|
| 18. |
What are the components of DBMS? Explain. |
|
Answer» (a) databases – database is an organized collection of information. (b) Data Denition Language(DDL) – Data Denition Language is used to specify the denitions of Da-tabase Schema. The result of compilation of DDL statements is a set of tables stored in a special le called data dictionary. (c) Data Manipulation Language(DML) – It is a language that enable users to access or manipulate data in the database. It also provides interfaces with programming languages. (d) Users – users interact with DBMS indirectly via application programs or directly via simple query language. |
|
| 19. |
Match the following :ABDomainTableTupleNo. of rows in a relationAttributeNo of columns in a relationCardinalityRows in a relationDegreeA pools of valuesRelationColumn in a Table |
||||||||||||||
Answer»
|
|||||||||||||||
| 20. |
Observe the given table BOOK and write down the outputs of the following relational expressions :Book_codeBook_TitlePublisherPriceC105Computer Fundamentals BPB198C108C++ ProgrammingBPB170P105PhysicsNCERT215P112PhysicsSCERT200C112Mystery of chemistryTata MacGraw Hill189 |
||||||||||||
|
Answer» a. This query returns all the tuples (rows) that contain BPB in column publisher.
b. This query returns the column Book_Title with price < 200. Book Title Computer Fundamentals C++ Programming Mystery of Chemistry. |
|||||||||||||
| 21. |
Components of DBMS |
|
Answer» (a) databases – database is an organized collection of information. (b) Data Denition Language(DDL) – Data Denition Language is used to specify the denitions of Da-tabase Schema. The result of compilation of DDL statements is a set of tables stored in a special le called data dictionary. (c) Data Manipulation Language(DML) – It is a language that enable users to access or manipulate data in the database. It also provides interfaces with programming languages. (d) Users – users interact with DBMS indirectly via ; application programs or directly via simple query language. |
|
| 22. |
Explain the major components of DBMS. |
|
Answer» Components of DBMS 1. Databases – It is the main component. 2. Data Denition Language (DDL) – It is used to dene the structure of a table. 3. Data Manipulation Language (DML) – It is used to add, retrieve, modify and delete records in a database. 4. Users- With the help of programs users interact with the DBMS |
|
| 23. |
A table with three columns is given below. For each relational operation given in the 1st column find the best matches from 2nd and 3rd columns.OperationSymbolFeature1. Selecta) ∩i) output will be only those rows in the first operand table that are not in the second operand.2. Unionb) - (minus)ii) Gives the horizontal subset of the operand table3. Set Differencec) σ (sigma)iii) Gives a table that contains all rows of the operand tablesd) Uiv) Gives the vertical subset of the operand table. |
|
Answer» 1. Select → c) o → (ii) 2. Union → d) ∪ → (iv) 3. Set difference → b) – → (i) |
|
| 24. |
Categorise the users of DBMS and write their functions. |
|
Answer» Users of Database: 1. Database Administrator: It is a person who has a central control over the DBMS. 2. Application Programmer: These are computer professionals who interact with the DBMS through programs. 3. Naive users: He is an end user. He does not know the details of DBMS. |
|
| 25. |
Anju is able to do all the internal operations in a DBMS. What type of user is she? What are the other type of users? |
|
Answer» DBA, Other type users are Appl Prograammer and Naive users. |
|
| 26. |
The SQL Data Manipulation Language (DML) includes a Query language based on relational algebra.(a) Give any four commands used in DML. (b) Write an SQL statement to INSERT values to the elds (adm_no, name, course, percent) with values (101, “Anoop”, “Science”, 75) for the table STUD. |
|
Answer» (a) Insert, delete, select and update (b) insert into STUD values(101,’Anoop’,’Science’,75); |
|
| 27. |
Consider the following Query in SQL. From Employee Where branch = ‘Kannur’ Group By Department Having avg (salary) > 7000, Compare the ‘where’ clause and ‘Having’ Clause using the above query. |
|
Answer» ‘where’ clause applies on single rows but Having clause applies on a group. |
|
| 28. |
Are the numbers 452, 673, 259, 356 divisible by 2? |
|
Answer» 452 and 356 have 2 and 6 in their ones place respectively. So, they are divisible by 2. 673 and 259 have 3 and 9 in their ones place respectively. So, they are not divisible by 2. |
|
| 29. |
Choose the correct words from the brackets and complete the following passage:(sides, unwillingly, saluted, drifting, soldier, forget) “I think that is what every …1…. wants, on both ….2…..,” Heins Wolf said. “Take care, Jim Macpherson. I shall never ….3….. this moment, nor you.” He …..4…. and walked away from me slowly, …..5….., I felt. He turned to wave just once and then became one of the hundreds of grey-coated men 6. back towards their trenches. |
|
Answer» 1. soldier 2. sides 3. forget 4. saluted 5. unwillingly 6. drifting |
|
| 30. |
(a) What is common in all these species. What are they called?O2-, N3-, Mg2+, Na+, F-(b) Arrange the above species in the increasing order of radii.(c) The electron gain enthalpy of F is less than CL. Why? |
||||||||||||
Answer»
Since the number of electrons is same in all these species. So, these species are known as isoelectronic species. (b) Increasing order of radii: Mg2+ < Na+< F−< O2−<N3− (c) The electron gain enthalpy of F is less than Cl due to small size of fluorine. |
|||||||||||||
| 31. |
(a) Define ionization enthalpy. (b) Define electron gain enthalpy. What are its units? |
|
Answer» (a) Ionization Enthalpy : The energy required to remove an electron from an isolated gaseous atom in its ground state is called ionization enthalpy. It is represented by ∆iH. (b) Electron Gain Enthalpy: When an electron is added to a neutral gaseous atom to convert it into a negative ion, the enthalpy change accompanying the process is called electron gain enthalpy. The unit of electron gain enthalpy is kJ/mol. |
|
| 32. |
(i) Which is largest in size Cu+ , Cu2+ or Cu and why?(ii) Which element in periodic table has highest ionization energy (IE)?(iii) Which element is more metallic Mg or Al and why? |
|
Answer» (i) Among Cu+ , Cu2+ or Cu, Cu is largest in size due to less effective nuclear charge. Cu No. of protons = 29, No. of electrons = 29 Cu+ No. of protons = 29, No. of electrons = 29-1 = 28 Cu2+ No. of protons = 29, No. of electrons 29-2 = 27 (ii) In the periodic table, helium (He) has highest ionization energy (IE). (iii) Among Mg or Al, Mg is more metallic due to its low ionization energy. |
|
| 33. |
Explain why? (a) Ionization enthalpy of nitrogen is more than that of oxygen. (b) Electron gain enthalpy of fluorine is less than that of chlorine. (c) Anionic radius is more than the cationic radii. |
|
Answer» (a) 7N = 1s2, 2s2, 2px1,2py1,2pz1 8O = 1s2, 2s2, 2px2,2py1,2pz1 Since nitrogen has half-filled p-orbital which are more stable than incompletely filled p-orbitals of oxygen. So, ionization enthalpy of nitrogen is more than that of oxygen. (b) 9F = 1s2, 2s2, 2px2,2py2,2pz1 17Cl = 1s2, 2s2, 2p6,3s2,3px2, 3py2,3pz1 Fluorine has two shells and the incoming electron is to be accommodated in the second shell. As the radius of second shell is smaller than that of third shell so incoming electron has to face electronic repulsion due to increased electron density. So, electron gain enthalpy of fluorine is less than that of chlorine. (c) Anion in formed by gain of electron by adding extra electron, the net nuclear charge decreases on the valence shell. Hence the radius of anion is greater than that of parent atom. On the other hand the cations are formed by loss of electron, this removes the valence shell and as the number of shells decreases, the radius of cation also decrease as compared to parent atom. |
|
| 34. |
(a) Arrange the following species in increasing order of their ionic size: N3-,Na+, F-, O2- (b) How does atomic radius vary in a period and in a group? How do you explain the variation? |
|
Answer» (a) The species N3−, O2−, F−,Na+ in their increasing order of ionic radii: Na+ < F− < O2− < N3− (b) Across the period-Atomic radii decrease on account of the following facts: Nuclear charge increases progressively by one unit but the additional electron goes to the same principal shell. As a result, the electron cloud is pulled closer to the nucleus by the increased effective nuclear charge. Across the group: Atomic radii increase Reason: Nuclear charge increases with increase in atomic numbers but at the same time, there is progressive increase in principal energy levels. |
|
| 35. |
(a) What is the significance of the term "isolated gaseous atom" while defining ionization enthalpy? (b) Na and Mg+ have the same number of electrons but removal of electron from Mg+ requires more energy. Give reason. (c) Elements in the same group have similar chemical properties. Give reason. |
|
Answer» (a) In the gaseous state, the atoms are widely separated, therefore, interatomic forces are minimum. It is because of this reason the term 'isolated gaseous atom' has been included in definition of ionization enthalpy. (b) The effective nuclear charge increases across a period. Both Na and Mg+ has same numbers of electrons in outermost shell, but Mg+ has more effective nuclear charge than Na. As the effective nuclear charge increases, the hold of the nucleus on the outermost electrons will also be increased. Thus, it will be very difficult to remove the electrons for outer most shell. That's why it is difficult to remove electron from Mg+ as compared to Na. (c) Elements in the same group in the periodic table have similar chemical properties because their atoms have the same number of electrons in the highest outermost shell. |
|
| 36. |
Everyday the presentation of a beautiful flower to Miss. Meadows by _____ her favourite has pupil become a ritual. (a) Muriel (b) Mr. Basil (c) Rosy (d) Mary Beazley |
|
Answer» (d) Mary Beazley |
|
| 37. |
What kind of relationship existed between Miss Meadows and the Science Mistress? |
|
Answer» Both hated each other. Science Miss gave her a “Sugary smile” concealing her hostility. But Miss. Meadows enquiries responded to her deception always with a cold grimace. |
|
| 38. |
Why had Miss Meadows chosen ‘A Lament’ as the lesson that particular day? |
|
Answer» Miss. Meadows had chosen “A lament” as a lesson for that particular day. She was only in a mood to lament her broken engagement and shattered dreams. The choice of the music lesson reflected her real mood of dejection and despondency. |
|
| 39. |
What was the knife that Miss Meadows carried with her? |
|
Answer» Miss. Meadows had received a letter from Mr. Basil calling off the marriage. She deemed it a kind of personal failure. Her anger and disappointed became despair. She carried cold despair buried deep in her heart like a wicked knife. |
|
| 40. |
‘The only difference between a good day and a bad day is your attitude.’Relate this to a real life experience you have had. Share your thoughts in class. |
|
Answer» It is true that attitude makes or mars things. I was waiting for my Std X public exam resuls. I had put in 10 hours of work everyday. I was an average boy but I hoped to join the top five any time. The results were scheduled to be out the next morning. I have no internet connectivity at home. But one of my friends had it. His name is Murali. His father had come to my home. When I was out, he had told my parents I had failed in one subject. When I returned home, I found both my parents upset. I asked them what was wrong. They said it was a bad day. I asked them to tell me what was in their mind. They asked me to take things as they come by. I didn’t understand. My dad told philosophically that failure is a stepping stone to success. Still they were not open with me. When I went out for tea, the local newspapers carried Std X public exam results. To my joy, I had passed with a first class. When I broke the news, my parents disclosed what had upset them. If they had just not reacted to the wrong information, their natural joy would not have been robbed. Now that they knew the information, they were over joyed. I just wondered at the human capacity to go down in misery and bounce back to extreme joy just by a turn of events. The best course of action to be happy all the time would be to. retain the key to our happiness and never give up on our joy to any external event. “Don’t take it on yourself to repay a wrong. Trust the Lord and He will make it right.” |
|
| 41. |
Describe Miss Meadows’ mood before and after receiving the telegram. How did it affect her class? |
|
Answer» Miss. Meadow was heart-broken. The letter written by Basil had pierced her heart and she was bleeding. Her hatred and anger became a knife and she carried it with her. Her icy cold response to science Miss demonstrates it. She is least bothered about the tender feelings of young children who look at her face all time for a friendly nod or smile of approval. Her favourite pupil Mary Beazley is baffled at her treatment of the chrysanthemum she had brought with so much love. The choice of the song “A lament” perfectly jells well with her worst mood. She is in fact in her heart lamenting over the loss of love, trust and future hopes. She is unnecessarily severe with young children forcing them to redo the singing which drives them to despair, pain and tears they manage to stifle. After she receives the telegram from Basil apologizing for his insane letter, her mood changes to joy. She takes the chrysanthemum and keeps it close to her lips to conceal her blush. She goads the children to sing a song of joy congratulating some one for success. She persuades them to show warmth in their voices. Her warm and lively voice dominates the tremulous voices of the young ones. The young ones now realize that Miss Meadow who was in a wax earlier is now in her elements. “My moods don’t just swing – they bounce, pivot, recoil, rebound, oscillate, fluctuate and occasionally PIROUETTE. ” |
|
| 42. |
Briefly explain the cause of Miss Meadows’ joy at the end. |
|
Answer» Contrary to the expectation of Miss. Wyatt, the telegram was from Basil. It was an apology and reconciliatory in nature. In the telegram, her fiance had asked her to ignore the letter written when he must have been mad. A few hours before, she was the embodiment of disappointment and self-pity. The telegram had restored her joy. She could gather the pieces of her shattered dreams and hopes and built them anew. She was so happy that Miss. Wyatt’s warnings fell into deaf ears. |
|
| 43. |
Suggest some ways by which we can maintain a calm temperament under all circumstances. |
|
Answer» Early morning walks, meditation and the practice of treating both success and failure, joy and sorrow with the same composure will naturally increase our life span on this planet. Listening to good music and reading good books, not only text books, can drastically reduce unpleasant stress. Thus we can maintain a calm temperament at all occasions. |
|
| 44. |
Complete the mind map given below and write a brief summary of the story in your own words. |
|
Answer» (i) a letter from Basil breaking the engagement (ii) irritable (iii) sing a lament (iv) Basil as a knife piercing her heart (v) deserted her (vi) of mpod (vii) Head mistress Miss. Wyatt (viii) the letter A brief summary: Miss Meadows was upset over a letter from Basil breaking the engagement. She remains gloomy and irritable in class. She taxes the students making them sing a lament. She thinks of the letter from Basil as a knife piercing her heart. Basil seems to have deserted her. Suddenly she is called by Head mistress Miss. Wyatt. The headmistress gives her a telegram which asks her to forget the letter. Miss Meadows feels happy and returns to the class with vigour and good cheer. |
|
| 45. |
Note the following words from the story. They all refer to different ways of walking. Find out their meanings and use each of them in meaningful sentences of your own. Refer a thesaurus and add a few more to the list.(a) trod (b) fluttered (c) hurried (d) skipped (e) strode (f) sped |
|
Answer» (a) trod – walked, stepped, strode, went (b) fluttered – hovered, danced, flitted, flapped, oscillated, twitched, vibrated, flickered (c) hurried – went fast, hastened, sped, charged, sprinted, chased, scampered, galloped, scrambled. (d) skipped – capered, bobbed, bounded, jumped, leapt, gambolled, ’frisked, romped (e) strode – marched, trod, paced, stalked, dashed, ran, flaunted, joggled, tramped, rushed,zoomed (f) sped – hurried, rushed, zipped, spurred, hurtled, sailed, hastened, quickened |
|
| 46. |
The story is set in _____season. (a) winter (b) spring (c) autumn(d) rainy |
|
Answer» Correct Answer is : (c) autumn |
|
| 47. |
Name the two groups in which various sources of energy are classified. State on what basis are they classified. |
|
Answer» Sources of energy are classified as shown below: 1. Renewable or non-conventional sources 2. Non-renewable or conventional sources The above classification is done on the basis of availability of the energy sources. |
|
| 48. |
Select the renewable and non-renewable sources of energy from the following:(a) Coal(b) Wood(c) Water(d) Diesel(e) Wind(f) Oil |
||||||||
Answer»
|
|||||||||
| 49. |
What is meant by the renewable and non-renewable sources of energy? Distinguish between them giving two examples of weach. |
||||||||||||
Answer»
|
|||||||||||||
| 50. |
Name five renewable and three non-renewable sources of energy |
|
Answer» Five renewable sources of energy: 1. Sun 2. Wind 3. Flowing water 4. Bio-mass 5. Tides Three non-renewable sources of energy: 1. Coal 2. Petroleum 3. Natural gas |
|