Font size
WorksheetsAptech Finals
Total questions: 94
Worksheet time: 24hrs 30mins
(Inside Microsoft Office-A671)
Which option can be used to prioritize notes in
OneNote?
Sort the notes
Tagging the notes
Adding Links to the notebook
Filter the notes
(Inside Microsoft Office-A671)
Which option of PowerPoint should a user use in case the same picture needs to be on all slides?
Select all and CTRL + V
Insert picture in each slide
Handout Master
Slide Master
(Inside Microsoft Office-A671)
Identify which of them is a part of exciting transition in
PowerPoint.
Honeycomb
Split
Blinds
Random Bars
(Inside Microsoft Office•A671)
Which option allows user to change the theme of the slide?
Slide Master
Animation
Design
Slide Sorter
(inside Microsoft Office-A671)
Which the PivotTable form displays subtotals at the top of each
group?
Compact
Tabular
Collapse
Outline
(Inside Microsoft Office-A671)
Which method allows user to analyse results or outcomes in different scenarios with the same set Of data?
What-if analysis
Pivot Table
Conditional Formatting
Sort and Filter
(Inside Microsoft Office•A671)
Which shortcut can be used to make any changes to the formula in Excel?
Press F3
Press Esc
Press Alt+X
Press F2
(Inside Microsoft Office-A671)
Identify the three types of sheet views available in MS
Normal Layout View
Page Layout View
Zoom View
Page Break Preview
(Inside Microsoft Office-A671)
What does Data Label in a chart specify?
Names of the horizontal and axis
Details of each data series
Details Of each data series and enables to select the position Of values
States what each data series stands for and also enables to decide the position of values and data
(Inside Microsoft Office-A671)
How can user prevent any external and unauthorized access to the PC?
User Account Control
Windows Firewall
Windows Defender
External Anti-Virus
(Inside Microsoft Office-A671)
In case an administrator forgets to activate Cortana on user's system, which option should the user choose to get it activated?
Ask the administrator to switch it ON remotely
user should not accept the system if the Cortana is not
The user should check Windows Update and then reinstall Cortana
The user can click Settings icon on left pane of Cortana and enable it by switching the toggle to ON
(Inside Microsoft Office•A671)
What is the function Of File Explorer in Windows 10?
To access recent files
To navigate to other folders and documents stored in computer
To manage the file locations
To only access frequently used images
(Inside Microsoft Office-A671)
Which tools in PowerPoint should a user apply to align objects on slides while creating presentations?
Align
Grid
Guides
Gridlines
(Inside Microsoft Office-A671)
Select options that a user can use to protect data from tampering in Excel.
File Encryption
Restrict Access
Digital Signatures
Restrict Sharing
(Inside Microsoft Office-A671)
Identify the correct option that can be used to duplicate slides in PowerPoint.
Add new slide and select similar layout
Right-click and select duplicate slide
Left-click and select duplicate slide
Insert duplicate slide
(Inside Microsoft Office-A671)
Which feature of MS Word allows user to change the theme of the
document?
Layout
Design
Styles
Insert
(Inside Microsoft Office-A671)
Which tab should a user use in case he/she wants to accommodate the content in a page?
Documents Area
Scales
Layout
Zoom Controls
(Inside Microsoft Office-A671)
Which tab will be displayed when a specific object type is
selected?
Quick Access Toolbar
Core Tabs
Contextual Tabs
Dialog Box Launchers
(Programming with Python - A549)
The _______ is shortform for else if
eliif
eif
ellif
elif
(Programming with Python - A549)
The function provides more information about any built-in entity.
help()
hide()
play()
seek
(Programming with Python - A549)
_______ refers to looking inside and represents the act of thinking about inner thoughts or actions.
Intromission
introversion
Introspection
introduction
(Programming with Python - A549)
In Python, the interpreter raises an exception when its ______ occurs during execution.
corresponding error
following error
existing error
current error
(Programming with Python - A549)
Which of the following clause is optional in Python and is usually useful for releasing external resources?
full
finally
finish
follow
(Programming with Python - A549)
What is the process of restoring the stream to its original
hierarchy?
unpacking
unpicking
unseeing
unorganising
(Programming with Python - A549)
Until a requirement arises, it is always beneficial to use built-in data types. This is because the built-in objects
Make it simpler to code
Are components of extensions
Are more structured than regular structures
Are the language's standard part
(Programming with Python - A549)
The ____ function accepts two parameters namely, a lowest number and a highest number to generate a random number between the two.
Marker
Choice
Random
Randint
(Programming With Python - A549)
Which Of the following are the differences between Python 2 and Python 3?
a. Print
b. Division with integers
c. utility
d. Unicode Su ort
a, b, c, and d
b, c, and d
a, b, and d
a, c, and d
(Programming with Python - A549)
In Python 2, any specified without decimals is of type _____.
fraction
integer
variable
whole number
(Programming with Python - A549)
The standard implementation of Python is in portable ________ code.
ANCI
ANSI
ANPI
ANBI
(Programming with Python - A549)
Which of the following help to process the objects and are part of the statements?
Images
Characters
Expressions
Texts
(Programming with Python • A549)
A developer can use ______ interactively to create data types to understand Python objects
ILDE
ILED
IDEL
IDLE
(Programming with Python - A549)
______ in Python, is a piece of memory with data in of values and series of related operations.
GRAPH
CHART
TABLE
OBJECT
Programming with Python - A549
_______ is a smart Python Integrated Development Environment (IDE) for Mac OS, Linux, and Windows.
PySell
PyChart
PyCharm
PySim
(Programming with Python - A549)
Python is a robust and _______ programming language, which is not widely in use.
High Level
Low Level
Basic Level
Middle Level
(Programming with Python - A549)
The _____ statement is used to withdraw from a function and go back to the location from where the object called.
Loop
proceed
back
return
(Programming with Python - A549)
Which command helps in quitting the utility?
reject()
end()
stop()
quit()
Learning Java - A Foundational Joumey-A679
What Will be the output of the following lines of code?
try(FileReader FRdemo=new FileReader("E:\\test.txt");
BufferedReader Brdemo= new BufferedReader(Frdemo))
{
BRdemo.lines.forEach(System.out::println);
}
Characters
Streams
Integers
Float
Leaming Java - A Foundational Joumey-A679
Identify the statements that are correct about Collections.
a. Collections focus on holding data in memory
b. Collections are iterated explicitly
c. Collections operate on user demand basis
d. Collections are based on pipelining
A, B, C
B, C, D
A, B
C, D
Learning Java - A Foundational Journey-A679
Default method cannot override a method from which of the following
classes?
java.lang.class
java.util.collections
java.util.stream
java.lang.object
Learning Java - A Foundational Journey-A679
Math-Pl is a constant _______ that contains a value closest to Pl.
int
double
long
float
Learning Java - A Foundational Jouney-A679
In how many ways can the Math.abs() method be
overloaded?
1
2
3
4
Learning Java - A Foundational Journey-A679
What is recursion?
A method calling itself repeatedly
A method calling other methods repeatedly
A chain of methods repeatedly calling each other in cyclic way
Defining methods with a class
Learning Java - A Foundational Joumey-A679
Java supports concurrency through _______
Interfaces
java.extend function
CompleteableFuture Class
ScriptEngineManage class
Learning Java - A Foundational Journey-A679
Functional interface has _______ abstract methods and ______ default methods.
one, zero
zero, one
two, one
two, zero
Learning Java - A Foundational Joumey•A679
A stream containing _______ intermediate operators has no limitations-
5
10
15
N
Learning Java - A Foundational Journey A679
Which of the following classes contains the method splitAsStream(CharSequence) used to generate streams?
Stream
Pattern
Collection
BufferedReader
(Learning Java - A Foundational Joumey•A679)
What should be done to execute code with arguments in NetBeans IDE?
Type the arguments in the Arguments box of Run property
Type the arguments in the Builds box of Run property.
Specify the arguments in the Main Class box of Run property
Select Customize to type in the arguments
Learning Java - A Foundational Journey-A679
Which class breaks the input into tokens and translates individual tokens depending on their data type?
Format
Next
Scanner
Value
(SQL)
What is the function of TOP (expression) [PERCENTI TIES)?
Returns all records that have the same value as last records retuned by the TOP clause, based on the ORDER BY clause.
Specifies that the query should return a percent of rows from all rows processed rather than a specific number of rows
Analyses the statement to determine the most efficient way to extract the requested data.
None of the Above
Learning Java - A Foundational Journey-A679
Which of the following feature helps reduce the startup time and memory footprint between multiple JVMs?
Class Data Sharing
Java Archive File
JVM MetaData
JVM processes
Learning Java • A Foundational Journey-A679
In the ______ statement, conditions are evaluated sequentially starting from the top of the ladder and moving downwards.
If-else
if-else-if Ladder
Nested-If
switch-case
Learning Java - A Foundational Journey-A679
________ are also called decision-making statements.
Conditional Statements
Branching Statements
Iteration Statements
Jump Statements
Learning Java - A Foundational Joumey-A679
Logical operators (&& and 11) work on _______ Boolean expressions.
2
3
1
4
Learning Java - A Foundational Journey-A679
_______ is not a operator in Java.
Assignment Operator
Binary Operator
Conditional Operator
Bitwise Operator
Learning Java - A Foundational Joumey•A679
__________ is a location in the computer?s memory which stores the data that is used in a Java program.
Class
Variable
Subprogram
Object
Learning Java - A Foundational Journey-A679
In an OOP language, a class comprises fields and methods, collectively called as __________.
Objects
Attributes
Members
States
Learning Java - A Foundational Joumey-A679
_______ are referred to as procedures, functions, or modules in different structured programming languages.
Subprograms
Programming Paradigm
Structured Programs
Hierarchical Programs
(SQL)
Which of these is a correct syntax for BEGIN....END?
BEGIN { sql_statementlstatement_block } END
BEGIN { sql_statement ) END
BEGIN { ) END
BEGIN { statementlstatement_block } END
(SQL)
The wildcard character _________ displays any single character not within the range enclosed in the brackets of the expression.
--
%
[]
[^]
(SQL)
You can determine the number of summary rows in the result set by using _______ clause.
WHERE
SELECT
GROUP BY
SELECT with WHERE
(SQL)
_______ is an open source container orchestration platform that automates many of the manual processes involved in deploying, managing, and scaling containerized applications
Kubernetes
Spark
Hadoop Distributed File System
SQL Server
(SQL)
Vulnerability Assessment is a service built into Azure SQL Database.
Visibility
Error Identification
Scanning
Security
(SQL)
Identify the instances where run-time errors occur.
Performing a calculation such as division by 0
Trying to execute code that is not defined clearly
Performing a calculation such as multiplication with zero
Keyword is used in a wrong way
(SQL)
Why should a user use Columnstore Indexes?
To reduce storage cost
To speed up the process
For better performance
To simplify the data
(SQL)
______ is used to bind the view to a schema?
BINDING
SCHEMABINDING
VIEWSCHEMABINDING
VIEWSCHEMA
(SQL)
Which of the following are advantages of Stretch Database?
Migrate Historical Data to Azure
Economical solution for long-term storage data
combine non-relational data and relational data
Cost reduction in storage data
(SQL)
The architecture of calling one procedure from another procedure is referred to as ________ architecture.
Nested Procedure
Joined Procedure
Inner Procedure
Transaction
(SQL)
__________ Keyword is used to create a view using columns from multiple tables
INSERT
UNION
JOIN
UPDATE
(SQL)
Aggregate function ignore NULLS except when ________ is used
SELECT
ROLLUP
CUBE
COUNT(*)
(SQL)
What is the use of [] wildcard character
It will display a single character.
It will display a string of any length.
it will display a single character within the range enclosed within the bracket.
it will display a single character not within the range enclosed within the bracket.
(SQL)
Which of the following code snippets list all the product ids of both tables that match with each other using the UNION operator?
SELECT Productid FROM Product INTERSECT SELECT Productid FROM SalesOrderDetai1
SELECT Productid FROM Product EXCEPT SELECT Productid FROM SalesOrderDetail
SELECT Productid FROM Product UNION SELECT Productid FROM SalesOrderDetail
SELECT Productid FROM Product MERGE SELECT Productid FROM SalesOrderDetail
(SQL)
Using the CONVER() function, a value of one data type can be transformed to another. Which of the following syntax will help you to
achieve this?
CONVERT(datatype1. datatype2)
CONVERT(datatype[(length)], expression[,style])
CONVERT(datatype, expression)
CONVERT(expression1, expression2)
(SQL)
What is the function of the IDENTITY property?
Creates identifier columns to identify each row within a table
Creates identifier columns to identify each nullable rows within a table
Creates identifier columns to identify each row with default values within a table
Creates identifier columns to identify each row with a timestamp data type
(SQL)
Identify the instances where run-time errors occur.
Performing a calculation such as division by 0
Trying to execute code that is not defined clearly
Performing a calculation such as multiplication with zero
Keyword is used in a wrong way
(SQL)
What are the type of errors that occur when code cannot be parsed by SQL Server?
Syntax Error
Transact Error
Information Error
Run-Time Error
(SQL)
Identify the properties of logical unit of work.
Atomicity
Consistency
Efficiency
Durability
(SQL)
_______ marks an end of a successful implicit or explicit transaction-
BEGIN TRANSACTION
COMMIT TRANSACTION
FIRST TRANSACTION
LAST TRANSACTION
(SQL)
Which of these are deterministic built-in functions?
POWER
CAST
LOG
ISDATE
(Large Data Management (MongoDB) • 4621)
The first step to create a TTL index is:
Type db.createCoIlection
Type db.log_events-createlndex
Type db.runCommand
Type db.webserverlog. createlndex
(Large Data Management (MongoDB) - A621)
Why is it necessary to create an index when updating a capped collection?
So that a secondary can resync from the primary.
So that secondary can replicate and allocate space.
To avoid a table scan.
For primary to accept the update.
(Large Data Management (MongoDB) - A621)
Which of the following languages do applications use to communicate with MongoDB?
1. Erlang
2. C++ Haskell
3. Scala
4. Python
1, 3, and 4
2, 3, and 4
1, 2, 3, and 4
1, 2, and 3
(Large Data Management (MongoDB) - A621)
GridFS stores files in ________ and ________.
Files id, FS.chunks
n values, files
fs.chunks, FSfiles
n fields, n files
(Large Data Management (MongoDB) - A 621)
Which Of the following actions does GridFS NOT perform?
1. Does not allow access to any file without loading the entire file into the memory.
2. Splits a file into different parts or Chunks and stores each unit as a separate
document.
3. Stores files in two collections.
4. Does not allow ran e ueries on the files stored in GridFS.
2 and 3
1 and 2
1 and 4
3 and 4
(Large Data Management (MongoDB) • A621)
Correct the sequence of steps to insert a document in a collection:
1. Call the append method to set the values for all the fields that need to be populated.
2. Create an instance of the DBCollection object by calling the getCollection() method of the DB object.
3. Create BasicDBObject to represent the JSON document in the Java code.
4. Call the insert method of DBCollection after BasicDBObject is initialized
1, 2, 3, 4
2, 3, 1, 4
3, 4, 2, 1
4, 1, 2, 3
(Large Data Management (MongoDB) - A621)
What happens if an ordered bulk insert exceeds 1000 operations?
It is divided into smaller groups of 500 or less
The operation request is retuned
It is divided into smaller groups of 1000 or less.
The operation stops completely.
(Large Data Management (MongoDB) - A 621)
A batch insert is performed as a single ________ request
Transmission Control Protocol
File Processing
Internet Protocol
Database
(Large Data Management (MongoDB) - A 621)
A single batch insert in MongoDB is limited to ______.
5MB
10MB
8MB
16MB
(Large Data Management (MongoDB) • A621)
A replica in MongoDB version 3.0 can have maximum _____ members with only _____ members capable Of
10, 5
25, 15
50, 7
100, 50
(Large Data Management (MongoDB) - A621)
What is the immediate effect if the primary node of a replica set stops communicating with other members for more than 10 seconds?
Selection happens through an election process
The secondary node that gets majority of votes the primary
It reconnects on its own after 10 seconds
Another member is as the new primary.
(Large Data Management (MongoDB) • A621)
Which of the following options about the Arbiter is TRUE?
Maintains a data set.
Requires a dedicated hardware
Remains unchanged when primary members convert to secondary
Does not participate in an election to select the primary node
(Large Data Management (MongoDB) - A621)
Which of the following strategies should be used to route read operations to specific computers?
Distribute Members Geographically
Use Replica Set Tag Sets
Add Capacity Ahead of Demand
Use Journaling
(Large Data Management (MongoDB) - A621)
Which of the following BEST defines the collection name where the operation is performed?
Timestamp
Namespace
Op Key
O Key
(Large Data Management (MongoDB) • A621)
Match the Read Preference Modes with Description
A1- b5, a2 – b4, a3-b2, a4-b1, a5-b3
A1- b4, a2 – b3, a3-b2, a4-b1, a5-b5
A1- b5, a2 – b4, a3-b3, a4-b1, a5-b1
A1- b1, a2 – b2, a3-b3, a4-b4, a5-b5
(Large Data Management (MongoDB) • A621)
The correct sequence Of Steps that a replica set follows is:
l. The primary node receives the write operations from clients.
2. The secondaries replicate the oplog of the primary and apply all the operations to their data sets.
3. The primary mongod receives all write operations and the secondary mongod replicates the
operations from the primary.
4. The primary logs any changes or updates to its data sets in its oplog.
5. When the primary becomes unavailable, the replica set nominates a secondary as the primary.
4, 2, 1, 5, 3
3, 1, 4, 2, 5
2, 4, 1, 3, 5
5, 3, 2, 1,4
