WorksheetsTechnical for MCA
Total questions: 70
Worksheet time: 52mins
Which tag is used for php
<?php
?>
<style>
<php ?>
<php
/php>
What are the two types of array in php
Indexed, sequence
Associative, sequence
Indexed, associative
None
$a=array("Timmy","Jimmy");
Is an example of
Indexed array
Associative array
Sequence array
None
$a=array(10=>"Jimmy",20=>"mummy");
Is an example of
Sequence array
Indexed array
Associative array
None
In php the keyword to be used before function name is
Function
Static
function
FUNCTION
function add()
{
$a=10;
echo $a;}
This is an example for
Call by value
Call by reference
None
Both
function add(&a)
{
$a=10;
echo $a;}
$a=33;
This is an example for
Call by value
Call by reference
Both of the above
None
<?php
function add()
{
global $a=10;
echo $a;
}
add();
$a+=10;
?>
Output is
10
15
20
30
$a="deepan";
$b="Deepan";
if(strcmp($a,$b))
{
echo "equal";
}
else{
echo " not equal";}
Output is
Equal
Not equal
Error
None
$a="IT is favorite department";
$b=sub_string($a,"bes",7,14);
echo $b;
Output is
IT is best department
IT is bes department
Error
IT is favorite department
The reason for software bugs and failures is due to
Software companies
Software Developers
Both Software companies and Developers
Software
Which one of the following models is not suitable for accommodating any change?
Build & Fix Model
Prototyping Model
RAD Model
Waterfall Model
Identify the disadvantage of Spiral Model.
Doesn’t work well for smaller projects
High amount of risk analysis
Strong approval and documentation control
Additional Functionality can be added at a later date
Software costs more to maintain than it does to develop
True
False
The user system requirements are the parts of which document ?
SDD
SRS
DDD
SRD
Which metric gives the idea about the contents on a web page ?
Word Token
Word Count
Word Size
Word Length
COCOMO stands for
Constructive cost model
Comprehensive cost model
Constructive cost estimation model
Complete cost estimation model
Project management involves the planning, monitoring, and control of the people, process, and events that occur as software evolves from a preliminary concept to an operational implementation.
True
False
Which of the following is an activity that distributes estimated effort across the planned project duration by allocating the effort to specific software engineering tasks?
Software Macroscopic schedule
Software Project scheduling
Software Detailed schedule
None of the mentioned
Every task that is scheduled should be assigned to a specific team member is termed as
Compartmentalization
Defining milestones
Defining responsibilities
Defining outcomes
Which of the following process is concerned with analyzing the costs and benefits of proposed changes?
Change management
Version management
System building
Release management
The modification of the software to match changes in the ever changing environment, falls under which category of software maintenance?
Corrective
Adaptive
Perfective
Preventive
Which granularity level of testing checks the behavior of module cooperation?
Unit Testing
Integration Testing
Acceptance Testing
Regression Testing
A set of inputs, execution preconditions and expected outcomes is known as a
Test plan
Test case
Test document
Test Suite
The testing in which code is checked
Black box testing
White box testing
Red box testing
Green box testing
What is the meaning of the term 'cyber'?
hacking
computer related
antivirus
viruses
What is the term used to describe a cybercrime where an attacker sends emails that appear to be from a ______ source?
trusted
virus
known
phishing
A computer virus is a program that can copy or______ its code in the system
modify
erase
decode
change
What is Ransomware
A Disease you get from playing to much Fortnite
A type of malware that wants Money
An Anti Virus Software
Software that protects you from Phishing
What is an example of a cyber crime?
Accessing unauthorised data/ using someone's computer without permission
Tricking people into downloading malware
Accessing the DarkWeb
Creating an account on something you're not old enough for
What is encryption used for?
Passing text through a mathematical algorithm to scramble the text
Changing the letters by a set number (Caesar Cipher)
Converting text to ASCII code
Converting text to hexadecimal
What is a computer program that replicates itself in order to spread to other computers, often using a computer network and relying on security failures on the target computer to access it?
Malicious Code
Computer Worm
Anti Virus Software
Computer Virus
When should you use AntiVirus software?
When you first purchase a new computer.
All the time, only on your laptop - and ensure it is regularly updated!
All the time, on ALL digital devices - and ensure they are regularly updated!
When you start experiencing symptoms of a computer virus.
What does "DDoS" stand for in cybersecurity?
Distributed Detection of System Outages
Digital Defense of Server Operations
Distributed Denial of Service
Data Deletion over Secure Sockets
Which cybersecurity practice involves disguising data to make it unreadable without the appropriate decryption key?
Hacking
Phishing
Encryption
Intrusion detection
Which of the following is NOT considered a strong password?
"Password123"
"D0g$L0v3r!"
"Tr3ndy$ecureP@ss"
"Pr0t3ctMyD@t@"
What is adware?
Malicious software designed to steal personal data
Software that displays unwanted advertisements
Software that protects your computer from viruses
A type of firewall
Which type of malware encrypts a victim's files and demands a ransom for decryption?
Spyware
Worm
Ransomware
Trojan Horse
Which of these is an indicator that the website is secure?
http:\\
http://
https://
https:\\
JavaScript was originally developed under the name _______.
ActionScript
Mocha
Sencha
Oak
JavaScript is ______ Side Scripting Language.
Server
Browser
ISP
None of These
Inside which HTML element do we put the JavaScript?
<scripting>
<script>
<js>
<javascript>
JavaScript is designed for following purpose –
To Style HTML Pages
To Perform Server Side Scripting Operation
To add interactivity to HTML Pages
To Execute Query Related to DB on Server
JavaScript is invented by ________.
What does SQL stand for?
Structured Query Language
Strong Question Language
Structured Question Language
Strong Query Language
Which SQL statement is used to extract data from a database?
OPEN
SELECT
EXTRACT
GET
Which SQL statement is used to delete data from a database?
DELETE
COLLAPSE
DROP
REMOVE
Which SQL statement is used to update data in a database?
MODIFY
SAVE AS
SAVE
UPDATE
With SQL, how do you select a column named "FirstName" from a table named "Persons"?
SELECT FirstName FROM Persons
SELECT Persons.FirstName
SELECT Persons Where FirstName
SELECT Persons From FirstName
Which SQL statement is used to insert new data in a database?
ADD RECORD
INSERT INTO
ADD NEW
INSERT NEW
With SQL, how do you select all the columns from a table named "Persons"?
SELECT [all] FROM Persons
SELECT Persons
SELECT * FROM Persons
SELECT Persons From Persons
With SQL, how do you select all the records from a table named "Persons" where the value of the column "FirstName" is "Peter"?
SELECT * FROM Persons WHERE FirstName<>'Peter'
SELECT * FROM Persons WHERE FirstName LIKE 'Peter'
SELECT * FROM Persons WHERE FirstName='Peter'
SELECT [all] FROM Persons WHERE FirstName='Peter'
The OR operator displays a record if ANY conditions listed are true. The AND operator displays a record if ALL of the conditions listed are true
True
False
Both A and B
None of these
With SQL, how do you select all the records from a table named "Persons" where the "FirstName" is "Peter" and the "LastName" is "Jackson"?
SELECT * FROM Persons WHERE FirstName='Peter' AND LastName='Jackson'
SELECT * FROM Persons WHERE FirstName<>'Peter' AND LastName<>'Jackson'
SELECT FirstName='Peter', LastName='Jackson' FROM Persons
SELECT*FROM Persons WHERE FirstName='Peter' OR LastName='Jackson'
With SQL, how do you select all the records from a table named "Persons" where the "LastName" is alphabetically between (and including) "Hansen" and "Pettersen"?
SELECT LastName>'Hansen' AND LastName<'Pettersen' FROM Persons
SELECT * FROM Persons WHERE LastName>'Hansen' AND LastName<'Pettersen'
SELECT [all] FROM Persons WHERE LastName>'Hansen' AND LastName<'Pettersen'
SELECT * FROM Persons WHERE LastName BETWEEN 'Hansen' AND 'Pettersen'
With SQL, how can you insert a new record into the "Persons" table?
INSERT ('Jimmy', 'Jackson') INTO Persons
INSERT VALUES ('Jimmy', 'Jackson') INTO Persons
INSERT INTO Persons VALUES ('Jimmy', 'Jackson')
INSERT INTO Persons VALUES
With SQL, how can you insert "Olsen" as the "LastName" in the "Persons" table?
INSERT INTO Persons (LastName) VALUES ('Olsen')
INSERT ('Olsen') INTO Persons (LastName)
INSERT INTO Persons ('Olsen') INTO LastName
INSERT IN Persons ('Olsen') TO LastName
Which operator is used to select values within a range?
WITHIN
RANGE
ORDER BY
BETWEEN
Which SQL statement is used to create a database table called 'Customers'?
CREATE TABLE Customers
CREATE DATABASE TABLE Customers
CREATE DATABASE TAB Customers
CREATE DB Customers
which of the following is not a valid SQL commands?
Data Definition Language
Data Manipulation Language
Data Control Language
Data Verification Language
Which is not a DDL Command?
CREATE
ALTER
DROP
UPDATE
Which is not a DML Command?
SELECT
INSERT
ALTER
DELETE
Which of the following is not a valid SQL type?
DECIMAL
NUMERIC
FLOAT
CHARACTER
Which of the following are DCL commands?
COMMIT and ROLLBACK
UPDATE and TRUNCATE
GRANT and REVOKE
SELECT and UPDATE
