Database Administration Questions


Q:

What can you break but not touch?

A) Mirror B) Word
C) Promise D) All of the above
 
Answer & Explanation Answer: C) Promise

Explanation:

A promise. 

 

The Promise made to somebody by you can be break but you cannot touch it.

Report Error

View Answer Report Error Discuss

4 2184
Q:

Importance of project life cycle?

Answer

A project has a beginning and an end and passes through several phases of development known as life cycle phases. Every project has certain phases of development. A clear understanding of these phases allows managers and executives to maintain control of the project more efficiently.
These phases are varied depending upon the industry involved but all follow the same basic steps.


 


How Important is Project Life Cycle::


1. This is a tried and tested method for delivering projects on time, within budget and to the expected quality targets.


2. Aids communication and helps define roles within the project organisation as it provides a framework for the project that is visible and understood by all members of the project.


3. The project lifecycle will allow the project manager to link progress directly to each phase and recognise the completion of each phase


4. The phases within the project lifecycle provide an understanding of the evolution of the project, being able to identify areas that need greater attention at different times such as risk management in the early stages and more Project Evaluation Reviews during the Implementation stage.


5. At each stage, approval is generally required from outside the project team before proceeding to the next stage.


6. The project life cycle also allows for the gate procedure to be used.


7. At each stage, approval is generally required from outside the project team before proceeding to the next stage.

Report Error

View answer Workspace Report Error Discuss

6 2182
Q:

Which sentence is punctuated correctly?

A) One question you should always ask yourself: “Am I pleased with the results?” B) Always ask yourself this question: “Am I pleased with the results?
C) Always ask yourself a question like: “Am I pleased with the results?” D) One question you should always ask yourself is: “Am I pleased with the results?”
 
Answer & Explanation Answer: A) One question you should always ask yourself: “Am I pleased with the results?”

Explanation:

The second would employ a comma, or semi-colon, and not a colon so it is not properly punctuated.

 

The third sentence would not be correct because it uses 'like', usually used for comparison. Since you are not comparing two questions, it would not be appropriate.

 

The fourth sentence has 'is' before the colon, which is a implies declaration and not listing. So, again, it would not be appropriate.

 

Hence, the first sentence, however, is punctuated correctly.

Report Error

View Answer Report Error Discuss

7 2180
Q:

Explain Data Control Language

Answer

Data Control Language (DCL):-statements to take care of the security and authorization.


Examples:



    1. GRANT

    2. REVOKE

Report Error

View answer Workspace Report Error Discuss

2 2174
Q:

What is Log Shipping?

Answer

Log shipping defines the process for automatically taking backup of the database and transaction files on a SQL Server and then restoring them on a standby/backup server. This keeps the two SQL Server instances in sync with each other. In case production server fails, users simply need to be pointed to the standby/backup server. Log shipping primarily consists of 3 operations:


Backup transaction logs of the Production server.


Copy these logs on the standby/backup server.


Restore the log on standby/backup server.

Report Error

View answer Workspace Report Error Discuss

2 2171
Q:

In a spreadsheet program how is data organized?

A) Rows and columns B) Layers and planes
C) Lines and spaces D) All of the above
 
Answer & Explanation Answer: A) Rows and columns

Explanation:
Report Error

View Answer Report Error Discuss

1 2162
Q:

The resolution of a printer is measured in

A) DPI B) Megabits
C) Hertz D) Inches
 
Answer & Explanation Answer: A) DPI

Explanation:

Dots per inch (DPI, or dpi) is a measure of spatial printing or video or image scanner dot density, in particular the number of individual dots that can be placed in a line within the span of 1 inch (2.54 cm).

Report Error

View Answer Report Error Discuss

1 2157
Q:

If you are using C language to implement the heterogeneous linked list, what pointer type will you use?

Answer

The heterogeneous linked list contains different data types in its nodes and we need a link, pointer to connect them. It is not possible to use ordinary pointers for this. So we go for void pointer. Void pointer is capable of storing pointer to any type as it is a generic pointer type.

Report Error

View answer Workspace Report Error Discuss

Subject: Database Exam Prep: GATE
Job Role: Database Administration

0 2153