Pages

Wednesday, 6 March 2013

cpism demo paper :part 1


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