Thursday, March 6, 2014

TCS ASPIRE WEB TECHNOLOGY QUIZ AND ANSWER 2013

  1. Question 1 of 10 10.0 Points
  2. Which of the following sequences of HTML tags is correct?
  3. A. <html><head><title></<title><body></body></head></html>
  4. B. <html><title></<title><head></head><body></body></html>
  5. C. <html><head></head><body><title></<title></body></html>
  6. D. <html><head><title></<title></head><body></body></html>
  7. Answer Key: D
  8. Feedback: <html><head><title></<title></head><body></body></html>

  9. Question 2 of 10 10.0 Points
  10. What does CSS stand for?
  11. A. Cascading Style Sheets
  12. B. Common Style Sheets
  13. C. Central Style Sheets
  14. D. Control Style Sheets
  15. Answer Key: A

  16. Question 3 of 10 10.0 Points
  17. How would you define id selector?
  18. A. None of the above
  19. B. id selector as #
  20. C. id selector as @
  21. D. id selector as $
  22. Answer Key: B

  23. Question 4 of 10 10.0 Points
  24. In an HTML document, which is the correct place to refer to an external style sheet?
  25. A. In the <head> section
  26. B. At the end of the document
  27. C. At the beginning of the document
  28. D. In the <body> section
  29. Answer Key: A

  30. Question 5 of 10 10.0 Points
  31. Which of the following tags would you use to insert JavaScript in an HTML page?
  32. A. <script type=”text/javascript”></script>
  33. B. <HTMLScript type=”text/javascript”></HTMLScript>
  34. C. <JScript type=”text/javascript”></JScript>
  35. D. <JavaScript type=”text/javascript”></JavaScript>
  36. Answer Key: A

  37. Question 6 of 10 10.0 Points
  38. The ——– JavaScript is also known as server-side JavaScript.
  39. A. Navigator
  40. B. Microsoft
  41. C. LiveWire
  42. D. Native
  43. Answer Key: C

  44. Question 7 of 10 10.0 Points
  45. The following code would allow you to set background with CSS:
  46. <style type=”text/css”>
  47. body {background-color: yellow}
  48. </style>
  49. True
  50. False
  51. Answer Key: True

  52. Question 8 of 10 10.0 Points
  53. If para1 is the DOM object for a paragraph, what is the correct syntax to change the text within the paragraph?
  54. A. para1.firstChild.nodeValue= “New Text”;
  55. B. para1.nodeValue=”New Text”;
  56. C. “New Text”?
  57. D. para1.value=”New Text”;
  58. Answer Key: D

  59. Question 9 of 10 10.0 Points
  60. How does JavaScript store date in a date object?
  61. A. None of the above
  62. B. The number of seconds since Netscape’s public stock offering.
  63. C. The number of milliseconds since January 1st, 1970
  64. D. The number of days since January 1st, 1900
  65. Answer Key: C

  66. Question 10 of 10 10.0 Points
  67. How would you define First-line pseudo-element in CSS?
  68. A. None of the above
  69. B. selector:pseudo-elements {property: values}
  70. C. select:pseudo-element {property: value}
  71. D. selector:pseudo-element {property: value}
  72. Answer Key: D




  73. Question 1 of 10 10.0 Points
  74. What does CSS define in HTML?
  75. A. How to display HTML elements
  76. B. How to send HTML elements
  77. C. How to made HTML elements
  78. D. How to save HTML elements Reset Selection

  79. Question 2 of 10 10.0 Points
  80. Which of the following HTML tags is used to define an internal style sheet?
  81. A. <script>
  82. B. <style>
  83. C. <css> Reset Selection

  84. Question 3 of 10 10.0 Points
  85. What does CSS stand for?
  86. A. Common Style Sheets
  87. B. Central Style Sheets
  88. C. Cascading Style Sheets
  89. D. Control Style Sheets
  90. Question 4 of 10 10.0 Points
  91. Which of the following event fires when the form element loses the focus: <button>, <input>, <label>, <select>, <textarea>?
  92. A. onblur
  93. B. ondblclick
  94. C. onclick
  95. D. onfocus Reset Selection

  96. Question 5 of 10 10.0 Points
  97. Which of the following popup boxes would you use when you want a value from the user before opening a page?
  98. A. alert(“Write some text here”)
  99. B. prompt(“Write here some text”,”Write default value here”)
  100. C. confirm(“Write some text here”) Reset Selection

  101. Question 6 of 10 10.0 Points
  102. Among the following optionsl, which is the correct syntax as per w3c standard?
  103. a.<br><p>Welcome to tcs</br></p>
  104. b.<p>Welcome to tcs</p>
  105. c.<br><p>Welcome to tcs</p></br>
  106. d.<b><p>Welcome to tcs</p></b>
  107. e.<b><p>Welcome to tcs</b></p>
  108. A. a,e
  109. B. c,e
  110. C. b,d
  111. D. a,c
  112. If para1 is the DOM object for a paragraph, what is the correct syntax to change the text within the paragraph?
  113. A. para1.firstChild.nodeValue= “New Text”;
  114. B. para1.nodeValue=”New Text”;
  115. C. para1.value=”New Text”;
  116. D. “New Text”? Reset Selection

  117. Question 8 of 10 10.0 Points
  118. Among the following options, select the command that you can use to link a page with an HTML page?
  119. A. <a attach=\”page.htm\” ></a>
  120. B. <a connect=\”page.htm\” ></a>
  121. C. <a href=\”page.htm\”?phpMyAdmin=70ac9566533a2665b6597346aab7f985&phpMyAdmin=f43d4e0b88acea2d2a393515f6bf38f2 ></a>
  122. D. <a link=\”page.htm\” ></a>

  123. Question 10 of 10 10.0 Points
  124. Why would you use variables in JavaScript programs?
  125. A. For Varying randomly
  126. B. For storing numbers, dates, or other values
  127. C. For causing high-school algebra flashbacks
  128. D. None

  129. Question 9 of 10 10.0 Points
  130. Which of the following tags would you use to insert JavaScript in an HTML page?
  131. A. <script type=”text/javascript”></script>
  132. B. <HTMLScript type=”text/javascript”></HTMLScript>
  133. C. <JavaScript type=”text/javascript”></JavaScript>
  134. D. <JScript type=”text/javascript”></JScript>
  135. Q: You used CSS class into your html, but divided your page without break line. Which of following would you have to use?
  136. A. <div> </div>
  137. B. None
  138. C. <p>
  139. D. <span></span>
  140. In an HTML document, which is the correct place to refer to an external style sheet?
  141. A. In the <body> section
  142. B. In the <head> section
  143. C. At the end of the document
  144. D. At the beginning of the document
  145. default value here”)
Posted by at No comments:

TCS ASPIRE : DATABASE ASSIGNMENT

Question 1: Provide the create table syntax to Create a Table Employee whose details are as below.
Employee(EmployeeID, LastName, FirstName, Address, DateHired)
Create Table Employee (EMP_NO NUMBER (4) NOT NULL, LAST_NAME VARCHAR (25), FIRST_NAME VARCHAR (25), ADDRESS VARCHAR (50), DATE_HIRED DATE);

Question 2: Provide the INSERT query to be used in Employee Table to fill the Details.
INSERT INTO Employee (EMP_NO, LAST_NAME, FIRST_NAME, ADDRESS, DATE_HIRED) VALUES (311,’sayed’, ‘makdoom’,’ 311, radha aprts, kurla depot, mumbai’, SYSDATE);

Question 3: When we give SELECT * FROM EMPLOYEE .How does it Respond?
The command retrieves all the records from all the columns of the Employee table, i.e., it retrieves the entire data inserted into the table Employee.  

Question 4: Create a Table CLIENT whose details are as below.
Client(ClientID, LastName, FirstName, Balance, EmployeeID)
Create Table Client (CLIENT_NO NUMBER (3) NOT NULL, LAST_NAME VARCHAR (40), FIRST_NAME VARCHAR (40), BALANCE NUMBER (10), EMPLOYEE_ID NUMBER (5));

Question 5: Provide the INSERT query to be used in CLIENT Table to fill the Details.
INSERT INTO Client (CLIENT_NO, LAST_NAME, FIRST_NAME, BALANCE, EMPLOYEE_ID) VALUES (311,’sayed’, ‘makdoom’, 502, 31150);

Question 6: When we give SELECT * FROM CLIENT .How does it Respond?
The command retrieves all the records from all the columns of the Client table, i.e., it retrieves the entire data inserted into the table Client.

Question 7: Choose the correct answer. The SQL command to create a table is:
a. Make Table
b. Alter Table
c. Define Table
d. Create Table
 sol :Create table.

Question 8: Choose the correct answer. The DROP TABLE statement:
a. deletes the table structure only
b. deletes the table structure along with the table data
c. works whether or not referential integrity constraints would be violated
d. is not an SQL statement
sol: Deletes the table structure along with the table data




Question 9: What are the different data types available in SQL server?
The different data types available in SQL server are: 
 Exact Numeric
 Approximate Numeric
Date and Time
Character Strings
 Unicode Character Strings
Binary Character Strings

Question 10: Which is the subset of SQL commands used to manipulate Oracle Database structures, includingtables?
The Data Definition Language (DDL) commands are used to manipulate the Oracle Database structures, including tables. These include:
Create
 Alter
 Drop
  Rename
 Truncate
 Comment

Question 11: What operator performs pattern matching?
“LIKE" is the operator used in pattern matching.
 
Question 12: What operator tests column for the absence of data?
The IS NULL operator tests column for the absence of data.

 Question 13: Which command executes the contents of a specified file?
  The command “START <filename> or @<filename>” executes the contents of a specified file
 
Question 14: What is the parameter substitution symbol used with INSERT INTO command?
The & symbol is the parameter substitution symbol used with INSERT INTO command.

 Question 15: Which command displays the SQL command in the SQL buffer, and then executes it?
 The RUN command is used to display the SQL command in the SQL buffer and then execute it.

Question 16: What are the wildcards used for pattern matching?
The wildcards used for pattern matching are: 
    _ : for single character substitution  
   % : for multi-character substitution

 

Question 17: State whether true or false.
EXISTS, SOME, ANY are operators in SQL.
True. EXISTS, SOME, ANY are operators in SQL.

 Question 18: State whether true or false.
!=, <>, ^= all denote the same operation.
True. !=, <>, ^= all denote the same operation. They denote not equal to.

Question 19: What are the privileges that can be granted on a table by a user to others?
 The privileges that can be granted on a table by a user to others are: 
Insert
  Update
 Delete
  Select
  References
  Index
  Execute
  Alter
  All

Question 20: What command is used to get back the privileges offered by the GRANT command?
The REVOKE command is used to get back the privileges offered by the GRANT command.
 
Question 21: Which system tables contain information on privileges granted and privileges obtained?
 The tables USER_TAB_PRIVS_MADE, USER_TAB_PRIVS_RECD contain information on privileges granted and privileges obtained.

Question 22: Which system table contains information on constraints on all the tables created?
 The table USER_CONSTRAINTS contains all the constraints that have been set on all the tables for that particular session. When a new session is started, or a new user logs in the constraints mentioned in the USER_CONSTRAINTS may differ.

Question 23: What is the difference between TRUNCATE and DELETE commands?
 
 The DELETE command is used to remove rows from a table.
  A WHERE clause can be used to remove some rows only.
  If no WHERE condition is specified, all rows will be removed.
  After performing a DELETE operation you need to COMMIT the transaction to make the change permanent.
  If not committed, the change can be rolled back using the ROLLBACK statement, so the deleted data can be restored.

  This operation will cause all DELETE triggers on the table to fire.
 The TRUNCATE command removes all rows from a table.
  The operation cannot be rolled back, i.e., the operation is permanent.
  NO triggers will be fired.
  As such, TRUCATE is faster and doesn't use as much undo space as a DELETE.

Question 24: What command is used to create a table by copying the structure of another table?
 The command CREATE TABLE... AS SELECT is used to create a table by copying the structure of another table.

Top of Form
Bottom of Form
Posted by at No comments:
Subscribe to: Comments (Atom)