Durability:<\/strong> This enables transactions to be saved regardless of any system failure.<\/li>\n<\/ul>\n\n\n\nQ44. Explain the concept of garbage collection in Java.<\/h4>\n\n\n\n
Answer:<\/strong> Java’s garbage collection mechanism automatically releases memory that is being used by unused objects. This means freeing up memory space, which makes it easier for developers to code Java apps.<\/p>\n\n\n\nQ45. Define synchronization in Java.<\/h4>\n\n\n\n
Answer:<\/strong> Synchronization in Java refers to the ability to manage and regulate the access of multiple threads to a shared resource. In multithreading, when several threads attempt to access shared resources simultaneously, it can result in inconsistent outcomes. Therefore, synchronization is crucial for ensuring reliable communication between these threads.<\/p>\n\n\n\nQ46. What is an SQL scalar function in a DBMS?<\/h4>\n\n\n\n
Answer:<\/strong> A scalar function refers to a custom-made function programmed in SQL that produces a single value whenever it is called upon. The source code for the user-defined function can be found within its definition. These functions are categorized into two types: inlined and compiled versions.<\/p>\n\n\n\nQ47. What is the significance of the ‘this’ keyword in Java?<\/h4>\n\n\n\n
Answer:<\/strong> In Java, the keyword ‘this’ plays a vital role by referring to the current object. Essentially, it represents the specific instance of a class in which it is utilized. This powerful tool allows for easy access to and modification of fields within an object, particularly when field names overlap with local variable names.<\/p>\n\n\n\nQ48. List the various levels of data abstraction in a DBMS.<\/h4>\n\n\n\n
Answer:<\/strong> The levels of data abstraction are:<\/p>\n\n\n\n\n- Physical Level (Actual Storage): <\/strong>This level defines how data is stored.<\/li>\n\n\n\n
- Logical Level (Database Schema):<\/strong> This level explains the relationships that exist between data.<\/li>\n\n\n\n
- View Level (Virtual Tables): <\/strong>This provides a quality view of the different data sections.<\/li>\n<\/ul>\n\n\n\n
Q49. Explain the process of pattern matching in SQL.<\/h4>\n\n\n\n
Answer:<\/strong> In SQL, pattern matching is a common technique for searching text data. This is achieved through the use of the ‘LIKE’ operator, which allows users to search for specific patterns within a string. <\/p>\n\n\n\nWildcard characters such as ‘%’ and ‘_’ are frequently used in conjunction with this operator to represent unknown or variable parts of the string. The per cent sign represents zero or more characters, while the underscore stands for any single character.<\/p>\n\n\n\n
Q50. Define hard real-time (HRT) systems.<\/h4>\n\n\n\n
Answer:<\/strong> HRT systems are designed to handle time-critical tasks efficiently and reliably. This is achieved through various techniques, such as deterministic scheduling, priority-based execution, and hardware synchronization mechanisms. These techniques ensure that critical tasks receive the necessary computational resources on time.<\/p>\n\n\n\nQ51. What sets DROP and TRUNCATE commands apart?<\/h4>\n\n\n\n
Answer:<\/strong> DROP completely removes database objects like tables, indexes, views, or procedures from the database. TRUNCATE removes all rows from a table, deallocating the data pages used by the table’s data, but it keeps the table’s structure intact, including its columns, constraints, indexes, and triggers.<\/p>\n\n\n\nQ52. Can you distinguish between the UNIQUE and DISTINCT keywords in DBMS?<\/h4>\n\n\n\n
Answer:<\/strong> DISTINCT is used in queries to retrieve unique values from a result set, eliminating duplicate rows. UNIQUE, on the other hand, is a constraint applied to a column in a table, ensuring that each value in that column is unique within the table. Despite serving different purposes, both DISTINCT and UNIQUE contribute to maintaining data consistency across tables and queries.<\/p>\n\n\n\nQ53. How many accounting standards does India have?<\/h4>\n\n\n\n
Answer:<\/strong> The Council of the Institute of Chartered Accountants in India (ICAI) has released a total of 41 accounting standards.<\/p>\n\n\n\nQ54. Why are accounting standards mandatory?<\/h4>\n\n\n\n
Answer:<\/strong> Accounting standards are mandatory to reduce discrepancies in financial statements and ensure uniformity across companies.<\/p>\n\n\n\nQ55. How do you estimate bad debts?<\/h4>\n\n\n\n
Answer:<\/strong> This can be done by calculating a percentage based on the company’s experience with uncollectible debts. The calculated rate is then applied to the total sales for the period to determine an estimated amount of bad debt expenses.<\/p>\n\n\n\nQ56. Define deferred tax liability.<\/h4>\n\n\n\n
Answer:<\/strong> A deferred tax liability refers to the taxes that a company has not paid in full and will be settled at a later date. It does not imply that the company has failed to meet its tax responsibilities, but rather acknowledges an upcoming payment that is currently unpaid.<\/p>\n\n\n\nQ57. Define deferred tax assets.<\/h4>\n\n\n\n
Answer:<\/strong> A deferred tax asset is a financial entry on the balance sheet that arises when taxes have been overpaid or pre-paid.<\/p>\n\n\n\nQ58. What are some popular accounting applications?<\/h4>\n\n\n\n
Answer:<\/strong> Popular accounting applications are Tally, QuickBooks, Zoho Books, FreshBooks, and Wave.<\/p>\n\n\n\nQ59. Define tally accounting.<\/h4>\n\n\n\n
Answer:<\/strong> Tally is a popular ERP accounting software that enables companies to effectively manage their daily business data. This automates and consolidates various aspects of operations, including purchasing, finance, sales, inventory management, and manufacturing.<\/p>\n\n\n\nPro Tip: <\/strong>Enroll in a short-term Tally course<\/a> to gain proficiency in accounting software widely used in various businesses. <\/p>\n\n\n\nQ60. Define fictitious assets.<\/h4>\n\n\n\n
Answer:<\/strong>Fictitious assets refer to intangible assets that lack a physical form and do not hold any tangible value, yet are presented as legitimate costs in financial reports. <\/p>\n\n\n\nQ61. Explain purchase returns in accounting.<\/h4>\n\n\n\n
Answer:<\/strong> When a customer returns a defective product to the seller and receives either a full or partial refund, this is known as a purchase return. The transaction is then documented in the contra-revenue account. Upon completion of the purchase return, it will be recorded in the same account under contra expenses.<\/p>\n\n\n\nQ62. What is a bank reconciliation statement?<\/h4>\n\n\n\n
Answer:<\/strong> A bank reconciliation statement is a document that compares the bank’s records of a company’s transactions with the company’s records. It is used to ensure that all transactions are accurately recorded and that there are no discrepancies between the bank’s records and the company’s records. <\/p>\n\n\n\n