Prepare for and practice interview questions from Capital One across topics like Product Metrics, Algorithms, Analytics and more.

Capital One Interview Questions

Python

Machine Learning

Product Metrics

A/B Testing

Analytics

Statistics

Probability

Algorithms

Capital One Interview Guides

You are given two lists: a full list and a missing list. The full list contains a list of integers, while the missing list contains all the integers from the full list except for one. Your task is to create a function that finds the missing element.

For example:

Example 1:

Input:

<pre tabindex="0" class="chroma"><code>full = [1, 2, 3, 4, 5]
missing = [1, 2, 3, 5]
</code></pre>

Output:

<pre tabindex="0" class="chroma"><code>one_element_removed(full, missing) -&gt; 4
</code></pre>

Example 2:

Input:

<pre tabindex="0" class="chroma"><code>full = [4,-6,3,10,11,150,120]
missing = [4,-6,3,10,11,150]
</code></pre>

Output:

<pre tabindex="0" class="chroma"><code>one_element_removed(full, missing) -&gt; 120
</code></pre>

Example 3:

Input:

<pre tabindex="0" class="chroma"><code>full = [17, 11, 15, 19, 21, 11]
missing = [17, 15, 19, 21, 11]
</code></pre>

Output:

<pre tabindex="0" class="chroma"><code>one_element_removed(full, missing) -&gt; 11
</code></pre>

In this case, one of the 11’s is missing from the missing list. Your function should return the repeated number.

This question tests your ability to manipulate lists and use bitwise operations to solve a problem. You are given two lists, one with all integers and the other missing one integer from the full list. Your task is to create a function to find the missing integer.

Find the Missing Element

Let’s say you work at a company developing a new ride-sharing app.

How would you design a database that could record rides between riders and drivers?

What would the schema of the tables look like and how would they join together?

Design a database for a ride-sharing app.

Ride-Sharing App Schema

Write a query to return pairs of projects where the end date of one project matches the start date of another project. 

Example:

Input:

<code>projects</code> table

<table>
<thead>
<tr>
<th>Columns</th>
<th>Type</th>
</tr>
</thead>

<tbody>
<tr>
<td><code>id</code></td>
<td>INTEGER</td>
</tr>

<tr>
<td><code>title</code></td>
<td>VARCHAR</td>
</tr>

<tr>
<td><code>start_date</code></td>
<td>DATETIME</td>
</tr>

<tr>
<td><code>end_date</code></td>
<td>DATETIME</td>
</tr>

<tr>
<td><code>budget</code></td>
<td>FLOAT</td>
</tr>
</tbody>
</table>
Output

<table>
<thead>
<tr>
<th>Columns</th>
<th>Type</th>
</tr>
</thead>

<tbody>
<tr>
<td><code>project_title_end</code></td>
<td>VARCHAR</td>
</tr>

<tr>
<td><code>project_title_start</code></td>
<td>VARCHAR</td>
</tr>

<tr>
<td><code>date</code></td>
<td>DATETIME</td>
</tr>
</tbody>
</table>

Capital One Interview Questions

Capital One Interview Guides

Capital One Interview Questions

Capital One Salaries by Position