All About Oracle

What is a table called, if it does not have neither Cluster nor Non-cluster Index? What is it

noreply@blogger.com (Educational Information) — Fri, 18 Apr 2008 04:06:00 PDT

What is a table called, if it does not have neither Cluster nor Non-cluster Index? What is it used for? Ans: Unindexed table or Heap. Microsoft Press Books and Book On Line (BOL) refers it as...

[[ This is a content summary only. Visit my website for full links, other content, and more! ]]

How to get @@error and @@rowcount at the same time?

noreply@blogger.com (Educational Information) — Fri, 18 Apr 2008 04:07:00 PDT

If @@Rowcount is checked after Error checking statement then it will have 0 as the value of @@Recordcount as it would have been reset. And if @@Recordcount is checked before the error-checking...

[[ This is a content summary only. Visit my website for full links, other content, and more! ]]

What is Identity?

noreply@blogger.com (Educational Information) — Fri, 18 Apr 2008 04:07:00 PDT

Identity (or AutoNumber) is a column that automatically generates numeric values. A start and increment value can be set, but most DBA leave these at 1. A GUID column also generates numbers, the...

[[ This is a content summary only. Visit my website for full links, other content, and more! ]]

What is a Scheduled Jobs or What is a Scheduled Tasks?

noreply@blogger.com (Educational Information) — Fri, 18 Apr 2008 04:07:00 PDT

Scheduled tasks let user automate processes that run on regular or predictable cycles. User can schedule administrative tasks, such as cube processing, to run during times of slow business...

[[ This is a content summary only. Visit my website for full links, other content, and more! ]]

What is De-normalization?

noreply@blogger.com (Educational Information) — Fri, 18 Apr 2008 04:08:00 PDT

De-normalization is the process of attempting to optimize the performance of a database by adding redundant data. It is sometimes necessary because current DBMSs implement the relational...

[[ This is a content summary only. Visit my website for full links, other content, and more! ]]

What are the properties of the Relational tables?

noreply@blogger.com (Educational Information) — Sat, 10 May 2008 02:18:00 PDT

Relational tables have six properties: · Values are atomic. · Column values are of the same kind. · Each row is unique. · The sequence of columns is insignificant. · The sequence of rows is...

[[ This is a content summary only. Visit my website for full links, other content, and more! ]]

What is data integrity? Explain constraints?

noreply@blogger.com (Educational Information) — Sat, 10 May 2008 02:19:00 PDT

Data integrity is an important feature in SQL Server. When used properly, it ensures that data is accurate, correct, and valid. It also acts as a trap for otherwise undetectable bugs within...

[[ This is a content summary only. Visit my website for full links, other content, and more! ]]

What is the basic functions for master, msdb, model, tempdb databases?

noreply@blogger.com (Educational Information) — Sat, 10 May 2008 02:20:00 PDT

The Master database holds information for all databases located on the SQL Server instance and is the glue that holds the engine together. Because SQL Server cannot start without a functioning...

[[ This is a content summary only. Visit my website for full links, other content, and more! ]]

What are primary keys and foreign keys?

noreply@blogger.com (Educational Information) — Sat, 10 May 2008 02:20:00 PDT

Primary keys are the unique identifiers for each row. They must contain unique values and cannot be null. Due to their importance in relational databases, Primary keys are the most fundamental of all...

[[ This is a content summary only. Visit my website for full links, other content, and more! ]]

What is the STUFF function and how does it differ from the REPLACE function?

noreply@blogger.com (Educational Information) — Sat, 10 May 2008 02:21:00 PDT

STUFF function to overwrite existing characters. Using this syntax, STUFF(string_expression, start, length, replacement_characters), string_expression is the string that will have characters...

[[ This is a content summary only. Visit my website for full links, other content, and more! ]]

Using query analyzer, name 3 ways to get an accurate count of the number of records in a

noreply@blogger.com (Educational Information) — Sat, 10 May 2008 02:21:00 PDT

Using query analyzer, name 3 ways to get an accurate count of the number of records in a table? ANS: SELECT * FROM table1 SELECT COUNT(*) FROM table1 SELECT rows FROM sysindexes WHERE id =...

[[ This is a content summary only. Visit my website for full links, other content, and more! ]]

How to rebuild Master Database?

noreply@blogger.com (Educational Information) — Sat, 10 May 2008 02:21:00 PDT

Shutdown Microsoft SQL Server 2000, and then run Rebuildm.exe. This is located in the Program Files\Microsoft SQL Server\80\Tools\Binn directory. In the Rebuild Master dialog box, click Browse. In...

[[ This is a content summary only. Visit my website for full links, other content, and more! ]]

What are three SQL keywords used to change or set someone’s permissions?

noreply@blogger.com (Educational Information) — Sat, 10 May 2008 02:22:00 PDT

GRANT, DENY, and REVOKE.

[[ This is a content summary only. Visit my website for full links, other content, and more! ]]

What does it mean to have quoted_identifier on? What are the implications of having it off?

noreply@blogger.com (Educational Information) — Sat, 10 May 2008 02:22:00 PDT

When SET QUOTED_IDENTIFIER is ON, identifiers can be delimited by double quotation marks, and literals must be delimited by single quotation marks. When SET QUOTED_IDENTIFIER is OFF,...

[[ This is a content summary only. Visit my website for full links, other content, and more! ]]

What are the different types of replication? Explain.

noreply@blogger.com (Educational Information) — Sat, 10 May 2008 02:23:00 PDT

The SQL Server 2000-supported replication types are as follows: · Transactional · Snapshot · Merge Snapshot replication distributes data exactly as it appears at a specific moment in time and does...

[[ This is a content summary only. Visit my website for full links, other content, and more! ]]

What are the OS services that the SQL Server installation adds?

noreply@blogger.com (Educational Information) — Sat, 10 May 2008 02:23:00 PDT

MS SQL SERVER SERVICE, SQL AGENT SERVICE, DTC (Distribution transac co-ordinator)

[[ This is a content summary only. Visit my website for full links, other content, and more! ]]

What is the difference between a local and a global variable?

noreply@blogger.com (Educational Information) — Sat, 10 May 2008 02:24:00 PDT

A local temporary table exists only for the duration of a connection or, if defined inside a compound statement, for the duration of the compound statement. A global temporary table remains in the...

[[ This is a content summary only. Visit my website for full links, other content, and more! ]]

What command do we use to rename a db?

noreply@blogger.com (Educational Information) — Sat, 10 May 2008 02:24:00 PDT

sp_renamedb ‘oldname’ , ‘newname’ If someone is using db it will not accept sp_renmaedb. In that case first bring db to single user using sp_dboptions. Use sp_renamedb to rename database. Use...

[[ This is a content summary only. Visit my website for full links, other content, and more! ]]

What is sp_configure commands and set commands?

noreply@blogger.com (Educational Information) — Sat, 10 May 2008 02:24:00 PDT

Use sp_configure to display or change server-level settings. To change database-level settings, use ALTER DATABASE. To change settings that affect only the current user session, use the SET statement.

[[ This is a content summary only. Visit my website for full links, other content, and more! ]]

What is @@ERROR?

noreply@blogger.com (Educational Information) — Sat, 10 May 2008 02:25:00 PDT

The @@ERROR automatic variable returns the error code of the last Transact-SQL statement. If there was no error, @@ERROR returns zero. Because @@ERROR is reset after each Transact-SQL statement, it...

[[ This is a content summary only. Visit my website for full links, other content, and more! ]]

What is Raiseerror?

noreply@blogger.com (Educational Information) — Sat, 10 May 2008 02:25:00 PDT

Stored procedures report errors to client applications via the RAISERROR command. RAISERROR doesn't change the flow of a procedure; it merely displays an error message, sets the @@ERROR automatic...

[[ This is a content summary only. Visit my website for full links, other content, and more! ]]

What is log shipping?

noreply@blogger.com (Educational Information) — Sat, 10 May 2008 02:25:00 PDT

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...

[[ This is a content summary only. Visit my website for full links, other content, and more! ]]

Which command using Query Analyzer will give you the version of SQL server and operating

noreply@blogger.com (Educational Information) — Sat, 10 May 2008 02:26:00 PDT

Which command using Query Analyzer will give you the version of SQL server and operating system? Ans: SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'),...

[[ This is a content summary only. Visit my website for full links, other content, and more! ]]

What is SQL server agent?

noreply@blogger.com (Educational Information) — Sat, 10 May 2008 02:26:00 PDT

SQL Server agent plays an important role in the day-to-day tasks of a database administrator (DBA). It is often overlooked as one of the main tools for SQL Server management. Its purpose is to ease...

[[ This is a content summary only. Visit my website for full links, other content, and more! ]]

Can a stored procedure call itself or recursive stored procedure? How many level SP nesting

noreply@blogger.com (Educational Information) — Sat, 10 May 2008 02:26:00 PDT

Can a stored procedure call itself or recursive stored procedure? How many level SP nesting possible? Ans: Yes. Because Transact-SQL supports recursion, you can write stored procedures that call...

[[ This is a content summary only. Visit my website for full links, other content, and more! ]]