20+ Electronic Arts Interview Questions and Answers

Area of square except inscribed circle

• Find area of square

• Subtract area of circle from square

• Area of square = L^2, Area of circle = pi*(L/2)^2

• Answer = L^2 - pi*(L/2)^2

SDLC is a process followed by software development teams to design, develop and test high-quality software.

• SDLC stands for Software Development Life Cycle

• It consists of several phases including planning, analysis, design, implementation, testing, and maintenance

• Each phase has its own set of activities and deliverables

• The goal of SDLC is to produce high-quality software that meets customer requirements and is delivered on time and within budget

• Examples of SDLC models include W...read more

Other than indexes and tables, a DBMS also includes views, stored procedures, triggers, and functions.

• Views: Virtual tables that are based on the result of a query. They provide a way to simplify complex queries and restrict access to data.

• Stored Procedures: Precompiled sets of SQL statements that can be executed with a single command. They enhance performance and allow for code reusability.

• Triggers: Special types of stored procedures that are automatically executed when a sp...read more

Indexes are implemented using B Trees and B+ Trees.

• B Trees and B+ Trees are data structures used to organize and efficiently search data in databases.

• B Trees are balanced search trees that store data in nodes with multiple children.

• B+ Trees are similar to B Trees but have additional features like leaf nodes that form a linked list.

• Indexes are created on specific columns of a database table to improve query performance.

• When a query is executed, the database uses the index to q...read more

Activity flow diagrams for Ola cabs management system and washing machine.

• Ola cabs management system: User books a cab -> Driver accepts the ride -> User gets picked up -> User reaches destination -> Payment is made.

• Washing machine: User selects wash cycle -> Machine fills with water -> Detergent is added -> Machine agitates clothes -> Water drains -> Clothes are rinsed -> Machine spins clothes -> Cycle ends.

A database administrator manages and maintains databases, ensuring their security, performance, and availability.

• Designing and implementing database structures

• Installing and configuring database software

• Monitoring and optimizing database performance

• Ensuring data integrity and security

• Backing up and restoring databases

• Troubleshooting and resolving database issues

• Collaborating with developers and system administrators

• Planning and implementing database upgrades and migrations

A program to find factorial using recursion.

• Define a function that takes an integer as input.

• Check if the input is 0 or 1, return 1 in that case.

• Otherwise, call the function recursively with input-1 and multiply it with the input.

Types of integrity in DBMS include foreign, referential, and domain.

• Foreign integrity ensures that foreign key values in a table match primary key values in another table.

• Referential integrity ensures that relationships between tables are maintained, preventing orphaned or invalid data.

• Domain integrity ensures that data in a column adheres to specified data types, formats, or constraints.

• For example, in a database for an online store, foreign integrity would ensure that a cus...read more

Generic collections are type-safe and can store any type of data. Non-generic collections can only store objects of type 'object'.

• Generic collections are preferred as they provide compile-time type safety.

• Non-generic collections are slower and can cause runtime errors if the wrong type is added.

• Examples of generic collections include List, Dictionary, and Queue.

• Examples of non-generic collections include ArrayList and Hashtable.

Ways to improve performance of stored procedures

• Use SET NOCOUNT ON to reduce network traffic

• Avoid using SELECT *

• Use table variables instead of temporary tables

• Avoid using cursors

• Use appropriate indexes

• Avoid using scalar functions

• Minimize the use of triggers

• Use stored procedures instead of ad hoc queries

Indexes are data structures that improve the speed of data retrieval operations in a database. Views are virtual tables created from queries.

• Indexes are used to quickly locate data in a database by creating a sorted structure that allows for efficient searching.

• Views are virtual tables that are created by executing a query and storing the result set as a named object.

• Indexes can be created on one or more columns of a table to improve the performance of SELECT, UPDATE, and DEL...read more

Agile methodology is an iterative and incremental approach to software development.

• Agile methodology emphasizes collaboration, flexibility, and customer satisfaction.

• It involves breaking down the project into small, manageable tasks called user stories.

• Teams work in short iterations called sprints, typically 1-4 weeks long.

• Regular meetings like daily stand-ups and sprint reviews are held to track progress and gather feedback.

• Adaptability and continuous improvement are key pri...read more

Managed code is executed by the CLR while unmanaged code is executed by the operating system.

• Managed code is written in languages like C#, VB.NET, etc. and is compiled into Intermediate Language (IL) code.

• Unmanaged code is written in languages like C, C++, etc. and is compiled into machine code.

• Managed code is executed by the Common Language Runtime (CLR) while unmanaged code is executed by the operating system.

• Managed code provides automatic memory management while unmanaged...read more

Stack using queues: push() - enqueue to queue1, pop() - dequeue from queue2 after transferring n-1 elements from queue1 to queue2

• To push an element, enqueue it to queue1

• To pop an element, transfer n-1 elements from queue1 to queue2, dequeue the last element from queue1 and swap the names of queue1 and queue2

• Queue using stacks: enqueue() - push to stack1, dequeue() - pop from stack2 after transferring all elements from stack1 to stack2

• To implement a queue using stacks, maintai...read more

In, out and ref are parameter modifiers in C# used to pass arguments to a method.

• In parameters are read-only and used to pass values to a method.

• Out parameters are write-only and used to return values from a method.

• Ref parameters are read-write and used to pass values to and from a method.

• In parameters are passed by value, out and ref parameters are passed by reference.

• In parameters are optional, out and ref parameters are required.

Difference between viewdata, viewbag and tempdata

• ViewData is used to pass data from controller to view

• ViewBag is a dynamic object used to pass data from controller to view

• TempData is used to pass data between controller actions or redirects

Triggers are database objects that automatically execute in response to certain events.

• Triggers can be used to enforce business rules or perform complex calculations.

• Types of triggers include DML triggers, DDL triggers, and logon triggers.

• DML triggers fire in response to data manipulation language (DML) events, such as INSERT, UPDATE, or DELETE statements.

• DDL triggers fire in response to data definition language (DDL) events, such as CREATE, ALTER, or DROP statements.

• Logon tr...read more

Check if two strings are anagram

• Sort both strings and compare them

• Use a hash table to count the frequency of each character in both strings and compare the hash tables

• Use an array of size 26 to count the frequency of each letter in both strings and compare the arrays

Doubly linked list is a data structure where each node has a pointer to both previous and next nodes.

• Create a Node class with data, prev and next pointers

• Create a LinkedList class with head and tail pointers

• Implement methods to add, remove and traverse nodes