TheJobOverflow | Revature | OA | Revature Aptitude, SQL & Essay Writing Assessment | Number Series & Database Filtering | Feb 6th Campus Assessment

Entering edit mode

Section 1: Problem Solving (Matrix Puzzle)

Question 1: Number Matrix Logic Which number will replace the question mark?

........

Options:

Section 2: Databases (SQL)

Question 2: SQL Pattern Matching You have a table with the following schema in a database:

CREATE TABLE users
(
    id INT NOT NULL,
    firstname VARCHAR(255) NOT NULL,
    lastname VARCHAR(255) NOT NULL,
    age INT NOT NULL,
    address VARCHAR(255) NOT NULL
)

You need to get the list of people who have "baker street" in their addresses. Which of the following queries will provide you the required result?

SELECT * FROM users WHERE address = 'baker street'
SELECT * FROM users WHERE address LIKE 'baker street'
SELECT * FROM users WHERE address LIKE '%baker street%'
SELECT * FROM users WHERE address LIKE '_baker street_'

Section 3: English (Grammar)

Question 3: Verb Application Fill in the blanks using the correct application of the verbs provided in the brackets.

Employees or IT experts using remote desktop software should look for an option that ......... (be) easy to use and download. Complicated setup processes or login procedures can .........(become) frustrating and make the remote desktop software more of a chore than a tool for .........(get) work done easily. Because sensitive or confidential information ............... (to be) frequently accessed via remote desktop software, security features are critical. The software should have an automatic timeout so that no one can access the remote PC if the user ..........(forget) to log out.

Section 4: Written Communication

Question 4: Essay Draft Draft your points on your favorite online food ordering and delivery app.

Instructions: Your draft should have a minimum of 100 words up to a maximum of 200 words.

ADD COMMENT • link