Database Administration Questions


Q:

Which of the following is system software?

A) MS Paint B) MS Excel
C) MS Word D) MS Windows
 
Answer & Explanation Answer: D) MS Windows

Explanation:

We know that, the collection of programs which performs specific tasks in a computer is called as software. Software in a computer is of two types. They are :

 

1. Aplication Software

2. System Software

 

System software is a computer program that performs the basic functionaility of a computer i.e, running a systems hardware and applications like loading programs, saving data, displaying, etc...

Report Error

View Answer Report Error Discuss

1 2590
Q:

How can you describe an operational level agreement (OLA) ?

A) It is a legally binding contract outlining services delivered to an IT service provider that underpin a service that provider delivers to its customers. B) It is a written agreement between a supplier and the IT customer(s), defining the key service targets and responsibilities of both parties.
C) It contains targets that underpin those within an SLA to ensure that targets will not be breached by failure of the supporting activity. D) It is an agreement between a supplier and another part of the same organization that assists with the provision of services.
 
Answer & Explanation Answer: D) It is an agreement between a supplier and another part of the same organization that assists with the provision of services.

Explanation:

An agreement between an IT service provider and another part of the same organization. An OLA supports the IT service provider's delivery of services to customers. The OLA defines the goods or services to be provided and the responsibilities of both parties.

 

* For an example there be an OLA - between the IT service provider and a acquiring department to obtain hardware in discussed times - between the Service Desk and a support group to provide Incident resolution in accepted times.

Report Error

View Answer Report Error Discuss

7 2590
Q:

70000 a year is how much an hour?

A) 80 B) 8
C) 0.8 D) 0.08
 
Answer & Explanation Answer: B) 8

Explanation:

Given for year = 70000

=> 365 days = 70000

=> 365 x 24 hours = 70000

=>   1 hour = ?

70000/365x24 = 7.990 = 8

Report Error

View Answer Report Error Discuss

3 2589
Q:

Which continent has the least countries?

A) Africa B) South America
C) Antarctica D) Europe
 
Answer & Explanation Answer: C) Antarctica

Explanation:

Africa - 54 countries

South America - 12 countries

Antarctica - 0 countries

Europe - 43 countries.

 

Hence, Antarctica continent has the least countries.

Report Error

View Answer Report Error Discuss

0 2588
Q:

At what temperature (in Fahrenheit) pure water freezes?

A) 0 B) 17
C) 32 D) 39
 
Answer & Explanation Answer: C) 32

Explanation:

32oFWe know that T(°F) = T(°C) × 1.8 + 3232(°F) = 0(°C)

Report Error

View Answer Report Error Discuss

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

10 2584
Q:

Which command is used to return maximum value from result set?

A) MAX B) MIN
C) MAXIMUM D) MAXI
 
Answer & Explanation Answer: A) MAX

Explanation:

MAX command is used to return maximum value from result setMAX 

Report Error

View Answer Report Error Discuss

1 2580
Q:

HTML documents are saved in

A) Machine language codes B) ASCII text
C) Special binary format D) None of the above
 
Answer & Explanation Answer: B) ASCII text

Explanation:

Word and WordPad can save documents as ASCII text and HTML, but this approach can lead to problems. NotePad should launch with a new document open.

From the File pull-down menu, Select "Save As," save the file to the Desktop, and name the file using the ".html" extension (e.g., "home.html").

Report Error

View Answer Report Error Discuss

0 2569
Q:

What is the difference between a Local and a Global temporary table?

Answer

Local :


Only available to the current Db connection for current user and are cleared when connection is closed.


Multiple users can’t share a local temporary table.


 


Global:


Available to any connection once created. They are cleared when the last connection is closed.


Can be shared by multiple user sessions

Report Error

View answer Workspace Report Error Discuss

1 2564