wayground logo

Free Printable Worksheets

NEW

Font size

S
M
L
XL
Worksheets

Technical Evaluation - 102 - 2024

Total questions: 50

Worksheet time: 1hrs 15mins

Name
Class
Date
1.
Which of the following statement is true?
a)
DELETE does not free the space containing the table and TRUNCATE free the space containing the table
b)
Both DELETE and TRUNCATE free the space containing the table
c)
Both DELETE and TRUNCATE does not free the space containing the table
d)
DELETE free the space containing the table and TRUNCATE does not free the space containing the table
2.
What is the purpose of the SQL AS clause?
a)
The AS SQL clause is used to change the name of a column in the result set or to assign a name to a derived column
b)
The AS clause is used with the JOIN clause only
c)
The AS clause defines a search condition
d)
All of the mentioned
3.
What does the ALTER TABLE clause do?
a)
The SQL ALTER TABLE clause modifies a table definition by altering, adding, or deleting table columns and/or constraints
b)
The SQL ALTER TABLE clause is used to insert data into database table
c)
THE SQL ALTER TABLE deletes data from database table
d)
The SQL ALTER TABLE clause is used to delete a database table
4.
_______ allow us to identify uniquely a tuple in the relation.
a)
schema
b)
superkey
c)
domain
d)
attribute
5.
Logical design of database is called
a)
all of the options
b)
database schema
c)
database instance
d)
database snapshot
6.
Which of the following is correct regarding Aggregate functions?
a)
it takes a single value and returns a single value as result
b)
it takes a list of values and return a single values as result
c)
it takes a list of values and return a list of values as result
d)
it takes a single value and returns a list of values as result
7.
The attribute that can be divided into other attributes is called
a)
composite attribute
b)
derived attribute
c)
simple attribute
d)
multi-valued attribute
8.
What is ACID properties of Transactions?
a)
atomicity, consistency, isolation, database
b)
automatically, concurrency, isolation, durability
c)
atomicity, consistency, isolation, durability
d)
atomicity, consistency, inconsistent, durability
9.
If every non-key attribute is functionally dependent on the primary key, the relation will be in
a)
fourth formal form
b)
third normal form
c)
first normal form
d)
second normal form
10.
Database locking concept is used to solve the problem of
a)
inconsistent data
b)
lost update
c)
uncommitted dependency
d)
all of the options
11.
Which of the following package procedure is UNRESTRICTED in Oracle?
a)
CLEAR_BLOCK
b)
USER_EXIT
c)
CALL_INPUT
d)
EXECUTE_QUERY
12.
Which of the following functions can help us to find the version of python that we are currently working on?
a)
sys.version(1)
b)
sys.version(0)
c)
sys.version()
d)
sys.version
13.
What is the order of precedence in python?
a)
Exponential, Parentheses, Multiplication, Division, Addition, Subtraction
b)
Exponential, Parentheses, Division, Multiplication, Addition, Subtraction
c)
Parentheses, Exponential, Multiplication, Division, Subtraction, Addition
d)
Parentheses, Exponential, Multiplication, Division, Addition, Subtraction
14.
What will be the output of the following Python code snippet if x=1? x << 2
a)
4
b)
2
c)
1
d)
8
15.
Which of the following is true for variable names in Python?
a)
underscore and ampersand are the only two special characters allowed
b)
unlimited length
c)
all private members must have leading and trailing underscores
d)
none of the mentioned
16.
What are the values of the following Python expressions? 2**(3**2) (2**3)**2 2**3**2
a)
512, 64, 512
b)
512, 512, 512
c)
64, 512, 64
d)
64, 64, 64
17.
Which of the following is a feature of Python DocString?
a)
In Python all functions should have a docstring
b)
Docstrings can be accessed by the __doc__ attribute on objects
c)
It provides a convenient way of associating documentation with Python modules, functions, classes, and methods
d)
All of the mentioned
18.
What will be the output of the following Python code? print("Hello {0[0]} and {0[1]}".format(('foo', 'bin')))
a)
Hello (‘foo’, ‘bin’) and (‘foo’, ‘bin’)
b)
Error
c)
Hello foo and bin
d)
None of the mentioned
e)
Hello f and o
19.
What will be the output of the following Python code? l=list('HELLO') p=l[0], l[-1], l[1:3] 'a={0}, b={1}, c={2}'.format(*p)
a)
Error
b)
“a=’H’, b=’O’, c=(E, L)”
c)
“a=H, b=O, c=[‘E’, ‘L’]”
d)
Junk value
20.
What will be the output of the following Python code? m=reduce(lambda x: x-3 in range(4, 10)) print(list(m))
a)
[1, 2, 3, 4, 5, 6, 7]
b)
No output
c)
[1, 2, 3, 4, 5, 6]
d)
Error
21.
Write a list comprehension for number and its cube for l=[1, 2, 3, 4, 5, 6, 7, 8, 9].
a)
[x**3 for x in l]
b)
[x^3 for x in l]
c)
[x**3 in l]
d)
[x^3 in l]
22.
Which of the following is not the element associated with the HTML table layout?
a)
alignment
b)
color
c)
size
d)
spanning
23.
HTML is a subset of ___________
a)
SGMT
b)
SGML
c)
SGME
d)
XHTML
24.
In HTML, which attribute is used to create a link that opens in a new window tab?
a)
src=”_blank”
b)
alt=”_blank”
c)
target=”_self”
d)
target=”_blank”
25.
Which tag is used to create a dropdown in HTML Form?
a)
<input>
b)
<select>
c)
<text>
d)
<textarea>
26.
Which HTML element is used for YouTube videos?
a)
<samp>
b)
<small>
c)
<frame>
d)
<iframe>
27.
Which element is used to create multi-line text input?
a)
text
b)
textarea
c)
submit
d)
radio button
28.
Which attribute is used with <select> element?
a)
multiple
b)
selected
c)
name
d)
value
29.
Which of the following is the correct syntax to link an external style sheet in the HTML file?
a)
<link rel=”stylesheet” href=”style.css” />
b)
<link rel=”stylesheet” src=”style.css” />
c)
<style rel=”stylesheet” src=”style.css” />
d)
<style rel=”stylesheet” link=”style.css” />
30.
Which of the following function defines a linear gradient as a CSS image?
a)
gradient()
b)
linear-gradient()
c)
grayscale()
d)
image()
31.
Which of the following CSS property sets the shadow for a box element?
a)
set-shadow
b)
box-shadow
c)
shadow
d)
canvas-shadow
32.
Which of the following CSS Property sets the stacking order of positioned elements?
a)
y-index
b)
z-index
c)
x-index
d)
all of the mentioned
33.
A similar rule called the ____________ is specified using the plus sign (+) and is used to select elements that would be siblings of each other.
a)
class selectors
b)
attribute selectors
c)
adjacent-sibling selector
d)
none of the mentioned
34.
Where is Client-side JavaScript code is embedded within HTML documents?
a)
A URL that uses the special javascript:code
b)
A URL that uses the special javascript:protocol
c)
A URL that uses the special javascript:encoding
d)
A URL that uses the special javascript:stack
35.
Which of the following object is the main entry point to all client-side JavaScript features and APIs?
a)
Position
b)
Window
c)
Standard
d)
Location
36.
What is the basic difference between JavaScript and Java?
a)
Functions are considered as fields
b)
Functions are values, and there is no hard distinction between methods and fields
c)
Variables are specific
d)
There is no difference
37.
Why event handlers is needed in JS?
a)
Allows JavaScript code to alter the behaviour of windows
b)
Adds innerHTML page to the code
c)
Change the server location
d)
Performs handling of exceptions and occurrences
38.
Which of the following is not an error in JavaScript?
a)
Missing of Bracket
b)
Division by zero
c)
Syntax error
d)
Missing of semicolons
39.

Is the one that requires the machine to group similar objects in the data set.

a)

Classification

b)

Regression

c)

Clustering

40.

What is the average case time complexity for finding the height of the binary tree?

a)

h = O(loglogn)

b)

h = O(nlogn)

c)

h = O(n)

d)

h = O(log n)

41.

What are the conditions for an optimal binary search tree and what is its advantage?

a)

The tree should not be modified and you should know how often the keys are accessed, it improves the lookup cost

b)

You should know the frequency of access of the keys, improves the lookup time

c)

The tree can be modified and you should know the number of elements in the tree before hand, it improves the deletion time

d)

The tree should be just modified and improves the lookup time

42.

The number of edges from the node to the deepest leaf is called _________ of the tree.

a)

Height

b)

Depth

c)

Length

d)

Width

43.

A has been visited what happens next

a)

Visit B

b)

Visit D

c)

Visit E

d)

Visit C

44.

With breadth-first traversal, which node will be visited next?

a)

C

b)

F

c)

G

45.

Which method of graph traversal makes use of a queue?

a)

Depth-First

b)

Breadth-First

46.

What advantage does a linked list have over an array?

a)

Size of the list doesn't need to be mentioned at the beginning of the program

b)

You can add or remove elements from the middle of the list.

c)

The linked list doesn't have a size limit

d)

All of these are true.

47.

What is the operation of the below statements?

a)

Insert a new node to the front of a linked list

b)

Create a new node for a linked list

c)

Insert a new node to the end of the linked list

d)

Calculate the size of a linked list

48.

How many times should


“temp =temp->next” be executed in the image to get the value of "Null" when the initial value of temp is temp=head

a)

1

b)

2

c)

3

d)

4

49.

User perform following operations on stack of size 5 then -

push(1);

pop();

push(2);

push(3);

pop();

push(2);

pop();

pop();

push(4);

pop();

pop();

push(5);

a)

Overflow Occurs

b)

Stack Operations will be performed Smoothly

c)

Underflow Occurs

d)

None of these

50.

Select a real life situation implement stack

a)

All of the answers

b)

The cars in a garage, the first car in will be the last car out of the garage

c)

The batteries in a flashlight

d)

Wearing equal size bangles in a hand

Similar Resources on Wayground

Cyberbezpieczeństwo

46 questions

Cyberbezpieczeństwo

quiz

Worksheet

•

Professional Development

Computer Hardware and Software - Networking

50 questions

Computer Hardware and Software - Networking

quiz

Worksheet

•

Professional Development

Quiz Active Directory (AD)

48 questions

Quiz Active Directory (AD)

quiz

Worksheet

•

Professional Development

computer networks semester quiz

50 questions

computer networks semester quiz

quiz

Worksheet

•

University - Professi...

IT Security ICDL

50 questions

IT Security ICDL

quiz

Worksheet

•

Professional Development

Midterm Exam Review (Business concepts) S2

50 questions

Midterm Exam Review (Business concepts) S2

quiz

Worksheet

•

Professional Development

HTML and CSS

50 questions

HTML and CSS

quiz

Worksheet

•

Professional Development

AWS Cloud Practitioner 1.1

50 questions

AWS Cloud Practitioner 1.1

quiz

Worksheet

•

Professional Development