60 Dawg
1. A flowchart is a diagrammatic representation of an algorithm.
o True
o False
2. In the relational model terminology, a row is called a ___________, a column an ___________, and a table a ________________.
o attribute, relation, tuple
o tuple, attribute, relation
o attribute, tuple, relation
o row, column, tuple
3. Which of the following code snippets add as a filegroup to an existing database, called EMP_DB?
o ALTER DATABASE EMP_DB INSERT FILEGROUP FG_ReadOnly
o ALTER DATABASE EMP_DB DELETE FILEGROUP FG_ReadOnly
o ALTER DATABASE EMP_DB SELECT FILEGROUP FG_ReadOnly
o ALTER DATABASE EMP_DB ADD FILEGROUP FG_ReadOnly
4. Bitwise logical operators are __, __, __ and __.
o &, |, ~ and ^
o % , ^ , * and @
o !, ], & and *
o None of the above
5. ______________ in a table is a column that points to a primary key column in another table.
o Secondary key
o Foreign key
o Local key
o Repeated key
6. Which of the following browser supports accessibility for audio and video elements?
□ Firefox
□ IE9
□ Opera
□ Netscape Navigator
7. Which of the following authentication is required to connect to SQL Azure?
o System Administrator Authentication
o Windows Authentication
o SQL Server Authentication
o No Authentication
8. Which statement starts the error processing for a session and displays an error message?
o RAISERROR
o SETERROR
o STARTERROR
o EXECUTERROR
9. Fseek() function returns value _________ if it is successful.
o -1
o 1
o 0
o None of the above
10. Which of the following options will be correctly identified by the pattern /[^AB]PQ/?
o ARQ
o CPQ
o BPQ
o APQ
11. ____________ is a JavaScript library which is supported on multiple browsers. It simplifies the designing of client-side scripting on HTML pages.
o Html
o CSS3
o JavaScript
o JQuery
12. Which of the following property of SQL Server is used to create identifier columns that can contain auto-generated sequential values to uniquely identify each row within a table?
o DEFAULT
o IDENTITY
o SELECT
o INSERT
13. Which of the following code snippets renames a database Employee_DB with a new database name, Emp_DB?
o ALTER DATABASE Customer_DB MODIFY NAME = CUST_DB
o ALTER DATABASE Customer_DB REMANE = CUST_DB
o DROP DATABASE Customer_DB MODIFY NAME = CUST_DB
o RENAME DATABASE Customer_DB MODIFY NAME = CUST_DB
14. ___________ Styles are placed inside the <head> section of a particular Web page source code.
o Inline
o External
o Internal
o Indented
15. Which of the following link paths provides the complete URL of the linked document including the protocol to use?
o Root-Relative path
o Absolute path
o Xpath
o Document-Relative path
16. The ftell() function returns a small int value that gives the position of curp from the beginning of the file in the specified stream.
o True
o False
17. _________ are action that occurs on the web page.
□ Time
□ Set
□ Events
18. Identifying the category of pattern matching where characters or symbols allow matching characters that reappear frequently in a string.
o Repetition
o Back Reference
o Character Classes
o Position Matching
19. Identify the attribute of a span tag which is used in specifying a language code for the content in an element, in XHTML documents.
o Id
o Xml:lang
o Lang
o Class
20. A ___________ stream is sequence of bytes.
o Character
o Text
o Binary
o None of the above
21. The _________ property of CSS is used to specify the space between the element border and the element content.
o Padding
o Min-width
o Max-height
o Spacing
22. The _________ events occurs when user clicks inside a field.
o onClick
o onSelect
o onCheck
o onFocus
23. _______ are pre-built components used for creating common user interface elements.
o CSS Layouts
o Spry Effects
o Spry Framework for Ajax
o Spry Widgets
24. Which of the following mode works together with Live view to help identify HTML elements?
o Check Browser compatibility
o File Management
o Visual Aids
o CSS Inspect mode
25. The _________ tag enables to link to specific areas of a Web page.
o Form
o Named Anchor
o Variable
o Div
26. Which of the following options are values for the border-style property?
□ Groove
□ Dashed
□ Lined
□ Ridge
27. Which of the following options can be defined as an HTML page element that can be visualized and placed anywhere on the Web page while working in the Design view?
o CSS Layout outline
o CSS Layout Block
o Unified CSS Panel
o New Unified Panel
28. Which of the provides options for closing the active document, opening an existing document, and opening one of the recent documents
o Ribbon
o Document View
o Selection Bar
o Backstage View
29. Which of the following features allows the user to cut/copy/paste content within a document and across documents without any formatting?
o Format Painter
o Paste
o Paste Special
o Clipboard
30. Which of the following Document View displays the overall structure of the document by showing headings and sub-headings in levels?
o Outline
o Full Screen Reading
o Web Layout
o Backstage
31. Which of the following feature in Microsoft Word enables user to insert text with different graphic effects presentation of the content?
o ClipArt
o WordArt
o SmartArt
o Picture
32. Which of the following functions allow users to perform various mathematical and trigonometric calculations?
o DText
o Date & Time
o Math & Trig
o Lookup & Reference
33. Which of the following functions help users to retrieve data from the Analysis Service Cubes?
o Information
o Statistical
o Cube
o Engineering
34. Steps involved in solving a problem are: studying the problem in details, gathering the relevant information, processing the information and arriving the results.
o True
o False
35. Which of the following function repositions the curp by the specified number of bytes from the start, the current position or the end of the stream depending upon the position specified?
o rewind()
o fseek()
o ftell()
o None of the above
36. The remove() function erases the specified __________
o Directory
o File
o Contents of the file
o None of the above
37. What does URI stand for?
o Uniform Recourse Information
o Uniform Resource Identifier
o Uniform Reply identifier
o Uniform Recourse Informer
38. The fflush() function flushes out the buffer.
o True
o False
39. ____________ is a set of statements, which perform a specific task. It may or may not return a value.
o Procedure
o Function
o Sub procedure
o None of the above.
40. ________________ is a logical and concise list of steps to solve a problem.
o pseudo codes
o Algorithm
o Flow chat
o None of the above
41. The _______ __ data type is used to indicate the C compiler that no value is being returned.
o Int
o Char
o Float
o Void
42. Which of the following escape sequence is used in JavaScript to insert a horizontal tab in an HTML page?
o \r
o \t
o \n
o \f
43. The names of variables, functions, labels, and various other user-defined objects are called ________________.
o Constant
o Argument
o Type def
o Identifiers
44. The modulus operator _______ acts only on integers and results in remainder after integer division.
o /
o +
o %
o &
45. Which of the following link types can be created in Dreamweaver?
□ Internal links
□ External links
□ Links to Named Anchors
□ Links to Networks
46. The __________ function returns the level of the current procedure.
o @NEWSTINGLEVEL
o @@NEWSTLEVEL
o @@ERROR_LINE
o @LEVEL
47. Which triggers execute stored procedures when a session is established with a LOGON event?
o Log triggers
o Login triggers
o Logon triggers
o Logged triggers
48. A _____________ is an association or bond that exists between one or more entities.
o Property
o Attribute
o Entity
o Relationship
49. ________ is an aggregate operator that produces a super-aggregate row.
□ CUBE
□ ROLLUP
□ GROUPING SET
□ GROUPING_ID
50. Which of the following code snippets creates a table using the NULL NULL and NOT NULL keywords with column definations?
o CREATE TABLE BookDetails (BookIDint NULL; Name varchar(40) NULL)
o CREATE TABLE BookDetails (BookIDint NOT NULL, Name varchar(40) NULL)
o CREATE TABLE BookDetails (BookIDint, Name varchar (40) )
o CREATE bookDetails (BookIDint NOT NULL, Name varchar(40) NULL)
51. The ________________data model allows a child node to have more than one parent.
o Relational
o Hierarchical
o Flat File
o Network
52. ________________ is used to administer permissions on the databases and database objects.
o Sub-schema
o Data Manipulation Language (DML)
o Data Definition Language (DDL)
o Data Control Language (DCL)
53. Which of the following meta tags indicates that Web application runs in a full-screen mode?
o <Meta name=?HandheldFriendly? content=?true?/>
o <meta name=?Format-detection?content=?telephone=no?/>
o <meta name=”MobileOptimized” content=”width”/>
o <meta name=?Apple-mobile-app-capable? Content=?yes?/>
54. Which of the following are tabs appear in Chart Tools group on the Ribbon?
□ Layout
□ Design
□ Options
□ Format
55. The ____________ element used in HTML5 is not only limited to draw rectangles on the Web sites, but also allows the user to draw graphics using JavaScript.
o Rectangle
o Canvas
o Line
o Arc
56. Which of the following statements are true about the Date & Time functions?
1. It does not allow the user to perform various calculations.
2. They allow extracting weekdays, year, months, hours and seconds from the current date and time.
3. It allows you to perform various mathematical computations.
4. The user can work with and manage the text type of Data present in the worksheet.
o 1,2,4
o 1,3,4
o 1,2,3
o 2,3
57. ______________ operators treat the operands as bits rather than numerical value.
o Arithmetic
o Logical
o Bitwise
o None of the above
58. The feof() function is used to indicate end-of-file when the file is opened for binary operation.
o True
o False
59. Which of the following code snippets drop the Contact_number column from the table?
o ALTER TABLE Employee ADD COLUMN [Contact_name];
o MODIFY TABLE Employee DROP COLUMN [Contact_name];
o ALTER TABLE Employee DROP COLUMN [Contact_name];
o ALTER TABLE Employee DELETE COLUMN [Contact_name]
60. The process in which a server does the XSL transformation for an XML document is known as _________.
o Server-side XSL transformation
o Client-Side XSL transformation
o Client-server-side transformation
o Remote-side transformation
It's so helpful for me.
ReplyDeleteI need second semester paper
ReplyDelete