Interview Questions

Q:

Whar are the Difference between online and offline backups?

Answer

- Online backup is one which is taken at the time the database is running in the ARCHIVELOG mode.


- Following files should be backed up during the Offline Backup: All data file, all control file and all online redo log file. But in the case of the online backup following files is backed up: All data files all archived redo log files and one control file via the alter database command.


- Offline database we cannot rely upon but in case of online database no issues.


- Offline backup no archived mode is required but in the online backup it is must.

Report Error

View answer Workspace Report Error Discuss

Subject: Oracle

0 3955
Q:

What’s the difference between accessing a class method via -> and via ::?

Answer :: is allowed to access methods that can perform static operations, i.e. those, which do not require object initialization.
Report Error

View answer Workspace Report Error Discuss

Subject: PHP

0 3955
Q:

Which SQL keyword is used to sort the result-set?

A) ORDER B) ORDER BY
C) SORT BY D) SORT
 
Answer & Explanation Answer: B) ORDER BY

Explanation:

SQL keyword ORDER BY is used to sort the result-set.

Report Error

View Answer Report Error Discuss

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

1 3944
Q:

What are type safe function pointers?

A) Delegates B) Break points
C) Both A and B D) None
 
Answer & Explanation Answer: A) Delegates

Explanation:

A delegate declares a ref type that references a named of anonymous method. Delegates are secure and type-safe.

Report Error

View Answer Report Error Discuss

Filed Under: .NET

1 3940
Q:

What is 255.255.255.255 used for?

Answer

Research

Report Error

View answer Workspace Report Error Discuss

4 3938
Q:

What is Log Shipping?

Answer

Log shipping is the process of automating the backup of database and transaction log files on a production SQL server, and then restoring them onto a standby server. Enterprise Editions only supports log shipping. In log shipping the transactional log file from one server is automatically updated into the backup database on the other server. If one server fails, the other server will have the same db and can be used this as the Disaster Recovery plan. The key feature of log shipping is that it will automatically backup transaction logs throughout the day and automatically restore them on the standby server at defined interval.

Report Error

View answer Workspace Report Error Discuss

Subject: SQL

0 3936
Q:

A check returned by the bank marked nsf means

A) Cheque has been forged B) Cheque can't be cashed being illegal
C) There are not sufficient funds in your accoun D) Bank can't verify your identity
 
Answer & Explanation Answer: C) There are not sufficient funds in your accoun

Explanation:

NSF means - Not Sufficient Funds.

Report Error

View Answer Report Error Discuss

Filed Under: Bank Interview
Exam Prep: AIEEE , Bank Exams , CAT , GATE
Job Role: Analyst , Bank Clerk , Bank PO

0 3928
Q:

What are the different types of assemblies? Explain them in detail.

Answer

The following are the two types of assemblies:



          =>  Private Assembly - Refers to the assembly that is used by a single application. Private assemblies are kept in a local folder in which the client application has been installed.

          =>  Public or Shared Assembly - Refers to the assembly that is allowed to be shared by multiple applications. A shared assembly must reside in Global Assembly Cache (GAC) with a strong name assigned to it.


For example, imagine that you have created a DLL containing information about your business logic. This DLL can be used by your client application. In order to run the client application, the DLL must be included in the same folder in which the client application has been installed. This makes the assembly private to your application. Now suppose that the DLL needs to be reused in different applications. Therefore, instead of copying the DLL in every client application folder, it can be placed in the global assembly cache using the GAC tool. These assemblies are called shared assemblies.

Report Error

View answer Workspace Report Error Discuss

Subject: .NET

0 3926