Font size
Worksheets12TH CA FULL
Total questions: 197
Worksheet time: 2hrs 39mins
What is multimedia?
a type of computer hardware
a type of computer software
a type of computer network
the use of multiple forms of media to communicate information
________ has five major components like text, images, sound, video and animation.
Multimedia
Master Page
Master item
Multi-word
What is a raster image?
a type of image made up of pixels
a type of image made up of geometric shapes
a type of image made up of text
a type of image made up of sound waves
What is a vector image?
a type of image made of pixels
a type of image made up of geometric shapes
a type of image made up of text
a type of image made up of sound waves
Which of the following is a raster image file format?
JPEG
EPS
CDR
SVG
Which of the following is a vector image file format?
PSD
JPEG
EPS
BMP
RTF (Rich Text Format) file format was introduced by __________
TCS
MICROSOFT
APPLE INC.
IBM
The expansion of JPEG is _____________
Joint Photographic Experts Group
Joint Photo Experts Group
Join Photon Experts Group
Joint Photographic expressGroup
AIFF file format was developed by _______
TCS
MICROSOFT
APPLE INC.
IBM
Which of the following is an audio file format?
MP3
AVI
MPEG
PNG
DTP stands for ______________
Desktop Publishing
Desktop Publication
Doctor To Patient
Desktop Printer
____________ is a DTP software.
Lotus 1-2-3
Maya
Flash
Pagemaker
Which menu contains the New option?
File Menu
Layout Menu
Edit Menu
Type Meny
In PageMaker Window, the area outside of the dark border is referred to as _________.
Page
Pasteboard
Blackboard
Dashboard
Shortcut to close a document in PageMaker is ______________
Ctrl + A
Ctrl + B
Ctrl + C
Ctrl + W
A __________ tool is used for magnifying the particular portion of the area.
Text Tool
Line Tool
Zoom Tool
Hand Tool
_________ tool is used for drawing boxes.
Line
Ellipse
Rectangle
Text
Place option is present in _____________ menu.
File
Edit
Layout
Window
To select an entire document using the keyboard, press ___________
Ctrl + A
Ctrl + B
Ctrl + C
Ctrl + D
Character formatting consists of which of the following text properties?
Bold
Italic
Underline
All of these
Which tool lets you edit text?
Text Tool
Type Tool
Crop Tool
Hand Tool
Shortcut to print a document in PageMaker is ___________
Ctrl + A
Ctrl + P
Ctrl + C
Ctrl + V
Which language is used to request information from a Database?
Relational
Query
Compiler
Structural
The ---------- diagram gives a logical structure of the database graphically?
Entity-Relationship
Entity
Architectural Representation
Database
An entity set that does not have enough attributes to form primary key is known as
Strong Entity Set
Weak Entity Set
Identity Set
Owner Set
---------- Command is used to delete a database.
Delete database database_name
Delete database_name
drop database database_name
drop database_name
MySQL belongs to which category of DBMS?
Object Oriented
Hierarchical
Relational
Network
MySQL is freely available and is open source.
True
False
---------- represents a “tuple” in a relational database?
Table
Row
Column
Object
Communication is established with MySQL using
SQL
Network calls
Java
API's
Which is the MySQL instance responsible for data processing?
MySQL Client
MySQL Server
SQL
Server Daemon Program
The structure representing the organizational view of entire database is known as -------- in MySQL database.
Schema
Table
View
Instance
The expansion of PHP is _________
PHP: Hypertext Preprocessor
Personal Hypertext Preprocessor
Pretext Home page
Preprocessor Home Page
What is the extension of PHP file?
.html
.xml
.php
.ph
The PHP script should start with _________
<?php
<php
<php?
<:?
How many data types does PHP support?
18
28
8
38
Every variable name in PHP must begin with a _________ symbol.
#
//
$
<
_________ in PHP are case – sensitive.
Variable names
Keywords
Variable names and Keywords
None of the above
The assignment operator is ___________
=
==
===
!=
_________ operators perform an action to compare two values.
Arithmetic
Logical
Comparison
Increment
Which operator is called “identical”?
=
==
===
<>
_________ is a data type which contains decimal numbers.
Integer
Float
Boolean
Null
A_________is a block of code that performs a specific task.
Parameter
Label
Function
Class
Pre-defined functions are also called _________.
User-defined functions
Recursive functions
Built-in functions
Lambda functions
Which one of the following is the right way of defining a function in PHP?
function functionname() { // code to be executed }
function() {}
def myFunction():
None of the above
A user-defined function in PHP starts with the keyword _________.
function
defined
def
funct
Which of the following is a correct way to call a function in PHP?
functionName();
call functionName;
execute functionName;
run functionName();
What is an array in PHP?
An array is a special data type.
It can hold many values under a single variable name.
An array element can be any type of data.
All of the above
How many types of arrays are there in PHP?
2
3
4
5
What is the index of the first element in an indexed array in PHP?
0
1
2
3
What is the index of the third element in an indexed array in PHP with 5 elements?
2
3
4
5
How do you create an indexed array in PHP?
By enclosing a comma-separated list of values in square brackets
By using the array() function
By enclosing a comma-separated list of values in curly braces
Both A and B
How do you access the elements of an indexed array in PHP?
By using the array index in square brackets
By using the array key in square brackets
By using the array index in curly braces
By using the array key in curly braces
Which of the following is NOT a type of conditional statement in PHP?
if
if ... else
if ... elseif ... else
while
What type of statement is the if...else statement?
Conditional statement
Looping
Input statement
Output statement
What is the simplest conditional statement in PHP?
if-else statement
if statement
switch statement
if-elseif-else statement
How does the if statement work in PHP?
A block of code is executed if a certain condition is true.
A block of code is executed if a certain condition is false.
A block of code is executed if multiple conditions are true.
A block of code is executed if multiple conditions are false.
What happens if the condition in an “if” statement is false?
The code inside the curly braces is executed.
The code inside the curly braces is skipped.
The program terminates.
None of the above
What is the syntax for an if-else statement in PHP?
if(condition) { //True-block; }
if(condition) { //True-block; } else { //False-block; }
if(condition) { //True-block; } else { //False-block; }
if-elseif(condition) { //True-block; } else { //False-block; }
Which of the following is used to specify multiple conditions in an if ... elseif ... else statement?
And
Or
case
elseif
Which of the following is used to specify multiple conditions in a switch statement?
And
Or
Case
If
What happens if none of the case values match the expression in a switch statement?
The default case block is executed
The program terminates
The nearest case block is executed
The first case block is executed
Which of the following is used to terminate the switch statement?
return
continue
break
goto
Which of the following is NOT a type of loop statement in PHP?
for
if.. else
while
do... while
What type of loop is “for loop” in PHP?
Entry-Check Loop
Exit-Check Loop
Counter Loop
Iteration Loop
What is the syntax for for loop in PHP?
for(initialization; condition; increment) { // code}
foreach(initialization; condition; decrement) { // code}
while(condition)
do{...}while(condition)
What are the three parts of the for loop syntax in PHP?
initialization, condition, increment
initialization, code block, condition
code block, condition, increment
condition, initialization, code block
When is the ‘initialization’ part of a for loop executed?
Before each iteration
After each iteration
Only once at the beginning of the loop
Only once at the end of the loop
What is the purpose of the ‘increment’ part of a for loop?
To initialize variables
To update variables
To check the condition
To execute the code block
What type of loop is “while loop” in PHP?
Entry-Check Loop
Exit-Check Loop
Counter Loop
Iteration Loop
What type of loop is “do...while loop” in PHP?
Entry-Check Loop
Exit-Check Loop
Counter Loop
Iteration Loop
Which looping structure should be used to iterate over elements of an array in PHP?
for loop
do... while loop
while loop
foreach loop
What is the output of the following code?
12345
54321
11111
None of the above
What are HTML forms used for?
To collect input from users
To create server-side programming language
To create a database
To send emails
Which of the following is NOT a form control available in HTML forms?
Text inputs
Buttons
Check Boxes
Cropping Tool
Which tag is used to create an HTML form?
form
input
textarea
select
What form control allows the user to select multiple values?
Text Inputs
Buttons
Checkboxes
Radio Buttons
What form control allows the user to select only one value at a time?
Text Inputs
Buttons
Radio Buttons
Checkboxes
What is the purpose of validation in PHP?
To check the input data submitted by the user from the client machine
To display data to users
To store data on the server
To send data to the client
How many types of validation are available in PHP?
One
Two
Three
Four
Which PHP function can be used to open a file?
fopen()
fread()
fwrite()
fclose()
What PHP function can be used to read a file?
fread()
fopen()
fwrite()
fclose()
What PHP function can be used to close a file?
fopen()
fread()
fclose()
fwrite()
Which is the correct function to execute the SQL queries in PHP ?
mysqli_query(“Connection Object”,”SQL Query”)
query(“Connection Object”,”SQL Query”)
mysql_query(“Connection Object”,”SQL Query”)
mysql_query(“SQL Query”)
Which is the correct function Closing Connection in PHP ?
mysqli_close(“Connection Object”);
close(“Connection Object”);
mysql_close(“Connection Object”);
mysqli_close(“Database Object”);
Which is the correct function to establish Connection in PHP ?
mysqli_connect(“Server Name “,”User Name”,”Password”,”DB Name”);
connect(“Server Name “,”User Name”,”Password”,”DB Name”);
mysql_connect(“Server Name “,”User Name”,”Password”,”DB Name”);
mysqli_connect (“Database Object”);
Which is the not a correct MySQL Function in PHP ?
Mysqli_connect() Function
Mysqli_close() Function
mysqli_select_data() Function
mysqli_affected_rows() Function
How many parameter are required for MYSQLi connect function in PHP ?
2
3
4
5
How many parameter are required for MYSQLi query function in PHP ?
2
3
4
5
How many parameter are required for MYSQLi Close function in PHP ?
1
2
3
5
Which version of PHP supports MySQLi fuctions ?
Version 2.0
Version 3.0
Version 4.0
Version 5.0
A set of computers connecting together is called as ----------
Network
Server
Hub
Node
Many discussions in an online forum leads to personal attacks and is called
Hackers
Virus
Online War
Flame War
Wi-Fi is short name for
Wireless Fidelity
Wired Fidelity
Wired Fiber Optic
Wireless Fiber Optic
Which among them was challenging to the business people on computer networking
Hacking
Virus
Both Hacking and Virus
None of The Above
Which one of the following is not the social media
Gmail
In mobile network, land areas for network coverage was distributed as
Firmware
Cells
Range
Service
Which one of the following are harmful to computer?
Bloggers
Browser
Hackers
Which of the following system securely share business’s information with suppliers,
vendors, partners and customers.
Extranet
Intranet
Apranet
Arcnet
Choose the order correctly
i,ii,iii,iv
ii,iii,iv,i
iii,iv,i,ii
iv,iii,ii,i
Communication over ------------------is be made up of voice, data, images and text messages.
Social Media
Mobile Network
Software
Wi-Fi stands for---------------------
Wireless Fidelity
Wired Fidelity
Wired Optic Fibre
Wireless Optic Fibre
A TCP/IP network with access restricted to members of an organization
LAN
WAN
MAN
Intranet
RFID stands for --------------
Radio Frequency Identification
Real Frequency Identity
Radio Frequency Indicators
Real Frequency Identification
It guarantees the sending of data is successful and which checks error on operation at OSI layer is--------------
Application Layer
Transport Layer
Network Layer
Physical Layer
Which one of the following will secure data on transmissions
HTTPS
HTTP
FTP
SMTP
----------- provides e-mail service
DNS
TCP
FTP
SMTP
------------- refer to other host computers by using names rather than numbers.
DNS
TCP
FTP
SMTP
Which of the following is used to maintain all the directories of domain names?
Domain Name System
Domain Name Space
Name Space
IP Address
Which of the following notation is used to denote IPv4 addresses?
Binary
Dotted-Decimal
Hexa-Deciamal
Binary and Dotted Decimal
How many bits are used in the IPv6 addresses?
32
64
128
16
Expansion of URL is ----------
Universal Resource Location
Uniform Resource Locator
Universal Resource Locator
Uniform Resource Location
How many types are available in URL?
2
3
4
5
Maximum characters used in the label of a node?
255
128
63
32
In the domain name, the sequence of labels is separated by
Semicolon (;)
Dot (.)
Colon (:)
NULL
Which of the following initiates the mapping of domain name to IP address?
Zone
Domain
Resolver
Name Servers
Which is the contiguous area up to which the server has access?
Zone
Domain
Resolver
Name Servers
Root Name servers are maintained by
IANA
ICANN
WHOIS
DNS
ARPANET stands for
American Research Project Agency Network
Advanced Research Project Agency Network
Advanced Research Project Area Network
American Research Programs And Network
WWW was invented by
Tim Berners Lee
Charles Babbage
Blaise Pascal
John Napier
Which cable is used in cable TV?
UTP Cable
Fiber Optics
Coaxial Cable
USB Cable
Expansion of UTP is
Uninterrupted Twisted Pair
Uninterrupted Twisted Protocol
Unshielded Twisted Pair
Universal Twisted Protocol
Which medium is used in the optical fiber cables to transmit data?
Microwave
Infrared
Light
Sound
Which of the following is a small peripheral device with a sim slot to connect the computers to Internet?
USB
Dongles
Memory Card
Mobiles
Which connector is used in the Ethernet cables?
RJ11
RJ21
RJ61
RJ45
Which of the following connector is called as champ connector?
RJ11
RJ21
RJ61
RJ45
How many pins are used in RJ45 cables?
8
6
50
25
Which wiring standard is used for connecting two computers directly?
Straight Through Wiring
Cross Over Wiring
Rollover Wiring
None
If the source code of a software is freely accessible by the public, then it is known as
Freeware
Firmware
Open Source
Public Source
Which of the following is a software program that replicates the functioning of a computer network?
Network Software
Network Simulation
Network Testing
Network Calculator
Which of the following can document every incident that happened in the simulation and are used for examination?
Net Exam
Network Hardware
Trace File
Net Document
Which is an example of network simulator?
Simulator
TCL
Ns2
C++
Choose the Correct Pair from the following to build NS2
UNIX & TCL
UNIX & C++
C++ & OTcl
C++ & Ns2
Which of the following is not a network simulation software?
Ns2
OPNET
SSFNet
C++
Which of the following is a open source network monitoring software?
C++
OPNET
Open NMS
OMNet++
Open NMS was released in …………………
1999
2000
2003
2004
A company involved in E-Business if
it has many branches across the world.
it conduct business electronically over the Internet.
it sells commodities to a foreign country.
it has many employees.
Which of the following is not a tangible good?
Mobile Phone
Mobile Apps
Medicine
Flower Bouquet
SME stands for
Small and medium sized enterprises
Simple and medium enterprises
Sound messaging enterprises
Short messaging enterprises
The dotcom phenomenon deals with ________
Textile Industries
Mobile Phone Companies
Internet Based Companies
All the above
Which of the following is not correctly matched
The First Wave of Electronic Commerce: 1985 -1990
The Second Wave of Electronic Commerce: 2004 – 2009
The Third Wave of Electronic Commerce: 2010 – Present
Dotcom burst: 2000 – 2002
Assertion (A): The websites of First wave dotcom companies were only in English Reason (R): The dotcom companies of First wave are mostly American companies.
Both (A) and (R) are correct and (R) is the correct explanation of (A)
Both (A) and (R) are correct, but (R) is not the correct explanation of (A)
(A) is true and (R) is false
(A) is false and (R) is true
Off-shoring means
Work outsourced to a branch of its own company
Work outsourced to new employees
Work outsourced to a third party locally
Work outsourced to a third party outside its own country
G2G systems are classified into
Internal facing and External facing
Internet and Extranet
First wave and Second wave
Left facing and Right facing
____ host the e-books on their websites.
Bulk-buying websites
Community websites
Digital publishing websites
Licensing websites
Which of the following is a characteristics of E-Commerce
Products can be inspected physically before purchase.
Goods are delivered instantly.
Resource focus supply side
Scope of business is global.
Based on the monetary value e payment system can be classified into
Micro and Macro
Micro and Nano
Maximum and Minimum
Maximum and Macro
______ refers to a payment made from one bank account to another bank account using
eletronic methods.
Electronic payment
Direct payment
Indirect payment
None of the above
Assertion (A): Macro electronic payment systems support higher value payments. Reason (R): Expensive cryptographic operations are included in macro payments
Both (A) and (R) are correct and (R) is the correct explanation of (A)
Both (A) and (R) are correct, but (R) is not the correct explanation of (A)
(A) is true and (R) is false
(A) is false and (R) is true
Which of the following is correctly matched
Credit Cards - pay before
Debit Cards - pay now
Stored Value Card - pay later
Smart card – pay anytime
ECS stands for
Electronic Clearing Services
Electronic Cloning Services
Electronic Clearing Station
Electronic Cloning Station
Which of the following is a online payment system for small payments.
Card based payment
Micro electronic payment
Macro electronic payment
Credit card payment
Which of the following is true about Virtual payment address (VPA)
Customers can use their e-mail id as VPA
VPA does not includes numbers
VPA is a unique ID
Multiple bank accounts cannot have single VPA
Pick the odd one in the credit card transaction
Card Holder
Merchant
Marketing Manager
Acquirer
Which of the following is true about debit card
i, ii, iii
ii, iii, iv
iii alone
iv alone
Match The Following
A1 --> B4
A2 --> B3
A3 --> B2
A4 --> B1
A1 --> B2
A2 --> B1
A3 --> B3
A4 --> B4
A1 --> B2
A2 --> B3
A3 --> B4
A4 --> B1
A1 --> B2
A2 --> B4
A3 --> B3
A4 --> B1
In E-Commerce, when a stolen credit card is used to make a purchase it is termed as
Friendly fraud
Clean fraud
Triangulation fraud
Cyber squatting
Which of the following is not a security element involved in E-Commerce?
Authenticity
Confidentiality
Fishing
Privacy
Asymmetric encryption use ___________ keys for encryption and decryption.
Same
Different
Positive
Negative
The security authentication technology includes i)Digital Signatures ii) Digital Currency iii) Digital Image iv) Digital Certificates
i & iv
ii & iii
i, ii, & iii
all the above
PGP stands for
Pretty Good Privacy
Pretty Good Person
Private Good Privacy
Private Good Person
_____ protocol is used for securing credit cards transactions via the Internet
Secure Electronic Transaction (SET)
Credit Card Verification
Symmetric Key Encryption
Public Key Encryption
Secure Electronic Transaction (SET) was developed in
1999
1996
1969
1997
The websites secured by Secure Socket Layer protocols can be identified using
html://
http://
htmls://
https://
______ is the process of converting plain text into meaningless cipher text
Encryption
Decryption
Digital certificate
Digital signature
Which of the following is true about Ransomware
Ransomware is not a subset of malware
Ransomware deletes the file instantly
Typo piracy is a form of ransomware
Hackers demand ransom from the victim
EDI stands for
Electronic Details Information
Electronic Data Information
Electronic Data Interchange
Electronic Details Interchange
Which of the following is an internationally recognized standard format for EDI?
TSLFACT
SETFACT
FTPFACT
EDIFACT
Which is the first industry-specific EDI standard?
TDCC
VISA
Master
ANSI
Which of the following is a type of EDI?
Direct EDI
Indirect EDI
Collective EDI
Unique EDI
Who is called as the father of EDI?
Charles Babbage
Ed Guilbert
Pascal
None of the above
Write the Expansion of MIDI
Musical Information Digital Interface
Musical Instrument Digital Interface
Musical Intelligent Digital Interface
Musical Information Digital Identifier
The least frame rate of at least ____ frames in Multimedia Animation looks Smooth
10
12
15
16
Which is not an Image Format?
AIFF
GIF
TIFF
JPEG
What is the Keyboard Shortcut to open a PageMaker file?
Ctrl+ Q
Ctrl+ M
Ctrl+ N
Ctrl+ X
Shortcut to fetch a Pointer Tool in Pagemaker
F2
F5
F7
F9
____ Command is used to show the ruler in PageMaker
View --> Ruler
Show --> Ruler
View --> ShowRulers
None
The horizontal entity in a Table is known as ___
Key
Record
Table
Column
Which of the follwing is not a DDL Command?
INSERT
CREATE
ALTER
DROP
--- uniquely identifies the row in Database Table.
Foreign Key
Super Key
Primary Key
Composite Key
SQL can be expanded as ___
Script Query Language
Special Query Language
Server Query Language
Structured Query Language
DBMS stands for ___
Database Model System
Database Management System
Database Management Software
Data Management System
Recent Stastistics of Server Side Scripting Language usage depict that 78.9% of websites are developed by scripting language ?
PHP
Microsoft ASP
CSS
JSP
How many types of functions are there in PHP?
5
4
3
2
What will be the output of the following PHP code?
<?php
$x
if ($x == 0 )
print "hi";
else
print "how are you";
?>
no output
how are you
hi
error
Most complicated looping structure in PHP is ...
for
while
do...while
none of these
........ checks the condition at the end .
for loop
do-while loop
for each
while loop
In PHP .... variables collect the data prepares the response accordingly.
Method
$_GET,$_POST
fread(),fwrite()
All the above
PHP is a .... programming language
User Side
Server Side
Object Side
File Side
___ is a request for data (or) information from a database table (or) combinatiion of tables.
Code
Query
Form
Report
Computer , which is connected to a network is called ___
device
node
system
cable
What is the expansion of TCP?
Television Control Protocol
Television Control Program
Transmission Control Program
Trasmission Control Protocol
There are ..... number of layers in OSI.
5
6
8
7
Which one of the following is a technology to locate objects using radio signals?
Wifi
URL
RFID
HTTP
Which is the Non-Profitable Organization?
.edu
.gov
.org
.com
The cables that are placed in deep underground to avoid any damage to the cabels is ---
Fiber Optics
Coaxial Cables
USB Cables
Twisted Pair Cables
Expansion of SET
Secure Enabled Transaction
Secure Electronic Transaction
Secure Exchange Transaction
Secure Electric Transaction
