Database Administration Questions


Q:

Which of the following is NOT an objective of service transition ?

A) To plan and manage the capacity and resource requirements to manage a release B) To provide quality knowledge and information about services and service assets
C) To provide training and certification in project management D) To ensure that a service can be operated, managed and supported
 
Answer & Explanation Answer: C) To provide training and certification in project management

Explanation:
Report Error

View Answer Report Error Discuss

7 5454
Q:

Define "Correlated Subqueries" ?

Answer

In a SQL Database, a 'correlated subquery' is a kind of sub query yet connected subquery is dependent on another query for a value that is returned. In case of execution, the sub query is executed first and afterwards the correlated query will be executed.

Report Error

View answer Workspace Report Error Discuss

6 1948
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 2335
Q:

What do you mean by APM ?

Answer

APM is abbreviated as Advanced Power Management, which was developed by Microsoft and Intel as an API. This API is mainly utilised for power management, and is very useful especially to those using Windows on their laptops or desktops.

Report Error

View answer Workspace Report Error Discuss

5 1041
Q:

What is the maximum number of characters when applying MsgBox and InputBox ?

Answer

The maximum number of characters allowed is 1024 characters.

Report Error

View answer Workspace Report Error Discuss

13 1890
Q:

What is the name of the service included with the Windows Server operating system that manages a centralized database containing user account and security information ?

A) Windows Directory B) Active Directory
C) Directory Plus D) None of the above
 
Answer & Explanation Answer: B) Active Directory

Explanation:

Active Directory (AD) is a centralized database that is included with the Windows Server operating system. Active Directory is used to store information about a network, such as user accounts, computers, printers, and security policies.

Report Error

View Answer Report Error Discuss

7 4443
Q:

Which of the following are displayed in File Explorer ?

A) Only OneDrive B) Only Storage locations
C) Both A & B D) Hardware devices such as monitors, printers, and cameras
 
Answer & Explanation Answer: C) Both A & B

Explanation:

Storage locations and OneDrive are both displayed in File Explorer.

Report Error

View Answer Report Error Discuss

8 1476
Q:

Both Joyel and Susy share a Windows 10 tablet with different user accounts. Joyel needs to access some files in Susy’s Documents folder. How can he do this ?

A) Joyel can access the files only if he has administrative rights B) Susy must choose to make the Documents folder Public for Joyel to see them
C) Joyel can, by default, see and access the files in any Documents folder on this computer D) Joyel cannot access those files without Susy moving them to another folder
 
Answer & Explanation Answer: A) Joyel can access the files only if he has administrative rights

Explanation:
Report Error

View Answer Report Error Discuss

5 1164