Database Administration Questions


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 2176
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 2173
Q:

Different IP address on same network?

Answer

There are two IP address assigned to each device on a Wi-Fi network.


 


An Internal (Private) and an External (Public) IP address.


 


Internal IP address is used for communication between Your computer and a smartphone or whatever devices that are connected to that Wifi network. This is unique for each. If they are same the system cannot differentiate between each device.


 


While, the External IP address is that visible to the the internet - the websites, the internet connected Apps so on. By default, Routers with NAT (all routers today have it) assign same Public IP address to all devices under its network.

Report Error

View answer Workspace Report Error Discuss

9 2167
Q:

Which of these is an example of personification?

A) The moon smiled at me B) This shirt is as white as snow
C) Water is as hot as sun D) It is like a soft butter
 
Answer & Explanation Answer: A) The moon smiled at me

Explanation:

"The moon smiled at me" is the example of personification in the given options.

 

Personification is a technique in which we give objects human traits like emotions, gestures, speech,... by using metaphor. 

Here moon is an object which cannot smile but using metaphor sense, we gave that sense to it.

Report Error

View Answer Report Error Discuss

Filed Under: English
Exam Prep: AIEEE , Bank Exams , CAT , GATE , GRE , TOEFL
Job Role: Analyst , Bank Clerk , Bank PO , Database Administration , IT Trainer

2 2165
Q:

What is a word made up of 4 letters, yet is also made up of 3. Everything is written with 9 letters, and then with 4. Rarely consists of 6, and never is written with 5.

Answer

The Riddle itself has the Answers.


What is a 4 letter word


Yet is written in 3 letters


Everything is written with 9 letters


Then with 4 letters


Rarely has 6 letters


Never is written in 5 letters.

Report Error

View answer Workspace Report Error Discuss

9 2164
Q:

3/8 as a decimal

A) 1.375 B) 2.375
C) 0.375 D) 3.75
 
Answer & Explanation Answer: C) 0.375

Explanation:

Expressing 3/8 as a decimal fraction:

We can convert 3/8 into a decimal fraction by just dividing 3 by 8 or making 3 into 8 parts.

Then, it is 3/8 = 0.375 as a decimal fraction.

 

Other Method::

3/8 as a Decimal :

In this we should convert the denominator into 10, 100, 1000, 10000, 100000,... to make it simple.

Now to make 8 into 1000, we multiply numerator and denominator with 125

 

=> (3 x 125)/(8 x 125) = 375/1000 = 0.375.

 

Report Error

View Answer Report Error Discuss

3 2150
Q:

We can modify an existing Company from

A) Company Info > Alter B) Gateway of Tally > Modify Company
C) Company Info > Alter Company D) All of the above
 
Answer & Explanation Answer: A) Company Info > Alter

Explanation:
Report Error

View Answer Report Error Discuss

Filed Under: SQL
Job Role: Analyst , Database Administration , IT Trainer

1 2145
Q:

What kind of Room has No Doors or Windows

Answer

Mushroom.

Report Error

View answer Workspace Report Error Discuss

2 2145