General Air Traffic Control MCQs

1. How many 7s come between 150 and 200?

2. Which statement regarding images in Microsoft Excel 2010 are true?

3. What should be done with an irate customer after they have vented out and explained their situation?

4. You are editing a shape using the Drawing Tools. Which among the following Shape Fill options in the Shape Styles group gives you control over the transparency for a shape?

5. When square of a number is increased by 3, then the resulting value becomes equal to four times the original number. Find the number(s).

6. The default chart colors are determined by what?

7. Find the value of the following expression: (15*15)+(25*25)

8. Which one would be the best thing to say to an irate customer?

9. A fixed-wing aircraft has an unaccelerated stall speed of 60 knots. What would its stall speed be under a load factor of 4G?

10. How do you repair a Microsoft Outlook 2010 .pst file if it gets damaged?

11. Which one is not a category of transition?

12. What information do you gather from the image shown above?

13. In Microsoft Word 2010, 'Keep lines together' paragraph formatting:

14. Complete the following sentence using the best option from the options listed below. Humility keeps you grounded and ensures that

15. The VOR (VHF omnidirectional range) radio navigation system operates in the frequency range of ______.

16. _______________ is the range of air band on which the VHF aviation communication system works.

17. The stalling speed VS1 indicates _______________.

18. What is the minimum age limit to obtain a student pilot certificate?

19. Which marshalling signal is shown in the image above?

20. If a commercial pilot certificate was issued to a person in the year 2012, then according to the FAA (Federal Aviation Administration) regulations, which of the following is true about the expiry date of the given commercial pilot certificate?

21. Which are the primary flight control surfaces of an airplane?

22. According to FAA (Federal Aviation Administration), unless otherwise authorised by the administrator, no person may operate an aircraft below 10,000 feet mean sea level at an indicated airspeed of more than ________ knots.

23. Which figure is indicating the 'Slow down' signal?

24. If an airplane having a gross weight of 2500 pounds is subjected to a 60 degree constant-altitude bank, then the total load on that airplane would be:

25. Which airborne end systems in an aircraft sends flight plan change requests, position reports, etc. and receives clearances and controller instructions?

26. Which is the reasons for the development of ACARS (Aircraft Communications Addressing and Reporting System)?

27. Which of the following is/are the applications of radar? 1.It is used in weather forecasting. 2.It warns of obstacles in or approaching their path and gives accurate altitude readings. 3.It is used to map the composition of Earth's crust. 4.It is used to monitor and regulate ship movements in busy waters.

28. Which level of junk e-mail protection available in Microsoft Outlook 2010 will you apply, if you want all such e-mails to be treated as junk whose senders are neither on your Safe Senders List nor on your Safe Recipients List?

29. Choose the most grammatically correct statement.

30. The temperature of the Pack Outlet Air is controlled by adjusting the flow through the _________.

31. According to the FAA (Federal Aviation Administration) Regulations, what should be the maximum authorized indicated airspeed of an aircraft when operating in a VFR corridor designated through class B airspace?

32. How important is consistency while offering customer service to different people?

33. It is not easy to crack an entrance exams of leading universities.

34. If 75% of 1/3 of a number is 25, then the number is:

35. Among five software companies, Mars pays higher wages to its employees than what Venus pays, but its wages are not as much as those paid by Jupiter. Uranus pays more than what Earth pays, but still not as much as what Venus pays to its employees. Who among them pays the least to its employees?

36. Which one is the new form of the word 'AUSTERIT', if each consonant in the word is substituted by the third letter that comes in the English alphabet after it and each vowel by the very first letter that comes after it?

37. Which ones are included in a digitally signed e-mail message?

38. Which one defines the correct purpose of using a poster frame image?

39. The minimum VFR (Visual Flight Rules) day and night flight visibility requirements at an altitude of 10,200 feet MSL (mean sea level) in Class G airspace are _______.

40. For which airspace class, there are no minimum visibility requirements?

41. Due to the _______ effect of the background music, the _______ of the play did not seem very long.

42. Choose the most grammatically correct statement.

43. Peter purchases a bicycle for Rs.25000 and sells it at a profit of 25%. What is the selling price of the bicycle?

44. At or above what speed does an airplane risk hydroplaning during a takeoff roll with tire pressure of 64 PSI?

45. Which one is INCORRECT regarding setting of passwords in Microsoft Outlook 2010?

46. The minimum approximate flight visibility for VFR flights operating at 8800 feet in Class B airspace with no clouds would be ______ statute miles.

47. Which area in the Microsoft Excel 2010 PivotTable Field List, calculates the aggregates of columns?

48. Which one is the standard specification fuel used by most of the countries in commercial airplane engines?

49. What does a customer with a problem expect from a customer service representative?

50. Spot the error in the following sentence. I do not think she is very fond in Italian food.

51. Which one is true about Radar Altimeter (RA)?

52. A fixed-wing aircraft is operating at 8000 feet MSL (mean sea level). What would the effect on the plane be if it is subjected to a 70 degree constant altitude bank?

53. The man in the image appears to be feeling unwell. What is the most likely reason behind this?

54. The maximum certified carrying capacity of Airbus A380 as of 2012 is _______ passengers.

55. John takes a loan from his friend on an amount of Rs.1400 at the rate of 6% p.a. What will be the simple interest for one year on this amount?

56. What is the importance of customer oriented goodwill?

57. What is the first step in mollifying a customer who has received bad service?

58. Which V speed represents the speed indicated by the red mark in the airspeed indicator shown above?

59. The international Cospas-Sarsat SAR (Search and Rescue) satellite system has ceased satellite processing of __________________ MHz frequency beacons on or after February 2009.

60. Find the difference between the local value and the face value of 5 in the numeral 6765734.

61. In a certain code language '$ @ & *' means 'Values Are Always Good'; '# & $' means 'Inculcate Good Values'. Which one could be the code for 'Always Inculcate Good Habits', if the sign % stands for Habits?

62. A is daughter of B. B is son of C. What is the relationship between A and C?

63. How many items can be maintained on the clipboard at one time?

64. What are the respective colors of the fuel mixture control and throttle control in a typical Cessna 152 engine aircraft?

65. Which V speeds indicates the stalling speed of an aircraft with flaps extended, landing gear down and spoiler retracted?

66. By default, when you paste a chart from Excel into PowerPoint 2007, is it linked or embedded?

67. According to the FAA (Federal Aviation Administration) regulations, each and every occupant (crew members and passengers) of the aircraft must be provided with supplemental oxygen continuously when operating at:

68. The unaccelerated stall speed of a fixed-wing aircraft is 80 knots. What would its approximate stall speed be under a load factor of 2G?

69. If audible clicks are noticed in the speaker or headphones of an airplane, which equipment is most likely responsible for this interference?

70. At or above what speed does an airplane risk hydroplaning at touchdown if the tire pressure is 49 PSI?

71. Choose the most grammatically correct statement.

72. How will you read comments that reviewers have added to your presentation?

73. The function of compressor in an air system is to:

74. The ones who excelled in the entrance test were the ones who were ready to _______ in order to achieve their goal.

75. Which one is NOT indicated by the airspeed indicator shown above?

76. Which one is the major component(s) of the ACARS (Aircraft Communications Addressing and Reporting System) datalink system? 1)Aircraft equipment 2)Service provider 3)Cabin terminal 4)Ground processing system

77. The airflow in all the modern jetliners is approximately ______ outside air and ______ filtered air.

78. Which one is considered part of an aircraft's environmental control system?

79. You want to add an image as the first character in your paragraph. Which type of text wrapping treats your graphic as if it were a character?

80. Which filters are used in jetliners that trap all the bacteria and clustered viruses?

81. Except for those below the age of twenty five, the drinks were _______ for everyone at the dinner.

82. I have been ______ for a chocolate ever since I ______ my new healthy diet.

83. User defined data type columns can be designated with ROWGUIDCOL.

84. Which value specifies that each instance of the XML data type in column_name can contain multiple top-level elements?

85. Analyze the following code snippet for creating a stored procedure in SQL Server 2008: CREATE PROCEDURE Person.GetEmployees @LastName nvarchar(50), @FirstName nvarchar(50) AS SET NOCOUNT ON SELECT FirstName, LastName, JobTitle, Department FROM Person.EmployeeDepartment WHERE FirstName = @FirstName AND LastName = @LastName GO Which of the following is a valid code to execute the GetEmployees stored procedure?

86. Which default password is used by sqlcmd if -P option is used at the end of the command prompt without a password?

87. Which clauses of SQL Server 2008 avoids enforcing a constraint when repeated inserts are performed?

88. Analyze the following code snippet: DECLARE @myDate DATETIME2 SELECT @myDate = '2009/10/08 12:35:29.2348 +12:15' SELECT @myDate AS '@myDate' What is the output of the above code?

89. Which counters are used to monitor compression of the whole instance of SQL Server?

90. What is the default maximum precision of decimal data type in SQL Server 2008?

91. Windows Security log can be specified as a target for Audit in SQL Server 2008.

92. Which statement is true if you create a global temporary table in SQL Server 2008 and specify a FOREIGN KEY with the CREATE TABLE command?

93. Which query is used to rename a database in SQL Server 2008?

94. Which features of SQL Server 2008 evaluates servers for compliance with a set of predefined conditions and prevents making undesirable changes to servers?

95. Which permissions are required to create a view in SQL Server 2008?

96. What happens to the audit records if a failure to write the Audit event does NOT trigger the SQL Server instance to shut down?

97. Analyze the following code which uses the TOP clause of SQL Server 2008: USE Person GO DECLARE @p AS int SELECT @p=10 SELECT TOP(@p) FROM Employee GO What Will be the output of the above code?

98. What is the return type of the value returned by @@DATEFIRST in SQL Server 2008?

99. Which one is used to comment a portion of an SQL Server 2008 script?

100. What is the maximum value for the sum of the values of MIN_CPU_PERCENT and MIN_MEMORY_PERCENT for all the resource pools of SQL Server?

101. Suppose you create a stored procedure and save it in the database with ''sp_'' prefix. Which statement is true regarding the execution of the stored procedure?

102. Analyze the following code snippet: DECLARE @myTime TIME(4) = '02:02:02.234567 +01:01' SELECT @myTime AS '@myTime' What is the output of the above code?

103. Which function/functions are performed by the following statement? DBCC CHECKIDENT ('table_name', RESEED, new_reseed_value)

104. Which formats are supported by the language_term argument while altering a full-text stoplist in SQL Server 2008?

105. Starting from the lowest, arrange the following operators in the order in which they produce results in an SQL WHERE query.

106. Which Audit object primarily describes the destination where the audit data of SQL Server 2008 gets stored?

107. How many audit action groups are available for a server in SQL Server 2008 to perform different actions on audit data?

108. Which data type can be specified as SPARSE?

109. How many groupings are generated when CUBE is used with the GROUP BY clause of SQL Server 2008?

110. Which command is used to connect to a named instance of SQL Server using the sqlcmd utility of SQL Server?

111. What is the data type of the parameter ''Audit_file_offset'' of function ''fn_get_audit_file()'' in SQL Server 2008?

112. Analyze the following data types and schemas: 1.The SQL Server system data type. 2.The default schema of the current user in the current database. 3.The dbo schema in the current database. In which order does the SQL Server Database Engine refer to type_name when a type_schema_name is NOT specified while creating a table in SQL Server 2008?

113. What is the default value of the SORT_IN_TEMPDB clause of the relational_index_option specified at the time of creation of an index on a table in SQL Server 2008?

114. Which one is a valid code to remove the key used to encrypt a database using Transparent Data Encryption algorithm?

115. Which options are available for the DATA_COMPRESSION clause specified for a table in SQL Server 2008?

116. Which option is used to change the value of the password variable and exit using sqlcmd?

117. Which compression features have been introduced in SQL Server 2008 that were NOT supported by SQL Server 2005?

118. What is the default timeout for login to sqlcmd while you try to connect to a server?

119. Analyze the following code used to update a Common Table Expression: USE demodb GO DECLARE @a TABLE (ID int, Value int); DECLARE @b TABLE (ID int, Value int); INSERT @a VALUES (1, 10), (2, 20); INSERT @b VALUES (1, 100),(2, 200); WITH cte AS (SELECT * FROM @a) UPDATE cte SET Value = b.Value FROM cte AS a INNER JOIN @b AS b ON b.ID = a.ID SELECT * FROM @a GO What Will be the output of the above code?

120. Which one is the correct precedence order of the data types in SQL Server 2008?

121. Which feature is used by SQL Server Audit to create and manage audits in SQL Server 2008?

122. Which one is a valid code to delete a clustered index with a PRIMARY KEY constraint in SQL Server 2008?

123. What range is supported by the TIME data type in SQL Server 2008?

124. Which stored procedure is used to delete data from the management data warehouse of a Data Collector?

125. What is the function of DBCC CHECKDB command in SQL Server 2008?

126. Which command is used to save the output to a text file after you run a Transact-SQL script using sqlcmd?

127. Which one is a valid code to change the index created on a column of a table to page compression?

128. Which namespace is used to manage the audit configuration programmatically in SQL Server 2008?

129. Multiple CHECK constraints can be applied to a single column and a single CHECK constraint can be applied to multiple columns in SQL Server 2008.

130. Which data types are supported by SQL Server 2008?

131. The output of a Transact SQL query using the GROUPING function of SQL Server 2008 is of __________ return type.

132. Which one is a valid syntax of the ALTER SERVER AUDIT statement used to enable a server audit?

133. Which spatial data types are used in SQL Server 2008?

134. Which statements are true about the FILESTREAM argument of SQL Server 2008?

135. An identifier denoting a global temporary object in SQL Server 2008 starts with a ______ sign.

136. PRIMARY KEY constraint defaults to __________ index.

137. Which one is used by SQL Server 2008 Management Studio to execute scripts in regular mode in the Query Editor?

138. Which command is used to run a Transact-SQL script file by using sqlcmd?

139. Which statements are true?

140. Which command is used to start the Resource Governor in SQL Server 2008?

141. All MDX, DMX and XML/A errors are displayed in the Error List window of the SQL Server 2008. Management Studio.

142. Which permissions is/are required to create an XML SCHEMA COLLECTION?