Database Administration Questions


Q:

What kind of Room has No Doors or Windows

Answer

Mushroom.

Report Error

View answer Workspace Report Error Discuss

2 2220
Q:

What does a VLAN do?

A) Breaks up broadcast domains in a layer 2 switch internetwork B) Provides multiple broadcast domains within a single collision domain
C) Provides multiple collision domains on one switch port D) Acts as the fastest port to all servers
 
Answer & Explanation Answer: A) Breaks up broadcast domains in a layer 2 switch internetwork

Explanation:

virtual LAN (VLAN) is any broadcast domain that is partitioned and isolated in a computer network at the data link layer (OSI layer 2). LAN is the abbreviation for local area network and in this context, virtual refers to a physical object recreated and altered by additional logic.

VLANs work by applying tags to network packets and handling these tags in networking systems – creating the appearance and functionality of network traffic that is physically on a single network but acts as if it is split between separate networks. In this way, VLANs can keep network applications separate despite being connected to the same physical network, and without requiring multiple sets of cabling and networking devices to be deployed.

Report Error

View Answer Report Error Discuss

0 2211
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 2209
Q:

IP addresses are converted to

A) A binary string B) A domain name
C) Alphanumeric string D) A hexadecimal string
 
Answer & Explanation Answer: B) A domain name

Explanation:

IP addresses are converted to a domain name by DNS - Domain Name System.

Report Error

View Answer Report Error Discuss

7 2206
Q:

Land is considered a resource because it

A) is used to produce things B) requires labor to be useful
C) is always available to use D) costs little or nothing to use
 
Answer & Explanation Answer: A) is used to produce things

Explanation:

Land is considered as an important resource because it is useful in producing many things. For example, in agriculture, land is used for cultivating the crop, in industrial use, it is used for constructing factories and to make products that we use.

Report Error

View Answer Report Error Discuss

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

1 2204
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 2199
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 2197
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 2182