Technology Questions

Q:

How to rebuild Master Database?

Answer

Master database is system database and it contains information about running server's configuration. When SQL Server 2005 is installed it usually creates master, model, msdb, tempdb resource and distribution system database by default. Only Master database is th one which is absolutely must have database. Without Master database SQL Server cannot be started. This is the reason it is extremely important to backup Master database.


To rebuild the Master database, Run Setup.exe, verify, and repair a SQL Server instance, and rebuild the system databases. This procedure is most often used to rebuild the master database for a corrupted installation of SQL Server.

Report Error

View answer Workspace Report Error Discuss

Subject: SQL

0 3937
Q:

Write SQL Query to find second highest salary of Employee.

Answer

There are many ways to find second highest salary of Employee in SQL, you can either use SQL Join or Subquery to solve this problem. Here is SQL query using Subquery :


SELECT MAX(Salary) from Employee WHERE Salary NOT IN (select MAX(Salary) FROM Employee );

Report Error

View answer Workspace Report Error Discuss

Subject: SQL

2 3932
Q:

What is difference between baseband and broadband transmission?

Answer

In a baseband transmission, the entire bandwidth of the cable is consumed by a single signal. In broadband


transmission, signals are sent on multiple frequencies, allowing multiple signals to be sent simultaneously.

Report Error

View answer Workspace Report Error Discuss

1 3931
Q:

Which utility allows you to reference an assembly in an application?

Answer

An assembly can be referenced by using the gacutil.exe utility with the /r option. The /r option requires a reference type, a reference ID, and a description.

Report Error

View answer Workspace Report Error Discuss

Subject: .NET

1 3926
Q:

What are the advantages of using friend classes?

Answer

- Friend classes are useful when a class wants to hide features from users which are needed only by another, tightly coupled class. 


- Implementation details can be kept safe by providing friend status to a tightly cohesive class.

Report Error

View answer Workspace Report Error Discuss

Subject: C++

0 3924
Q:

What COBOL construct is the COBOL II EVALUATE meant to replace?

Answer

EVALUATE can be used in place of the nested IF THEN ELSE statements.

Report Error

View answer Workspace Report Error Discuss

0 3914
Q:

What is the difference between characters 23 and x23?

Answer The first one is octal 23, the second is hex 23
Report Error

View answer Workspace Report Error Discuss

Subject: PHP

0 3912
Q:

How would you automatically transfer your visitors to a new web page?

Answer

- You can do it with the help of meta tag mentioned below: 


<META HTTP-EQUIV="Refresh" CONTENT="2"; URL="https://www.yourname.com"> 


- Place this tag between <HEAD></HEAD> . 


- It will load yousite.com in 2 seconds.

Report Error

View answer Workspace Report Error Discuss

Subject: Web Technology

1 3899