SQL and Databases Mock Test 6

Operator used for concatenation of two or more strings is:

1 Mark(s)

Your Answer:

+ +
+=' +='
& &
|| ||

Setup, data transfer and connection teardown are three phases of:

1 Mark(s)

Your Answer:

circuit switching circuit switching
packet switching packet switching
message switching message switching
source switching source switching

In multiple unicasting, the packets are created with a relative delay in:

1 Mark(s)

Your Answer:

large packet large packet
large networks large networks
large databits large databits
large nodes large nodes

Select the modifiers which can be used with the properties?

1 Mark(s)

Your Answer:

Private Private
Public Public
Protected Internal Protected Internal
All of the mentioned All of the mentioned

Data processing logic includes such activities as data validation and identification of processing errors.

1 Mark(s)

Your Answer:

True True
False False

Association establishment in Stream Control Transmission Protocol (SCTP), requires a:

1 Mark(s)

Your Answer:

2 way handshake 2 way handshake
3 way handshake 3 way handshake
four way handshake four way handshake
1 way handshake 1 way handshake

Three resistors of 2 Ohms, 3 Ohms, and 5 Ohms are connected in series with a 12V battery with no internal resistance. Find the total resistance of the combination and the potential difference across the resistor of 5 Ohms.

1 Mark(s)

Your Answer:

10 Ohms, 5V 10 Ohms, 5V
10 Ohms, 3V 10 Ohms, 3V
10 Ohms, 1.2V 10 Ohms, 1.2V
10 Ohms, 6V 10 Ohms, 6V

Which protocol is a signalling communication protocol used for controlling multimedia communication sessions ?

1 Mark(s)

Your Answer:

session initiation protocol session initiation protocol
session modelling protocol session modelling protocol
session maintenance protocol session maintenance protocol
none of these none of these

Which of the following are unary operators?

1 Mark(s)

Your Answer:

sizeof sizeof
- -
++ ++
all of the mentioned all of the mentioned

Which Flip-Flop toggles when inputs are 1,1?

1 Mark(s)

Your Answer:

SR Flip-Flop SR Flip-Flop
JK Flip-Flop JK Flip-Flop
D Flip-Flop D Flip-Flop
T Flip-Flop T Flip-Flop

Which one of the following principles of cyber security refers that the security mechanism must be as small and simple as possible?

1 Mark(s)

Your Answer:

Open-Design Open-Design
Economy of the Mechanism Economy of the Mechanism
Least privilege Least privilege
Fail-safe Defaults Fail-safe Defaults

Plants grow well and they need for it:

1 Mark(s)

Your Answer:

sunlight sunlight
bulb light bulb light
fire fire
thermo light thermo light

The output of the function len(sys.argv) is . . . . . . . .

1 Mark(s)

Your Answer:

Error Error
1 1
0 0
Junk value Junk value

What will be the output of the following R code? > f <- function(elt) { + elt[, 1] + } > lapply(x, f)

1 Mark(s)

Your Answer:

$a [1] 1 2 $b [1] 1 2 3 $a [1] 1 2 $b [1] 1 2 3
$a [1] 1 2 3 $b [1] 1 2 3 $a [1] 1 2 3 $b [1] 1 2 3
$a [1] 1 2 3 $b [1] 1 2 $a [1] 1 2 3 $b [1] 1 2
Error Error

The antiderivative of certain elementary functions cannot themselves be expressed as:

1 Mark(s)

Your Answer:

elementary function elementary function
exponential function exponential function
transfer function transfer function
unidirectional function unidirectional function

When a caller needs to communicate with the callee, the caller can use the e-mail address instead of the IP address in the:

1 Mark(s)

Your Answer:

OK Message OK Message
bye message bye message
INVITE Message INVITE Message
great message great message

Which of the following is true concerning a global transaction?

1 Mark(s)

Your Answer:

The required data are at one local site and the distributed DBMS routes requests as necessary.
The required data are located in at least one nonlocal site and the distributed DBMS routes requests as necessary.
The required data are at one local site and the distributed DBMS passes the request to only the local DBMS.
The required data are located in at least one nonlocal site and the distributed DBMS passes the request to only the local DBMS.

In Internet Protocol Version (IPv4) addresses, the reserved addresses of the Internet are unique:

1 Mark(s)

Your Answer:

globally globally
locally locally
regionally regionally
masking masking

In R, which package is specifically designed for working with time series data?

1 Mark(s)

Your Answer:

forecast forecast
timeSeries timeSeries
tsdata tsdata
chron chron

__________ prevents search engines from following links inside the page

1 Mark(s)

Your Answer:

noarchive noarchive
nofollow nofollow
noindex noindex
novalue novalue

Web browser looks for the uniform resource locator, which is the web site's:

1 Mark(s)

Your Answer:

code code
file extension file extension
address address
protocol protocol

Determine output: public class Test{ public static void main(String[] args){ int[] x = {1, 2, 3, 4}; int[] y = x; x = new int[2]; for(int i = 0; i

1 Mark(s)

Your Answer:

1 2 3 4 1 2 3 4
0 0 0 0 0 0 0 0
1 2 1 2
0 0 0 0
None of these None of these

What will be the output? C++ #include <iostream> class Sample { public: ~Sample() { std::cout << "Destructor executed "; } }; void createObject() { Sample s; } int main() { createObject(); std::cout << "Main done "; }

1 Mark(s)

Your Answer:

Main done Main done
Destructor executed Destructor executed
Main doneDestructor executed Main doneDestructor executed

A function has a Laplace transform if:

1 Mark(s)

Your Answer:

t < 0 t < 0
t>0 t>0
t ≤ 0 t ≤ 0
t≥ 0 t≥ 0

Asynchronous elements in the program can be implemented through:

1 Mark(s)

Your Answer:

Bugs Bugs
Threads Threads
Programs Programs
Security Policy Security Policy

Two students estimate the same value differently, but both are close to the actual value. Based on this information, which of the following statements is correct?

1 Mark(s)

Your Answer:

A) Both estimates are incorrect A) Both estimates are incorrect
B) Only one estimate is correct B) Only one estimate is correct
C) Both estimates are acceptable C) Both estimates are acceptable
D) Estimation is not useful D) Estimation is not useful

What will be the output of the following Java code? class exception_handling { public static void main(String args[]) { try { int a = args.length; int b = 10 / a; System.out.print(a); try { if (a == 1) a = a / a - a; if (a == 2) { int c = {1}; c[8] = 9; } } catch (ArrayIndexOutOfBoundException e) { System.out.println("TypeA"); } catch (ArithmeticException e) { System.out.println("TypeB"); } } } } Note : Execution command line : $ java exception_handling one

1 Mark(s)

Your Answer:

TypeA TypeA
TypeB TypeB
Compilation Error Compilation Error
Runtime Error Runtime Error

The prepareStatement method is of the class:

1 Mark(s)

Your Answer:

Statement Statement
Execute Execute
Query Query
Connection Connection

Output?int a=10; cout << ++a << a++;

1 Mark(s)

Your Answer:

11 11 11 11
11 12 11 12
12 11 12 11
10 11 10 11

Layer 2 switching provides which of the following? 1. Hardware-based bridging (ASIC) 2. Wire speed 3. Low latency 4. Low cost

1 Mark(s)

Your Answer:

1 and 3 1 and 3
2 and 4 2 and 4
1, 2 and 4 1, 2 and 4
All of the above All of the above

Plant products like timber, rubber, herbs, medicines resin and oils are derived from:

1 Mark(s)

Your Answer:

respiration respiration
photosynthesis photosynthesis
processing processing
transpiration transpiration

What is Apache Pig in the context of Hadoop?

1 Mark(s)

Your Answer:

High-level platform for processing and analyzing large datasets
A storage format in Hadoop A storage format in Hadoop
A query language for HBase A query language for HBase
A distributed file system A distributed file system

System in which output characteristics depend explicitly upon time is known as:

1 Mark(s)

Your Answer:

Time-invariant system Time-invariant system
Time-variant system Time-variant system
Non-linear system Non-linear system
Constant system Constant system

A software that can harm your computer is called?

1 Mark(s)

Your Answer:

Virus Virus
Server Server
Extension Extension
None of these None of these

[a,b]={x|a≤ b} is:

1 Mark(s)

Your Answer:

open bounded open bounded
close bounded close bounded
open unbounded open unbounded
close unbounded close unbounded

What will be the output of the following Python function? hex(15)

1 Mark(s)

Your Answer:

f f
0xF 0xF
0Xf 0Xf
0xf 0xf

Hydrogen atoms do not have:

1 Mark(s)

Your Answer:

electron electron
neutron neutron
carbon carbon
atom atom

In which version of PHP was MySQL Native Driver(also known as mysqlnd) introduced?

1 Mark(s)

Your Answer:

PHP 5.0 PHP 5.0
PHP 5.1 PHP 5.1
PHP 5.2 PHP 5.2
PHP 5.3 PHP 5.3

What is the primary function of Hadoop's Audit Logging?

1 Mark(s)

Your Answer:

Capturing and logging security-related events
Optimizing resource allocation in MapReduce
Enabling speculative execution in MapReduce
Configuring SSL/TLS for communication Configuring SSL/TLS for communication

Which loop in C# executes its body at least once, even if the condition is false?

1 Mark(s)

Your Answer:

for for
do-while do-while
foreach foreach
None of the above None of the above

The size_t integer type in C++ is?

1 Mark(s)

Your Answer:

Unsigned integer of at least 64 bits Unsigned integer of at least 64 bits
Signed integer of at least 16 bits Signed integer of at least 16 bits
Unsigned integer of at least 16 bits Unsigned integer of at least 16 bits
Signed integer of at least 64 bits Signed integer of at least 64 bits

Sum of potential differences across all the capacitors in series is equal to the:

1 Mark(s)

Your Answer:

applied potential difference applied potential difference
ground voltage ground voltage
zero capacitance zero capacitance
electric field of center capacitance electric field of center capacitance

What is the stored in the object obj in following lines of Java code? box obj;

1 Mark(s)

Your Answer:

Memory address of allocated memory of object
NULL NULL
Any arbitrary pointer Any arbitrary pointer
Garbage Garbage

The line between two cells is :

1 Mark(s)

Your Answer:

Margin Margin
Cell Cell
Tab Tab
None of these None of these

What will be the output of the following C# code snippet? class UseTypeof { static void Main() { Type t = typeof(StreamReader); Console.WriteLine(t.FullName); if(t.IsClass) Console.WriteLine("Is a class."); if(t.IsAbstract) Console.WriteLine("Is abstract."); else Console.WriteLine("Is concrete."); } }

1 Mark(s)

Your Answer:

Is a class Is abstract Is a class Is abstract
Is abstract Is abstract
System.IO.StreamReader Is a class Is concrete
Both Is a class Is abstract & System.IO.StreamReader Is a class Is concrete

Which of the following algorithms can be used to find all-pairs shortest paths in a graph?

1 Mark(s)

Your Answer:

Dijkstra's Algorithm Dijkstra's Algorithm
Bellman-Ford Algorithm Bellman-Ford Algorithm
Kruskal's Algorithm Kruskal's Algorithm
Floyd-Warshall Algorithm Floyd-Warshall Algorithm

Which metric gives the idea about the contents on a web page ?

1 Mark(s)

Your Answer:

Word Token Word Token
Word Count Word Count
Word Size Word Size
Word Length Word Length

Search engines maintain heavy database of:

1 Mark(s)

Your Answer:

keywords keywords
URLs URLs
web pages web pages
all of these all of these

Modern Computer are very reliable but they are not___________?

1 Mark(s)

Your Answer:

Fast Fast
Powerful Powerful
Infallible Infallible
Cheap Cheap

For a number of reasons, normalizations is not often an advantage for a(n) ________ database.

1 Mark(s)

Your Answer:

read-only read-only
updateable updateable
either a read-only or an updateable either a read-only or an updateable
None of the above is correct None of the above is correct

Mail Merge is a feature of which software?

1 Mark(s)

Your Answer:

Microsoft Word Microsoft Word
Microsoft Excel Microsoft Excel
Microsoft PowerPoint Microsoft PowerPoint
None of these None of these

Digital signals are represented in:

1 Mark(s)

Your Answer:

sine waves sine waves
levels levels
stages stages
cosine waves cosine waves

What will be the output of the following C++ code? #include <iostream> using namespace std; class Base { public: virtual void print() const = 0; }; class DerivedOne : public Base { public: void print() const { cout << "DerivedOne\n"; } }; class DerivedTwo : public Base { public: void print() const { cout << "DerivedTwo\n"; } }; class Multiple : public DerivedOne, public DerivedTwo { public: void print() const { DerivedTwo :: print(); } }; int main() { int i; Multiple both; DerivedOne one; DerivedTwo two; Base *array[ 3 ]; array[ 0 ] = &both; array[ 1 ] = &one; array[ 2 ] = &two; array[ i ] -> print(); return 0; }

1 Mark(s)

Your Answer:

DerivedOne DerivedOne
DerivedTwo DerivedTwo
Error Error
DerivedThree DerivedThree

How to call a function without using the function name to send parameters?

1 Mark(s)

Your Answer:

typedefs typedefs
Function pointer Function pointer
Both typedefs and Function pointer Both typedefs and Function pointer
None of the mentioned None of the mentioned

What will be the output of the following C++ code? #include <iostream> using namespace std; class polygon { protected: int width, height; public: void set_values (int a, int b) { width = a; height = b;} }; class output1 { public: void output (int i); }; void output1::output (int i) { cout << i << endl; } class rectangle: public polygon, public output1 { public: int area () { return (width * height); } }; class triangle: public polygon, public output1 { public: int area () { return (width * height / 2); } }; int main () { rectangle rect; triangle trgl; rect.set_values (4, 5); trgl.set_values (4, 5); rect.output (rect.area()); trgl.output (trgl.area()); return 0; }

1 Mark(s)

Your Answer:

20 20
10 10
20 10 20 10
30 30

Statement that may specify restrict in order to prevent cascading revocation, is called:

1 Mark(s)

Your Answer:

Revoke Revoke
Restrict Restrict
Assign Assign
Cascade Cascade

Determine output: public class Test{ public static void main(String args[]){ MyClass obj = new MyClass(); obj.val = 1; obj.call(obj); System.out.println(obj.val); } } class MyClass{ public int val; public void call(MyClass ref){ ref.val++; } }

1 Mark(s)

Your Answer:

1 1
2 2
3 3
Compilation Error Compilation Error
None of these None of these

The best AI agent is one which____________

1 Mark(s)

Your Answer:

Needs user inputs for solving any problem
Can solve a problem on its own without any human intervention
Need a similar exemplary problem in its knowledge base
All of the above All of the above

When object is stationary, its kinetic energy is:

1 Mark(s)

Your Answer:

zero zero
one one
∞ ∞
random random

The search that can't be targeted by SEO is . . . . . . . .

1 Mark(s)

Your Answer:

video search video search
image search image search
academic search academic search
audio search audio search

The status bit is also called as -

1 Mark(s)

Your Answer:

Unsigned bit Unsigned bit
Signed bit Signed bit
Flag bit Flag bit
None of the above None of the above

What will be the output of the following Python code? list(map((lambda x:x^2), range(10)))

1 Mark(s)

Your Answer:

[0, 1, 4, 9, 16, 25, 36, 49, 64, 81] [0, 1, 4, 9, 16, 25, 36, 49, 64, 81]
Error Error
[2, 3, 0, 1, 6, 7, 4, 5, 10, 11] [2, 3, 0, 1, 6, 7, 4, 5, 10, 11]
No output No output

Evaluating Your Answers

SQL and Databases Mock Test 6 : Question 1 of 62