NEW
Font size
WorksheetsDiagnostic Associate Diploma Software- Repeat 1
Total questions: 60
Worksheet time: 30mins
If different properties and functions of a real world entity is grouped or embedded into a single element, what is it called in OOP language? (Unit 7 KLO 1.1)
A. Inheritance
B. Polymorphism
C. Abstraction
D. Encapsulation
If you have a java program and you want to write comments in that program which of the following would you consider for writing a single line comment? (Unit 7 KLO 1.2)
A. /* ___*/
B. //
C. /**
D. !—
Provides interfaces and classes for transferring data between and within applications. (Unit 7 KLO 1.3)
A. java.awt
B. java.awt.datatransfer
C. java.awt.swing
D. java.awt.dnd
Typically, you write a code in a programming language such as Java or C++. Who or what is responsible for ensuring that the language you are using is translated into the language of the machine you are using? (Unit 7 KLO 1.4)
A. Interpreter
B. Compiler
C. Trannslator
D. Editor
Which of the following converts human readable file into platform independent code file in Java? (Unit 7 KLO 1.4a)
A. JRE
B. Applet
C. Compiler
D. JVM
What is the definition of machine code? (Unit 7 KLO 1.4b)
A. A code of ethic that machines operates by, which prevents Skynet from deciding to exterminate the human race in order to fulfill the mandates of its original coding.
B. A higher level programming language that is similar to human speech.
C. The MAC address of a computer that enables Information Technology professionals to identify computers on a network.
D. A strictly numerical language which is intended to run as fast as possible, and may be regarded as the lowestlevel representation of a compiled or assembled computer program or as a primitive and hardwaredependent programming language.
Which of the following is NOT true about servlet? (Unit 7 KLO 1.5)
A. Servlets creates static web page
B. Servlets have no GUI
C. Servlets executes on Servers
D. Servlet is a server-side programming language.
This is a named storage location in the computer's memory. (Unit 7 KLO 2.3)
A. class
B. key word
C. variable
D. operator
These are words that have a special meaning in the programming language. (Unit 7 KLO 2.4)
A. punctuation
B. programmer-defined names
C. key words
D. operators
If you have a number 9.6345 which of the following data type you will be using for the correct output. (Unit 7 KLO 2.5)
A. Float
B. Double
C. String
D. Integer
Identify which one is referred to as variance from product specifications? (Unit 8 KLO 1.1)
A. Defect
B. Requirement
C. Analysis
D. Result
When sub class declares a method that has the same type arguments as a method declared by one of its superclass, it is termed as (Unit 8 KLO 1.2)
A. Operator overloading
B. Method overriding
C. Operator overriding
D. Method overloading
It measures the quality of processes used to create a quality product. It is a system of management activities. It is a preventive process, It applies for the entire life cycle & deals with process. (Unit 8 KLO 1.3) A. Validation B. Verification C. Quality Assurance orrect answer D. Quality Control
A. Validation
B. Verification
C. Quality Assurance
D. Quality Control
The importance of software design can be summarized in a single word which is: (Unit 8 KLO 2.1)
A. Efficiency
B. Accuracy
C. Quality
D. Complexity
Which of the following are language independent (Unit 8 KLO 2.2)
A. Pattern
B. Libraries
C. Idioms
D. Framework
Illustrate which one is the functions and procedures (Unit 8 KLO 2.3)
A. Patterns
B. Idioms
C. Libraries
D. components
What does repository tools do? (Unit 8 KLO 2.4)
A. manages data
B. manages link among different applications
C. manages software
D. All the above
Select Appropriate Option(s) : JavaScript is can be written (UNIT 13 KLO 1.1)
A. directly into HTML pages
B. directly on the Server Script
C. directly into JS file and included into HTML
D. None of the above
JavaScript is (UNIT 13 KLO 1.2)
A. an interpreted language
B. a compiled language
C. both of the above
D. none of the above
Which of the following will make stateless session to stateful? (UNIT 13 KLO 2.1)
A. HTTP
B. Cookies
C. FTP
D. ISP
Which of the following is an example of authentication? (UNIT 13 KLO 2.2)
A. Secret question
B. Password
C. SMS code
D. all of the above
An example of stateless programming (UNIT 13 KLO 2.3)
A. HTTP
B. Cookies
C. ISP
D. FTP
Which of the following is an example of stateful session? (UNIT 13 KLO 2.4)
A. added items still in the shopping bag for the last 3 days
B. you need to log in every time you moved to next page
C. items disappear when I log out from the website
D. All of the above
Identify the point where a firewall is installed where the secure internal network and untrusted external network meet which is also known as (Unit 14 KLO 1.1)
A. Chock point
B. Meeting point
C. Firewall point
D. Secure point
An HTTP connection uses port _________ whereas HTTPS uses port ____________ and invokes SSL. (Unit 14 KLO 1.2)
A. 40; 80
B. 60; 620
C. 80; 443
D. 620; 80
Choose the protocol whose primary goal is to provide a private channel between communicating application, which ensures privacy of data authentication of the partners, and integrity. (Unit 14 KLO 1.3)
A. SSL
B. ESP
C. TSL
D. PSL
What is the main purpose of SSL? (Unit 14 KLO 1.3)
A. handle sensitive information
B. communicating with server
C. shut down a machine or network
D. crashing services
When sender and receiver of an e-mail are on same system, we need only two of the following (Unit 14 KLO 1.4)
A. User Agents
B. IP
C. Domain
D. Servers
In which of the following Pretty Good Privacy (PGP) is used? (Unit 14 KLO 1.4)
A. browser security
B. email security
C. FTP security
D. IP security
Which of the following is the type of software that has self-replicating software that causes damage to files and system? (Unit 14 KLO 1.5)
A. Viruses
B. Trojan horses
C. Bots
D. Worms
An attempt to make a computer resource unavailable to its intended users is called as (Unit 14 KLO 1.6)
A. denial-of-service attack
B. virus attack
C. worms attack
D. botnet process
Which of the following is not a web server? (Unit 14 KLO 1.7)
A. Apache tomcat
B. BlueGriffon
C. Jetty
D. Tornado
Each version of the Data Over Cable Service Interface Specification (DOCSIS) adds features and improvements over the previous version. What features does DOCSIS 2.0 add? (Unit 14 KLO 2.1)
A. Increased bandwidth of the upstream and advanced access systems so that lower orders of modulation are possible.
B. Increased bandwidth of the upstream so that enhanced security and adaptive equalization in the upstream path for improved data throughput are possible.
C. Increased bandwidth of the downstream with advanced access systems so that higher orders of modulation are possible.
D. Increased bandwidth of the upstream and advanced access systems so that higher orders of modulation are possible.
Examine the following which one is true for wireless distribution system (Unit 14 KLO 2.3)
A. multiple access point are inter-connected with each other orrect answer
B. there is no access point
C. only one access point exists
D. none of the mentioned
What does MIME stands for (Unit 14 KLO 2.5)
A. Multipurpose International Mail End
B. Multipurpose Internet Mail Extensions
C. Multipurpose Internet Mail Email
D. Multipurpose International Mail Entity
Estimate In SSL Protocol, the maximum number of bytes that each upper layer message can be fragmented into (Unit 14 KLO 2.6)
A. 2^16
B. 2^32
C. 2^14
D. 2^12
Identify the advantages of Database management system? (UNIT15 KLO 1.1)
A. Data Integrity
B. Reduction in Data Redundancy
C. Centralize Management
D. All of these
............................ is the powerful language for working with RDBMS. (UNIT15 KLO 1.2)
A. Embedded Programs
B. Dynamic Programs
C. Structured Query Language
D. Static Language Programs
A relational database consists of a collection of (UNIT15 KLO 1.3)
A. Tables
B. Fields
C. Records
D. Keys
The following are functions of a DBMS except (UNIT15 KLO 2.1)
A. creating and processing forms
B. creating databases
C. processing data
D. administrating databases
What does SQL stand for? (UNIT15 KLO 2.1)
A. Structured Query Language
B. Structured Question Language C. Strong Question Language
C. Strong Question Language
D. Strong Query Language
Which SQL statement is used to extract data from a database? (UNIT15 KLO 2.1)
A. OPEN
B. EXTRACT
C. SELECT
D. GET
Which SQL statement is used to update data in a database? (UNIT15 KLO 2.1)
A. UPDATE
B. MODIFY
C. SAVEAS
D. SAVE
Which SQL statement is used to delete data from a database? (UNIT15 KLO 2.1)
A. COLLAPSE
B. DELETE
C. REMOVE
D. DROP
Which SQL statement is used to insert new data in a database? (UNIT15 KLO 2.1)
A. INSERT INTO
B. ADD RECORD
C. ADD NEW
D. INSERT NEW
Which operator is used to search for a specified pattern in a column? (UNIT15 KLO 2.1)
A. FROM
B. GET
C. LIKE
D. SELECT
Which SQL keyword is used to sort the result-set? (UNIT15 KLO 2.2)
A. order by
B. sort by
C. where
D. like
Which of the following is not comparison operator? (UNIT15 KLO 2.2)
A. <>
B. <
C. =<
D. >=
How can you change "Hansen" into "Nilsen" in the "LastName" column in the Persons table? (UNIT15 KLO 2.2)
A. MODIFY Persons SET LastName='Hansen' INTO LastName='Nilsen
B. UPDATE Persons SET LastName='Hansen' INTO LastName='Nilsen'
C. MODIFY Persons SET LastName='Nilsen' WHERE LastName='Hansen'
D. UPDATE Persons SET LastName='Nilsen' WHERE LastName='Hansen'
With SQL, how can you delete the records where the "FirstName" is "Peter" in the Persons Table? (UNIT15 KLO 2.2)
A. DELETE FirstName='Peter' FROM Persons
B. DELETE ROW FirstName='Peter' FROM Persons
C. DELETE FROM Persons WHERE FirstName = 'Peter'
D. All of the above
With SQL, how can you return the number of records in the "Persons" table? (UNIT15 KLO 2.2)
A. SELECT COUNT() FROM Persons
B. SELECT COLUMNS() FROM Persons
C. SELECT COUNT(*) FROM Persons
D. SELECT COLUMNS(*) FROM Persons
Which of the syntax is correct for insert statement? i) insert into values ii) insert into (column list) values (UNIT15 KLO 2.2)
A. i-only
B. ii-only
C. Both of them
D. None of them
Which of the syntax is correct for insert statement? i) insert into values ii) insert into (column list) values (UNIT15 KLO 2.2)
A. i-only
B. ii-only
C. Both of them
D. None of them
To change column value in a table the ......... command can be used. (UNIT15 KLO 2.2)
A. create
B. insert
C. alter
D. update
The ........ is used for creating and destroying table, indexes and other forms of structures. (UNIT15 KLO 2.2)
A. data manipulation language
B. data control language
C. transaction control language
D. data definition language
Which SQL statement is used to return only different values? (UNIT15 KLO 2.2)
A. SELECT UNIQUE
B. SELECT DIFFERENT
C. SELECT DISTINCT
D. SELECT DIST
Which SQL statement is used to create a table in a database? (UNIT15 KLO 2.2)
A. CREATE TABLE
B. CREATE DATABASE TABLE
C. CREATE DB
D. CREATE DATABASE TAB
With SQL, how do you select a column named "FirstName" from a table named "Persons"? (UNIT15 KLO 2.1)
A. SELECT Persons.FirstName
B. EXTRACT FirstName FROM Persons
C. SELECT FirstName FROM Persons
D. EXTRACT Persons FROM FirstName
With SQL, how do you select all the columns from a table named "Persons"? (UNIT15 KLO 2.1)
A. SELECT Persons
B. SELECT * FROM Persons
C. SELECT [all] FROM Persons
D. SELECT *.Persons
With SQL, how do you select all the records from a table named "Persons" where the value of the column "FirstName" is "Peter"? (UNIT15 KLO 2.1)
A. SELECT * FROM Persons WHERE FirstName='Peter'
B. SELECT * FROM Persons WHERE FirstName<>'Peter'
C. SELECT [all] FROM Persons WHERE FirstName='Peter'
D. SELECT [all] FROM Persons WHERE FirstName LIKE 'Peter'
