SQL and Databases Mock Test 13

Which operator is used for exponentiation in Python?

1 Mark(s)

Your Answer:

^ ^
** **
^^ ^^
// //

Petroleum is a mixture of crude oil and natural gas, these two substance are formed:

1 Mark(s)

Your Answer:

none of them none of them
artificially artificially
naturally naturally
occasionally occasionally

X3y'''+xy'-5y=ex is a:

1 Mark(s)

Your Answer:

linear equation linear equation
non-linear equation non-linear equation
algebraic equation algebraic equation
logical equation logical equation

What will be the output of the following Python code? #generator def f(x): yield x+1 g=f(8) print(next(g))

1 Mark(s)

Your Answer:

8 8
9 9
7 7
Error Error

The central processing unit of the computer system is never idle as long as it executes:

1 Mark(s)

Your Answer:

1 job 1 job
2 jobs 2 jobs
3 jobs 3 jobs
4 jobs 4 jobs

Which of the following will run without errors?

1 Mark(s)

Your Answer:

round(45.8) round(45.8)
round(6352.898,2,5) round(6352.898,2,5)
round() round()
round(7463.123,2,1) round(7463.123,2,1)

The statement for correctly copying the contents of one string into another is:

1 Mark(s)

Your Answer:

String s1 = "String"; String s2; s2 = s1;
String s1 = "String" ; String s2; s2 = String.Concat(s1, s2);
String s1 = "String"; String s2; s2 = String.Copy(s1);
String s1 = "String"; String s2; s2 = s1.Replace();

To return the reminder after the number is divided by a divisor in Excel we use the function?

1 Mark(s)

Your Answer:

ROUND ( ) ROUND ( )
FACT ( ) FACT ( )
MOD ( ) MOD ( )
None of these None of these

What is the purpose of the difference() method for sets?

1 Mark(s)

Your Answer:

Returns a new set with elements from the first set that are not in the second set
Returns the union of two sets Returns the union of two sets
Returns the common elements of two sets Returns the common elements of two sets
Returns the symmetric difference of two sets

"Cu" is symbol of:

1 Mark(s)

Your Answer:

copper copper
cobalt cobalt
curium curium
carbon carbon

Consider the following code snippet let x=x+1; console.log(x);

1 Mark(s)

Your Answer:

0 0
Null Null
ReferenceError ReferenceError
NaN NaN

SQL includes comparison operator that specify that a value be less than or equal to some value and greater than or equal to some other value, known as:

1 Mark(s)

Your Answer:

IN IN
AS AS
Like Like
Between Between

Vertical Scaling means:

1 Mark(s)

Your Answer:

Upgrading machine Upgrading machine
Adding machines Adding machines
Load balancing Load balancing
Sharding Sharding

Energy associated with a set of electric charges arranged in a certain configuration is called:

1 Mark(s)

Your Answer:

Electric Potential Energy Electric Potential Energy
Magnetic Potential Energy Magnetic Potential Energy
Poynting Potential Energy Poynting Potential Energy
Dipole Potential Energy Dipole Potential Energy

Which of the following is not the sliding method in jQuery?

1 Mark(s)

Your Answer:

slideToggle() slideToggle()
slideDown() slideDown()
slideUp() slideUp()
slideIn() slideIn()

Which of the following best describes uploading information?

1 Mark(s)

Your Answer:

Sorting data on a disk drive Sorting data on a disk drive
Sending information to a host computer Sending information to a host computer
Receiving information from a host computer
Sorting data on a hard drive Sorting data on a hard drive

Which of the following is an unordered collection of elements that may contain duplicates?

1 Mark(s)

Your Answer:

Set Set
Bag Bag
List List
Dictionary Dictionary

What is the correct syntax for declaring a two-dimensional array in C++?

1 Mark(s)

Your Answer:

int arr[rowSize][colSize]; int arr[rowSize][colSize];
int arr = new int[rowSize][colSize]; int arr = new int[rowSize][colSize];
int[] arr[rowSize][colSize]; int[] arr[rowSize][colSize];
int* arr[rowSize][colSize]; int* arr[rowSize][colSize];

What is xyz in the following SQL statement? DELETE FROM xyz WHERE abc = 5;

1 Mark(s)

Your Answer:

column name column name
table name table name
row name row name
database name database name

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

1 Mark(s)

Your Answer:

1 1
0 0
10 10
∞ ∞

Which HTTP method should be used when retrieving data from the server without modifying it in ASP.NET Web API?

1 Mark(s)

Your Answer:

POST POST
PUT PUT
DELETE DELETE
GET GET

Which of the following is a NoSQL database?

1 Mark(s)

Your Answer:

MySQL MySQL
PostgreSQL PostgreSQL
MongoDB MongoDB
Oracle Oracle

Which topology has a single point of failure at the cable?

1 Mark(s)

Your Answer:

Bus Bus
Star Star
Mesh Mesh
Ring Ring

What will be the output of this program? int main() { int a=10, b=20; printf("a=%d b=%d",a,b); a=a+b; b=a-b; a=a-b; printf("a=%d b=%d",a,b); return 0; } ``` int main() { int a=10, b=20; printf("a=%d b=%d",a,b); a=a+b; b=a-b; a=a-b; printf("a=%d b=%d",a,b); return 0; } ```

1 Mark(s)

Your Answer:

a = 20, b = 20 a = 20, b = 20
a = 10, b = 20 a = 10, b = 20
a = 20, b = 10 a = 20, b = 10
a = 10, b = 10 a = 10, b = 10

A single try block must be followed by which of these?

1 Mark(s)

Your Answer:

finally finally
catch catch
Both finally & catch Both finally & catch
None of the mentioned None of the mentioned

The organs that build sense of balance are known as:

1 Mark(s)

Your Answer:

respiratory system respiratory system
auditory system auditory system
vestibular system vestibular system
digestive system digestive system

Choose all the lines which if inserted independently instead of "//insert code here" will allow the following code to compile: public class Test{ public static void main(String args[]){ add(); add(1); add(1, 2); } // insert code here }

1 Mark(s)

Your Answer:

void add(Integer... args){} void add(Integer... args){}
static void add(int... args, int y){} static void add(int... args, int y){}
static void add(int args...){} static void add(int args...){}
static void add(int[]... args){} static void add(int[]... args){}
static void add(int...args){} static void add(int...args){}

Which keyword is used to declare a member function of a class as constant in C++?

1 Mark(s)

Your Answer:

static static
final final
const const
virtual virtual

Tears are produced by:

1 Mark(s)

Your Answer:

tear glands tear glands
endocrine glands endocrine glands
sensory cell sensory cell
receptors receptors

Which loop in C# is more appropriate for iterating through an array?

1 Mark(s)

Your Answer:

for for
while while
do-while do-while
foreach foreach

Which escape sequence represents a new line?

1 Mark(s)

Your Answer:

\n \n
\t \t
\r \r
\a \a

Types of plotter are:

1 Mark(s)

Your Answer:

2 2
3 3
4 4
5 5

Which of the following tool enables you to add text to a slide without using the standard placeholders?

1 Mark(s)

Your Answer:

Text tool box Text tool box
Line tool Line tool
Drawing tool Drawing tool
Auto shapes tool Auto shapes tool

In which of the following scheme all the signal levels are on one side of the time axis?

1 Mark(s)

Your Answer:

unipolar unipolar
bipolar bipolar
polar polar
multi level multi level

Time-zone information is also stored if with it is specified for:

1 Mark(s)

Your Answer:

with timezone with timezone
without timezone without timezone
with datezone with datezone
without datezone without datezone

Agile methodology emphasizes:

1 Mark(s)

Your Answer:

Customer feedback Customer feedback
Documentation Documentation
Rigid planning Rigid planning
Contract negotiation Contract negotiation

What will be the output of the following Python code? s='%s, %s & %s' s%('mumbai', 'kolkata', 'delhi')

1 Mark(s)

Your Answer:

mumbai kolkata & delhi mumbai kolkata & delhi
Error Error
No output No output
'mumbai, kolkata & delhi' 'mumbai, kolkata & delhi'

In a computer, standard which governs parallel communication is:

1 Mark(s)

Your Answer:

RS-232 RS-232
RS-232a RS-232a
CAT 5 CAT 5
IEEE 1284 IEEE 1284

What is the correct way to declare and initialize a constant in C#?

1 Mark(s)

Your Answer:

int const VALUE = 10; int const VALUE = 10;
const VALUE = 10; const VALUE = 10;
VALUE = const 10; VALUE = const 10;
const int VALUE = 10; const int VALUE = 10;

What is the purpose of a return statement in a function?

1 Mark(s)

Your Answer:

Returns the value and continues executing rest of the statements, if any
Returns the value and stops the program Returns the value and stops the program
Returns the value and stops executing the function
Stops executing the function and returns the value

What is the process called when a new class is created by inheriting properties and behaviors from an existing class in C++?

1 Mark(s)

Your Answer:

Composition Composition
Encapsulation Encapsulation
Inheritance Inheritance
Polymorphism Polymorphism

When using ODBC, which of the following processes ODBC requests and submits specific SQL statements to a given type of data source?

1 Mark(s)

Your Answer:

Data source Data source
Driver Driver
Driver manager Driver manager
DBMS DBMS

If a server has no clue about where to find the address for a hostname then___________________?

1 Mark(s)

Your Answer:

server asks to the root server server asks to the root server
server asks to its adjcent server server asks to its adjcent server
request is not processed request is not processed
none of these none of these

Which of the following methods is used to merge two hashes together in Ruby?

1 Mark(s)

Your Answer:

merge merge
join join
combine combine
concat concat

Why Red-black trees are preferred over hash tables though hash tables have constant time complexity?

1 Mark(s)

Your Answer:

no they are not preferred no they are not preferred
because of resizing issues of hash table and better ordering in redblack trees
because they can be implemented using trees
because they are balanced because they are balanced

The CSS padding property is used for?

1 Mark(s)

Your Answer:

Space Space
Border Border
Background color Background color
Margin Margin

The type that converts a type to a single Unicode character is:

1 Mark(s)

Your Answer:

ToSingle ToSingle
ToByte ToByte
ToChar ToChar
ToDateTime ToDateTime

What does LRU stand for in page replacement algorithms?

1 Mark(s)

Your Answer:

Less Recently used Less Recently used
Least Recurrently used Least Recurrently used
Least Randomly used Least Randomly used
Least Recently used Least Recently used

What will be the output of the following C code? double x=1.2 printf("%.1lf", ceil(x));

1 Mark(s)

Your Answer:

1 1
2 2
1.0 1.0
2.0 2.0

The operating system creates _____ from the physical computer

1 Mark(s)

Your Answer:

Virtual space Virtual space
Virtual computers Virtual computers
Virtual device Virtual device
None None

Torison constant depends on suspension wire's length and:

1 Mark(s)

Your Answer:

displacement displacement
velocity velocity
diameter diameter
speed speed

Output?inline int f(int a) { return a+1; }int main() { int x = f(5); cout << x; }

1 Mark(s)

Your Answer:

5 5
6 6
Compilation error Compilation error
Garbage Garbage

Which of the following defines additional details that the user can view or hide?

1 Mark(s)

Your Answer:

<details> <details>
<article> <article>
<aside> <aside>
<figure> <figure>

The find() function in STL algorithms returns:

1 Mark(s)

Your Answer:

Index of element Index of element
Iterator pointing to the element if found, else end iterator
Boolean value Boolean value
Element itself Element itself

In the fragmentation of Internet Protocol Version (IPv4), the 13-bit field that shows the relative position of the fragment for the whole datagram is called:

1 Mark(s)

Your Answer:

identification field identification field
flag field flag field
fragmentation offset field fragmentation offset field
none of the given none of the given

Which of the following is a global object for a new worker?

1 Mark(s)

Your Answer:

WorkerGlobalScope WorkerGlobalScope
Worker Worker
WorkerScope WorkerScope
Window Window

How do you pass arguments to a method in Ruby?

1 Mark(s)

Your Answer:

method_name(arg1, arg2) method_name(arg1, arg2)
method_name { arg1, arg2 } method_name { arg1, arg2 }
method_name.with(arg1, arg2) method_name.with(arg1, arg2)
method_name arg1 arg2 method_name arg1 arg2

Java programs are compiled into bytecode.

1 Mark(s)

Your Answer:

True True
False False

What will be the output of the following C# code? { delegate string f(string str); class sample { public static string fun(string a) { return a.Replace('k', 'o'); } } class Program { static void Main(string[] args) { f str1 = new f(sample.fun); string str = str1("Test Ykur C#.NET Skills"); Console.WriteLine(str); Console.ReadLine(); } } }

1 Mark(s)

Your Answer:

Test Ykur C#.NET Skills Test Ykur C#.NET Skills
Test Ykour C#.NET Skills Test Ykour C#.NET Skills
Test Your C#.NET Skills Test Your C#.NET Skills
Test ur C#.NET Skills Test ur C#.NET Skills

Which of the following tab is not present in the control panel program in the start menu?

1 Mark(s)

Your Answer:

Web Web
Index Index
Search Search
Contents Contents

Hashing can be used in online spelling checkers.

1 Mark(s)

Your Answer:

True True
False False

The sign is used for the placeholder . . . . . . . .

1 Mark(s)

Your Answer:

& &
* *
^ ^
? ?

Database systems can be thought as more or less like:

1 Mark(s)

Your Answer:

Information filing systems Information filing systems
Information transfer systems Information transfer systems
Information manipulation systems Information manipulation systems
Information retrieval systems Information retrieval systems

By which option Purchase or Sales register can be viewed

1 Mark(s)

Your Answer:

Statutory Books Statutory Books
Inventory Books Inventory Books
Accounts Books Accounts Books
Display Display

Natural base of logarithm is:

1 Mark(s)

Your Answer:

2.7182 2.7182
2.7999 2.7999
2.8718 2.8718
2.1213 2.1213

Server-Sent Events allows a web page to get updates from:

1 Mark(s)

Your Answer:

Windows Windows
Local Storage Local Storage
Server Server
None None

Coefficient of thermal expansion of ordinary glass is:

1 Mark(s)

Your Answer:

1.2x10-4/C° 1.2x10-4/C°
9x10-6/C° 9x10-6/C°
3.2x10-4/C° 3.2x10-4/C°
11x10-6/C° 11x10-6/C°

Which of the following is not an application of priority queue?

1 Mark(s)

Your Answer:

Huffman codes Huffman codes
Interrupt handling in operating system Interrupt handling in operating system
Undo operation in text editors Undo operation in text editors
Bayesian spam filter Bayesian spam filter

I/O modules performs the requested action on:

1 Mark(s)

Your Answer:

Programmed I/O Programmed I/O
Direct Memory Access (DMA) Direct Memory Access (DMA)
Interrupt driven I/O Interrupt driven I/O
I/O devices I/O devices

Output?int a=10; int b=20; cout << (a!=b);

1 Mark(s)

Your Answer:

0 0
1 1
10 10
20 20

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

1 Mark(s)

Your Answer:

True True
False False

Python uses ______ for block structure.

1 Mark(s)

Your Answer:

Indentation Indentation
Braces Braces
Keywords Keywords
Semicolons Semicolons

Alcoholysis's value in mercerized cotton is calculated to be:

1 Mark(s)

Your Answer:

30 30
15 15
10 10
25 25

________ , _________ and society need to use a variety of systems to organize the collection, storage, processing, retrieval and communication of information?

1 Mark(s)

Your Answer:

Management, society Management, society
Communicating, organizations Communicating, organizations
Individuals, organizations Individuals, organizations
None of these None of these

Graphical user interface of the operating system programs was introduced by:

1 Mark(s)

Your Answer:

Aqua Aqua
Xerox parc Xerox parc
UNIX UNIX
Linux Linux

The well-known port used for File Transfer Protocols (FTP's) control connection is:

1 Mark(s)

Your Answer:

port 6 port 6
port 8 port 8
port 20 port 20
port 21 port 21

Which of the following factors leads to a Successful PPC Advertisement?

1 Mark(s)

Your Answer:

Selecting Relevant Keywords Selecting Relevant Keywords
Improved Landing Page Quality Improved Landing Page Quality
Quality Score Quality Score
All of the above All of the above

In the old-time, a user was connected to the Internet with a:

1 Mark(s)

Your Answer:

ISP ISP
ADSL ADSL
DSL DSL
dial up line dial up line

Personal logs or journal entries posted on the web are known as

1 Mark(s)

Your Answer:

Smart logs Smart logs
Photo Photo
Blogs Blogs
None of these None of these

Evaluating Your Answers

SQL and Databases Mock Test 13 : Question 1 of 79