Database Systems Mock Test 11

What is the purpose of image replacement?

1 Mark(s)

Your Answer:

To replace an image To replace an image
To implement special effects To implement special effects
Removal of image rollovers Removal of image rollovers
Implementation of image rollovers Implementation of image rollovers

What is the first version of HTML?

1 Mark(s)

Your Answer:

HTML 0.1 HTML 0.1
HTML5 HTML5
HTML1.0 HTML1.0
None None

In the formal, mathematical definition of the relational model, a relation is a:

1 Mark(s)

Your Answer:

Set Set
Table Table
Procedure Procedure
Method Method

The semicolon terminates a SQL statement (and executes it).

1 Mark(s)

Your Answer:

True True
False False

In Congestion, the maximum burst size normally refers to the maximum length of time the traffic is generated at the:

1 Mark(s)

Your Answer:

average rate average rate
packet rate packet rate
protocol rate protocol rate
peak rate peak rate

Coefficient of thermal expansion of fused quartz is:

1 Mark(s)

Your Answer:

1.2x10-6/C° 1.2x10-6/C°
51x10-6/C° 51x10-6/C°
0.5x10-6/C° 0.5x10-6/C°
0.7x10-6/C° 0.7x10-6/C°

Which of the following operators is the correct option for power(ab)?

1 Mark(s)

Your Answer:

a ^ b a ^ b
a**b a**b
a ^ ^ b a ^ ^ b
a ^ * b a ^ * b

Select a solution for the following statements: static void Main(string[] args) { int num1 = 20000; int num2 = 50000; long total; total = num1 + num2; Console.WriteLine("Total is : " +total); Console.ReadLine(); }:

1 Mark(s)

Your Answer:

Compiler will generate runtime error Compiler will generate runtime error
Conversion is implicit type, no error generation
Specifying data type for conversion externally will solve the problem
None of the mentioned None of the mentioned

What will be the output of the following code: my_set = {1, 2, 3} my_set.add(4) print(my_set)

1 Mark(s)

Your Answer:

{1, 2, 3} {1, 2, 3}
{4, 1, 2, 3} {4, 1, 2, 3}
{1, 2, 3, 4} {1, 2, 3, 4}
{3, 2, 1} {3, 2, 1}

Managed IT services are based on the concept of which one of the following?

1 Mark(s)

Your Answer:

Virtualization Virtualization
Utility Computing Utility Computing
Grid Computing Grid Computing
SOA SOA

In C, which operator is used for pointer-to-pointer relationships?

1 Mark(s)

Your Answer:

* *
& &
-> ->
:: ::

Function used for modelling density of an idealized point charge, as a function that is equal to zero everywhere except for zero and whose integral over the entire real line is one is:

1 Mark(s)

Your Answer:

unit impulse function unit impulse function
unit step function unit step function
dual step function dual step function
Heaviside step function Heaviside step function

A force can change the object's:

1 Mark(s)

Your Answer:

speed speed
volume volume
size size
control control

What will be the output of the following C# code? static void Main(string[] args) { Console.WriteLine("This is a Console Application:"); Console.Write("Please enter your lucky number:"); string val1 = Console.ReadLine(); int val2 = System.Convert.ToInt32(val1, 10); val2 = val2 * val2; Console.WriteLine("square of number is:" +val2); Console.Read(); }

1 Mark(s)

Your Answer:

Compile time error Compile time error
Runs successfully does not print anything
Runs successfully, ask for input and hence displays the result
Syntax Error Syntax Error

The Boolean operator which combines search terms so that each search result contains at least one of the terms, is:

1 Mark(s)

Your Answer:

and operator and operator
not operator not operator
or operator or operator
nor operator nor operator

Shortcut key to add Footnote ?

1 Mark(s)

Your Answer:

Alt+Ctrl+F Alt+Ctrl+F
Alt+Ctrl+D Alt+Ctrl+D
Alt+F Alt+F
None of these None of these

Which one has the most potential for minification?

1 Mark(s)

Your Answer:

JavaScript JavaScript
CSS CSS
HTML HTML
PHP PHP

What is the space complexity of storing a graph using an adjacency matrix?

1 Mark(s)

Your Answer:

O(V log V) O(V log V)
O(E) O(E)
O(V + E) O(V + E)
O(V2) O(V2)

To apply the aggregate function not only to a single set of tuples, but to a group of sets of tuples; using the:

1 Mark(s)

Your Answer:

Grouped clause Grouped clause
Group by clause Group by clause
Merge clause Merge clause
Avg clause Avg clause

The thing that is changing in an experiment:

1 Mark(s)

Your Answer:

variable variable
function function
equation equation
none of above none of above

The keyword used to tell the compiler that a variable's type can change or that it is not known until runtime is:

1 Mark(s)

Your Answer:

covariance covariance
dynamic dynamic
contravarience contravarience
object object

What will be the output of the following PHP code? <?php echo (checkdate(4,31,2010) ? 'Valid' : 'Invalid'); ?>

1 Mark(s)

Your Answer:

TRUE TRUE
FALSE FALSE
Valid Valid
Invalid Invalid

Which one of the following data structures are preferred in database-system implementation?

1 Mark(s)

Your Answer:

AVL tree AVL tree
B-tree B-tree
B+ -tree B+ -tree
Splay tree Splay tree

What will be the output of the following Python code? >>> class A: pass >>> class B(A): pass >>> obj=B() >>> isinstance(obj,A)

1 Mark(s)

Your Answer:

True True
False False
Wrong syntax for isinstance() method Wrong syntax for isinstance() method
Invalid method for classes Invalid method for classes

Which of the looping statements is/are supported by PHP? 1. for loop 2. while loop 3. do-while loop 4. foreach loop

1 Mark(s)

Your Answer:

1 and 2 1 and 2
1, 2 and 3 1, 2 and 3
All of the mentioned All of the mentioned
None of the mentioned None of the mentioned

What is embedded system?

1 Mark(s)

Your Answer:

The programme which arrives by being wrapped in box.
The programme which is the permanent part of the computer
The computer which is the part of a larger system or machine
The computer and software system that control the machine

A class consists of two interfaces with each interface consisting of three methods. The class had no instance data. Which of the following indicates the correct size of object created from this class?

1 Mark(s)

Your Answer:

12 bytes 12 bytes
16 bytes 16 bytes
0 bytes 0 bytes
24 bytes 24 bytes

Which of the following property is used to define the animations that should be run?

1 Mark(s)

Your Answer:

animation-delay animation-delay
animation-iteration-count animation-iteration-count
animation-duration animation-duration
animation-name animation-name

What will be the output of the following PHP code ? <?php function TV($string) { echo "my favourite TV show is ".$string; function b() { echo " I am here to spoil this code"; } } function b() { echo " I am here to spoil this code"; } b(); TV("Sherlock"); ?>

1 Mark(s)

Your Answer:

I am here to spoil this code I am here to spoil this code
Error Error
My favourite TV show isI am here to spoil this code
None of the mentioned None of the mentioned

What will be the output of the following Java code? class output { public static void main(String args[]) { StringBuffer s1 = new StringBuffer("Hello"); s1.insert(1,"Java"); System.out.println(s1); } }

1 Mark(s)

Your Answer:

hello hello
java java
Hello Java Hello Java
HJavaello HJavaello

Which of the following was the first Intel processor introduced?

1 Mark(s)

Your Answer:

3080 3080
4004 4004
8080 8080
8086 8086

Which of the following is attribute of SVG line?

1 Mark(s)

Your Answer:

x x
y y
x1 x1
all of the mentioned all of the mentioned

What are radio signals?

1 Mark(s)

Your Answer:

Analog signals Analog signals
Digital signals Digital signals
Optical signals Optical signals
Magnetic signals Magnetic signals

Automobile in a traffic flow simulation is:

1 Mark(s)

Your Answer:

object object
function function
data data
variable variable

The HTML element defines:

1 Mark(s)

Your Answer:

Line break Line break
Preformatted text Preformatted text
Paragraph Paragraph
Both A and C Both A and C

In NiFi, what is the purpose of the "EncryptContent" processor?

1 Mark(s)

Your Answer:

Apply encryption to the content of FlowFiles
A storage format in Hadoop A storage format in Hadoop
A query language for Hadoop A query language for Hadoop
A distributed file system A distributed file system

Which one is a Note-taking software for use with tablet PCs or regular PCs.

1 Mark(s)

Your Answer:

Microsoft PowerPoint Microsoft PowerPoint
None of these None of these
Microsoft OneNote Microsoft OneNote
Microsoft Access Microsoft Access

In C, which control structure is used to execute a block of code a specific number of times?

1 Mark(s)

Your Answer:

for loop for loop
while loop while loop
if statement if statement
switch case switch case

Plants in deserts have only few stomata to reduce:

1 Mark(s)

Your Answer:

water intake water intake
water loss water loss
mineral content mineral content
oxygen intake oxygen intake

What characteristic sets an Eulerian cycle apart from a Hamiltonian cycle?

1 Mark(s)

Your Answer:

A Hamiltonian cycle visits every vertex exactly once
AEulerian cycle visits every vertex exactly once
A Hamiltonian cycle visits every edge exactly once
AEulerian cycle visits every edge exactly once

To remove a relation from an SQL database, we use the:

1 Mark(s)

Your Answer:

Delete command Delete command
Eliminate Eliminate
Abort Abort
Drop Drop

In Domain Name Space (DNS), when the Internet was small, mapping was done by using a:

1 Mark(s)

Your Answer:

IP file IP file
host file host file
host ip host ip
host server host server

Static programs of the computer system are stored in:

1 Mark(s)

Your Answer:

RAM RAM
ROM ROM
hard disk hard disk
CD CD

Which method is used to find the index of the first occurrence of a specified character in a string in Java?

1 Mark(s)

Your Answer:

findIndex() findIndex()
indexOf() indexOf()
search() search()
findCharacter() findCharacter()

Action assertions have traditionally been implemented within an application program.

1 Mark(s)

Your Answer:

True True
False False

During logical database design, the conceptual data model is transformed into a logical data model which describes the data in terms of a specific data management technology.

1 Mark(s)

Your Answer:

True True
False False

In the following C# code, which of the following statement is not correct? public class MyContainer<T> where T: class, IComparable { /* insert code here */ }

1 Mark(s)

Your Answer:

Class MyContainer requires that its type argument must implement Icomparable interface
There are multiple constraints on type argument to MyContainer class
Class MyContainer requires that its type argument must be a reference type (class)
Compiler will report an error Compiler will report an error

For class member's security , the access specifier used is:

1 Mark(s)

Your Answer:

public public
protected protected
same as other members same as other members
private private

Which data structure allows for the efficient implementation of a circular buffer?

1 Mark(s)

Your Answer:

Deque Deque
Heap Heap
Circular Queue Circular Queue
Stack Stack

In-network addresses, each router has two:

1 Mark(s)

Your Answer:

addresses addresses
masks masks
blocks blocks
segments segments

Computers manipulate data in many ways, and this manipulation is called___________?

1 Mark(s)

Your Answer:

upgrading upgrading
processing processing
batching batching
utilizing utilizing

What is the result of the expression 5 > 3 && 4 < 6 in C?

1 Mark(s)

Your Answer:

TRUE TRUE
FALSE FALSE
1 1
0 0

Line coding includes digital signals conversion of a sequence of:

1 Mark(s)

Your Answer:

Bits Bits
Frames Frames
Packets Packets
Segments Segments

Salting passwords helps prevent:

1 Mark(s)

Your Answer:

Rainbow Table attacks Rainbow Table attacks
Brute Force Brute Force
Phishing Phishing
SQL Injection SQL Injection

When the parent entity is required and the parent has a surrogate key, update actions can be ignored.

1 Mark(s)

Your Answer:

True True
False False

Orion is a __________

1 Mark(s)

Your Answer:

A) constellation A) constellation
B) star B) star
C) planet C) planet
D) satellite D) satellite

Which of the following touch sensors is used in a cell phone?

1 Mark(s)

Your Answer:

Resistive touch sensors Resistive touch sensors
Human sensor Human sensor
Capacitive touch sensor Capacitive touch sensor
Follow sensor Follow sensor

MSIL is the abbreviation of:

1 Mark(s)

Your Answer:

Microsoft Intermediate Language Microsoft Intermediate Language
Microsoft Independent Language Microsoft Independent Language
Microsoft Intermediate Layer Microsoft Intermediate Layer
Mutual Software Implementable Laws Mutual Software Implementable Laws

The Database Management Query language is generally designed for the _____

1 Mark(s)

Your Answer:

Support end-users who use English like commands
Specifying the structure of the database
Support in the development of the complex applications software
All of the above All of the above

VDU stands for:?

1 Mark(s)

Your Answer:

Virus Destroy Unit Virus Destroy Unit
Visual Direct Unit Visual Direct Unit
Visual Display Unit Visual Display Unit
Virus Display Unit Answer Virus Display Unit Answer

How can you find the length of an array in C?

1 Mark(s)

Your Answer:

Use the length property Use the length property
Use the size property Use the size property
Use the sizeof operator Use the sizeof operator
Use the lengthof function Use the lengthof function

OLAP on large amounts of data requires that data be resident in a:

1 Mark(s)

Your Answer:

Database Database
Application Application
Process Process
Procedure Procedure

Which of the following helps to reduce spelling errors in a document being typed?

1 Mark(s)

Your Answer:

Auto Correct Auto Correct
Auto Format Auto Format
Smart Tags Smart Tags
Auto Text Auto Text

Any database modification that would cause a null to be inserted in an attribute declared to be not null generates an:

1 Mark(s)

Your Answer:

Exception Exception
Rejection Rejection
Output Output
Error Error

People with long-sightedness are treated by using:

1 Mark(s)

Your Answer:

concave lens concave lens
convex lens convex lens
lens lens
none of them none of them

What type of conflicts can occur in the shift-reduce parsing?

1 Mark(s)

Your Answer:

reduce/reduce reduce/reduce
shift/reduce shift/reduce
Both shift/reduce and reduce/reduce Both shift/reduce and reduce/reduce
None of the above None of the above

Petroleum is a mixture of crude oil and natural gas, these two substance are formed:

1 Mark(s)

Your Answer:

none of them none of them
artificially artificially
naturally naturally
occasionally occasionally

: Which operation is not typically performed directly on one-dimensional arrays?

1 Mark(s)

Your Answer:

Insertion Insertion
Deletion Deletion
Traversal Traversal
Random Access Random Access

What is 'Memoization'?

1 Mark(s)

Your Answer:

Deleting memory Deleting memory
Caching results Caching results
Sorting memory Sorting memory
Compressing data Compressing data

In MS word short cut "Shift+Delete " is used to

1 Mark(s)

Your Answer:

Delete the selected item permanently without placing the item in recycle bin
Copy the selected item Copy the selected item
Rename the selected item Rename the selected item
Create a short cut to selected item Create a short cut to selected item

A Web site's front page or main page is called

1 Mark(s)

Your Answer:

Home Page Home Page
Browser Page Browser Page
Search Page Search Page
none none

The dense white fumes which can be seen upon gas ammonia are due to mixing of:

1 Mark(s)

Your Answer:

hydrogen chloride hydrogen chloride
nitrogen dioxide nitrogen dioxide
ammonium chloride ammonium chloride
calcium chloride calcium chloride

In which data structure would you typically use depth-first search (DFS)?

1 Mark(s)

Your Answer:

Graph Graph
Heap Heap
Stack Stack
Queue Queue

Institute of Electrical and Electronics Engineers (IEEE) 802.11 have three categories of:

1 Mark(s)

Your Answer:

frames frames
fields fields
signals signals
sequences sequences

Which of the following statements concerning business rules is true?

1 Mark(s)

Your Answer:

It should be complex. It should be complex.
It should not be convertible to computer code.
It may include restrictions. It may include restrictions.
All of the above. All of the above.

Integral literals are assumed to be . . . . . . . . by default.

1 Mark(s)

Your Answer:

SMALL INT SMALL INT
INT INT
BIG INT BIG INT
TINY INT TINY INT

In R, what is the purpose of the repeat loop?

1 Mark(s)

Your Answer:

To repeat a block of code until a certain condition is met
To repeat a block of code a specified number of times
To repeat a block of code indefinitely To repeat a block of code indefinitely
To repeat a block of code based on a specific condition

Which SQL clause filters groups?

1 Mark(s)

Your Answer:

HAVING HAVING
WHERE WHERE
GROUP BY GROUP BY
ORDER BY ORDER BY

Tiny organisms which lived in seas and oceans are called:

1 Mark(s)

Your Answer:

mosses mosses
algae algae
plankton plankton
coral reef coral reef

Evaluating Your Answers

Database Systems Mock Test 11 : Question 1 of 79