Air Traffic Control MCQ Questions Answers

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

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

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

4. Which statements are true?

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

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

7. PRIMARY KEY constraint defaults to __________ index.

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

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

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

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

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

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

14. 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.

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

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

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

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

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

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

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

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

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

24. 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?

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

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

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

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

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

30. 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?

31. 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?

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

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

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

35. Which data type can be specified as SPARSE?

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

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

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

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

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

41. 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?

42. 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?

43. 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?

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

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

46. 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?

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

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

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

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

51. 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?

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

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

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

55. 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?

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

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

58. 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?

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

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

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

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

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

64. 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?

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

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

67. 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

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

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

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

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

72. Choose the most grammatically correct statement.

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

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

75. 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?

76. 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:

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

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

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

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

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

82. 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?

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

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

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

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

87. What is the importance of customer oriented goodwill?

88. 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?

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

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

91. 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?

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

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

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

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

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

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

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

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

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