SQL and Databases Mock Test 8

What is the purpose of the catch and throw keywords in Ruby?

1 Mark(s)

Your Answer:

They are used for error handling in asynchronous code
They provide a way to break out of nested loops or blocks
They are used to define custom error messages
None of the above None of the above

At Conceptual level Class diagrams should include_____________________?

1 Mark(s)

Your Answer:

operations only operations only
attributes only attributes only
both operations and attributes both operations and attributes
none of the mentioned none of the mentioned

SessionFactory is a thread-safe object.

1 Mark(s)

Your Answer:

True True
False False

The Incremental Model is a result of combination of elements of which two models?

1 Mark(s)

Your Answer:

Build & FIX Model & Waterfall Model Build & FIX Model & Waterfall Model
Linear Model & RAD Model Linear Model & RAD Model
Linear Model & Prototyping Model Linear Model & Prototyping Model
Waterfall Model & RAD Model Waterfall Model & RAD Model

Your router has the following IP address on Ethernet0: 172.16.2.1/23. Which of the following can be valid host IDs on the LAN interface attached to the router? 1. 172.16.1.100 2. 172.16.1.198 3. 172.16.2.255 4. 172.16.3.0

1 Mark(s)

Your Answer:

1 only 1 only
2 and 3 only 2 and 3 only
3 and 4 only 3 and 4 only
None of the above None of the above
2 and 5 only 2 and 5 only

Which of the following circuit convert the binary data into a decimal?

1 Mark(s)

Your Answer:

Decoder Decoder
Encoder Encoder
Code converter Code converter
Multiplexer Multiplexer

What is the role of the Fair Scheduler in Hadoop?

1 Mark(s)

Your Answer:

Ensures fair distribution of resources Ensures fair distribution of resources
Prioritizes tasks based on input size Prioritizes tasks based on input size
Allocates resources based on task complexity
Randomly assigns resources to tasks Randomly assigns resources to tasks

Fish exchange oxygen and carbon dioxide through gills in:

1 Mark(s)

Your Answer:

liquid liquid
water water
material material
solution solution

Computer memory which is non-volatile is:

1 Mark(s)

Your Answer:

RAM RAM
ROM ROM
DRAM DRAM
SRAM SRAM

. . . . . . . . is an RPC framework that defines a compact binary serialization format used to persist data structures for later analysis.

1 Mark(s)

Your Answer:

Pig Pig
Hive Hive
Thrift Thrift
None of the mentioned None of the mentioned

Determine Output: void main() { char not; not = !2; printf("%d", not); }

1 Mark(s)

Your Answer:

2 2
Garbage Value Garbage Value
0 0
None of These None of These

Study the following program: a = 1 while True: if a % 7 = = 0: break print(a) a += 1 Which of the following is correct output of this program? ``` a = 1 while True: if a % 7 = = 0: break print(a) a += 1 ```

1 Mark(s)

Your Answer:

1 2 3 4 5 1 2 3 4 5
1 2 3 4 5 6 1 2 3 4 5 6
1 2 3 4 5 6 7 1 2 3 4 5 6 7
Invalid syntax Invalid syntax

How many steps are there between Start and Finish in AutoContent Wizard?

1 Mark(s)

Your Answer:

3 3
4 4
5 5
6 6

In internet world, The communication between client and web server take place using?

1 Mark(s)

Your Answer:

PHA PHA
JAVA JAVA
CSS CSS
ASP NET ASP NET

Terminal speed of a shot is:

1 Mark(s)

Your Answer:

145 m/s 145 m/s
7 m/s 7 m/s
42 m/s 42 m/s
2 m/s 2 m/s

What is the output of the given code? a = 5 b=10 while a<b do puts a*b a+=2 b-=2 end

1 Mark(s)

Your Answer:

5 10 5 10
50 56 50 56
Infinite loop Infinite loop
5 6 7 8 9 10 5 6 7 8 9 10

What function can you use to create your own streams using the PHP stream wrappers and register them within PHP?

1 Mark(s)

Your Answer:

wrapper_register wrapper_register
stream_wrapper stream_wrapper
stream_wrapper_register stream_wrapper_register
stream_wrapper_reg stream_wrapper_reg

What are the formal parameters in C++?

1 Mark(s)

Your Answer:

Parameters with which functions are called
Parameters which are used in the definition of the function
Variables other than passed parameters in a function
Variables that are never used in the function

You have two jars, one jar which has 10 rings and the other has none. They are placed one above the other. You want to remove the last ring in the jar. And the second jar is weak and cannot be used to store rings for a long time.

1 Mark(s)

Your Answer:

Empty the first jar by removing it one by one from the first jar and placing it into the second jar
Empty the first jar by removing it one by one from the first jar and placing it into the second jar and empty the second jar by placing all the rings into the first jar one by one
There exists no possible way to do this There exists no possible way to do this
Break the jar and remove the last one Break the jar and remove the last one

The comprehensive software system that builds, maintains and provides acess to a database is_________________?

1 Mark(s)

Your Answer:

DBMS DBMS
CPU CPU
DASD DASD
CAI CAI

A durable transaction is one in which all committed changes are permanent.

1 Mark(s)

Your Answer:

True True
False False

Which of the following packages does not contain in "base" R system?

1 Mark(s)

Your Answer:

utils, graphics utils, graphics
mesh, compiler mesh, compiler
splines, stats4 splines, stats4
grDevices, datasets grDevices, datasets

Is the following Python code valid? >>> a=(1,2,3) >>> b=('A','B','C') >>> c=tuple(zip(a,b))

1 Mark(s)

Your Answer:

Yes, c will be ((1, 'A'), (2, 'B'), (3, 'C'))
Yes, c will be ((1,2,3),('A','B','C')) Yes, c will be ((1,2,3),('A','B','C'))
No because tuples are immutable No because tuples are immutable
No because the syntax for zip function isn't valid

API stands for

1 Mark(s)

Your Answer:

Algorithmic Protocol Interface Algorithmic Protocol Interface
Adapter Protocol Interface Adapter Protocol Interface
Application Programming Interface Application Programming Interface
Accellerated Programming Interface Accellerated Programming Interface

Density of earth's crust is equal to:

1 Mark(s)

Your Answer:

2.8x103 kg/m3 2.8x103 kg/m3
1.4x103 kg/m3 1.4x103 kg/m3
1.6x105 kg/m3 1.6x105 kg/m3
1x1010 kg/m3 1x1010 kg/m3

The output of the following program is: #define f(g,g2) g##g2 void main() { int var12=100; printf("%d", f(var,12)); }

1 Mark(s)

Your Answer:

Syntax error Syntax error
Runtime error Runtime error
g##g2 g##g2
100 100
10012 10012

What will be the output of the following C++ code? #include <typeinfo> #include <iostream> using namespace std; class shape { public: virtual void myvirtualfunc() const {} }; class mytriangle: public shape { public: virtual void myvirtualfunc() const { }; }; int main() { shape shape_instance; shape &ref_shape = shape_instance; try { mytriangle &ref_mytriangle = dynamic_cast(ref_shape); } catch (bad_cast) { cout << "Caught: bad_cast exception\n"; } return 0; }

1 Mark(s)

Your Answer:

Caught standard exception Caught standard exception
No exception arises No exception arises
Caught: bad_cast exception Caught: bad_cast exception
Caught: cast Caught: cast

What is the purpose of the binding method in Ruby?

1 Mark(s)

Your Answer:

To execute a block of code within the context of a specific object
To capture the current execution context and create a binding object
To generate a list of variables and their values within the current scope
None of the above None of the above

Helping people keep track of things is the purpose of a(n) ________ .

1 Mark(s)

Your Answer:

database database
table table
instance instance
relationship relationship

What is the full form of ICT?

1 Mark(s)

Your Answer:

InterConnect Technology InterConnect Technology
Internet Connection Topology Internet Connection Topology
Information and Communication Technology
Infer Communication Topology Infer Communication Topology

Name the exception thrown by read() on failure.

1 Mark(s)

Your Answer:

InterruptedException InterruptedException
SystemException SystemException
SystemInputException SystemInputException
I/O Exception I/O Exception

In dplyr, how do you select columns based on a partial name using the select() function?

1 Mark(s)

Your Answer:

select(starts_with("partial_name")) select(starts_with("partial_name"))
select(name_contains("partial_name")) select(name_contains("partial_name"))
select(partial_name) select(partial_name)
choose_columns("partial_name") choose_columns("partial_name")

What happens if the following program is executed in C and C++? #include<stdio.h> int main() { foo(); } int foo() { printf("Hello"); return 0; }

1 Mark(s)

Your Answer:

Error in both C and C++ Error in both C and C++
Warning in both C and C++ Warning in both C and C++
Error in C++ but Warning in C Error in C++ but Warning in C
Error in C but Warning in C++ Error in C but Warning in C++

Which statements are true regarding ICMP packets? 1. They acknowledge receipt of a TCP segment. 2. They guarantee datagram delivery. 3. They can provide hosts with information about network problems. 4. They are encapsulated within IP datagrams.

1 Mark(s)

Your Answer:

1 only 1 only
2 and 3 2 and 3
3 and 4 3 and 4
2, 3 and 4 2, 3 and 4

The layer under the epifermis that contains connective tissue, hair follicles, sweat glands and nerve endings is known as:

1 Mark(s)

Your Answer:

pore pore
dermis dermis
receptors receptors
sensory cell sensory cell

HTTPS provides a ______communication over a computer network.

1 Mark(s)

Your Answer:

secure secure
text text
voice voice
video video

CIA in security stands for:

1 Mark(s)

Your Answer:

Confidentiality, Integrity, Availability
Control, Integrity, Access Control, Integrity, Access
Computer, Internet, Access Computer, Internet, Access
Central, Intelligence, Agency Central, Intelligence, Agency

Monitor design ensures that:

1 Mark(s)

Your Answer:

only one process can be active at a time within the monitor
number of processes can be active at a time
the queue has only one process in it at a time
particular processes can be active at a time

Which of the following is also known as Rope data structure?

1 Mark(s)

Your Answer:

Cord Cord
String String
Array Array
Linked List Linked List

Which of the following best explains why we use models in science?

1 Mark(s)

Your Answer:

A) They replace real experiments A) They replace real experiments
B) They help understand complex phenomena
C) They are easier to memorize C) They are easier to memorize
D) They eliminate the need for observation

Which of the following is true if the property value of a name-value pair added by an element with an itemprop attribute is a time element ?

1 Mark(s)

Your Answer:

The value is the element’s datetime value.
The value is the value of the element’s content attribute, if any, or the empty string if there is no such attribute.
The value is the value of the element’s value attribute, if it has one, or the empty string otherwise.
The value is the element’s textContent.

A conceptual schema is usually depicted in graphical format using E-R or object-modeling notations.

1 Mark(s)

Your Answer:

True True
False False

Which of the following key is used to update a formula in a table?

1 Mark(s)

Your Answer:

Alt + Ctrl + F9 Alt + Ctrl + F9
F9 F9
Shift + F9 Shift + F9
Ctrl + Tab Answer Ctrl + Tab Answer

Evaluating Your Answers

SQL and Databases Mock Test 8 : Question 1 of 43