DREAMOVAL APTITUDE TEST (COMPUTER SCIENCE INTERNS)

The following section focuses on project management and teamwork

For you to succeed on a project what must you do?

Always obey your team lead without any questions

Challenge and oppose your team lead especially if you feel you know better than him.

Cooperate with directives from team lead and raise objections where necessary

Report your team lead to management when he doesn't listen to you

How will understanding your role on a project help you?

Sense of ownership

Get a pay rise

Decreased morale

Low productivity

In order to communicate effectively, you need to practice "active listening". What does that involve?

Make a conscious effort to hear only the words that another person is saying

Allow yourself to become distracted by whatever else may be going on around you

Pay attention partially to the other person

Maintain focus on what the other person is saying

System integration consists of

A) Assuring that the pieces of a project come together at the right time

B) Planning for contingencies that may occur throughout the life cycle of the project

C) The pieces of the project function as an integration unit

Both a) and c)

Which of the following sql queries lists all entries in the transaction table and includes the order type from the order table where applicable

Select transaction.id,transaction.date,transaction.orderId,order.orderType,transaction.amount from transaction left join order on transaction.orderId=order.orderId;

Select transaction.id,transaction.date,transaction.orderId,order.orderType,transaction.amount from transaction right join order on transaction.orderId=order.orderId;

Select * from transaction,order where transaction.orderId=order.orderId;

Select * from transaction,order;

Which sql query correctly lists duplicate order ids and the number of times they have been duplicated in the transaction table, without explicitly using the duplicate order ids or null

Select orderId from transaction group by orderId having count(orderId) > 1;

Select orderId, sum(orderId) from transaction group by orderId having orderId >1;

Select orderId, count(orderId) from transaction group by orderId having count(orderId) > 1;

Select orderId, count(orderId) from transaction group by orderId > 1;

Using the tables above which of the following is a foreign key?

Transaction.date

Order.date

Transaction.orderId

Order.orderId

What is the most efficient way to structure and summarize data in an excel sheet?

Pivot table

Conditional aggregates

Filter

Sort

You have two non-graduated beakers. The first beaker contains 4 litres of water and the

2 steps

5 steps

3 steps

7 steps

Which of these are in the right order for the process of data analytics

Data aggregation, data cleaning , data validation, understanding the business need, tool selection, data visualization

Understanding the business need, data aggregation, data cleaning, data validation, tool selection, data visualization

Tool selection, data cleaning, data validation, data aggregation, understanding the business need, data visualization

Understanding the business need, tool selection, data aggregation, data validation, data cleaning, data visualization

The following section deals with programming and web technologies

Two factor authentication usually involves

Username, password and a secret token

A captcha

Username and password only

None of the above

Deployment in simple terms is:

Setting up a server to run an application

Integrating code into a shared repository several times a day

Recording changes to a file or set of files over time to recall specific versions later

Writing a piece of code to perform a specific task you would otherwise do by hand

What is the difference between Authentication and Authorization?

Authorization verifies who you are, authentication verifies what access you have

Authorization verifies your access level, authentication verifies who you are

Authorization and authentication mean the same thing

Authorization defines ownership, authentication defines reliability

This section tests your problem solving skills and logical reasoning

The person in the circle numbered 1 is

Married, with children

Married, with at least one son

Unmarried, with at least one daughter

Unmarried, with at least one son

Unmarried, with no children

Susan can type 10 pages in 5 minutes. Mary can type 5 pages in 10 minutes. Working together on different computers, how many pages can they type in 30 minutes?

A software engineer has the capability of thinking 100 lines of code in five minutes and can type 100 lines of code in 10 minutes. He takes a break for five minutes after every ten minutes. How many lines of codes will he complete typing after an hour?

250

300

150

200

Robert who is facing east, turns 1000 degrees in the anti-clock-wise direction and then 1450 degrees in the clock-wise direction. Which direction is he facing now?

North

South

East

West

In a shop, a watermelon costs twice as much as a pineapple. A customer bought 3 pineapples and 5 watermelons. If the customer had bought 3 watermelons and 5 pineapples, she would have spent 10 cedis less. How much does a watermelon cost?

In a storey building with an elevator, 2 people live on the ground floor, 4 on the first floor, 5 on the second floor and 6 on the third floor. Which floor calls the elevator the most?

Ground floor

First floor

Second floor

Third floor

Adwoa has 12 black socks and 12 white socks in her drawer. In complete darkness and without looking, how many socks must she take from the drawer in order to be sure to get a pair that match?

In a zoo, there are snakes, elephants and ostriches. A man counted 50 eyes, 40 legs and 6 trunks. How many snakes are in the zoo?

Unlock and Upgrade

Remove all limits from your Quizzes

DREAMOVAL APTITUDE TEST (COMPUTER SCIENCE INTERNS)

More Quizzes