Q1)
To run ASP, an application server is needed that supports
Microsoft Active Server Page 2.0. Which of the following are the choices?
a.
Microsoft IIS
b.
Microsoft
PWS
c.
Sun Chilli!Soft ASP
d.
Solaris ASP
Q2) To open sit
map panel: press_________________commond form keyboard.
a.
Crl+Alt+F8
b.
Alt+F6
c.
Shift+Alt+F8
d.
Alt+F8
Q3) Which of the following
are true about ColdFusion?
a.
It
Is a tool, which help the programmers to
create a web application that access database.
b.
It
Is a set of extended HTML tags known as CFML-Cold Fusion Markup Language.
c.
To run ColdFusion pages, the PHP application
server is required.
d.
ColdFusion
technology allows web developers and designers to rapidly develop and easily
maintain information-rich, dynamic web pages. pending
Q4) Which of the
statement is true about alert box and confirmation box?
1.
Alert box displays only the OK
button.
2.
A confirm box displays the OK and
Cancel button.
3.
An
alert box displays the OK and Cancel button.
4.
A
confirm box displays only the OK button.
a.
3 and 4
b.
All are false
c.
Only 1
d.
1
and 2
Q5) Which of the following is the basic HTML a
type?
a.
Character
encodings
b.
Link type
c.
Currency
d.
Dates
and Times.
Q6) Site maps can be saved as either a
____________ or a PNG file.
a.
Bitmap (BMP)
b.
GIF
c.
JPEG
d.
TIFF
Q7) You wants to display a greeting message to the user
at the beginning when the page open which of the following codes will help you
to achieve this?
1. <script>
message(“Good Morning. Welcome to Aptech!”)
</script>
<body>
JavaScript Codes
</body>
2. <script>
</script>
<body> JavaScript Codes
alert(“Good Morning. Welcome to Aptech!”)
</body>
3.
<script>
alert
(“Good Morning. Welcome to Aptech!”)
</script>
<body>
JavaScript Codes
</body>
4. <script>
</script>
alert (“Good Morning. Welcome to Aptech!”)
<body> JavaScript Codes
alert(“Good Morning. Welcome to Aptech!”)
</body>
a.
1
b.
2
c.
3
d.
4
Q8) If you click
on the home link then it goes to the ____________ web page.
a.
Book gallery
b.
New
c.
Index
Q9) Which of the following is true regarding
comments in JavaScript Codes?
a.
Comments that make the cod easier
to understand.
b.
Comments are marked with the special
character, Which are //* and **/.
c.
Comments help to hide the code from browsers that
cannot interpret JavaScript.
d.
Comments are marked with special characters such
as ?/*? and ?*/?
Q10)
A______________ is a section of an HTML document that contains special elements
called as controls.
a.
Controls
b.
Form
c.
Frame
d.
Group
box
Q11) Which of the following are the advantages
of Style Sheets?
1.
Override
the browser
2.
Page
layout
3.
Style
Sheets can be re-used
4.
One
time effort
a.
1,2,3
b.
2,3,4
c.
1,3,4
d.
1,2,3,4
Q12) For the named
Anchor in the Prorperty inspector the linked file or location within the page
will be indicated with the number sign____________ followed by the name of the
anchor.
a.
#
b.
*
c.
@
d.
"
Q13)
Java Script supports____________ dimensional
Array.
a.
Single
b.
Multi
c.
Double
Q14)
In SQL Server 2008, the____________ menu provides an Object Explorer Details option
using which you can view several details about database and server objects.
a.
Tools
b.
File
c.
View
d.
Search
Q15)
What will be the output of the following
code?
SELECT
DATEPART(QUARTER, ’2010-06-01 12:10:30.1234567’);
a.
2
b.
4
c.
1
d.
3
Q16)If we want to
remove the link do the following select remove link and
press.__________________
a.
Alt +
Shift + L
b.
Ctrl +
Shift + L
c.
Ctrl +
L
d.
Alt +
L
Q17) Which of the following is not a new
addition in DATEPART() function?
a.
Microseconds
b.
TZoffset
c.
Nanosecond
d.
Millisecond
Q18)
Open the property inspector select___________ browsing
for internal file.
a.
Insert
---> Properties
b.
Open
---> Properties
c.
Format
---> Properties
d.
Window
---> Properties
Q19)
____________ is the attribute used for
defining a UDT?s size in SQL Server 2008.
a.
SqlUserDefinedTypeAttribute.MaxSize
b.
SqlUserDefinedTypeAttribute.Max
c.
SqlUserDefinedTypeAttribute.MaxByteSize
d.
SqlUserDefinedType.MaxByteSize
Q20)
Function strcmp(str1, str2) will return
less than zero,if str2>str1.
a.
True
b.
False
Q21)
If we want to remove the link do the following select
remove link and press.__________________
e.
Alt +
Shift + L
f.
Ctrl +
Shift + L
g.
Ctrl +
L
h.
Alt +
L
Q22)
_________are used in web pages to request information
from visitors who are visiting your websites
a.
Action Field
b.
Text field
c.
Elements
a. Forms
b.
Frames
c.
Images
Q23)
The strlen() function returns the length
of string -1.
a.
True
b.
False
Q17)
_________are used in web pages to request information
from visitors who are visiting your websites
d. Forms
e.
Frames
f.
Images
Q24)
A string is a sequence of characters surrounded
by double quotes.
c.
True
d.
False
Q25)
Arrays in C are implemented as series of
characters terminated by the NULL (\0).
a.
True
b.
False
Q26)
The ----------------------- Statement is more of an
internal property.
a.
That
b.
this
c.
object
Q27)
To use strcat() function, the ____________
header file must be included in the program.
a.
Stdio.h
b.
Iostream.h
c.
Conio.h
d.
String.h
Q28)
A___________ groups together a number of
data items, which need not be of the same data type.
a.
Block
b.
Structure
c.
Array
d.
None of the above.
Q29)
The____________ operator is used to
access the elements of a structure using a pointer to that structure.
a.
->
b.
*
c.
.
d.
None of the above
Q30)
The ------------------------ function is used to create a
new instance of an object.
a.
Math
b.
eval
c.
string
Q31)
In_____________ sort, values of the
elements is compared with value in the adjacent element. In this method, the
smaller elements bubble up and at the end, the array is sorted.
a.
Bubble
b.
Insertion
c.
Binary
d.
None
of the above.
Q32)
Which of the following can define a new
data type?
a.
Typedef
b.
Struct
c.
New
operator
d.
None
of the above.
Q33)
The___________ secondary XML indexes are
used to execute queries that retrieve one or more node values from the XML
column.
a.
PATH
b.
PROPERTY
c.
VALUE
d.
PRIMARY
Q34)
The ___________ statement with
the____________ keyword allows you to recognize an index.
a.
CREATE
INDEX,REORGANIZE
b.
ALTER
INDEX, ORGANIZE,
c.
ALTER
INDEX, REORGANIZE, pending
d.
UPDATE
INDEX, REORGANIZE
Q35)
A view created using columns from one or
more tables is referred as a___________.
a.
Standard
view
b.
Indexed
view
c.
Partitioned
view
d.
Compound
view.
Q36)
Which of the following code creates a
view, Salary_Details with the WITH
ENCRYPTION option?
a.
CREATE
VIEW Salary_Details WITH ENCRYPTION AS SELECT EmpID, FirstNAme, LastName,
Salary FROM Employee_Details.
b.
CREATE
VIEW Salary_Details AS SELECT EmpID, FirstNAme, LastName, Salary WITH ENCRYPTION
FROM Employee_Details.
c.
CREATE VIEW Salary_Details AS
SELECT EmpID, FirstNAme, LastName, Salary FROM Employee_Details WITH ENCRYPTION.
d.
CREATE
VIEW Salary_Details USING WITH ENCRYPTION AS SELECT EmpID, FirstNAme, LastName,
Salary FROM Employee_Details.
Q37)
Which of the following codes creates a
variable of XML data type?
1.
DECLARE @xmlvar xml
SELECT @xmlvar=’<Employee name=”joan”/>’
2.
DECLARE
@xmlvar xml
SELECT @xmlvar=<Employee
name=joan>
3.
DECLARE
@xmlvar xml
SELECT @xmlvar=’<Employee name=”joan”’
4.
DECLARE
@xmlvar xml
SELECT @xmlvar=<Employee
name=”joan”/>
a.
1
b.
2
c.
3
d.
4
Q38)
The cricket match details are stored in
the Teaminfo xml data type of Cricket team table. The international board of
Cricket wants to see the details of all the cricket such as country name and
their score during the ongoing World Cup. Which of the following code will
enable you to achieve this?
1.
SELECT query (‘/MatchDetails/Team’) AS information
FROM CricketTeam.
2.
SELECT Teaminfo query (/MatchDetails/Team) AS
information FROM CricketTeam.
3.
SELECT Teaminfo query (‘/MatchDetails/Team’)
AS information FROM CricketTeam.
4.
SELECT Teaminfo AS information FROM
CricketTeam.
a.
1
b.
2
c.
3
d.
4
Q39)
The --------------------object has properties and methods
that represents advance mathematical calculations.
a.
Math Pending
b.
Math
c.
form
Q40)
Which is a function of a constraint?
a.
It prevents certain type of inconsistent
data values from being entered.
b.
It
assigns a row(s) null able value/s.
c.
It
assigns a column(s) duplicate data values from being entered.
Q41)
Every table have only one primary key
constrain. You can add a primary key by using which of the following syntax?
1.
CREATE
TABLE <table_name>(Column_name datatype PRIMARY KEY {,column_list})
2.
CREATE TABLE
<table_name>(Column_name datatype PRIMARY KEY {column_list})
3.
CREATE
TABLE <table_name>(Column_name datatype PRIMARY KEY {column_list});
4.
CREATE
TABLE (table_name Column_name datatype
PRIMARY KEY {,column_list})
a.
1
b.
2
c.
3
d.
4
Q42)
_________ are action that occurs on the web page.
a.
events
b.
set
c.
time
Q43) Which of the following columns, DEFAULT definitions
cannot be created?
a.
A timestamp data type
b.
An IDENTITY and ROWGUIDCOL property
c.
An existing default definition
d.
A
table with nullable rows and columns.
Q44) What is the function of IDENTITY property?
a.
Creates identifier columns to
identify each row within a table.
b.
Creates
identifier columns to identify each nullable row within a table.
c.
Creates
identifier columns to identify each row with default value within a table.
d.
Creates
identifier columns to identify each row with a timestamp data type.
Q45) You can know whether a table has an
IDENTITY column by using the______________ function.
a.
OBJECTPROPERTY()
b.
COLUMNPROPERTY()
Q46)
The segment of code is called an/a __________
a.
event
handeler
b.
html
c.
objects
Q47)
Which of the following feature of Dreamweaver
8.0,a piece of code for HTML, JavaScript, CSS and so can be stored, and reused
as and when required?
a.
High
Powered Coding Feature
b.
Snippets Panel
c.
Dynamic
Web Pages
d.
Powerful
Templates.
Q48) Which of the following features of
Dreamweaver 8.0 supports digest authentication and SSL for secure file transfer
and offers improved connectivity with a wider array of servers?
a.
Improved
WebDAV
b.
Code collapse
c.
Improved site synchronize and check in/ check
out
d.
Visual XML Data Binding
Q49)
A_____________ is container for content
that can be placed anywhere in the document.
a.
Frame
b.
Framework
c.
Layers
d.
Web
page.
Q50)
Which of the following are the site
launch checklists?
1.
Preview
Pages in Browser
2.
Check
Target Browser
3.
Validate
Pages
4.
Check
for Accessibility
a.
1,2,3
b.
2,3,4
c.
1,2,4
d.
1,2,3,4
Q17)
A browesre display the content of an __________ document.
a.
html
b.
object
c.
title
Q51)
Which of the following methods can be
used to transfer files to the remote site?
1.
FTP
2.
Local/
Network
3.
SourceSafe
4.
webRDS
a.
1,2,3
b.
2,3,4
c.
1,2,4
d.
1,2,3,4
Second Paper
Q52)
What is the function of top(expression)[PERCENT][WITH
TIES]?
a.
Return all records that have the same values
as last records returned by the TOP clause, based on the ORDER BY clause.
b.
Specifies
that the query should return a percent of rows from all rows processed rather than a specific number of rows
c.
Analyzes the statement to determine the most
efficient ways to extract the requested data.
Q53)
The process of processing a set of
commands one at a time from a batch of commands is known as______________.
a.
Command
processing
b.
Batch processing
c.
Set
processing
d.
Singular
processing
Q54)
___________ loads the previous url from the history.
a.
forward
b.
back
c.
history
Q55)
Database applications determine catalog
and system information. By using the functionality of____________, the
Microsoft SQL Server can be administered in applications.
a.
System catalog views
b.
Administration utilities
c.
SQL Server management objects
d.
T- SQL scripts and stored procedures
No comments:
Post a Comment