Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...

Un-Answered Questions { Databases }

How to set the time zone for MySQL to particular country time?

2344


what is difference between 1.append to media 2.overright the existing media when we take back up in sql server2000

1207


can we delete autodiff back up that we have set through sql server agent.

1381


How would you go about increasing the buffer cache hit ratio?

1423


Explain the difference between $ORACLE_HOME and $ORACLE_BASE.

5757


Explain the use of table functions.

1310


Where in the Oracle directory tree structure are audit traces placed?

1544


How would you determine what sessions are connected and what resources they are waiting for?

1174


Give two methods you could use to determine what DDL changes have been made.

5213


What view would you use to determine free space in a tablespace?

1309


How would you determine who has added a row to a table?

1326


What is an SQL FORMS ?

1894


Can you give me some DBCC command options?(Database consistency check) - DBCC CHECKDB - Ensures that tables in the db and the indexes are correctly linked.and DBCC CHECKALLOC - To check that all pages in a db are correctly allocated. DBCC SQLPERF - It gives report on current usage of transaction log in percentage. DBCC CHECKFILEGROUP - Checks all tables file group for any damage.

1635


What is log shipping? Can we do logshipping with SQL Server 7.0 - Logshipping is a new feature of SQL Server 2000. We should have two SQL Server - Enterprise Editions. From Enterprise Manager we can configure the logshipping. In logshipping 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 we can use this as the DR (disaster recovery) plan.

1857


Scalability, Availability, Integration with internet, etc.)?

1978