Database Administration Questions


Q:

The capacity to change the conceptual schema without having to change external schemas or application programs is called

A) Physical Data Independence B) Logical Data Independence
C) Both A and B D) None
 
Answer & Explanation Answer: B) Logical Data Independence

Explanation:

LDI is the capacity to change the conceptual schema without having to change external schemas or application programs.

Report Error

View Answer Report Error Discuss

Filed Under: Database
Job Role: Database Administration

0 4224
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 4219
Q:

Who invented Electric Generator?

A) Michael Faraday B) Thomas Alva Edison
C) Graham Bell D) Alfred Nobel
 
Answer & Explanation Answer: A) Michael Faraday

Explanation:

Michael Faraday invented Electric Generator in 1831.

 

        • The operating principle of electromagnetic generators was discovered in the years of 1831–1832 by Michael Faraday.

 

        • The principle later called Faraday's law, is that an electromotive force is generated in an electrical conductor which encircles a varying magnetic flux.


 

Report Error

View Answer Report Error Discuss

Filed Under: Inventions
Exam Prep: CAT , Bank Exams , AIEEE
Job Role: IT Trainer , Database Administration , Bank PO , Analyst

11 4191
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 4164
Q:

What is the difference between mysql_connect and mysql_pconnect?

Answer

There is a decent page in the php manual on the subject, in short mysql_pconnect() makes a persevering association with the database which implies a SQL join that don't close when the execution of your script closes. mysql_connect()provides just for the database new association while utilizing mysql_pconnect , the capacity would first attempt to locate a (relentless) connection that is as of now open with the same host, username and password. On the off chance that one is found, an identifier for it will be returned as opposed to opening another connection... the connection with the SQL server won't be terminated when the execution of the script ends. Rather, the link will stay open for future use.

Report Error

View answer Workspace Report Error Discuss

Subject: PHP
Job Role: Database Administration

0 4141
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 4138
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

3 4127
Q:

Which of the following memory is volatile?

A) RAM B) Floppy disc
C) ROM D) Magnetic tape
 
Answer & Explanation Answer: A) RAM

Explanation:

Volatile memory is computer memory that requires power to maintain the stored information. It is a temporary memeory which cannot contain information permanently.

Example :: RAM or Random Access Memory

Report Error

View Answer Report Error Discuss

4 4118