Database Administration Questions


Q:

Which of the following describes a relational database?

A) It retrieves data related to its queries B) It provides a relationship between floats
C) It provides a relationship between integers D) It consists of separate tables or related data
 
Answer & Explanation Answer: D) It consists of separate tables or related data

Explanation:

A relational database is a digital database based on the relational model of data, a database structured to recognize relations between stored items of information. A software system used to maintain relational databases is a relational database management system.

 

Computer database in which all data is stored in Relations which (to the user) are tables with rows and columns. Each table is composed of records (called Tuples) and each record is identified by a field (attribute) containing a unique value. Every table shares at least one field with another table in 'one to one,' 'one to many,' or 'many to many' relationships. These relationships allow the database user to access the data in almost an unlimited number of ways, and to combine the tables as building blocks to create complex and very large databases.

Report Error

View Answer Report Error Discuss

36 4678
Q:

What is conversion operator ?

Answer

Class can have a public method for specific data type conversions.
for example:
class B
{
double value;
public  B(int i )
operator double()
{
return value;
}
};
B BObject;
double i = BObject; // assigning object to variable i of type double.
now conversion operator gets called to assign the value.

Report Error

View answer Workspace Report Error Discuss

11 4664
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 4662
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 4653
Q:

Breaking of relationships is allowed once referential integrity on a database is enforced

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

Explanation:

Breaking of relationships is prevented once referential integrity on a database is enforced

Report Error

View Answer Workspace Report Error Discuss

0 4653
Q:

Cloud computing uses Server virtualization.

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

Explanation:

Cloud computing :: 


Cloud computing is an information technology (IT) paradigm that enables ubiquitous access to shared pools of configurable system resources and higher-level services that can be rapidly provisioned with minimal management effort, often over the Internet.


 


Server virtualization :


Server virtualization is a virtualization technique that involves partitioning a physical server into a number of small, virtual servers with the help of virtualization software. In server virtualization, each virtual server runs multiple operating system instances at the same time.


cloud-computing_server_virtuaization1532503685.jpg image


 


Server virtualization is more for a good reason. It offers the potential to dramatically save space and improve server efficiency. Vendors are in fierce competition to offer the most advanced tools that they hope will earn them the virtualization crown.


 


Hence, the given statement that 'Cloud computing uses Server virtualization.' is TRUE.


 


 

Report Error

View Answer Workspace Report Error Discuss

37 4645
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 4644
Q:

The Indian to beat the computers in mathematical wizardry is

A) Shakuntala Devi B) Raja Ramanna
C) Rina Panigrahi D) Ramanujam
 
Answer & Explanation Answer: A) Shakuntala Devi

Explanation:
Report Error

View Answer Report Error Discuss

3 4618