NEW
Font size
S
M
L
XL
WorksheetsTechnical Evaluation - 101 - 2024
Total questions: 50
Worksheet time: 1hrs 15mins
Name
Class
Date
1.
Which SQL function is used to count the number of rows in a SQL query?
a)
COUNT()
b)
NUMBER()
c)
SUM()
d)
COUNT(*)
2.
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
3.
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
4.
_______ allow us to identify uniquely a tuple in the relation.
a)
schema
b)
superkey
c)
domain
d)
attribute
5.
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
6.
The attribute that can be divided into other attributes is called
a)
composite attribute
b)
derived attribute
c)
simple attribute
d)
multi-valued attribute
7.
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
8.
Database locking concept is used to solve the problem of
a)
inconsistent data
b)
lost update
c)
uncommitted dependency
d)
all of the options
9.
A type of query that is placed within a WHERE or HAVING clause of another query is called
a)
multi-query
b)
sub query
c)
super query
d)
master query
10.
If a piece of data is stored in two places in the database, then
a)
in can be more easily accessed
b)
both storage space is wasted and changing the data in one spot will cause data inconsistency
c)
storage space is wasted
d)
changing the data in one spot will cause data inconsistency
11.
Which of the following is not an advantage of the database approach
a)
elimination of data redundancy
b)
ability of associate deleted data
c)
increased security and program/data independence
d)
all of the above
12.
which of the following is not an Aggregate function?
a)
min
b)
max
c)
select
d)
avg
13.
________ is the smallest unit of allocation in an Oracle database.
a)
Database
b)
Instance
c)
Tablespace
d)
Database Block
14.
An Oracle __________ is a set of tables and views that are used as a read-only reference about the database.
a)
Database dictionary
b)
Dictionary table
c)
Data dictionary
d)
Dictionary
15.
Which of the following is the smallest unit of storage in an Oracle database?
a)
Segment
b)
Extent
c)
Data File
d)
Data Block
16.
Which of the following package procedure is UNRESTRICTED in Oracle?
a)
CLEAR_BLOCK
b)
USER_EXIT
c)
CALL_INPUT
d)
EXECUTE_QUERY
17.
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
18.
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
19.
What will be the output of the following Python code?
l=[1, 0, 2, 0, 'hello', '', []]
list(filter(bool, l))
a)
[1, 0, 2, ‘hello’, ”, []]
b)
Error
c)
[1, 2, ‘hello’]
d)
[1, 0, 2, 0, ‘hello’, ”, []]
20.
What is the order of namespaces in which Python looks for an identifier?
a)
Python first searches the built-in namespace, then the global namespace and finally the local namespace
b)
Python first searches the built-in namespace, then the local namespace and finally the global namespace
c)
Python first searches the local namespace, then the global namespace and finally the built-in namespace
d)
Python first searches the global namespace, then the local namespace and finally the built-in namespace
21.
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
22.
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]
23.
Which of the following is used to read an HTML page and render it?
a)
Web server
b)
Web network
c)
Web browser
d)
Web matrix
24.
What is DOM in HTML?
a)
Language dependent application programming
b)
Hierarchy of objects in ASP.NET
c)
Application programming interface
d)
Convention for representing and interacting with objects in html documents
25.
Which of the following is not a HTML5 tag?
a)
<track>
b)
<video>
c)
<slider>
d)
<source>
26.
Which of the following is not the element associated with the HTML table layout?
a)
alignment
b)
color
c)
size
d)
spanning
27.
HTML is a subset of ___________
a)
SGMT
b)
SGML
c)
SGME
d)
XHTML
28.
Which attribute is used with <select> element?
a)
multiple
b)
selected
c)
name
d)
value
29.
Which of the following tag is used to embed css in html page?
a)
<css>
b)
<!DOCTYPE html>
c)
<script>
d)
<style>
30.
Which of the following CSS selector is used to specify a rule to bind a particular unique element?
a)
class
b)
id
c)
tag
d)
both class and tag
31.
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” />
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.
Which of the following is correct about JavaScript?
a)
JavaScript is an Object-Based language
b)
JavaScript is Assembly-language
c)
JavaScript is an Object-Oriented language
d)
JavaScript is a High-level language
35.
Arrays in JavaScript are defined by which of the following statements?
a)
It is an ordered list of values
b)
It is an ordered list of objects
c)
It is an ordered list of string
d)
It is an ordered list of functions
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.
What are the disadvantages of normal binary tree traversals?
a)
improper traversals
b)
complexity in implementing
c)
there is no traversal which is efficient
d)
there are many pointers which are null and thus useless
40.
The maximum, minimum child for internal node in B-tree
a)
m/2,m
b)
m,m/2
c)
m,m/2-1
d)
m/2-1,m
41.
Circular Queue is also known as ________
a)
a) Ring Buffer
b)
b) Square Buffer
c)
c) Rectangle Buffer
d)
d) Curve Buffer
42.
What does the following function do for a given Linked List with first node as head?
void fun1(struct node* head)
{
if(head == NULL)
return;
fun1(head->next);
printf("%d ", head->data);
}
a)
a) Prints all nodes of linked lists
b)
b) Prints all nodes of linked list in reverse order
c)
c) Prints alternate nodes of Linked List
d)
d) Prints alternate nodes in reverse order
43.
To measure Time complexity of an algorithm Big O notation is used which:
a)
A. describes limiting behaviour of the function
b)
B. characterises a function based on growth of function
c)
C. upper bound on growth rate of the function
d)
D. all of the mentioned
44.
If for an algorithm time complexity is given by O(1) then complexityof it is:
a)
A. constant
b)
B. polynomial
c)
C. exponential
d)
D. none of the mentioned
45.
In the __________traversal we process all of a vertex’s descendents before we move to an adjacent vertex.
a)
Depth First
b)
Breadth First
c)
With First
d)
Depth Limited
46.
_____________is the method used by card sorter?
a)
Radix sort
b)
Insertion
c)
Heap
d)
Quick
47.
______________the condition indicate the queue is empty.
a)
Front=Null
b)
Null=Front
c)
Front=Rear
d)
Rear=Null
48.
Other name for directed graph is _________
a)
Direct graph
b)
Digraph
c)
Dir-graph
d)
Dgraph
49.
Which method of graph traversal makes use of a queue?
a)
Depth-First
b)
Breadth-First
50.
Which of the following is true?
a)
A graph may contain no edges and many vertices
b)
A graph may contain many edges and no vertices
c)
A graph may contain no edges and no vertices
Reset
