Daily Exam Programmer 27-07-2024

Join us on Telegram


Q 1:

Consider;

public class MyClass

{

public MyClass() { /*code*/ }

//more code

}

To instantiate MyClass, you would write?

(1) MyClass mc= new MyClass();
(2) MyClass mc= MyClass();
(3) MyClass mc= MyClass;
(4) MyClass mc= new MyClass;
Correct Answer: MyClass mc= new MyClass();

Q 2: Which of the following tool is not used during system analysis
(1) Data Flow Diagram
(2) Structured English
(3) Structured Chart
(4) Decision Table
Correct Answer: Structured Chart

Q 3: Which is not a product metric?
(1) Size
(2) Reliability
(3) Productivity
(4) Functionality
Correct Answer: Productivity

Q 4: UML stands for
(1) Uniform Modeling Language
(2) Unified Modeling Language
(3) Universal Modeling Language
(4) None
Correct Answer: Unified Modeling Language

Q 5: Viruses which execute when computer starts is=
(1) Macro
(2) file infector
(3) boot sector
(4) salami shaving
Correct Answer: boot sector

Q 6: A.... is an ARP that acts on behalf of a set of hosts.
(1) ARP
(2) RARP
(3) proxy ARP
(4) None
Correct Answer: proxy ARP

Q 7: Which of the following is true regarding VLANs?
(1) Two VLANs are configured by default on all Cisco switches.
(2) VLANs only work if you have a complete Cisco switched internetwork. No off-brand switches are alloweed.
(3) You should not have more than 10 switches in the sam eVTP domain
(4) VTP is used to send VLAN information to switches in a configured VTP domain
Correct Answer: VTP is used to send VLAN information to switches in a configured VTP domain

Q 8:

Consider the following Employee table:


E_No
Job
Salary
Dept_No
178
System Analyst
25000
10
179
Software Engineer
30000
10
180
Quality Assurer
21000
20
181
Technical Writer
17000
30
182
Associate Software Engineer
20000
10

Which of the following statements gives the list of departments having average salary greater than 25000 from employee table?

(1) SELECT Dept_No, AVG (Salary) FROM Employee ORDER BY Dept_No HAVING AVG (Salary) > 25000
(2) SELECT Dept_No, AVG (Salary) FROM Employee HAVING AVG (Salary) > 25000
(3) SELECT Dept_No, AVG (Salary) FROM Employee GROUP BY Dept_No HAVING AVG (Salary) > 25000
(4) SELECT Dept_No, AVG (Salary) FROM Employee WHERE AVG (Salary) > 25000
Correct Answer: SELECT Dept_No, AVG (Salary) FROM Employee GROUP BY Dept_No HAVING AVG (Salary) > 25000

Q 9: Aggregation is:
(1) An abstraction through which relationships are not treated at all as entities
(2) An abstraction through which relationships are treated as higher level entities
(3) An abstraction through which relationships are treated as lower level entities
(4) None
Correct Answer: An abstraction through which relationships are treated as higher level entities

Q 10:

Which of the following commands permanently delete the record marked for deletion from the data base filed?

(1) PACK
(2) ZAP
(3) SEEK
(4) SKIP
Correct Answer: PACK