NEW
Font size
WorksheetsCLASS 12 COMPUTER APPLICATIONS CH-1 TO CH-6 STATEBOARD I - MID
Total questions: 63
Worksheet time: 32mins
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
PageMaker
Maya
Flash
Which menu contains the New option?
File menu
Edit menu
Layout menu
Type menu
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
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
View
Instance
Table
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?
<:?
________ is a data type which contains decimal numbers.
Integer
Float
Boolean
Null
A_________is a block of code that performs a specific task.
Parameter
Function
Class
Label
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
def
defined
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-else(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
goto
break
Which language is used to request information from a Database?
Relational
Structural
Query
Compiler
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
comparison
increment
logical
Which operator is called “identical”?
a) = b) == c) === correct d) <>
=
==
===
<>
