wayground logo

Free Printable Worksheets

Font size

S
M
L
XL
Worksheets

App Support Review

Total questions: 72

Worksheet time: 38mins

Name
Class
Date
1.

which of the following is wrapper class in java

a)

Float

b)

Integer

c)

Double

d)

all of above

2.

which one of the following is true?

a)

runnable interface declares the start method

b)

Thread.start() method is used to move a thread from a new state to the runnable state

c)

Thread.runnable() method is used to move a thread from new state to the runnable state

d)

Thread.run() method is used to move a thread from new state to the runnable state

3.

Which one of the following statement is not true about the collection interface?

a)

all methods defined in set interface are also defined in collection interface

b)

list interface extends collection interface

c)

set interface extends collection interface

d)

all methods defined in list interface are also defined in collection interface

4.

which one of the following is a legal decelration of a two- dimensional array of integers

a)

int[] a[] = new int[5][];

b)

int[5][5] a = new int[][];

c)

int a = new int[5,5];

d)

int[][] a = new int[][5];

5.

which interface needs to be implemented in order to make an object seralized

a)

clonnable

b)

remote

c)

seralizable

d)

none of the above

6.

which of this class is used by character streams for reading data from buffer

a)

BufferReader

b)

InputStreamReader

c)

FileReader

d)

FileInputStream

7.

which of this class is used by character streams for reading data from buffer

a)

BufferReader

b)

InputStreamReader

c)

FileReader

d)

FileInputStream

8.

which one this keywords are used to create a class in java

a)

class

b)

struct

c)

int

d)

none of the avove

9.

Who invented Java?

a)

James Gosling

b)

Sergey Brin

c)

Steve Jobs

d)

Bill Gates

e)

Tim Berners-Lee

10.

Which company owns Java?

a)

Oracle

b)

Microsoft

c)

Google

d)

Apple

e)

Intel

11.
If more than one class implements an interface, its methods are ____.
a)
aggregated
b)
public
c)
dependent
d)
polymorphic
12.

The following Syntax is used for?


class Subclass-name extends Superclass-name

{

//methods and fields

}

a)

Polymorphism

b)

Encapsulation

c)

Inheritance

d)

None of the above

13.

A class that is inherited is called a ______ .

a)

superclass

b)

Subclass

c)

subsetclass

d)

Relativeclass

14.
What does polymorphism mean?
a)
Changing shapes
b)
Having many forms
c)
Being unchangeable
d)
Easy
15.
Which of these cannot be passed down through inheritance?
a)
Public variables
b)
Private variables
c)
Methods
d)
Data
16.

This is a general structure a method.

a)

<Returnvalue type> <Method Name> (argument / s)

b)

<Modifier> < type> <Method Name> (parameter / s)

c)

public static void main (String[ ] args)

d)

<Method Name> (parameter)

17.

There two (2) types of method which are

a)

return

b)

Standard library

c)

User defined

d)

non-return

18.

PL SQL Stands for

a)

Programming Language for SQL

b)

Procedural Language for SQL

c)

Plain Language for SQL

d)

None of these

19.

Name 4 attributes of explicit cursors

a)

%FOUND,%NOTFOUND,%ROWCOUNT,%ISOPEN

b)

%FOUND,%NOTFOUND,%ISCLOSE,%ISOPEN

c)

%FOUND,%OPEN,%ROWCOUNT,%ISOPEN

d)

None of these

20.

________ provide a way for your program to select multiple rows of data from the database and then process each row individually.

a)

Trigger

b)

Cursor

c)

Select

d)

Procedure

21.

_____cursor is declared by ORACLE for each UPDATE, DELETE and INSERT SQL commands.

a)

Internal

b)

External

c)

Implicit

d)

Explicit

22.

_______ is used to recreate if trigger already exists

a)

Create

b)

Cursor

c)

Procedure

d)

Replace

23.

Which SQL function is used to count the number of rows in a SQL query?

a)

COUNT()

b)

NUMBER()

c)

SUM()

d)

COUNT(*)

24.

Which of the following SQL clauses is used to DELETE tuples from a database table?

a)

DELETE

b)

REMOVE

c)

DROP

d)

CLEAR

25.

Which query would return only the fields DesignerID and Designer?

a)

SELECT * FROM Designers

b)

SELECT DesignerID, Name FROM Designers

c)

SELECT DesignerID AND Designer FROM Designers

d)

SELECT DesignerID, Designer FROM Designers

26.

What is the most common JOIN statement used in business?

a)

Inner Join

b)

Left Join

c)

Right Join

d)

Full Outer Join

27.

Which join would you use to create a query that returns ALL data from Table B and only those on Table A that match?

a)

Inner Join

b)

Left Join

c)

Right Join

d)

Full Outer Join

28.

Q2. If 5 tables are joined, what is the minimum number of join conditions needed in order to avoid Cartesian Product?

a)

3

b)

4

c)

5

d)

6

29.

Q4. An outer join, either Left or Right, retreives records that match

as well as records that do not match.

a)

True

b)

False

30.

Q5. How many records will the following SQL statement produce?

SELECT Dept_ID, Title_ID

FROM Department, JobTitle;

a)

5

b)

13

c)

18

d)

65

31.

If a required skillset is in short supply it may be difficult for the service provider to know what is needed without additional superfluous contact with partners, hiring agencies and contractors. What term best describes this factor for dealing with partners or suppliers?

a)

Demand patterns

b)

Resource scarcity

c)

External constraints

d)

Strategic focus

32.

Which pair of terms does NOT represent a valid ITIL 4 dimension?

a)

Partners and suppliers

b)

Social and environmental

c)

Value streams and processes

d)

Information and technology

33.

What considerations influence the supplier strategy of an organization?

a)

Contracts and agreements

b)

Type of cooperation with suppliers

c)

Corporate culture of the organization

d)

Level of formality

34.

Which dimension of service management considers governance, management, and communication?

a)

Organizations and people

b)

Information and technology

c)

Partners and suppliers

d)

Value streams and processes

35.

Which is NOT a key focus of the ‘information and technology’ dimension?

a)

Security and compliance

b)

Communication systems and knowledge bases

c)

Workflow management and inventory systems

d)

Roles and responsibilities

36.

What is a series of steps an organization takes to create and deliver products and services to consumers?

a)

Process

b)

Value streams

c)

Procedures

d)

Practices

37.

What is a shell script?

a)

group of commands

b)

a file containing a series of commands

c)

group of functions

d)

a file containing special symbols

38.

Which of the following commands is used to display the directory attributes

a)

cat

b)

ls

c)

mkdir

d)

cp

39.

Which command is used to remove a file?

a)

remove

b)

del

c)

rm

d)

mv

40.

The following command can list out all the current active logins.

a)

A - whoami

b)

B - who am i

c)

C - who

d)

D - None of the above.

41.

In a system, if 5 people are currently using the vi editor. then the number of corresponding processes will be

a)

1

b)

5

c)

2

d)

0

42.

The mv command changes

a)

Only the directory entry

b)

Only the directory entry and i-node

c)

Only the i-node number

d)

None of the above

43.

Unix operating system is written in

a)

Ada Language

b)

Perl Language

c)

C Language

d)

Pascal Language

44.

Which command is used to create a file

a)

ls

b)

cat

c)

vi

d)

lyrix

45.

Who was the first know user of the Caesar Cipher?

a)

Caesar Romanus

b)

Julius Caesar

c)

Alan Turing

d)

There isn't one

46.

In Cryptography, original message, before being transformed, is called

a)

Simple Text

b)

Plain Text

c)

Cipher Text

d)

Filled Text

47.

An encryption algorithm transforms plain text into:

a)

Cipher text

b)

Simple Text

c)

Empty Text

d)

Plain Text

48.

The art and science of breaking the cipher text is known as

a)

Cryptanalysis

b)

Cryptography

c)

Staganography

d)

Watermarking

49.

The _______ is a number or a set of numbers on which the cipher operates.

a)

secret

b)

cipher

c)

key

d)

none of the mentioned

50.

Which of the following is a type of middleware?

I. RPC

II. Object middleware

III. Database middleware

IV. TP middleware

a)

I, III

b)

I, II, III

c)

II, III, IV

d)

I, II, III and IV

51.

In the diagram, A is _____.

a)

Web server

b)

Application server

c)

File server

d)

Grid computing

52.

What is the need for DevOps?

a)

Increase deployment frequency

b)

Lower failure rate of new releases

c)

1 and 2

d)

none

53.

What are the Business advantages of DevOps?

a)

Faster delivery of features

b)

less stable operating environments

c)

More time available to add value

d)

2 and 3

e)

1 and 3

54.

How does solving difficult-customer situations benefit your company?

a)

It will generate repeat business.

b)

The difficult customers won’t bother you again.

c)

You will get a promotion.

d)

All the employees will get promotions.

55.

Review: The order of which the shell references to execute after Aliases is ____________

a)

File system

b)

Shell reserved word

c)

Function

d)

Built-in commands

56.

True or False: The Shell is an interface between the user and the kernel

a)

True

b)

False

57.

________ in shell scripts begin with at a pound sign "#" and continue to the end of the line.

a)

hashtag

b)

comments

c)

remarks

d)

note

58.

She-bang, the ______________

a)

number one single of Ricky Martin

b)

the first line

c)

the first argument

d)

best single of Justin Bieber

59.

True or False: GREP comes from the term "global search", regular expression and print.

a)

True

b)

False

60.
With SQL, how can you insert a new record into the "Persons" table?
a)
INSERT INTO Persons VALUES ('Jimmy', 'Jackson')  
b)
INSERT ('Jimmy', 'Jackson') INTO Persons
c)
INSERT VALUES ('Jimmy', 'Jackson') INTO Persons
d)
INSERT VALUES ('Jimmy, Jackson') INTO Persons
e)
INSERT ('Jimmy', 'Jackson') VALUES into Persons
61.
Which of the following is valid SQL for an Index?
a)
CREATE INDEX ID;
b)
CHANGE INDEX ID;
c)
ADD INDEX ID;
d)
REMOVE INDEX ID;
e)
DELETE INDEX ID;
62.
Which one of the following sorts rows in SQL?
a)
SORT BY
b)
ALIGN BY
c)
ORDER BY
d)
GROUP BY
e)
SORT
63.
Which of the following function cannot be performed by SQL ?
a)
Setting permissions on tables
b)
Creating views in a database
c)
Updating records
d)
Creating Complex UI
e)
Delete database
64.

What acronym represents the four basic functions of persistent data storage?

a)

CRUD

b)

SQL

c)

ACID

d)

SaaS

65.

Which are valid data types in SQL?

a)

VARCHAR()

b)

INT

c)

CHAR()

d)

STR()

e)

FLOAT

66.

Which are valid joins in SQL?

a)

CROSS JOIN

b)

FULL INNER JOIN

c)

FULL OUTER JOIN

d)

LEFT JOIN

67.

Which of the following are the five built-in functions provided by SQL?

a)

A. COUNT, SUM, AVG, MAX, MIN

b)

B. SUM, AVG, MIN, MAX, MULT

c)

C. SUM, AVG, MULT, DIV, MIN

d)

D. SUM, AVG, MIN, MAX, NAME

68.

Which of the following must be enclosed in double quotes?

a)

A) Dates

b)

B) Column Alias

c)

C) Strings

d)

D) All of the above

69.

1.Which is the subset of SQL commands used to manipulate Oracle Database structures, including tables?

a)

a) Data Definition Language(DDL)

b)

b) Data Manipulation Language(DML)

c)

c) DDL and DML

d)

d) None of the Mentioned

70.

2. In SQL, which command is used to SELECT only one copy of each set of duplicable rows

a)

a) SELECT DISTINCT

b)

b) SELECT UNIQUE

c)

c) SELECT DIFFERENT

d)

d) All of the Mentioned

71.

A stand alone computer cannot connect to the Internet or any other computer.

a)

true

b)

false

72.

Which of the following does a computer need to connect to a network or other computer devices?

a)

ethernet card

b)

NIC card

c)

IP Address

d)

WiFi

Similar Resources on Wayground

TESTING

70 questions

TESTING

quiz

Worksheet

•

Professional Development

MEM16008 Computing Technology Training Quiz

71 questions

MEM16008 Computing Technology Training Quiz

quiz

Worksheet

•

Professional Development

Computer Basics Quiz

70 questions

Computer Basics Quiz

quiz

Worksheet

•

Professional Development

PowerProtect DD Systems Worksheet

71 questions

PowerProtect DD Systems Worksheet

quiz

Worksheet

•

Professional Development

Server, Konsola, Virtual, AD, DHCP, DNS, NAT, IIS, FTP

72 questions

Server, Konsola, Virtual, AD, DHCP, DNS, NAT, IIS, FTP

quiz

Worksheet

•

7th Grade - Professio...

แบบทดสอบ การเขียนโปรแกรม Java

67 questions

แบบทดสอบ การเขียนโปรแกรม Java

quiz

Worksheet

•

Professional Development