Database Administration Questions


Q:

A column defined as UNIQUE can contain Nulls while a column defined as PRIMARY KEY can't contain Nulls

A) TRUE B) FALSE
Answer & Explanation Answer: A) TRUE

Explanation:

Because a table can have only one primary key

Report Error

View Answer Workspace Report Error Discuss

1 4515
Q:

Sravan drove from home to a neighboring town at the speed of 50 km/h and on his returning journey, he drove at the speed of 45 km/h and also took an hour longer to reach home. What distance did he cover?

A) 350 kms B) 450 kms
C) 900 kms D) 700 kms
 
Answer & Explanation Answer: C) 900 kms

Explanation:

Let the distance he covered each way = d kms

According to the question,

d/45 - d/50 = 1

=> d = 450 kms.

 

Hence, the total distance he covered in his way = d + d = 2 d = 2 x 450 = 900 kms.

Report Error

View Answer Report Error Discuss

14 4512
Q:

The ratio of two positive numbers is 3 : 5 and the average of the number is 48. What is the product of numbers?

A) 3365 B) 2160
C) 1854 D) 1632
 
Answer & Explanation Answer: B) 2160

Explanation:

Let the number be 3p and 5p

ATQ,

8p = 2 x 48

p = 96/8

p = 12

 

The numbers are 36 and 60.

 

Hence, the product of the numbers = 36 x 60 = 2160.

Report Error

View Answer Report Error Discuss

3 4500
Q:

World's smallest Computer is unveiled by

A) Infosys B) Intel
C) IBM D) Microsoft
 
Answer & Explanation Answer: C) IBM

Explanation:

IBM has unveiled the world's smallest computer - a device no bigger than a grain of salt. Presented at the company's Think 2018 conference in Las Vegas, Nevada, the unit measures just 1mm by 1mm but has the same processing power as the x86 chip that ran early Nineties IBM desktop computers.

Report Error

View Answer Report Error Discuss

2 4500
Q:

Which of the following is true of VoIP?

A) It uses the public switched telephone network. B) Skype is an example of VoIP software.
C) It uses a slow speed dial-up connection. D) All of the above
 
Answer & Explanation Answer: B) Skype is an example of VoIP software.

Explanation:

VOIP is an acronym for Voice Over Internet Protocol, or in more common terms phone service over the Internet.

 

Voice over Internet Protocol is a category of hardware and software that enables people to use the Internet as the transmission medium for telephone calls by sending voice data in packets using IP rather than by traditional circuit transmissions of the PSTN.

 

Here in the given options, Skype is the only voice service that enables us to talk over internet.

Report Error

View Answer Report Error Discuss

7 4498
Q:

MS-EXCEL is based on

A) OS/2 B) UNIX
C) WINDOWS D) DOS
 
Answer & Explanation Answer: C) WINDOWS

Explanation:

Microsoft Excel is a spreadsheet developed by Microsoft for Windows, macOS, Android and iOS. It features calculation, graphing tools, pivot tables, and a macro programming language called Visual Basic for Applications.

Report Error

View Answer Report Error Discuss

4 4484
Q:

From a group of 7 boys and 6 girls, five persons are to be selected to form a team, so that at least 3 girls are there in the team. In how many ways can it be done?

A) 427 B) 531
C) 651 D) 714
 
Answer & Explanation Answer: B) 531

Explanation:

Given in the question that, there are 7 boys and 6 girls. 

Team members = 5

Now, required number of ways in which a team of 5 having atleast 3 girls in the team = 

6C3  x 7C2  + 6C4 x 7C1 + 6C5= 6x5x43x2x1 x 7x62x1 + 6x5x4x34x3x2x1 x 7 + 6x5x4x3x25x4x3x2x1= 420 + 105 + 6= 531.

Report Error

View Answer Report Error Discuss

5 4474
Q:

What cannot be performed from the windows task manager?

A) Open a program B) Check recent CPU usage
C) Delete a program from the hard drive D) View what applications are running in the background
 
Answer & Explanation Answer: C) Delete a program from the hard drive

Explanation:

The task manager enables you to monitor processes, applications and services currently running on your computer. You can use it to start and stop programs and processes. In addition, you can use the task manager to show informative stats about your PC’s performance and network.

 


Hence, to delete a program from the hard drive, you have to go to the control panel to uninstall an application properly.

 

Report Error

View Answer Report Error Discuss

6 4472