Description : Discounted cash flow criteria for investment appraisal does not include A. Not present value B. Benefit cost ratio C. Accounting rate of return D. Internal rate of return
Last Answer : B. Benefit cost ratio
Description : Cost Unit is defined as: (a) Unit of quantity of product, service or time in relation to which costs may be ascertained or expressed (b) A location, person or an item ... the responsibility of generating and maximising profits (d) Centres concerned with earning an adequate return on investment
Last Answer : Unit of quantity of product, service or time in relation to which costs may be ascertained or expressed
Description : Increased volume of sales is an example of ………….…. Benefit. Reduction of bad debts is an example of ……….. A) Tangible, Intangible B) Tangible, Tangible C) Intangible, Tangible D) Intangible, Intangible
Last Answer : D) Intangible, Intangible
Description : Select the ‘False’ statement from the following statements about Normal Forms: (A) Lossless preserving decomposition into 3NF is always possible (B) Lossless preserving decomposition into BCNF is always possible (C) Any relation with two attributes is in BCNF (D) BCNF is stronger than 3NF
Last Answer : (B) Lossless preserving decomposition into BCNF is always possible
Description : Rol measures----- a) Profitability in relation to investment b) Profitability in relation to sales c) Operating efficiency d) Long term solvency
Last Answer : a) Profitability in relation to investment
Description : ………………………. is an important factor of management information system. A) System B) Data C) Process D) All
Last Answer : A) System
Description : As compared to rental and leasing methods to acquire computer systems for a Management Information System (MIS), purchase method has following advantage : (A) It has high level of flexibility (B) It doesn’t require cash up-front (C) It is a business investment (D) Little risk of obsolescence
Last Answer : (C) It is a business investment
Description : In a heat treatment shop, steel components are heat-treated in batches of 80 Tons. The heat treatment cycle is as follows; Increase temperature from 30 OC to 850 OC in 3 hours. ... efficiency of 80%, for same requirement. The investment towards installation of the new furnace is Rs. 50
Last Answer : Quantity of steel treated per batch - 80 Tons a. Efficiency of Furnace: Useful heat supplied to steel - 80000 x 0.12 x (850 - 30) = 7872000 kcal/batch .1 mark Total heat ... = Rs. 64400/batch Efficiency of new LPG furnace - 80% Heat supplied in new LPG furnace - 7872000/0.8
Description : Which of the following might be considered a "red flag" indicating possible fraud in a large manufacturing company with several subsidiaries? a. A consistent record of above average ... payrolls by each subsidiary d. Complex sales-transactions and transfers of funds between affiliated companies
Last Answer : Complex sales-transactions and transfers of funds between affiliated companies
Description : When a company adjusts price levels so that it can increase sales volume to levels that match the organisation's expenses, it is said to employ a ---- pricing objective. A)market share B)cash flow C)return on investment D)survival E)profit
Last Answer : D)survival
Description : _____________ may be defined as the excess of present value of project cash inflows over that of out flows. A. Net present value technique. B. Average rate of return. C. Benefit-Cost ratio. D. Internal rate of return
Last Answer : A. Net present value technique.
Description : The main ingredient of the report documenting the ……………… is the cost benefit analysis. A) System Analysis B) Feasibility Study C) System Analyst D) System Design
Last Answer : B) Feasibility Study
Description : Which of the following is not typically a benefit of dynamic linking? I. Reduction in overall program execution time. II. Reduction in overall space consumption in memory. III. Reduction in overall space consumption on disk. IV. ... updates. (A) I and IV (B) I only (C) II and III (D) IV only
Last Answer : (B) I only
Description : The return available by investing the capital elsewhere is known as (A) profit rate (B) discount rate (C) opportunity cost (D) return on investment
Last Answer : (C) opportunity cost
Description : _________ method for profitability evaluation of a project does not account for investment cost due to land. (A) Net present worth (B) Pay out period (C) Discounted cash flow (D) Rate of return on investment
Last Answer : (B) Pay out period
Description : Pick out the wrong statement. (A) The annual depreciation rate for machinery and equipments in a chemical process plant is about 10% of the fixed capital investment (B) Annual depreciation rate ... chemical industry, research and development cost amounts to about 15% of net sales realisation (NSR)
Last Answer : (D) In a chemical industry, research and development cost amounts to about 15% of net sales realisation (NSR)
Description : Explain the following a) Dry Bulb Temperature and Wet bulb Temperature b) Maximum Demand and Power Factor c) Gross Calorific Value & Net Calorific Value d) 5S & Return of Investment (ROI) e) CUSUM
Last Answer : a) Dry Bulb Temperature and Wet bulb Temperature Dry bulb Temperature is an indication of the sensible heat content of air-water vapour mixtures Wet bulb Temperature is a measure of ... of capital cost. This is a broad indicator of the annual return expected from initial capital investment
Description : ………………….. operator is basically a join followed by a project on the attributes of first relation. A) Join B) Semi-Join C) Full Join D) Inner Join
Last Answer : B) Semi-Join
Description : Select operator is not a unary operator. ii) Project operator chooses subset of attributes or columns of a relation. A) i-True, ii-False B) i-True, ii-True C) i-False, ii-True D) i-False, ii-False
Last Answer : C) i-False, ii-True
Description : A .................. normal form normalization will be needed where all attributes in a relation tuple are not functionally dependent only on the key attribute. A) First B) Second C) Third D) Fourth
Last Answer : C) Third
Description : The number of attributes in relation is called as its ..................... A) Cardinality B) Degree C) Tuples D) Entity
Last Answer : B) Degree
Description : An instance of a relation is a time varying set of …………………. A) Tuples B) Rows C) Both of them D) None of them
Last Answer : C) Both of them
Description : The number of tuples in a relation is called its …………. While the number of attributes in a relation is called it’s ……………….. A) Degree, Cardinality B) Cardinality, Degree C) Rows, Columns
Last Answer : B) Cardinality, Degree
Description : ………..defines the structure of a relation which consists of a fixed set of attribute-domain pairs. A) Instance B) Schema c) Program D) Super Key
Last Answer : B) Schema
Description : The RDBMS terminology for a row is (A) tuple. (B) relation. (C) attribute. (D) degree.
Last Answer : (A) tuple
Description : _____ produces the relation that has attributes of R1 and R2 (A) Cartesian product (B) Difference (C) Intersection (D) Product
Last Answer : A) Cartesian product
Description : A relational database developer refers to a record as (A) a criteria. (B) a relation. (C) a tuple. (D) an attribute.
Last Answer : C) a tuple
Description : A thread is usually defined as a light weight process because an Operating System (OS) maintains smaller data structure for a thread than for a process. In relation to this, which of the following ... separate stack for each thread. (D) OS does not maintain virtual memory state for each thread.
Last Answer : (B) OS maintains only CPU registers for each thread.
Description : Let the time taken to switch between user mode and kernel mode of execution be T1 while time taken to switch between two user processes be T2. Which of the following is correct? (A) T1 < T2 (B) T1 > T2 (C) T1 = T2 (D) Nothing can be said about the relation between T1 and T2.
Last Answer : (A) T1 < T2
Description : The solution of recurrence relation, T(n) = 2T(floor (√n)) + logn is (A) O(n log log logn) (B) O(n log logn) (C) O(log logn) (D) O(logn log logn)
Last Answer : (D) O(logn log logn)
Description : For a database relation R(a, b, c, d) where the domains of a, b, c, d include only the atomic values. The functional dependency a → c, b → d holds in the following relation (A) In 1NF not in 2NF (B) In 2NF not in 3NF (C) In 3NF (D) In 1NF
Last Answer : (A) In 1NF not in 2NF
Description : The employee information of an Organization is stored in the relation: Employee (name, sex, salary, deptname) Consider the following SQL query Select deptname from Employee Where sex = M' ... D) Average salary of male employees in a department is more than average salary of the organization.
Last Answer : (D) Average salary of male employees in a department is more than average salary of the organization.
Description : The relation "divides" on a set of positive integers is .................. (A) Symmetric and transitive (B) Anti symmetric and transitive (C) Symmetric only (D) Transitive only
Last Answer : (B) Anti symmetric and transitive Explanation: The ‘divide’ operation is antisymmetric because if a divides b does not necessarily implies that b divides a. If a divides b and b divides c then a divides c. So, it is transitive as well.
Description : If D1, D2,…. Dn are domains in a relational model, then the relation is a table, which is a subset of (A) D1+D2+…. +Dn (B) D1x D2x… xDn (C) D1U D2U….UDn (D) D1- D2-….-Dn
Last Answer : (B) D1x D2x… xDn
Description : A Network Schema (A) restricts to one to many relationship (B) permits many to many relationship (C) stores Data in a Database (D) stores Data in a Relation
Last Answer : (B) permits many to many relationship
Description : Consider the formula in image processing RD = 1 - (1/CR) Where CR = n1/n2 CR is called as compression ratio n1 and n2 denotes the number of information carrying units in two datasets that represent ... . (A) Data Compression (B) Data Redundancy (C) Data Relation (D) Data Representation
Last Answer : (B) Data Redundancy
Description : The relation schemas R1 and R2 form a Lossless join decomposition of R if and only if: (a) R1⋂R2→(R1-R2) (b) R1→R2 (c) R1⋂R2→(R2-R1) (d) R2→R1⋂R2 (A) (a) and (b) happens (B) (a) and (d) happens (C) (a) and (c) happens (D) (b) and (c) happens
Last Answer : (C) (a) and (c) happens
Description : The Relation Vendor Order (V_no, V_ord_no, V_name, Qty_sup, unit_price) is in 2NF because : (A) Non key attribute V_name is dependent on V_no which is part of composite key (B) ... Qty_sup is dependent on primary_key unit price (D) key attribute V_ord_no is dependent on primary_key unit price
Last Answer : (A) Non key attribute V_name is dependent on V_no which is part of composite key
Description : The STUDENT information in a university is stored in the relation STUDENT (Name, Sex, Marks, DEPT_Name) Consider the following SQL Query SELECT DEPT_Name from STUDENT where SEX='M' group by ... The average marks of students is more than the average marks of male students in the University
Last Answer : (B) The average marks of male students is more than the average marks of the students in the University
Description : Suppose ORACLE relation R(A, B) currently has tuples {(1, 2), (1, 3), (3, 4)} and relation S(B, C) currently has {(2, 5), (4, 6), (7, 8)}. Consider the following two SQL queries SQ1 and SQ2 ... (A) 2 and 6 respectively (B) 6 and 2 respectively (C) 2 and 4 respectively (D) 4 and 2 respectively
Last Answer : (D) 4 and 2 respectively
Description : A relation R={A,B,C,D,E,F,G} is given with following set of functional dependencies: F={AD→E, BE→F, B→C, AF→G} Which of the following is a candidate key? (A) A (B) AB (C) ABC (D) ABD
Last Answer : Answer: D
Description : Let R and S be two fuzzy relations defined as: Then, the resulting relation, T, which relates elements of universe x to elements of universe z using max-min composition is given by
Last Answer : Answer: C
Description : Let L be the language generated by regular expression 0*10* and accepted by the deterministic finite automata M. Consider the relation RM defined by M. As all states are reachable from the start state, RM has ................ equivalence classes. (A) 2 (B) 4 (C) 5 (D) 6
Last Answer : (D) 6
Description : Consider the following two commands C1 and C2 on the relation R from an SQL database: C1: drop table R; C2: delete from R; Which of the following statements is TRUE? I. Both C1 and C2 delete the schema for R. II. C2 ... R. (A) I only (B) I and II only (C) II and III only (D) I, II and III
Last Answer : (C) II and III only
Description : The asymptotic upper bound solution of the recurrence relation given by T(n)= 2T(n/2)+n/log n is: (1) O(n2) (2) O(n log n) (3) O(n log log n) (4) O(log log n)
Last Answer : (3) O(n log log n)
Description : Consider the following relation: Works (emp_name, company_name, salary) Here, emp_name is primary key. Consider the following SQL query Select emp_name From Works T where salary>(select avg ( ... 4) Find all employees who earn more than the average salary of all employees of their company.
Last Answer : Find all employees who earn more than the average salary of all employees of their company.
Description : For a database relation R(A,B,C,D) where the domains of A,B,C and D include only atomic values, only the following functional dependencies and those that can be inferred from them are: A→C B→D The ... form but not in third normal form (4) Both in second normal form as well as in third normal form
Last Answer : First normal form but not in second normal form
Description : Let pk(R) denotes primary key of relation R. A many-to-one relationship that exists between two relations R1 and R2 can be expressed as follows: (1) pk(R2)→pk(R1) (2) pk(R1)→pk(R2) (3) pk(R2)→R1∩R2 (4) pk(R1)→R1∩R2
Last Answer : Answer: 2
Description : What is the benefit of Inheritance?
Last Answer : A: It is a very useful feature as it provides the concept of reusability. Also, it allows us to include or remove any features to an existing class without modifying it.
Description : With regard to the rate of return on investment (ROI), which one of the following statements is not valid ? (A) It is an overall indicator of the profitability of an enterprise (B) It is a ... superior measure compared to the cash flow generated per share (D) It was first developed by Dupont, USA
Last Answer : Answer: It is a superior measure compared to the cash flow generated per share