Database Systems Mock Test 9

Modern Bluetooth is the implementation of protocol, defined by:

1 Mark(s)

Your Answer:

frames frames
stations stations
signals signals
cellular cellular

Which one of the following is considered as the least safe typecasting in C++?

1 Mark(s)

Your Answer:

const_cast const_cast
reinterpret_cast reinterpret_cast
dynamic_cast dynamic_cast
None of the above None of the above

Can command line arguments be converted into int automatically if required?

1 Mark(s)

Your Answer:

Yes Yes
No No
Compiler Dependent Compiler Dependent
Only ASCII characters can be converted Only ASCII characters can be converted

Symbol of Antimony is:

1 Mark(s)

Your Answer:

Sb Sb
At At
An An
A A

On heating sugar gives off:

1 Mark(s)

Your Answer:

carbon(black solid0 carbon(black solid0
water vapors water vapors
both a and b both a and b
carbon dioxide carbon dioxide

What is the purpose of lazy loading?

1 Mark(s)

Your Answer:

Immediate loading is necessary Immediate loading is necessary
Loading under command Loading under command
Immediate loading is not necessary Immediate loading is not necessary
None of the mentioned None of the mentioned

What is the significance of the "cut" in the context of the Max-Flow Min-Cut Theorem?

1 Mark(s)

Your Answer:

It is the total weight of all edges. It is the total weight of all edges.
It represents the number of cycles in the graph.
It represents a partition of the vertices into two sets, where the minimum cut is the smallest set of edges that, if removed, would disconnect the source from the sink.
It represents the number of vertices in the graph.

Ruby can deal with both numbers and floating point values.

1 Mark(s)

Your Answer:

True True
False False

How can you insert a page break in Microsoft Word?

1 Mark(s)

Your Answer:

Ctrl + Tab Ctrl + Tab
Ctrl + Enter Ctrl + Enter
Ctrl + Alt Ctrl + Alt
Ctrl + Shift Ctrl + Shift

Which of these method is called when http daemon is acting like a normal web server?

1 Mark(s)

Your Answer:

Handle() Handle()
Handleget() Handleget()
handleGet() handleGet()
None of These None of These

A device that uses work to transfer energy from a low temperature reservoir to high temperature reservoir as the device continuously repeat a set series of thermodynamic processes is called:

1 Mark(s)

Your Answer:

refrigerator refrigerator
dispenser dispenser
heater heater
comparator comparator

Which malware demands money?

1 Mark(s)

Your Answer:

Ransomware Ransomware
Spyware Spyware
Adware Adware
Worm Worm

ASCII is a coding system that provides_____________?

1 Mark(s)

Your Answer:

256 different characters 256 different characters
512 different characters 512 different characters
1024 different characters 1024 different characters
128 different characters 128 different characters

What is the string contained in s after following lines of Java code? StringBuffer s new StringBuffer("Hello"); s.deleteCharAt(0);

1 Mark(s)

Your Answer:

Hell Hell
ello ello
Hel Hel
llo llo

Can linear search recursive algorithm and binary search recursive algorithm be performed on an unordered list?

1 Mark(s)

Your Answer:

Binary search can't be used Binary search can't be used
Linear search can't be used Linear search can't be used
Both cannot be used Both cannot be used
Both can be used Both can be used

What keystroke will terminate setup mode?

1 Mark(s)

Your Answer:

Ctrl+Z Ctrl+Z
Ctrl+^ Ctrl+^
Ctrl+C Ctrl+C
Ctrl+Shift+^ Ctrl+Shift+^

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

1 Mark(s)

Your Answer:

To define thread-specific data To define thread-specific data
To manage thread priorities To manage thread priorities
To create and manage threads To create and manage threads
To synchronize access to shared resources

Which Java standard library provides utility functions for manipulating strings?

1 Mark(s)

Your Answer:

StringUtils StringUtils
StringBuffer StringBuffer
String String
StringBuilder StringBuilder

Which of the following mixtures would you be able to separate using the method of filtration? (NCERT Exemplar)

1 Mark(s)

Your Answer:

A) Oil in water A) Oil in water
B) Cornflakes in milk B) Cornflakes in milk
C) Salt in water C) Salt in water
D) Sugar in milk D) Sugar in milk

Which of the following is not included in the framework?

1 Mark(s)

Your Answer:

font sizes font sizes
css reset css reset
button styles button styles
forms forms

What is the result of the expression *ptr in C, where ptr is a pointer to an int?

1 Mark(s)

Your Answer:

Address of ptr Address of ptr
Value pointed to by ptr Value pointed to by ptr
Size of ptr Size of ptr
Type of ptr Type of ptr

Which command is used to check DNS records?

1 Mark(s)

Your Answer:

ping ping
tracert tracert
netstat netstat
nslookup nslookup

You are troubleshooting a connectivity problem in your corporate network and want to isolate the problem. You suspect that a router on the route to an unreachable network is at fault. What IOS user exec command should you issue?

1 Mark(s)

Your Answer:

Router> ping Router> ping
Router> trace Router> trace
Router> show ip route Router> show ip route
Router> show interface Router> show interface

The cryptography can provide:

1 Mark(s)

Your Answer:

entity authentication entity authentication
nonrepudiation of messages nonrepudiation of messages
confidentiality confidentiality
authentication authentication

What is the primary purpose of the JDBC `RowSet` interface?

1 Mark(s)

Your Answer:

To manage JavaBean lifecycle To manage JavaBean lifecycle
To represent a set of rows from a database
To execute SQL queries To execute SQL queries
None of These None of These

What is the purpose of the Canvas widget in Tkinter?

1 Mark(s)

Your Answer:

Displaying images Displaying images
Drawing graphics and shapes Drawing graphics and shapes
Playing audio Playing audio
Handling user input Handling user input

Dynamic Programming is applicable when:

1 Mark(s)

Your Answer:

Overlapping Subproblems Overlapping Subproblems
Distinct Subproblems Distinct Subproblems
Greedy Choice Greedy Choice
Randomness Randomness

Which one of the following statement is true about Grid Computing?

1 Mark(s)

Your Answer:

Pieces combine small tasks into complex tasks
The subscription tier plays an important role in grid computing.
Breaks complex tasks into small operations
Both A and C Both A and C

In Java, which class is used to read binary data from an input stream?

1 Mark(s)

Your Answer:

`PrintStream` `PrintStream`
`BufferedReader` `BufferedReader`
`DataInputStream` `DataInputStream`
`FileInputStream` `FileInputStream`

For updates, the trigger can specify attributes whose update causes the trigger to:

1 Mark(s)

Your Answer:

Initiated Initiated
Evaluate Evaluate
Execute Execute
Prioritize Prioritize

Which of the following is an example of parallel sorting technique?

1 Mark(s)

Your Answer:

bogo sort bogo sort
sleep sort sleep sort
cube sort cube sort
merge sort merge sort

Which of the following selector selects the elements that are the default among a set of similar elements?

1 Mark(s)

Your Answer:

:default :default
:% :%
:disabled :disabled
none of the mentioned none of the mentioned

What will be the output of the following Java code? import java.util.*; public class genericstack <E> { Stack <E> stk = new Stack <E>(); public void push(E obj) { stk.push(obj); } public E pop() { E obj = stk.pop(); return obj; } } class Output { public static void main(String args[]) { genericstack <Integer> gs = new genericstack<Integer>(); gs.push(36); System.out.println(gs.pop()); } }

1 Mark(s)

Your Answer:

0 0
36 36
Runtime Error Runtime Error
Compilation Error Compilation Error

What is the purpose of using constants in Ruby programming?

1 Mark(s)

Your Answer:

To store values that can be modified during the execution of the program
To declare variables that are accessible only within a specific scope
To store values that are sensitive and should not be accessed by other parts of the program
To define values that remain constant throughout the execution of the program

What is the primary use of the Depth-First Search (DFS) algorithm in graph theory?

1 Mark(s)

Your Answer:

To explore all reachable vertices from a given source node.
To find the shortest path in a weighted graph.
To detect cycles in a graph. To detect cycles in a graph.
To perform level-order traversal. To perform level-order traversal.

What will be the output of the following C code? #include <stdio.h> struct p { struct p *next; int x; }; int main() { struct p* p1 = malloc(sizeof(struct p)); p1->x = 1; p1->next = malloc(sizeof(struct p)); printf("%d\n", p1->next->x); return 0; }

1 Mark(s)

Your Answer:

Compile time error Compile time error
1 1
Somegarbage value Somegarbage value
0 0

What will be the output of the following Python code? def foo(): try: return 1 finally: return 2 k = foo() print(k)

1 Mark(s)

Your Answer:

error, there is more than one return statement in a single try-finally block
3 3
2 2
1 1

Which key should be pressed to start a new paragraph in MS-Word?

1 Mark(s)

Your Answer:

Down Cursor Key Down Cursor Key
Enter Key Enter Key
Shift + Enter Shift + Enter
Ctrl + Enter Ctrl + Enter

Incremental commitment does not allow a project to be easily redirected or to be terminated.

1 Mark(s)

Your Answer:

True True
False False

What gives the full path to CGI script?

1 Mark(s)

Your Answer:

script_filename script_filename
script_name script_name
server_name server_name
request_method request_method

The NOT NULL constraint excludes the null value from the:

1 Mark(s)

Your Answer:

Domain Domain
Attribute Attribute
Definition Definition
Declaration Declaration

The prepared statements specify that the actual values will be provided:

1 Mark(s)

Your Answer:

Later Later
Compile time Compile time
At output window At output window
By the processor By the processor

Which of the following specifies header text of popover?

1 Mark(s)

Your Answer:

title title
trigger trigger
selector selector
placement placement

What is the purpose of the ThreadPool class in C#?

1 Mark(s)

Your Answer:

To manage and recycle a pool of worker threads
To allocate memory for storing thread-related data
To provide synchronization mechanisms for multithreaded programs
To execute tasks sequentially To execute tasks sequentially

which of these keys are used in ms excel to copy formulas from the above cell?

1 Mark(s)

Your Answer:

ctrl + ctrl +
ctrl +; ctrl +;
ctrl +: ctrl +:
ctrl +' ctrl +'

Storage locations which are available when a memory device has 12 address lines are:

1 Mark(s)

Your Answer:

144 144
512 512
2048 2048
4096 4096

Computer bus with 64 lines can carry:

1 Mark(s)

Your Answer:

32bits 32bits
64bits 64bits
16bits 16bits
8bits 8bits

Which of the following uses a lot of CPU cycles?

1 Mark(s)

Your Answer:

GUI GUI
Statically generated graphics Statically generated graphics
Dynamically generated graphics Dynamically generated graphics
All of the mentioned All of the mentioned

Free of-cost repair of software bugs available on the Internet is called --------?

1 Mark(s)

Your Answer:

Path Path
Tutorial Tutorial
Ad-on Ad-on
None None

What is a dangling pointer?

1 Mark(s)

Your Answer:

Points to freed memory Points to freed memory
Points to null Points to null
Points to void Points to void
Points to global Points to global

The evidence of fibre structure is based on:

1 Mark(s)

Your Answer:

chemistry of fibre chemistry of fibre
optical properties optical properties
physical properties physical properties
all of above all of above

Which is not a Mozilla value?

1 Mark(s)

Your Answer:

caret caret
resizer resizer
listbox listbox
scrollbar scrollbar

What will be the output of the following Python code? def f(x): for i in range(5): yield i g=f(8) print(list(g))

1 Mark(s)

Your Answer:

[0, 1, 2, 3, 4] [0, 1, 2, 3, 4]
[1, 2, 3, 4, 5, 6, 7, 8] [1, 2, 3, 4, 5, 6, 7, 8]
[1, 2, 3, 4, 5] [1, 2, 3, 4, 5]
[0, 1, 2, 3, 4, 5, 6, 7] [0, 1, 2, 3, 4, 5, 6, 7]

What is the output of the following code static void Main(string[] args) { int myInteger; string myString; myInteger = 17; myString = "\"myInteger\" is"; Console.WriteLine("{0} {1}.", myString, myInteger); Console.ReadKey();} :

1 Mark(s)

Your Answer:

My integer is 17 My integer is 17
"myInteger" is 17. "myInteger" is 17.
Errors due to wring memory allocation Errors due to wring memory allocation
0,1 "myInteger"is 17. 0,1 "myInteger"is 17.

Which of the following selectors selects direct descendents?

1 Mark(s)

Your Answer:

E > F E > F
E F E F
E + F E + F
E ~ F E ~ F

Which of the following can be renamed?

1 Mark(s)

Your Answer:

Worksheet Worksheet
Workbook Workbook
Both A and B Both A and B
None of these None of these

How do you restore the heap property after extracting the maximum element from a max-heap?

1 Mark(s)

Your Answer:

By performing a heapify operation. By performing a heapify operation.
By reordering the entire heap. By reordering the entire heap.
By inserting a new maximum element. By inserting a new maximum element.
By balancing the tree manually. By balancing the tree manually.

What is the purpose of the File.Create() method in C#?

1 Mark(s)

Your Answer:

Renames a file Renames a file
Deletes a file Deletes a file
Opens an existing file for reading Opens an existing file for reading
Creates a new file or overwrites an existing file

Window 9 main features are ________?

1 Mark(s)

Your Answer:

Windows 9 Has a New Look Windows 9 Has a New Look
Windows 9 Snap Layouts Windows 9 Snap Layouts
Multiple Desktops in Windows 9 Multiple Desktops in Windows 9
Window 9 Not launched Window 9 Not launched

In Hive, what is the significance of the WHERE clause in a SELECT statement?

1 Mark(s)

Your Answer:

Sort records based on a column Sort records based on a column
Group records based on a column Group records based on a column
Join records from multiple tables Join records from multiple tables
Filter records based on a condition Filter records based on a condition

Operating system is also known as:

1 Mark(s)

Your Answer:

database database
system software system software
hardware hardware
printer printer

The type 'float' can be safely converted to:

1 Mark(s)

Your Answer:

double double
long long
decimal decimal
ufloat ufloat

Which of the following is the default data type in MS Access?

1 Mark(s)

Your Answer:

Text Text
Number Number
Currency Currency
AutoNumber AutoNumber

Dark field electron microscopy is used to show presence of crystalline regions appearing:

1 Mark(s)

Your Answer:

dark against light background dark against light background
light against dark background light against dark background
dark dark
light light

Study the following program: i = 0 while i < 3: print(i) i += 1 else: print(0) What will be the output of this statement? ``` i = 0 while i < 3: print(i) i += 1 else: print(0) ```

1 Mark(s)

Your Answer:

0 1 0 1
0 1 2 0 1 2
0 1 2 0 0 1 2 0
0 1 2 3 0 1 2 3

What is the best data type definition for Oracle when a field is alphanumeric and has a fixed length?

1 Mark(s)

Your Answer:

VARCHAR2 VARCHAR2
CHAR CHAR
LONG LONG
NUMBER NUMBER

Which of the following is harmful for computer?

1 Mark(s)

Your Answer:

anti-virus anti-virus
virus virus
freeware freeware
shareware shareware

Layer of computer OSI model which provides services that directly supports user application is:

1 Mark(s)

Your Answer:

application application
presentation presentation
transport transport
physical physical

What is the space complexity of the following dynamic programming algorithm used to find the maximum sub-array sum? #include<stdio.h> int max_num(int a,int b) { if(a> b) return a; return b; } int maximum_subarray_sum(int *arr, int len) { int sum[len], idx; sum[0] = arr[0]; for(idx = 1; idx < len; idx++) sum[idx] = max_num(sum[idx - 1] + arr[idx], arr[idx]); int mx = sum[0]; for(idx = 0; idx < len; idx++) if(sum[idx] > mx) mx =sum[idx]; return mx; } int main() { int arr[] = {-2, -5, 6, -2, 3, -1, 0,-5, 6}, len = 9; int ans = maximum_subarray_sum(arr, len); printf("%d",ans); return 0; }

1 Mark(s)

Your Answer:

O(n) O(n)
O(1) O(1)
O(n!) O(n!)
O(n2) O(n2)

What is the primary purpose of the 'static' storage class?

1 Mark(s)

Your Answer:

Extend scope Extend scope
Preserve value Preserve value
Allocate memory Allocate memory
Register access Register access

Which one of the following array elements represents a binary min heap?

1 Mark(s)

Your Answer:

12 10 8 25 14 17 12 10 8 25 14 17
8 10 12 25 14 17 8 10 12 25 14 17
25 17 14 12 10 8 25 17 14 12 10 8
14 17 25 10 12 8 14 17 25 10 12 8

Evaluating Your Answers

Database Systems Mock Test 9 : Question 1 of 71