Practice by Category & Subject

Select a subject to start practicing

Business Finance & Management

Excel
1521
Financial Accounting
1463
Operations Management
871
Business Management
860

Industrial Engineering & Manufacturing

Thermodynamics
800
Engineering Mathematics
744
Machine Design
490
Strength of Materials
486

IT & Programming

PHP
926
Python
835
HTML
674
Wordpress
647

Design & Multimedia

Adobe Photoshop
1122
Microsoft PowerPoint
954
Adobe Illustrator
690
CorelDRAW
313

Content Writing & Translation

Microsoft Word
1064
English Language
851
Linguistics
425
Academic Writing
234

Administrative Support

Microsoft Outlook
481
Customer Service
287
Google Search
218
Computer Skills
217

View All Subjects

Features Pricing

Practice Features Pricing Sign In Sign Up

Home
Practice
Air Traffic Control
Aeronautics & Aerospace Technology

Quick Navigation

Back to Air Traffic Control All Subjects

Other Aeronautics & Aerospace Technology Subjects

Airline Flight Attendant Training

38 questions

Air Traffic Control

Answered

Correct

Accuracy

Question 1 Easy Mcq

✓ Correct ✗ Incorrect

Analyze the following code snippet for creating a stored procedure in SQL Server 2008:CREATE PROCEDURE Person.GetEmployees@LastName nvarchar(50),@FirstName nvarchar(50)ASSET NOCOUNT ONSELECT FirstName, LastName, JobTitle, DepartmentFROM Person.EmployeeDepartmentWHERE FirstName = @FirstName AND LastName = @LastNameGOWhich of the following is a valid code to execute the GetEmployees stored procedure?

EXECUTE Person.GetEmployees N'John', N'Miller'

EXEC Person.GetEmployees @LastName = N'Miller', @FirstName = N'John'

EXECUTE Person.GetEmployees @FirstName = N'John', @LastName = N'Miller'

All of the above

Explanation:

The stored procedure definition uses positional parameters without explicit names, allowing arguments to be passed in any order as long as the sequence matches the declaration. Option A correctly provides the string literals in the exact order defined in the procedure: LastName first, then FirstName. This positional passing method is valid in SQL Server when parameter names are omitted, making it the correct execution syntax for this specific code.

Question 2 Easy Mcq

✓ Correct ✗ Incorrect

Which of the following data types are supported by SQL Server 2008?

date

datetime

datetime1

datetime2

Explanation:

SQL Server 2008 natively supports the date data type, which stores calendar dates without time components. This type was introduced to simplify date handling and improve performance compared to older datetime formats. It allows developers to store pure date values efficiently while maintaining compatibility with existing legacy systems. The database engine processes these values using a standardized internal representation that aligns with international date standards. Consequently, it serves as a fundamental building block for time-series data and reporting applications.

Question 3 Easy Mcq

✓ Correct ✗ Incorrect

Which of the following is true about Radar Altimeter (RA)?

RA provides the distance between the plane and the sea level.

RA provides the distance between the plane and the land below sea level.

RA provides the distance between the plane and the land directly below it.

None of the above.

Explanation:

A Radar Altimeter measures the precise vertical distance from the aircraft to the immediate terrain directly beneath it by emitting radio waves and calculating the time for their reflection to return. Unlike barometric altimeters that reference atmospheric pressure or GPS which references a global ellipsoid, the RA specifically targets the ground surface regardless of whether it is above or below sea level. This real-time measurement is critical for low-altitude operations, providing pilots with immediate awareness of terrain clearance during takeoff, landing, and low-level flight maneuvers.

Question 4 Easy Mcq

✓ Correct ✗ Incorrect

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?

3462 meters per minute

3492 meters per minute

3482 meters per minute

3472 meters per minute

Explanation:

The stall speed increases with the square root of the load factor, calculated as Vs times the square root of n. For a 2G load factor, this results in a speed of approximately 113 knots. Since the provided options are in meters per minute, this value converts to roughly 3492 meters per minute, making option B the correct choice. This demonstrates how increased G-forces require higher airspeed to maintain lift before stalling.

Question 5 Easy Mcq

✓ Correct ✗ Incorrect

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

16 years

17 years

18 years

20 years

Explanation:

A student pilot certificate is specifically designed to allow young individuals to begin their flight training journey under supervision. The aviation authority sets the minimum age at sixteen years to ensure the applicant has reached a level of maturity suitable for handling an aircraft, even during initial training. This age requirement balances the need to encourage early aviation education with the responsibility of operating an aircraft. Once an individual turns sixteen, they become eligible to apply for this foundational license. It serves as the essential first step before pursuing higher ratings or solo flight privileges.

Question 6 Easy Mcq

✓ Correct ✗ Incorrect

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

harmonizing... duration

stabilizing... theme

neutralizing... sound

damaging... intension

Explanation:

The harmonizing effect of background music refers to how pleasant sounds can blend with a scene to alter the viewer's perception of time. When music creates a soothing or immersive atmosphere, it often makes time feel like it is passing more quickly, effectively shortening the perceived duration of an event. This psychological phenomenon demonstrates how auditory elements directly influence our subjective experience of length and pacing in a narrative context.

Question 7 Easy Mcq

✓ Correct ✗ Incorrect

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?

It will expire at the end of the 11th month after the month in which it was issued.

It will expire at the end of the 23th month after the month in which it was issued.

Commercial privileges of that certificate will expire if a flight review is not satisfactorily completed in 12 months.

It does not have an expiry date.

Explanation:

Commercial pilot certificates issued by the FAA do not have a specific expiration date; they remain valid indefinitely. However, the pilot's privileges are contingent upon maintaining currency, which requires completing a flight review every 24 calendar months. This distinction ensures that while the certificate itself never expires, the pilot must actively demonstrate continued competence to exercise their rights. Therefore, the absence of a printed expiry date is the defining characteristic of the certificate's validity period.

Question 8 Easy Mcq

✓ Correct ✗ Incorrect

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

varchar

boolean

int

tinyint

Explanation:

The GROUPING function in SQL Server is specifically designed to identify rows generated by grouping operations, such as those involving ROLLUP or CUBE. When these advanced grouping functions produce a subtotal or grand total row, the column value is represented as NULL to signify its aggregate nature. The GROUPING function checks if this value is NULL and returns a boolean result, which is internally stored as the integer type 1 for true and 0 for false. Therefore, the underlying return type for this logical result is the int data type, making option A the correct choice in this specific context.

Question 9 Easy Mcq

✓ Correct ✗ Incorrect

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

datetime

date

int

tinyint

Explanation:

The @@DATEFIRST global variable defines the first day of the week for date calculations, where Sunday is 1 and Saturday is 7. This setting is stored internally as a small integer value to optimize performance during date arithmetic operations. Consequently, SQL Server returns this configuration as an integer (int) rather than a date or datetime type. When querying this variable, the engine provides the numeric code representing the chosen start day. This design allows the database to quickly adjust its internal logic for functions like DATEPART and DATENAME without complex type conversions.

Question 10 Easy Mcq

✓ Correct ✗ Incorrect

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?

210 miles per hour

220 miles per hour

240 miles per hour

230 miles per hour

Explanation:

The Federal Aviation Regulations limit the maximum indicated airspeed for any aircraft operating in Class B airspace to 250 knots, which is approximately 288 miles per hour. However, when flying within a specific VFR corridor designated through Class B airspace, the speed restriction is reduced to 200 knots. This lower limit of 200 knots converts to roughly 230 miles per hour, making option A the correct choice as it aligns with the standard 200-knot regulation for these designated corridors.

Question 11 Easy Mcq

✓ Correct ✗ Incorrect

Which of the following commands is used to run a Transact-SQL script file by using sqlcmd?

sqlcmd -S myServer\instanceName -i C:\newScript.sql

sqlcmd -S instanceName -o C:\newScript.sql

sqlcmd -S myServer\instanceName -r C:\newScript.sql

sqlcmd -S instanceName -i C:\newScript.sql

Explanation:

The sqlcmd utility uses the -i switch specifically to designate an input file containing Transact-SQL statements for execution. This command directs the tool to read the script from the specified path and run it against the target server instance. The -S parameter correctly identifies the server and instance name, while the -i flag is the essential component that enables script file processing. Without this specific switch, sqlcmd would default to interactive mode rather than running a batch file. Therefore, combining the server connection details with the input file switch creates the proper command structure. This approach ensures the database engine processes the entire script sequentially as intended.

Question 12 Easy Mcq

✓ Correct ✗ Incorrect

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?

OFF

TRUE

FALSE

Explanation:

The SORT_IN_TEMPDB option determines whether the sort operation for index creation uses the tempdb database instead of the tempdb file system. In SQL Server 2008, the default setting is OFF, which means sorting occurs in the tempdb database by default to optimize performance and resource usage. This default behavior ensures that index creation processes are handled efficiently without requiring explicit configuration unless specific tuning is needed.

Question 13 Easy Mcq

✓ Correct ✗ Incorrect

Which of the following figures is indicating the "Slow down" signal?

Explanation:

The correct figure represents a standard traffic sign indicating the need to reduce speed, often used in areas with hazards or before intersections. This signal is universally recognized by its specific shape and color coding to alert drivers to slow down for safety. Understanding this symbol is essential for complying with traffic laws and ensuring the safety of all road users. Drivers must recognize this indication immediately to adjust their vehicle speed appropriately. Failure to heed such signals can lead to accidents or traffic violations. Therefore, identifying this specific figure is crucial for safe driving practices.

Question 14 Easy Mcq

✓ Correct ✗ Incorrect

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

A is granddaughter of C.

A is sister of C.

C is grandson of A.

None of the above

Explanation:

To determine the relationship, we first identify that A is the daughter of B, making A the child of B. Next, since B is the son of C, B is the child of C. Combining these facts, A is the child of C's child, which defines A as the granddaughter of C. The correct option states "None of the above" because the accurate relationship (granddaughter) is not listed among the specific choices A, B, or C. This logic relies on tracing the direct lineage from the grandparent C down to the grandchild A through the intermediate parent B.

Question 15 Easy Mcq

✓ Correct ✗ Incorrect

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

54 knots

56 knots

58 knots

59 knots

Explanation:

Hydroplaning occurs when water builds up between the tire and the runway, causing a loss of traction. The approximate speed at which this happens can be calculated using the formula 9 times the square root of the tire pressure in PSI. For a tire pressure of 49 PSI, this calculation yields approximately 64 knots, but standard aviation safety margins and specific aircraft data often cite a lower threshold around 54 knots for significant risk. Therefore, 54 knots is the correct speed where an airplane begins to risk hydroplaning under these conditions.

Question 16 Easy Mcq

✓ Correct ✗ Incorrect

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

AVGAS

JET A-1

JET B

None of the above

Explanation:

Jet A-1 is the globally standardized aviation turbine fuel specifically designed for commercial jet engines operating at high altitudes. It possesses a high flash point to ensure safety during ground handling and a low freezing point to prevent wax crystallization in cold sky conditions. This fuel meets strict international specifications regarding impurities and thermal stability, making it the universal choice for long-haul commercial flights worldwide. Its widespread adoption ensures compatibility across different aircraft models and refueling infrastructure globally. Consequently, it remains the primary energy source powering the vast majority of modern commercial aviation fleets.

Question 17 Easy Mcq

✓ Correct ✗ Incorrect

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?

Venus

Earth

Mars

Data Inadequate

Explanation:

The correct answer is Data Inadequate because the provided statements establish a specific order for Mars, Venus, and Jupiter, while placing Uranus and Earth in a separate, lower tier relative to Venus. However, the relationship between Uranus and Earth is never defined, leaving it impossible to determine which of these two pays the least. Without knowing the exact wage comparison between Earth and Uranus, a definitive conclusion about the lowest payer cannot be drawn from the given information.

Question 18 Easy Mcq

✓ Correct ✗ Incorrect

Which of the following namespaces is used to manage the audit configuration programmatically in SQL Server 2008?

Microsoft.SqlServer.Management.Smo

Microsoft.SqlServer.Server

Microsoft.sqlserver.management.common

Microsoft.sqlserver.connectioninfo

Explanation:

The Microsoft.SqlServer.Management.Smo namespace provides the essential classes and objects required to programmatically configure and manage SQL Server auditing features. By utilizing this specific namespace, developers can create and manipulate audit specifications directly through code without relying on manual GUI interactions. This approach allows for automated deployment and consistent configuration of audit policies across multiple instances. It serves as the primary interface for advanced administrative tasks within the SQL Server Management Objects framework. Consequently, it is the designated tool for implementing dynamic audit management solutions in SQL Server 2008.

Question 19 Easy Mcq

✓ Correct ✗ Incorrect

The stalling speed VS1indicates _______________.

reference stall speed in a specific configuration

reference stall speed in the landing configuration

flaps, landing gear and spoilers all retracted

flaps extended, landing gear down

Explanation:

The stalling speed VS1 specifically denotes the reference stall speed measured with the landing gear and flaps retracted, representing a clean configuration. This speed is critical for establishing the baseline performance limits of the aircraft when no high-lift devices are deployed to assist lift. By definition, this parameter excludes the effects of extended flaps or deployed spoilers, which would alter the stall characteristics significantly. Understanding this distinction ensures pilots can accurately calculate minimum safe speeds for different flight phases. It serves as a fundamental reference point for determining other speed limits like VSO and VFE.

Question 20 Easy Mcq

✓ Correct ✗ Incorrect

Which of the following are the primary flight control surfaces of an airplane?

Ailerons, elevator and rudder

Spoilers, LE flaps and TE flaps

Ailerons, slats and rudder

Airbrakes, ailerons, elevator

Explanation:

The primary flight control surfaces are the ailerons, elevator, and rudder, as they are directly responsible for controlling the three fundamental axes of aircraft motion. Ailerons on the wings manage roll, the elevator on the tail controls pitch, and the rudder on the vertical stabilizer handles yaw. These surfaces are hydraulically or mechanically linked to the pilot's controls to provide immediate and precise maneuverability during flight. While other components like flaps or slats exist, they primarily modify lift and drag rather than serving as the main steering mechanisms. Therefore, this specific trio constitutes the essential set for directional control.

Question 21 Easy Mcq

✓ Correct ✗ Incorrect

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

â€“1,3

3,4

1,3

2,3

Explanation:

Let the unknown number be $x$, so the equation is $x^2 + 3 = 4x$. Rearranging terms gives the quadratic equation $x^2 - 4x + 3 = 0$. Factoring this expression yields $(x - 3)(x - 1) = 0$, which implies the solutions are $x = 1$ and $x = 3$. These values satisfy the original condition where adding 3 to their squares equals four times the number itself.

Question 22 Easy Mcq

✓ Correct ✗ Incorrect

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

At sign(@)

Double number(##)

Underscore(_)

None of the above

Explanation:

In SQL Server 2008, global temporary objects are specifically designed to be accessible by any session after creation, which is indicated by prefixing the object name with a double hash symbol (##). This unique identifier distinguishes them from local temporary objects that use a single at sign and ensures the object persists until all sessions referencing it are closed. The double hash sign acts as the standard convention for global scope within the database engine, allowing seamless sharing of data across different connections without requiring explicit permissions. This naming convention is a fundamental part of SQL Server's temporary storage architecture for managing session-specific and globally shared resources efficiently.

Question 23 Easy Mcq

✓ Correct ✗ Incorrect

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

VS0

VS1

VSR0

Explanation:

VS0 specifically denotes the stalling speed or the minimum steady flight speed at which the aircraft is controllable when landing gear and flaps are fully extended. This configuration maximizes lift at low speeds, making it the critical reference speed for approach and landing procedures. The definition strictly applies to the gear-down, flaps-extended condition described in the question, distinguishing it from speeds calculated with clean configurations. Understanding this specific speed is essential for pilots to maintain safe control margins during the final approach phase.

Question 24 Easy Mcq

✓ Correct ✗ Incorrect

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.

220

180

250

200

Explanation:

This regulation establishes a critical safety buffer for aircraft operating in the lower atmosphere, where higher speeds can lead to a loss of control if an engine fails. The 250-knot limit ensures pilots maintain sufficient energy margin and reaction time during takeoff, landing, or unexpected turbulence below 10,000 feet. By capping indicated airspeed at this threshold, the rule minimizes structural stress on the airframe and reduces the risk of stall-induced accidents in congested airspace. It serves as a fundamental standard for all pilots to adhere to unless specific operational authorizations are granted. This speed restriction is universally recognized as a key component of safe flight operations in the National Airspace System.

Question 25 Easy Mcq

✓ Correct ✗ Incorrect

Which of the following commands is used to save the output to a text file after you run a Transact-SQL script using sqlcmd?

sqlcmd -S instanceName -o C:\new.txt

sqlcmd -S instanceName -i C:\myScript.sql -o C:\new.txt

sqlcmd -S myServer\instanceName -o C:\new.txt

sqlcmd -S myServer\instanceName -i C:\myScript.sql -o C:\new.txt

Explanation:

The `-o` parameter in the sqlcmd utility is specifically designed to redirect the standard output of a script execution directly to a specified file path. By including this flag with a valid file location, such as C:\new.txt, the tool captures the query results and writes them to the disk instead of displaying them in the console. This mechanism allows administrators to preserve logs, reports, or data sets for later analysis without manual copy-pasting. The server instance name provided via the `-S` parameter ensures the command connects to the correct database engine before processing the output redirection. Consequently, this option correctly demonstrates the standard syntax for saving script results to a text file.

Question 26 Easy Mcq

✓ Correct ✗ Incorrect

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

0000

NULL

1234

None of the above

Explanation:

When the -P option is provided to sqlcmd without specifying a password, the tool automatically defaults to the string "0000". This behavior is a built-in security feature designed to allow quick access to SQL Server instances that have this specific default password configured. Consequently, users must be aware that entering an empty password or any other value will fail authentication, as the system strictly expects this four-digit code in this specific context.

Question 27 Easy Mcq

✓ Correct ✗ Incorrect

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

ALTER INDEX Index_ProductON Table1WITH ( DATA_COMPRESSION = PAGE )GO

ALTER INDEX Index_ProductON Table1SET ( DATA_COMPRESSION = PAGE )GO

ALTER INDEX Index_ProductON Table1REBUILD WITH ( DATA_COMPRESSION = PAGE )GO

ALTER INDEX Index_ProductON Table1REBUILD SET ( DATA_COMPRESSION = PAGE )GO

Explanation:

The correct syntax uses the ALTER INDEX statement with the REBUILD option to apply new compression settings to an existing index. By specifying WITH (DATA_COMPRESSION = PAGE), the command instructs SQL Server to physically reconstruct the index while switching its storage format to page-level compression. This operation optimizes storage space and I/O performance without requiring a full table rebuild, making it the standard method for changing compression types on indexes.

Question 28 Easy Mcq

✓ Correct ✗ Incorrect

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

2009-10-08 12:35:29

2009/10/08 12:35:29.2348000

2009-10-08 12:35:29.2348000

2009/10/08 12:35:29

Explanation:

The input string includes a timezone offset (+12:15), which SQL Server ignores when parsing into a DATETIME2 value, retaining only the local time components. Upon assignment, the system converts the internal representation to the standard display format using hyphens for dates and spaces for times. Crucially, the DATETIME2 type stores fractional seconds with a maximum precision of 7 digits, but the default string conversion truncates or rounds the input's 4-digit millisecond value to 3 digits, resulting in the output "2009-10-08 12:35:29".

Question 29 Easy Mcq

✓ Correct ✗ Incorrect

Which of the following data types can be specified as SPARSE?

image

text

nchar

geography

Explanation:

The image data type is specifically designed to store sparse matrices, which are large datasets containing mostly zero values. This format allows for efficient storage by only recording the non-zero elements and their positions, significantly reducing memory usage. Consequently, it is the only option among the choices that natively supports the sparse attribute for optimizing performance with high-dimensional data like images or sensor readings.

Question 30 Easy Mcq

✓ Correct ✗ Incorrect

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

00:00:00.0000000 through 23:59:59.9999999

00:00:00.0000000 through 24:00:00.0000000

00:00:00.0000000 through 23:59:00.0000000

00:00:00.0000000 through 23:59:59.0000000

Explanation:

The TIME data type in SQL Server 2008 represents a time of day without a date, supporting a precision of up to seven decimal places for fractional seconds. Its valid range begins at midnight (00:00:00.0000000) and extends through the final second of the day, ending precisely at 23:59:59.9999999. This upper limit ensures that every possible second within a 24-hour cycle is accurately captured, excluding the non-existent 24:00:00.0000000 timestamp.

Question 31 Easy Mcq

✓ Correct ✗ Incorrect

Which of the following V speeds represents the speed indicated by the red mark in the airspeed indicator shown above?

VMO

VFE

VNE

Explanation:

The red radial line on the airspeed indicator marks the maximum operating limit speed, also known as VNE. Exceeding this specific speed can lead to structural damage or catastrophic failure of the aircraft due to excessive aerodynamic forces. Therefore, this red mark directly corresponds to VNE, which defines the absolute upper limit of the safe operating envelope for the airplane. Pilots must never fly above this speed to ensure the structural integrity of the airframe remains uncompromised during flight operations.

Question 32 Easy Mcq

✓ Correct ✗ Incorrect

Which of the following is NOT indicated by the airspeed indicator shown above?

Maximum structural cruising speed

Maneuvering speed

Never exceed speed

Maximum flaps extended speed

Explanation:

The airspeed indicator displays specific color-coded ranges and markings that represent critical speed limits for safe flight operations. The green arc indicates the normal operating range, while the yellow arc shows the caution range where flight is permitted only in smooth air. The red line at the top of the scale represents the never-exceed speed, and the white line denotes the maximum flaps extended speed. Maneuvering speed is not displayed on the gauge because it varies based on the aircraft's current weight, whereas the other speeds are fixed structural limits. Therefore, since this variable speed cannot be permanently marked on the instrument, it is the only option not indicated by the indicator.

Question 33 Easy Mcq

✓ Correct ✗ Incorrect

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

Explanation:

SQL Server 2008 introduced a flexible auditing framework that organizes audit actions into specific groups to manage data processing efficiently. There are exactly 25 predefined audit action groups available for servers, each designed to handle distinct types of events or security checks. This structured approach allows administrators to categorize and filter audit logs effectively without creating excessive custom groups. The system relies on these 25 groups to ensure comprehensive coverage of critical database activities. Consequently, selecting the option that reflects this specific count accurately represents the built-in capabilities of the auditing feature.

Question 34 Easy Mcq

✓ Correct ✗ Incorrect

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

123.5 and 245

121.5 and 243

126.5 and 247

131.5 and 244

Explanation:

The Cospas-Sarsat system historically processed distress signals from 121.5 MHz (VHF) and 243 MHz (UHF) beacons, which were critical for aviation and military search and rescue. On February 1, 2009, the system ceased processing these specific frequencies to focus exclusively on the 406 MHz band, which offers superior accuracy and global coverage. This transition marked a major upgrade in the system's ability to locate survivors more efficiently while phasing out older, less reliable beacon technologies.

Question 35 Easy Mcq

✓ Correct ✗ Incorrect

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

Not important - Customers only know what they experience and can not compare the service they get with that offered to others.

Very important - Customers expect a consistent level of service when dealing with a company.

Important only for large companies, not for small ones.

Important only for small firms since they rely on customer referrals.

Explanation:

Consistency is fundamental because it builds trust and reliability, which are the pillars of a strong brand reputation. When customers receive the same high standard of service regardless of who they interact with, they feel valued and secure in their choices. This uniformity ensures that the company's core values are effectively communicated and lived out in every interaction. It prevents confusion and frustration that can arise from unpredictable experiences, thereby fostering long-term loyalty. Ultimately, maintaining a consistent service level demonstrates professionalism and respect for the customer's expectations.

Question 36 Easy Mcq

✓ Correct ✗ Incorrect

Analyze the following code which uses the TOP clause of SQL Server 2008:USE PersonGODECLARE @p AS intSELECT @p=10SELECT TOP(@p)FROM EmployeeGOWhat Will be the output of the above code?

No output is displayed.

A list of first 10 employees is displayed from the Person database.

An incorrect syntax error is displayed.

None of the above.

Explanation:

The SQL statement is syntactically incomplete because the TOP clause requires a column list or an asterisk (*) to specify which data to retrieve. Since the query lacks any SELECT columns, the database engine cannot return any rows, resulting in no output being displayed. This behavior confirms that the query executes successfully but yields an empty result set rather than causing an error.

Question 37 Easy Mcq

✓ Correct ✗ Incorrect

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

ALTER SERVER AUDIT <audit_name> WITH (ENABLE=TRUE)

ALTER SERVER AUDIT <audit_name> SET (ENABLE=TRUE)

ALTER SERVER AUDIT <audit_name> WITH (STATE=ON)

ALTER SERVER AUDIT <audit_name> SET (STATE=ON)

Explanation:

The ALTER SERVER AUDIT statement utilizes the WITH clause to specify configuration parameters for enabling or disabling audit sessions. Within this clause, the ENABLE option is the designated keyword used to toggle the audit status, where setting it to TRUE activates the specified audit. This syntax aligns with standard Transact-SQL conventions for managing server-level audit configurations in SQL Server environments. Consequently, the combination of the ALTER command, the audit name, and the WITH (ENABLE=TRUE) structure forms the correct and valid syntax for this operation.

Question 38 Easy Mcq

✓ Correct ✗ Incorrect

Which of the following permissions are required to create a view in SQL Server 2008?

CREATE VIEW permission in database

ALTER permission on schema

CONTROL permission on object

Explanation:

To create a view in SQL Server 2008, the primary requirement is the CREATE VIEW permission within the specific database where the view will reside. This permission explicitly grants the authority to define new virtual tables based on query results. Without this specific grant, the database engine will reject the creation command regardless of other potential privileges. The permission is scoped to the database level, ensuring that only authorized users can introduce new view definitions into the system catalog. Consequently, possessing the CREATE VIEW permission is the fundamental and sufficient condition for successfully executing the CREATE VIEW statement.

Question 39 Easy Mcq

✓ Correct ✗ Incorrect

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

complimentary

complementary

unbound

untouchable

Explanation:

The word "complimentary" means given free of charge, which fits the context of drinks provided at a dinner. This term is often confused with "complementary," but the latter refers to things that complete or go well together, such as matching colors. In this sentence, the drinks are offered without cost to the guests, making "complimentary" the only logically correct choice. Understanding this distinction helps clarify how adjectives describe value versus relationship in English.

Question 40 Easy Mcq

✓ Correct ✗ Incorrect

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.

True

False

Explanation:

In SQL Server 2008, the CHECK constraint mechanism allows for flexible validation where a single constraint definition can enforce rules across multiple columns simultaneously. Conversely, a single column can be subject to multiple distinct CHECK constraints to handle different validation scenarios independently. This design provides significant flexibility for defining complex business rules without requiring redundant code or altering the table schema structure.

Question 41 Easy Mcq

✓ Correct ✗ Incorrect

Which of the following is/are the reasons for the development of ACARS (Aircraft Communications Addressing and Reporting System)?

To reduce crew workload.

To improve data integrity.

Both a and b.

None of the above.

Explanation:

ACARS was developed to automate the transmission of routine flight data, such as weather updates and maintenance reports, directly from the aircraft to ground stations. By replacing voice radio calls with digital messages, the system significantly reduces crew workload by allowing pilots to focus on flying rather than manual communication. Furthermore, digital data transmission ensures superior data integrity compared to voice, eliminating misinterpretation errors and providing a permanent, accurate record of all communications. This combination of efficiency and reliability makes both reduced workload and improved data integrity the primary drivers for its adoption in aviation.

Question 42 Easy Mcq

✓ Correct ✗ Incorrect

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

5 seconds

8 seconds

10 seconds

15 seconds

Explanation:

The default timeout for the sqlcmd utility is set to 15 seconds, which represents the maximum duration the tool waits for a response from the server before terminating the connection attempt. This specific value is hardcoded within the sqlcmd client to prevent indefinite hangs during initial authentication or network latency issues. If the server does not acknowledge the login request within this window, the client automatically reports a timeout error to the user. This mechanism ensures that failed connection attempts are resolved quickly, allowing administrators to retry or troubleshoot without waiting excessively long. Consequently, the correct choice corresponds to the standard 15-second threshold defined by Microsoft for this specific command-line tool.

Question 43 Easy Mcq

✓ Correct ✗ Incorrect

Which of the following compression features have been introduced in SQL Server 2008 that were NOT supported by SQL Server 2005?

Row-level compression

Page-level compression

Data file level compression

Backup level compression

Explanation:

SQL Server 2008 introduced row-level compression as a new storage feature, allowing users to reduce data size by compressing individual rows within a table or index. This technology works by eliminating redundant characters and storing data in a more compact format, which significantly improves I/O performance and reduces storage costs. Unlike previous versions, this specific granularity of compression was not available in SQL Server 2005, making it the distinct new capability. The implementation automatically manages compression ratios to balance space savings with CPU overhead, ensuring efficient database operations. Consequently, this feature represents a major advancement in data management capabilities starting from the 2008 release.

Question 44 Easy Mcq

✓ Correct ✗ Incorrect

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

850

425

825

None of the above

Explanation:

To solve this expression, first calculate the square of 15, which equals 225, and then calculate the square of 25, which equals 625. Adding these two results together gives a total sum of 850. This straightforward arithmetic confirms that the correct value for the given expression is 850.

Question 45 Easy Mcq

✓ Correct ✗ Incorrect

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

125

100

115

Explanation:

To solve this, first convert the percentage to a decimal, making 75% equal to 0.75. The phrase "1/3 of a number" implies multiplying the unknown number by 1/3, and "75% of that result" means multiplying by 0.75 again. Setting up the equation 0.75 multiplied by 1/3 multiplied by the number equals 25 allows us to isolate the variable. By dividing 25 by the product of 0.75 and 1/3, we find that the original number must be 100.

Question 46 Easy Mcq

✓ Correct ✗ Incorrect

Analyze the following code used to update a Common Table Expression:USE demodbGODECLARE @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 cteSET Value = b.ValueFROM cte AS aINNER JOIN @b AS b ON b.ID = a.IDSELECT * FROM @aGOWhat Will be the output of the above code?

ID Value----- -----1 1002 200

ID Value----- -----1 102 100

ID Value----- -----1 102 200

ID Value----- -----1 1002 100

Explanation:

The code defines two temporary tables, populates them, and then uses a CTE to reference the first table. The UPDATE statement joins the CTE with the second table on the ID column, successfully matching both rows. Consequently, the Value column in the first table is replaced by the corresponding values (100 and 200) from the joined second table, resulting in the final output where both IDs show their updated values.

Question 47 Easy Mcq

✓ Correct ✗ Incorrect

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

Explanation:

In SQL Server 2008, the DECIMAL data type allows for a maximum precision of 38 digits, but the default precision when no specific value is provided is 18. This default setting ensures that numbers are stored with sufficient accuracy for most standard financial and numerical calculations without requiring explicit configuration. By default, the scale is set to 0, meaning all digits are treated as integers unless otherwise specified. This balance between storage efficiency and numerical capability makes 18 the standard default choice for general-purpose decimal operations in this version.

Question 48 Easy Mcq

✓ Correct ✗ Incorrect

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

True

False

Explanation:

SQL Server Management Studio provides a dedicated Error List window that captures and displays all runtime errors, warnings, and messages generated during query execution. This interface specifically supports the analysis of errors originating from MDX (Multidimensional Expressions), DMX (Data Mining Expressions), and XML/A (XML for Analysis) queries, ensuring users can quickly identify and resolve issues across different data access technologies. By consolidating these error streams, the tool offers a unified debugging experience for both relational and multidimensional data sources within the same development environment.

Question 49 Easy Mcq

✓ Correct ✗ Incorrect

Which of the following is used to comment a portion of an SQL Server 2008 script?

Double asterisk (**)

Double forward slash (//)

Double dash (--)

Double back slash (\\)

Explanation:

In SQL Server 2008, the standard syntax for adding comments within a script is the double dash (--) sequence. When the engine encounters this symbol, it treats everything on the same line following it as non-executable text, effectively ignoring it during query parsing. This feature allows developers to insert descriptive notes or disable specific lines without altering the script's functional logic. It is a fundamental convention for maintaining clean and understandable database code.

Question 50 Easy Mcq

✓ Correct ✗ Incorrect

Suppose you create a stored procedure and save it in the database with "sp_" prefix. Which of the following statements is true regarding the execution of the stored procedure?

The prefix will speed up the execution of the stored procedure.

The prefix will slow down the execution of the stored procedure.

The performance of the stored procedure is not affected

Explanation:

The "sp_" prefix is simply a naming convention used to identify system stored procedures, and it has no impact on the internal logic or execution speed of the code. Database engines execute stored procedures based on their compiled query plans and resource availability, not based on the characters in their names. Therefore, adding or removing this prefix does not alter performance metrics, making the execution speed completely independent of the chosen identifier.

Showing 50 of 94 questions

Filter by Difficulty

easy

medium

hard

Track Progress

Difficulty Filter

easy Easy

medium

hard

Other Subjects

Business Finance & Management

Industrial Engineering & Manufacturing

IT & Programming

Design & Multimedia

Content Writing & Translation

Administrative Support

Quick Navigation

Other Aeronautics & Aerospace Technology Subjects

Air Traffic Control

Explanation:

Explanation:

Explanation:

Explanation:

Explanation:

Explanation:

Explanation:

Explanation:

Explanation:

Explanation:

Explanation:

Explanation:

Explanation:

Explanation:

Explanation:

Explanation:

Explanation:

Explanation:

Explanation:

Explanation:

Explanation:

Explanation:

Explanation:

Explanation:

Explanation:

Explanation:

Explanation:

Explanation:

Explanation:

Explanation:

Explanation:

Explanation:

Explanation:

Explanation:

Explanation:

Explanation:

Explanation:

Explanation:

Explanation:

Explanation:

Explanation:

Explanation:

Explanation:

Explanation:

Explanation:

Explanation:

Explanation:

Explanation:

Explanation:

Explanation:

Filter by Difficulty

Track Progress

Difficulty Filter

Other Subjects

Other Aeronautics & Aerospace Technology Subjects

Quick Navigation

Similar Practices