Database Systems Mock Test 5

Specifying a key ensures that no two objects belonging to a class have the same value for the key attribute(s).

1 Mark(s)

Your Answer:

True True
False False

: What is the correct way to declare a one-dimensional array of integers in C?

1 Mark(s)

Your Answer:

int array[10]; int array[10];
int array; int array;
array int[10]; array int[10];
int[10] array; int[10] array;

setvbuf() and setbuf() function controls buffering for the stream.

1 Mark(s)

Your Answer:

true true
false false

If an argument from the parameter list of a function is defined constant then . . . . . . . .

1 Mark(s)

Your Answer:

It can be modified inside the function It can be modified inside the function
It cannot be modified inside the function
Error occurs Error occurs
Segmentation fault Segmentation fault

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 data element ?

1 Mark(s)

Your Answer:

The value is the value of the element’s value attribute, if it has one, or the empty string otherwise.
The value is the item created by the element.
The value is the element’s datetime value.
None of the mentioned None of the mentioned

Call by reference What happens when a global variable is passed by reference to a function?

1 Mark(s)

Your Answer:

The function creates a local copy of the global variable
The function modifies the global variable directly
The global variable remains unchanged The global variable remains unchanged
A new copy is allocated in the heap A new copy is allocated in the heap

Which command will configure a switch port to use the IEEE standard method of inserting VLAN membership information into Ethernet frames?

1 Mark(s)

Your Answer:

Switch(config)# switchport trunk encapsulation isl
Switch(config)# switchport trunk encapsulation ietf
Switch(config)# switchport trunk encapsulation dot1q
Switch(config-if)# switchport trunk encapsulation isl
Switch(config-if)# switchport trunk encapsulation dot1q

. . . . . . . . produces one-dimensional scatterplots.

1 Mark(s)

Your Answer:

xyplot xyplot
stripplot stripplot
barchart barchart
bwplot bwplot

A shared lock allows which of the following types of transactions to occur?

1 Mark(s)

Your Answer:

Delete Delete
Insert Insert
Read Read
Update Update

Which of the following is a library for statistical quality control?

1 Mark(s)

Your Answer:

gcc gcc
qcc qcc
anc anc
pnc pnc

Complex real object contains:

1 Mark(s)

Your Answer:

attributes attributes
variables variables
constants constants
strings strings

To create a file:

1 Mark(s)

Your Answer:

allocate the space in the file system allocate the space in the file system
make an entry for new file in directory make an entry for new file in directory
both A and B both A and B
delete the old file delete the old file

Which of these is a method of ListIterator used to obtain index of previous element?

1 Mark(s)

Your Answer:

previous() previous()
previousIndex() previousIndex()
back() back()
goBack() goBack()

In a one-to-many relationship, the entity that is on the one side of the relationship is called a(n) ________ entity.

1 Mark(s)

Your Answer:

parent parent
child child
instance instance
subtype subtype

What does the `retry` keyword do in Ruby?

1 Mark(s)

Your Answer:

Repeats the current iteration of the loop
Exits the loop Exits the loop
Restarts the loop from the beginning Restarts the loop from the beginning
Restarts the current block of code from the beginning

What is the significance of the Hadoop Rack Awareness feature?

1 Mark(s)

Your Answer:

Optimizes data locality by considering rack information
Balances data across racks Balances data across racks
Allocates more resources to specific racks
Randomly assigns tasks to racks Randomly assigns tasks to racks

What is the primary use of `void` return type?

1 Mark(s)

Your Answer:

No value No value
Integer Integer
Pointer Pointer
Error Error

How to read entire file in one line using java 8?

1 Mark(s)

Your Answer:

Files.readAllLines() Files.readAllLines()
Files.read() Files.read()
Files.readFile() Files.readFile()
Files.lines() Files.lines()

What should be set with text-align property so that every line has equal width like in magazines and newspapers?

1 Mark(s)

Your Answer:

text-align: justify text-align: justify
text-align: none text-align: none
text-align: bottom text-align: bottom
text-align: top text-align: top

Prides work together to defend their land and:

1 Mark(s)

Your Answer:

hunt hunt
space space
area area
colony colony

In a regular expression, what does the metacharacter `Q` represent?

1 Mark(s)

Your Answer:

A digit A digit
A word boundary A word boundary
The end of a quoted section The end of a quoted section
The beginning of a quoted section The beginning of a quoted section

How do you call a block in Ruby?

1 Mark(s)

Your Answer:

By invoking it with parentheses () By invoking it with parentheses ()
By using the call method By using the call method
By passing it as an argument to a method
By passing it to a method using the yield keyword

Which of the following tag is used to linked information should be placed inside?

1 Mark(s)

Your Answer:

<head> <head>
<html> <html>
<div> <div>
<body> <body>

What is the purpose of the 'strtok()' function in C++?

1 Mark(s)

Your Answer:

Converts a string to lowercase Converts a string to lowercase
Returns the length of a string Returns the length of a string
Concatenates two strings Concatenates two strings
Tokenizes a string based on a delimiter Tokenizes a string based on a delimiter

A computer portable and easy to carry by travellers is_________________?

1 Mark(s)

Your Answer:

Super computer Super computer
Laptop Laptop
Mini computer Mini computer
File servers File servers

Interrupts are provided primarily as a way to:

1 Mark(s)

Your Answer:

Improve processor utilization Improve processor utilization
Improve processor execution Improve processor execution
Improve processor control Improve processor control
Improve processor speed Improve processor speed

What is the primary purpose of the HBase Bloom Filters?

1 Mark(s)

Your Answer:

Sort records based on a column Sort records based on a column
Group records based on a condition Group records based on a condition
Improve read performance by filtering unnecessary data
Join records from multiple tables Join records from multiple tables

In java, jar stands for_____.

1 Mark(s)

Your Answer:

Java Archive Runner Java Archive Runner
Java Application Resource Java Application Resource
Java Application Runner Java Application Runner
None of the above None of the above

What would happen if the data in the client had been wrong?

1 Mark(s)

Your Answer:

Sends back the data Sends back the data
Waits for correction Waits for correction
Sends back the data and Waits for correction
None of the mentioned None of the mentioned

Aprons, cylinders and sectors in machines are covered by:

1 Mark(s)

Your Answer:

steel spikes steel spikes
feeder table feeder table
cylinder cylinder
air flow air flow

What is the main advantage of using a union in C?

1 Mark(s)

Your Answer:

It saves memory by sharing the same memory location
It allows easy access to all members It allows easy access to all members
It enforces strong data typing It enforces strong data typing
It prevents data from being modified It prevents data from being modified

When will the else part of try-except-else be executed?

1 Mark(s)

Your Answer:

always always
when an exception occurs when an exception occurs
when no exception occurs when no exception occurs
when an exception occurs in to except block

What is testing process’ first goal ?

1 Mark(s)

Your Answer:

Bug prevention Bug prevention
Testing Testing
Execution Execution
Analyses Analyses

What is the role of the Hadoop AvroInputFormat?

1 Mark(s)

Your Answer:

Reads and parses Avro data Reads and parses Avro data
Manages computation resources Manages computation resources
Executes MapReduce jobs Executes MapReduce jobs
Manages Hadoop ecosystem tools Manages Hadoop ecosystem tools

Which of the following statements is true about C#?

1 Mark(s)

Your Answer:

C# is a scripting language C# is a scripting language
C# is a markup language C# is a markup language
C# is an object-oriented language C# is an object-oriented language
C# is a procedural language C# is a procedural language

What does the term "URL mapping" refer to in Java Servlets?

1 Mark(s)

Your Answer:

Associating a URL pattern with a servlet
Mapping a URL to a JavaBean Mapping a URL to a JavaBean
Mapping a URL to a database table Mapping a URL to a database table
Mapping a URL to a Java class Mapping a URL to a Java class

The organ that helps us in hearing and maintaining balance is known as:

1 Mark(s)

Your Answer:

eyes eyes
brain brain
ear ear
arteries arteries

Chemical fertilizers is mostly made with various mineral salts which are essential for plant:

1 Mark(s)

Your Answer:

growth growth
development development
good fruit good fruit
all of them all of them

.mpg is a file extension of ____.?

1 Mark(s)

Your Answer:

Video Video
Word Word
Picture Picture
None of these Answer None of these Answer

If the mass of a substance is lowered, its density will be:

1 Mark(s)

Your Answer:

increased increased
decreased decreased
same same
constant constant

What is the purpose of a matcher in RSpec?

1 Mark(s)

Your Answer:

Records the interactions between objects
Describes the behavior of an application in plain text
Specifies the requirements for a software feature
Checks if a value meets certain conditions

What will be the output of the following Python code? def check(n): if n

1 Mark(s)

Your Answer:

False False
True True
1 1
An exception is thrown An exception is thrown

How many columns are there in the basic grid of a skeleton?

1 Mark(s)

Your Answer:

17 17
12 12
16 16
10 10

Linear acceleration dv/dt is equals to:

1 Mark(s)

Your Answer:

d Ω/dt d Ω/dt
d Ωr/dt d Ωr/dt
d Ω/dr d Ω/dr
d Ωθ/dr d Ωθ/dr

What is the purpose of passing arguments by reference in C++ functions?

1 Mark(s)

Your Answer:

Ensures the function receives correct arguments
Reduces the memory consumption of the function
Improves performance of the function Improves performance of the function
Allows changes made to the arguments to reflect outside the function

The value 0000001 of the prefix of the Internet Protocol Version (IPv6) address shows the type of:

1 Mark(s)

Your Answer:

multicast address multicast address
unicast address unicast address
reserved reserved
ISO network addresses ISO network addresses

When . . . . . . . . contents exceed a configurable threshold, the memtable data, which includes indexes, is put in a queue to be flushed to disk.

1 Mark(s)

Your Answer:

subtable subtable
memtable memtable
intable intable
memorytable memorytable

Choose from the given options the one that can be overloaded:

1 Mark(s)

Your Answer:

constructors constructors
methods methods
parameters parameters
operators operators

You should choose Sleep option when

1 Mark(s)

Your Answer:

The computer is tired after working for the whole day
You are leaving for a very short time and want to resume you work shortly
When computer gets hanged frequently. Let it sleep for some time
You finish working and going to bed You finish working and going to bed

Which one of the following technique is always needed in digital to digital conversion?

1 Mark(s)

Your Answer:

scrambling scrambling
block coding block coding
line coding line coding
encoding encoding

Alloys are impure and they make elements more:

1 Mark(s)

Your Answer:

strong strong
hard hard
soft soft
both a and b both a and b

Polymers including those used in fibers can be crystallized from dilute solution to give:

1 Mark(s)

Your Answer:

crystals crystals
small crystals small crystals
single crystals single crystals
two crystals two crystals

What will be the output of the program if the array begins at 65472 and each integer occupies 2 bytes? #include<stdio.h> void main() { int a[3][4] = {1, 2, 3, 4, 4, 3, 2, 1, 7, 8, 9, 0}; printf("%u, %u", a+1, &a+1); }

1 Mark(s)

Your Answer:

65474, 65488 65474, 65488
65480, 65488 65480, 65488
65480, 65496 65480, 65496
65474, 65476 65474, 65476
None of these None of these

Which Excel function is used to add the current system date?

1 Mark(s)

Your Answer:

DATE() DATE()
NOW() NOW()
TODAY() TODAY()
CURRENT_DATE() CURRENT_DATE()

What will be used when terminating a structure?

1 Mark(s)

Your Answer:

: :
} }
; ;
;; ;;

MS Office is used for ______?

1 Mark(s)

Your Answer:

Web browsing Web browsing
Graphic designing Graphic designing
Office work and productivity Office work and productivity
None of these None of these

Determine Output: void main() { int i=10; i=!i>14; printf("i=%d", i); }

1 Mark(s)

Your Answer:

10 10
14 14
0 0
1 1

An instrument that comprises of only a single convex lens is:

1 Mark(s)

Your Answer:

Refracting telescope Refracting telescope
Compound telescope Compound telescope
Simple telescope Simple telescope
Reflecting telescope Reflecting telescope

Online real-time systems become popular in:?

1 Mark(s)

Your Answer:

First Generation First Generation
Second Generation Second Generation
Third Generation Third Generation
Fourth Generation Answer Fourth Generation Answer

Which concept in Object-Oriented Programming allows objects of different classes to be treated as objects of a common superclass?

1 Mark(s)

Your Answer:

Encapsulation Encapsulation
Inheritance Inheritance
Abstraction Abstraction
Polymorphism Polymorphism

What does the 'print' method do in Ruby?

1 Mark(s)

Your Answer:

Prints to console Prints to console
Converts to string Converts to string
Reads input from user Reads input from user
Finds the length Finds the length

To Zoom an Excel worksheet we can use _______?

1 Mark(s)

Your Answer:

The mouse pointer in Print Preview The mouse pointer in Print Preview
The zoom button on the Print Preview toolbar
The zoom command on the view menu The zoom command on the view menu
All of these All of these

Which of the following is true about Microsoft Active Server Pages (ASP)?

1 Mark(s)

Your Answer:

It is stored in .cfm files. It is stored in .cfm files.
It is executed on the client. It is executed on the client.
It does not use tags. It does not use tags.
It allows for coding of custom tags in an HTML file.

Which operator is having the right to left associativity in the following?

1 Mark(s)

Your Answer:

Array subscripting Array subscripting
Function call Function call
Addition and subtraction Addition and subtraction
Type cast Type cast

________ is an open source DBMS product that runs on UNIX, Linux and Windows.

1 Mark(s)

Your Answer:

MySQL MySQL
JSP/SQL JSP/SQL
JDBC/SQL JDBC/SQL
Sun ACCESS Sun ACCESS

In MS Word 2007, which shortcut key is used for "Go to a page, bookmark, footnote, table, comment, graphic or other location"?

1 Mark(s)

Your Answer:

CTRL + G CTRL + G
CTRL + H CTRL + H
ALT + H ALT + H
None of these None of these

Which one of the following has no filtering capability?

1 Mark(s)

Your Answer:

hubs hubs
bridges bridges
gateways gateways
repeaters repeaters

Quick Sort worst case complexity:

1 Mark(s)

Your Answer:

O(n) O(n)
O(n log n) O(n log n)
O(n^2) O(n^2)
O(log n) O(log n)

Evaluating Your Answers

Database Systems Mock Test 5 : Question 1 of 68