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. |
What is an exception? How are exceptions handled in java? Explain with example |
|
Answer» An error situation that is unexpected in the program execution and causes it to terminate unexpectedly is called an exception. For example Division by zero exception: try { int quotient = divide(10,0); System.out.println(quotient); } catch (Exception e) { System.out.println(e.getMessage()); } |
|
| 2. |
Which one is not an advantage of using DBMS Approach? a. Reduction in redundancy b. Improved consistency c. Improved security d. Security and recovery overheads |
|
Answer» Answer: a. Reduction in redundancy |
|
| 3. |
Networks in which certain computers have special dedicated tasks, providing services to other computers (in the network) are called.......... networks |
|
Answer» Client server Networks in which certain computers have special dedicated tasks, providing services to other computers (in the network) are called Client server networks |
|
| 4. |
Cardinality of a table is four and degree is three. If two columns and four rows are added to the table what will be the new degree and cardinality of the given table: a. 5,8 b. 3,4 c. 8,5 d. 4,3 |
|
Answer» Correct option a. 5,8 |
|
| 5. |
Select the correct query from the options given below to display the names of all streams only once. a. Select distinct stream from score; b. Select distinct(stream) from score; c. Select unique stream from score; d. Select stream from score where stream = distinct; |
|
Answer» Correct option: a. Select distinct stream from score; |
|
| 6. |
.................key is an accessibility function which is designed for people who have vision impairment or cognitive disabilities |
|
Answer» Toggle key Toggle key key is an accessibility function which is designed for people who have vision impairment or cognitive disabilities |
|
| 7. |
How database management concepts are helpful in Government sector? |
|
Answer» Database management concepts are helpful in Government sector for storing details of electoral roll, all types of taxes, criminal records, PAN cards, AADHAR cards, vehicle registration, birth/death certificate registration. |
|
| 8. |
Consider a table STAFF:NameCityAkashMumbaiAjayChennaiBanitDelhiFauziaMumbaiSakalChennaiSelect the command which will count the number of people in each city.a. SELECT COUNT(City) , City FROM STAFF WHERE GROUP BY City; b. SELECT COUNT(City) , City FROM STAFF GROUP BY City; c. SELECT COUNT(City) , City FROM STAFF WHERE ORDER BY City; d. SELECT COUNT(City) , City FROM STAFF ORDER BY City; |
|
Answer» Correct option: b. SELECT COUNT(City) , City FROM STAFF GROUP BY City; |
|
| 9. |
Consider the Table EMPLOYEE given below:NameZoneAgeDeptHaritWest2810KritikaCentre3010NaveenEast4020UdayNorth3830NupurEast2420MokshSouth2810ShellyNorth2430Choose the correct query/queries that will give the following output:NameHaritKritikaMoksh1. Select Name from EMPLOYEE where DEPT in (10); 2. Select Name from EMPLOYEE where AGE between 25 and 30; 3. Select Name from EMPLOYEE where NAME like “i%”; 4. Select Name from EMPLOYEE where ZONE in (“West”, “Centre”, ”South”);Choose the correct option a. Only (i) b. Both (i) and (ii) c. Both (ii) and (iv) d. All (i), (ii) and (iv) |
|
Answer» Correct option: d. All (i), (ii) and (iv) |
|
| 10. |
Reema wants to check whether the number is even or not but the code below is giving errors. underline the errors and help her write the correct code. If(int num%2=0); {jTextField1.setText(“even”) Else jTextField1.setText(“odd”) |
|
Answer» If(int num%2=0); {jTextField1.settext(“even”) Else jTextField1.setText(“odd”) Correct code : if(int num%2==0) jTextField1.setText(“even”); else jTextField1.setText(“odd”); (8 errors to be marked and corrected ) |
|
| 11. |
Consider a table ‘SCORE’:ROLLNONAMESTREAMOPTIONAL1GreeshaScience102SatishCommerce303TeenaNULL204YasmineHumanities105YashikaScience106LalitHumanities20Reema wants to display names of those students who have not been assigned any stream. Help her select the correct query:a. Select name from SCORE where stream = NULL;b. Select name from SCORE where stream =null; c. Select name from SCORE where stream = “ “; d. Select name from SCORE where stream is NULL; |
|
Answer» Correct option: d. Select name from SCORE where stream is NULL; |
|
| 12. |
The _______command is used to modify the structure of the table STUDENT in MySQL. a. Modify table STUDENT b. Alter table STUDENT c. Alter STUDENT d. Modify STUDENT |
|
Answer» The Alter table STUDENT command is used to modify the structure of the table STUDENT in MySQL. |
|
| 13. |
Consider a table FACTORY:YEARProduction200812000200910000201010600201115000201214500Reema wants to calculate the average production of the years 2008-2012. Help her select the correct SQL command for it:a. SELECT AVERAGE(Production) from FACTORY; b. SELECT AVERAGE(Production) from FACTORY group by Production; c. SELECT SUM(Production) from FACTORY; d. SELECT AVG(Production) from FACTORY; |
|
Answer» Correct option: d. SELECT AVG(Production) from FACTORY; |
|
| 14. |
The National Portal of India provides a single window access to information and services being provided by the various Indian Government entities Which of the following is the website for the National Portal of India: a. india.gov.in b. india.gov.org c. indian.gov.in d. indian.gov.org |
|
Answer» Correct option: a. india.gov.in |
|
| 15. |
Online shopping is an e-commerce application where the customer can purchase goods over the Internet. There are several websites where the customer can go for online shopping. Select from the options given below which of the following is not an online shopping website: a. snapdeal.com b. myntra.com c. coursera.org d. infibeam.com |
|
Answer» Correct option: c. coursera.org |
|
| 16. |
Garvit wants to change the default value of DISCOUNT in the CUSTOMER table from 10 to 15. Select the most appropriate command to do the same from the following options:a. ALTER TABLE CUSTOMER ALTER DISCOUNT SET DEFAULT 15; b. ALTER TABLE CUSTOMER DELETE DISCOUNT SET DEFAULT 15; c. ALTER TABLE CUSTOMER MODIFY DISCOUNT SET DEFAULT 15; d. ALTER TABLE CUSTOMER CHANGE DISCOUNT SET DEFAULT 15; |
|
Answer» Correct option: a. ALTER TABLE CUSTOMER ALTER DISCOUNT SET DEFAULT 15; |
|
| 17. |
Consider a table: COACHING having fields CITY_NAME, ENROLMENTS. Shikhar wants to display the data of the above table in ascending order of enrolments. Choose the correct query/queries from the following:i. Select * from coaching order by enrolments asc; ii. Select * from coaching order by enrolments desc; iii. Select * from coaching order by enrolments; iv. Select * from coaching order by enrolments ascending;Select the correct option: a. Only (i) is correct b. Both (i) and (ii) are correct c. Both (i) and (iii) are correct d. Only (iv) is correct |
|
Answer» Correct option: c. Both (i) and (iii) are correct |
|
| 18. |
Can I ask questions of JEE level(PCM) in this website and get answered for free within 18-24 hours of asking the question ? |
| Answer» Of course, you can ask questions on JEE Level on this website and will get solutions from Teachers, subject experts, seniors, and friends. | |
| 19. |
Geeta wants to know the usage of NULL in MySQL. Help her choose in which of the following case NULL value cannot be assigned to the column Admission Number: a. When the Admission Number is zero b. When the Admission Number is not known c. When the Admission Number is not available d. When the Admission Number is not applicable |
|
Answer» Correct option: a. When the Admission Number is zero |
|
| 20. |
______are real time lectures, where users participate, may ask questions, and get their queries answered. a. Interactive tutorials b. Video tutorials c. Power Point Presentationd. Webinars |
|
Answer» Webinars are real time lectures, where users participate, may ask questions, and get their queries answered. |
|
| 21. |
Which of the following is NOT an advantage of DBMS approach: a. All the data is stored at one place. There is no repetition of the same data. b. There is a single copy of data that is accessed or updated by all the users. c. The DBA can provide security to the database by controlling users' database access rights. d. Designing the database specifications and writing application programs is a time-consuming process. |
|
Answer» Correct option: d. Designing the database specifications and writing application programs is a time-consuming process. |
|
| 22. |
_______ Phase of Web Application development problem statement for which the web application is to be developed is identified. v. Requirement vi. Design vii. Implementation viii. Test |
|
Answer» v. Requirement Requirement Phase of Web Application development problem statement for which the web application is to be developed is identified. |
|
| 23. |
There are four main phases of development a Web Application Project.Statement 1: The scope of the application is decided in the first phase.Statement 2: The data connectivity is established between the Front-End interface and Back-End Database in the implementation phase.Select the correct option:a. Only Statement 1 is correct b. Only Statement 2 is correct c. Both Statement 1 and Statement 2 are correct d. None of the above statements are correct |
|
Answer» Correct option: c. Both Statement 1 and Statement 2 are correct |
|
| 24. |
Rewrite the following code using WHILE loop:int x=100; for(int i=2;i<=22;i=i+4) { jTextArea1.append("\n"+(i+x)); x=x-2; } |
|
Answer» int x=100; int i = 2; while (i<=22) { jTextArea1.append("\n"+(i+x)); x=x-2; i = i+4; } |
|
| 25. |
Explain important phases of Web Application Development. |
|
Answer» 1.Requirement Definition Phase: In this phase problem is identified for which the web application is to be developed. 2. Design Phase: The focus is on "how" the application is to be designed. 3. Implementation Phase: Create backend database, frontend and the connectivity between them. 4. Testing Phase: Test the complete application (Front-End and Back-End) with multiple sample sets of data. |
|
| 26. |
State the potential areas of Work Integrated Learning in the field of education. |
|
Answer» Work Integrated Learning can be used for. 1. For storing information such as student details, marks and result. 2. For storing information about faculty and Teaching / Non Teaching / Support and staff members. 3. For storing details about school/college such as infrastructure details (transport/ Library /Fees, department and offered course details. |
|
| 27. |
A company is making database of Employees having personal details and Salary details Personal details have columns Empid, Name, Address, BloodGroup. Suggest Columns for Salary Table |
|
Answer» Empid, Basic. Leave, project_details, deductions, allowances. |
|
| 28. |
Rewrite the following code using WHILE loop:int x=100;for(int i=2;i<=22;i=i+4){jTextArea1.append("\n"+(i+x));x=x-2;} |
|
Answer» int x=100,i=2; while(i<=22) { jTextArea1.append("\n"+(i+x)); x=x-2; =i+4; } |
|
| 29. |
Explain Work integrated learning with respect to education sector. |
|
Answer» For storing information such as student details, marks and result. For storing information about faculty and staff members. For storing details about school/college such as infrastructure details, department and offered course details. |
|
| 30. |
What is the role of Water Quality technician? |
|
Answer» Water Pollution is in its alarming state. This has given rise to the need of Water Quality Technicians to help monitor the water quality and treat it. |
|
| 31. |
The following code has error(s). Rewrite the correct code underlining all the corrections made :int n=15,int i=10,x=1;do;{x=x*i;i++;while[i<=n]jTextField1.settext(""+x); |
|
Answer» int n=15; int i=10,x=1; do; { x=x*i; i++; }while(i<=n) ; jTextField1.setText(""+x); ( ½ Mark each for any four corrections) |
|
| 32. |
What are heat set designs? Name any one thermoplastic fibre. |
|
Answer» Moulded at controlled temperature and pressure to create interesting textures and design variations; they are called heat-set designs. Example- Polyester/nylon/acrylic |
|
| 33. |
Explain Drop table with Cascade command. |
|
Answer» Drop Table will be dropped and with the CASCADE option, i.e. all the constraints that refer this table would also be automatically dropped. Example Drop table teacher Cascade; |
|
| 34. |
Differentiate between = and == operator in JAVA |
|
Answer» = is an assignment operator == is a comparison operator For example int a=10; Will assign a value 10 to variable a Whereas a==10 will check whether the value of a is 10 |
|
| 35. |
The following code has some error(s). Rewrite the correct code underlining all the corrections. Also categorize the loop as Entry / Exit Control Loop.int p p = 14; do; p = p-2; System.out.displayln(p); }while p >= 2 |
|
Answer» int p; p = 14; do { p = p-2; System.out.println(p); }while( p >= 2); |
|
| 36. |
Why shaped edges pose technical problems while applying? |
|
Answer» Since decorative effects on the hemlines of skirts and pants prevent length alterations. If the hem is raised or lowered, the design impact is lost. |
|
| 37. |
The following code has error(s). Rewrite the correct code underlining all the corrections made : int x = 10; int y = 50; do; { x+5 = x; y5 = y; while ( x <= y ); |
|
Answer» int x = 10; int y = 50; do { x= x+5; y = y5; } while ( x <= y ); |
|
| 38. |
What is the purpose of using underlining in a garment? |
|
Answer» Applied to the wrong side of the garment primarily to strength, support and durability |
|
| 39. |
Fill in the blanks.(a) The dye is applied with a mechanized ______ which blows or sprays color on the fabric. (b) In Greece, animal figure were painted on clothing using ______ dyes. (c) The fabric is coated with a chemical that is sensitive to light and then any _______ may be printed on it. (d) Polka dots comes under the category of _______ prints. (e) In Textile Industry ______ is employed to provide coloured direction (f) East India Company was given permission to import ____ & _____ . (g) ______ is the oldest form of printing. (h) Flax in 5000 B.C. was used by the early _______ cultures along the nile to make linen like fabric.(i) _______prints are suitable for wallpaper (j) _______prints are an example of Nautical prints (k) _______ was a prominent traditional printing technique in ancient India. (l) Botanical prints have been used a lot by designers like _______ in their collections. |
|
Answer» (a) Air Brush (b) Pigment Dyes (c) Photo printing (d) Dot Print (e) Colorist (f) Calicoes & Chintz (g) Block Printing (h) Egypt ion (i) Toil Prints (j) Boats, Ropes Sails & Shells (k) Bagru , Kalamkari (L) Matthew Willam Son, Alexender MC Queen |
|
| 40. |
Justify given statements: i. American fashion designers are also excellent marketers. ii. American textile industry has created fibres that have revolutionsed the fashion scene. |
|
Answer» i. Who sense the pulse of customers and proactively cater to their desires and lifestyle choices. ii. Nylon, polyester and lycra have become household terms across the world. |
|
| 41. |
Draw the flow chart of check –in procedure in fully automated system? |
|
Answer» A guest with confirmed reservation goes to the self check-in terminal ↓ Inputs the necessary information ↓ Depending on the room availability, the terminal allots the room as per guest preference or suggests alternatives ↓ The guest accepts the allotment and swipes credit card ↓ The terminal dispenses a receipt and issues the room key ↓ The terminal updates the front office records and sends notifications to all concerned departments. |
|
| 42. |
Discuss two items of clothing worn by women to cover lower half of the body. |
|
Answer» i. Skirts: Skirts cover the lower half of a woman‘s body. Different styles of skirts such as straight, flared, gathered, pleated, tiered, paneled can be achieved by pattern variations. ii. Trousers: Trousers also called Pants are bifurcated garments for lower half of the body. Some styles of trousers are Straight leg, Capri, Bell bottom/ Flared, riding pants also called Jodhpurs. |
|
| 43. |
Which of the following is not a self-management skill? (a) Problem solving (b) Bargaining (c) Understanding self (d) Confidence building |
|
Answer» Correct option: (b) Bargaining |
|
| 44. |
What does GPS stand for? (a) Global Positioning System (b) Global Payment System (c) Global Program System (d) Global Pointing System |
|
Answer» Correct option: (a) Global Positioning System |
|
| 45. |
"Who came to the party?" Which sentence type is used? (a) Imperative (b) Declarative (c) Interrogative |
|
Answer» Correct option: (c) Interrogative |
|
| 46. |
What are nutraceuticals and give 2 example. |
|
Answer» Nutraceuticals or functional foods are foods that offer health benefits beyond their nutritional value. In addition to nutrient-rich ingredients like fruits and veggies, the category also includes foods fortified with vitamins, minerals, probiotics, and fiber. Functional foods are generally separated into two categories: conventional and modified. Conventional foods are natural, whole-food ingredients that are rich in important nutrients like vitamins, minerals, antioxidants, and heart-healthy fats. Meanwhile, modified foods have been fortified with additional ingredients, such as vitamins, minerals, probiotics, or fiber, to increase a food’s health benefits. Here are some examples of conventional functional foods:
Here are some examples of modified functional foods:
|
|
| 47. |
What is the aim of entrepreneurship?(a) Earn a profit(b) Solve customers’ need innovatively (c) Both of the above (d) None of the above |
|
Answer» Correct option: (c) Both of the above |
|
| 48. |
Explain the role of computer in the following sections of a hotel i) Reservations ii) Front Desk iii) House keeping iv) Night Auditing |
|
Answer» Computer technology plays an important role in the hospitality and tourism industry. Today, most hospitality businesses such as: hotels, motels, food service, and beverage operations are using computers to record, report, and analyze the effectiveness of internal operations. i. Reservations: Use of computers has made the reservation or booking of rooms easy. It helps the reservation staff to rapidly check the availability of rooms when the guest calls for reserving a room. Reservation staff uses computer software programs to make reservations. ii. Front Desk: Front desk personnel use the software to check-in and checkout of guests and to print off bills. Additionally, they may check the computer to see if a room has been cleaned before checking in a guest. iii. Housekeeping: Housekeepers use the same software as front desk staff to verify which rooms are checking out and staying over each day. That way, they know which rooms to clean completely and which ones to simply tidy. Housekeepers use the software to communicate to the front desk, letting them know which rooms are clean vacant and available for check-ins. iv. Night Auditing: Night auditors use computer software for daily and overall accounting purposes. This includes reviewing the day’s check-ins and check-outs, payments received and owing and complementary given out, to make sure all is in order. |
|
| 49. |
Which of the following is a kind of flower arrangement? a) Bonsai b) Ikebana c) Topiary d) Hedge |
|
Answer» Correct option: b) Ikebana |
|
| 50. |
What do you mean by public health nutrition? |
|
Answer» Public Health Nutrition (PHN) focuses on the promotion of good health through nutrition and the primary prevention of nutrition related illness in the population. The journal provides an international peer-reviewed forum for the publication and dissemination of research aimed at understanding the causes of, and approaches and solutions to nutrition-related public health achievements, situations and problems around the world. This international journal is essential reading for epidemiologists and health promotion specialists interested in the role of nutrition in disease prevention; academics and those involved in fieldwork and the application of research to identify practical solutions to important public health problems. |
|