Database Systems Mock Test 13

What will be the output of the following PHP code ? <?php $x=0; function fun() { echo $GLOBALS['x']; $GLOBALS['x']++; } fun(); fun(); fun(); ?>

1 Mark(s)

Your Answer:

000 000
012 012
123 123
Error Error

Image that is formed at the point where light rays are focused is called:

1 Mark(s)

Your Answer:

real image real image
virtual image virtual image
convergence image convergence image
angular image angular image

What is the purpose of the GetInvocationList() method associated with delegates in C#?

1 Mark(s)

Your Answer:

Removes a delegate from the current delegate
Adds a new delegate to the current delegate
Invokes all the delegates bound to the current delegate
Retrieves an array of delegates bound to the current delegate

Which of the following style properties do you use to specify italic text in MS Word?

1 Mark(s)

Your Answer:

Font-italic Font-italic
Font-style Font-style
Text-style Text-style
None of these None of these

When ∊ is a constant then ∂/∂x(∊x)=:

1 Mark(s)

Your Answer:

∊x ∊x
x x
∊ ∊
∊x2 ∊x2

The hub of a MySQL installation is . . . . . . . .

1 Mark(s)

Your Answer:

mysqla mysqla
mysqlb mysqlb
mysqlc mysqlc
mysqld mysqld

What is the method used to check if a variable is empty in Ruby?

1 Mark(s)

Your Answer:

.empty? .empty?
.is_empty? .is_empty?
.null? .null?
.has_content? .has_content?

What happens when you access an array element out of bounds in C++?

1 Mark(s)

Your Answer:

The program crashes The program crashes
The compiler throws an error The compiler throws an error
The runtime throws an error The runtime throws an error
Undefined behavior Undefined behavior

What will be the output of the following PHP code ? <?php $x = 3.5; $y = 2; $z = 2; echo $x / $y / $z; ?>

1 Mark(s)

Your Answer:

1.75 1.75
0.875 0.875
3.5 3.5
Error Error

Zebra stripes help them to:

1 Mark(s)

Your Answer:

group group
stripes stripes
system system
camouflage camouflage

Which of the following physical quantity has S.I. unit J/C?

1 Mark(s)

Your Answer:

Electric flux Electric flux
Dipole moment Dipole moment
Electric Potential Electric Potential
Electric field intensity Electric field intensity

_____________________ is a reuse-based approach to defining, implementing, and composing loosely coupled independent components into systems?

1 Mark(s)

Your Answer:

Component-based software engineering Component-based software engineering
Component composition Component composition
Component model Component model
Component interfaces Component interfaces

The coding scheme that was designed to be used in combination with Non Return-to zero-invert (NRZ-I) is:

1 Mark(s)

Your Answer:

BSZS BSZS
8RIlOR 8RIlOR
4D/5D 4D/5D
R8ZS R8ZS

. . . . . . . . function takes various parameters like formula, data, subset, labels, etc.

1 Mark(s)

Your Answer:

Pears Pears
Pairs Pairs
Tears Tears
Cars Cars

What is the primary purpose of a mutex in C++ multi-threading?

1 Mark(s)

Your Answer:

To manage thread priorities To manage thread priorities
To synchronize the execution of threads To synchronize the execution of threads
To provide mutual exclusion To provide mutual exclusion
To execute a task asynchronously To execute a task asynchronously

In the email dialog box Bcc is used for?

1 Mark(s)

Your Answer:

Subject Subject
Email Address Email Address
Phone Numbers Phone Numbers
Names Names

Which of the following is the correct way to declare a 3D array in Java?

1 Mark(s)

Your Answer:

int[][][] array = new int[3][3][3]; int[][][] array = new int[3][3][3];
int array[][][] = new int[3][3][3]; int array[][][] = new int[3][3][3];
int array[3][3][3]; int array[3][3][3];
int[] array = new int[3][3][3]; int[] array = new int[3][3][3];

Photosynthesis is a process that converts waste products to useful substance, which in result provide:

1 Mark(s)

Your Answer:

oxygen oxygen
energy energy
neon neon
carbon dioxide carbon dioxide

Which file mode opens for reading and writing?

1 Mark(s)

Your Answer:

rw rw
rw+ rw+
r+ r+
x x

What is the shortcut key for Help in MS Word?

1 Mark(s)

Your Answer:

F1 F1
F2 F2
F3 F3
F4 F4

SQL also provides constructs that allow you to change the behavior with:

1 Mark(s)

Your Answer:

Null values Null values
Not Null values Not Null values
Unique values Unique values
Not Unique values Not Unique values

Early file systems were flat; that is, all files were stored in:

1 Mark(s)

Your Answer:

Not in directory Not in directory
Single directory Single directory
Multiple directories Multiple directories
Multple extensions Multple extensions

What is the storage duration of a variable with 'auto' storage class?

1 Mark(s)

Your Answer:

Static Static
Automatic Automatic
Register Register
External External

Which concept of OOPs is shown by Virtual Functions?

1 Mark(s)

Your Answer:

Inheritance Inheritance
Encapsulation Encapsulation
Polymorphism Polymorphism
Abstraction Abstraction

An element can exist as either atoms or:

1 Mark(s)

Your Answer:

molecule molecule
atom atom
compound compound
solution solution

SQL is not case sensitive. SELECT is the same as select.

1 Mark(s)

Your Answer:

True True
False False

Which of the following can be considered PaaS offering?

1 Mark(s)

Your Answer:

Youtube Youtube
Google Earth Google Earth
Google Adsense Google Adsense
Google Maps Google Maps

What is the size of a 'double' usually?

1 Mark(s)

Your Answer:

4 bytes 4 bytes
8 bytes 8 bytes
10 bytes 10 bytes
16 bytes 16 bytes

Which of the following has eccentricity of 0.250?

1 Mark(s)

Your Answer:

Mercury Mercury
Mars Mars
Pluto Pluto
Neptune Neptune

In an object diagram, an object is represented as a rectangle with two compartments.

1 Mark(s)

Your Answer:

True True
False False

Synchronous Optical Networking (SONET) frame can carry information from a digitized voice:

1 Mark(s)

Your Answer:

media media
channel channel
station station
signal signal

The administrator may need to create a subnet without changing the whole system to recognize:

1 Mark(s)

Your Answer:

subnetted address subnetted address
supernetted data supernetted data
subnetted link subnetted link
supernetted link supernetted link

Determine Output: class A{ public static void method(int i){ System.out.print("Method 1"); } public static int method(String str){ System.out.print("Method 2"); return 0; } } public class Test{ public static void main(String args[]){ A.method(5); } }

1 Mark(s)

Your Answer:

Method 1 Method 1
Method 2 Method 2
Compile time error as final method can't be overloaded
None of the above None of the above

When you sent an email which of the following fields should contain your email address?

1 Mark(s)

Your Answer:

To To
From From
Cc Cc
Bcc Bcc

What will be the output of the following C# code? static void Main(string[] args) { float f; for (f = 0.1f; f <= 0.5; f += 1) Console.WriteLine( ++f ); Console.ReadLine(); }

1 Mark(s)

Your Answer:

1.1 1.1
0.1 0.1
0.1 0.2 0.3 0.4 0.5 0.1 0.2 0.3 0.4 0.5
None of the mentioned None of the mentioned

What is the term used to describe a class that inherits properties and behaviors from another class in C++?

1 Mark(s)

Your Answer:

Base class Base class
Child class Child class
Derived class Derived class
Parent class Parent class

How many bits are in a Double Precision Float (IEEE 754)?

1 Mark(s)

Your Answer:

32 32
64 64
128 128
16 16

Which of the following will remove the resource(s) from the distributed cache?

1 Mark(s)

Your Answer:

delete FILE[S] <filepath>* delete FILE[S] <filepath>*
delete JAR[S] <filepath>* delete JAR[S] <filepath>*
delete ARCHIVE[S] <filepath>* delete ARCHIVE[S] <filepath>*
all of the mentioned all of the mentioned

The correct syntax to access the member of the ith structure in the array of structures is? Assuming: struct temp { int b; }s[50];

1 Mark(s)

Your Answer:

s.b.[i]; s.b.[i];
s.[i].b; s.[i].b;
s.b[i]; s.b[i];
s[i].b; s[i].b;

Which of the following is a technique used to detect conflicts between concurrent transactions?

1 Mark(s)

Your Answer:

Checkpointing Checkpointing
Deadlock detection Deadlock detection
Two-Phase Commit Two-Phase Commit
Write-Ahead Logging Write-Ahead Logging

it is a sign or symbol that specifies, operator, and values that produce a result?

1 Mark(s)

Your Answer:

Operator Operator
Query Query
Expression Expression
None of them None of them

The length of the dipole antenna for a carrier wave of the frequency of 6 x 10^8 Hz is:

1 Mark(s)

Your Answer:

0.25m 0.25m
0.125m 0.125m
0.5m 0.5m
0.1025m 0.1025m

In MS Word 2016, the Screenshot is in the?

1 Mark(s)

Your Answer:

Insert Insert
Review the bar Review the bar
Options menu Options menu
Backstage view Backstage view

A device used to measure the pressure of the atmosphere is:

1 Mark(s)

Your Answer:

Barometer Barometer
Manometer Manometer
Ammeter Ammeter
Voltmeter Voltmeter

Derivative of e(2x+3) is:

1 Mark(s)

Your Answer:

e2x+3 e2x+3
e2x e2x
2e2x+3 2e2x+3
2e2x 2e2x

Which function returns an array of row values?

1 Mark(s)

Your Answer:

fetchrow_array() fetchrow_array()
fetchrow_arrayref() fetchrow_arrayref()
fetch() fetch()
fetchrow_hashref() fetchrow_hashref()

Animals move

1 Mark(s)

Your Answer:

A) to search their food A) to search their food
B) to search for shelter B) to search for shelter
C) to escape from their enemies C) to escape from their enemies
D) all of these D) all of these

Which of the following is correct about virtual destructor?

1 Mark(s)

Your Answer:

Ensures derived destructor is called Ensures derived destructor is called
Must be pure Must be pure
Cannot have parameters Cannot have parameters
Cannot have body Cannot have body

What is the purpose of the 'std::barrier' class in C++ multi-threading?

1 Mark(s)

Your Answer:

To synchronize the execution of threads at a specified point
To execute a task asynchronously To execute a task asynchronously
To signal waiting threads To signal waiting threads
To manage thread priorities To manage thread priorities

What is the purpose of the `get(int index)` method in a generic list in Java?

1 Mark(s)

Your Answer:

To check if an element exists at the specified index
To remove an element at the specified index
To retrieve an element at the specified index
To add an element at the specified index

Which are the session tracking techniques? i. URL rewriting ii. Using sessi iii.Using response object iv. Using hidden fields v. Using cookies vi. Using servlet object

1 Mark(s)

Your Answer:

i, ii, iii, vi i, ii, iii, vi
i, ii, iv, v i, ii, iv, v
i, vi, iii, v i, vi, iii, v
i, ii, iii, v i, ii, iii, v

Which of the following is used to define a block of code in Python language?

1 Mark(s)

Your Answer:

Indentation Indentation
Key Key
Brackets Brackets
All of the mentioned All of the mentioned

Which process characteristic with respect to Dependability Engineering is mentioned by the statement: “The process should be understandable by people apart from process participants” ?

1 Mark(s)

Your Answer:

Diverse Diverse
Documentable Documentable
Auditable Auditable
None of the mentioned None of the mentioned

The purpose of dividing the picture into blocks is to decrease the number of:

1 Mark(s)

Your Answer:

channels channels
pixels pixels
calculations calculations
frames frames

Which Python library is commonly used for web scraping?

1 Mark(s)

Your Answer:

PyData PyData
WebTool WebTool
DataScraper DataScraper
BeautifulSoup BeautifulSoup

Which of the following refers to the number of tuples in a relation?

1 Mark(s)

Your Answer:

Entity Entity
Column Column
Cardinality Cardinality
None of the above None of the above

What will be the output of the following PHP code ? <?php function fun($x,$y) { $x = 4; $y = 3; $z = $x + $y / $y + $x; echo "$z"; } fun(3, 4); ?>

1 Mark(s)

Your Answer:

7 7
9 9
0 0
Error Error

In 2003, the .ico format was registered with the ____________

1 Mark(s)

Your Answer:

IANA IANA
W3C W3C
WIPO WIPO
EPO EPO

What will be the output of the following PHP code ? <?php $number = range(0, 5); print_r ($number); ?>

1 Mark(s)

Your Answer:

Array ( [0] => 0 [1] => 1 [2] => 2 [3] => 3 [4] => 4 [5] => 5 )
Array ( [0] => 0 [1] => 0 [2] => 0 [3] => 0 [4] => 0 [5] => 0 )
Array ( [0] => 5 [1] => 5 [2] => 5 [3] => 5 [4] => 5 [5] => 5 )
Array ( [0] => 0 [5] => 5 ) Array ( [0] => 0 [5] => 5 )

Any living thing is known as:

1 Mark(s)

Your Answer:

biotic biotic
abiotic abiotic
bio magnifications bio magnifications
autotroph autotroph

What will be the output of the following Java program? class output { public static void main(String args[]) { String s1 = "one"; String s2 = s1 + " two"; System.out.println(s2); } }

1 Mark(s)

Your Answer:

one one
two two
one two one two
compilation error compilation error

Choose the correct type of variable scope for the following C# defined variables. class ABC { static int m; int n; void fun (int x , ref int y, out int z, int[] a) { int j = 10; } }

1 Mark(s)

Your Answer:

m = static variable, n = local variable, x = output parameter, y = reference parameter, j = instance variable, z = output parameter, a[0] = array element
m = static variable, n = instance variable, x = value parameter, y = reference parameter, j = local variable, z = output parameter , a[0] = array element
m = static variable, n = instance variable, x = reference parameter, y = value parameter, j = local variable, z = output parameter, a[0] = array element
m = local variable, n = instance variable, x = reference parameter, y = value parameter, j = static variable, z = output parameter, a[0] = array element

Which diagram shows the configuration of run-time processing elements ?

1 Mark(s)

Your Answer:

Deployment diagram Deployment diagram
Component diagram Component diagram
Node diagram Node diagram
ER-diagram ER-diagram

In the relation model, the relation are generally termed as ________

1 Mark(s)

Your Answer:

Tuples Tuples
Attributes Attributes
Rows Rows
Tables Tables

What is the purpose of the event onAirEvent?

1 Mark(s)

Your Answer:

Content is played Content is played
Content is transfered Content is transfered
Both Content is played and transfered Both Content is played and transfered
None of the mentioned None of the mentioned

There is only one way to create and modify tables in SQL Server. Write SQL code using either the CREATE or ALTER statements.

1 Mark(s)

Your Answer:

True True
False False

It requires explicit dereferencing to access the value What is one potential issue when using call by pointer instead of call by reference?

1 Mark(s)

Your Answer:

Call by pointer is less efficient Call by pointer is less efficient
The pointer can accidentally be reassigned to another memory location
The pointer cannot be modified The pointer cannot be modified
It always leads to segmentation faults It always leads to segmentation faults

Which three commands can be used to check LAN connectivity problems on a router? 1. show interfaces 2. show ip route 3. tracert 4. ping 5. dns lookups

1 Mark(s)

Your Answer:

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

Evaluating Your Answers

Database Systems Mock Test 13 : Question 1 of 68