Interview Questions.

Question 1. How Do I Tell Which Tables Have Identities In Sybase?

Answer :

You can inform if a table has identities one in every of two methods:
1. Sp_help [tablename]: there may be a area blanketed within the sp_help output
describing a table referred to as “Identity.” It is ready to at least one for identification fields, 0 in any other case.
2. Within a database, execute this query:

 choose object_name(identification) “desk”,call “column”, prec “precision”
 from syscolumns
 in which convert(bit, (status & 0x80)) = 1
 move
this could listing all the tables and the sphere in the table that serves as an identity, and the dimensions of the identity field.

Question 2. Explain About The Sybase Group?

Answer :

Sybase completely makes a speciality of mobilizing and dealing with facts. It is thought to be the 1/3 largest database management corporation after Oracle and IBM. Sybase products on Investment banking are widely known to internationally and it offers many customized answers for business intelligence.

IBM DB2 Interview Questions
Question three. State Some Of The Products Of Sybase?

Answer :

Sybase has worlds leading merchandise a number of them are

 ASE
 Avantgo
 Power builder and strength designer
 SQL ianywhere
 Sybase IQ
 Sybase replication server
 Sybase RTE
 Sybase information federation
 Main frame join
Question 4. What Is The Depth Of Triggers?

Answer :

sixteen Levels i.E. 16 nested triggers can be there in Sybase

IBM DB2 Tutorial
Question five. State Some Of The Criticism About Sybase Iq?

Answer :

Sybase garage systems are optimized for Dataware housing applications in which information cannot be changed can be changed by using looking and getting access to the statistics. Its column based search criteria offers excessive overall performance for search but it negates the writing functionality to the information. Performance for row based relational based totally databases is worse due to the fact it's far very difficult for updating and editing them.

RDBMS Interview Questions
Question 6. What Are Triggers? Why Do We Use Them? Diff Types Of Triggers? What Are Magic Tables?

Answer :

A trigger is a stored method bound to a table, that's implicitly finished when a person tries to modify data with an insert, delete, or update command.
Use :   i. Validation cause
           ii.Referential integrity
Type of cause: –
           i. Replace
           ii. Delete
           iii.Insert
Two tables are created at the time of cause execution
1. Inserted
2. Deleted  which can be referred to as magic tables.

Question 7. What Are Stored Procedures?

Answer :

Stored manner is a database item that is series of SQL statements or constructs. Parameters can be passed and returned, and errors codes may be checked. Stored methods, after their first execution, end up reminiscence resident and do not want to be reparsed, reoptimized, or recompiled. So they are faster.

PHP Tutorial DBMS Interview Questions
Question 8. Explain What Is Update Statistics In Sybase?

Answer :

The replace statistics command facilitates the server make the great selections about which indexes to use when it tactics a question, by offering records about the distribution of the important thing values within the indexes. The update information commands create information, if there are no statistics for a specific column, or replaces present information if they already exist. The facts are stored within the machine tables systabstats and sysstatistics.

Question 9. Explain The Structure Of Adaptive Server Enterprise?

Answer :

Structure of ASE set up hosts numerous databases and it accommodates of one records server. Also system documents occupy handiest one meta facts. User databases are saved within the form of tables. Security and information privateness may be covered with the aid of setting permissions.

PHP Interview Questions
Question 10. Explain About The Features Of Sybase Iq?

Answer :

Sybase IQ stores information base inside the form of columns of records as an alternative in rows. This storage version improves the accessibility and search criteria for the data. Performance of the hunt standards improves substantially because it searches simplest columns instead of the rows and columns of the database. This is also environment friendly.

SQL Server 2008 Tutorial
Question eleven. Explain The Benefits You Can Get From Mainframe Connect?

Answer :

These are the subsequent benefits you could get from mainframe join: –
1) Client packages can be enabled. External software's may be linked to the mainframe join for higher performance.
2) Mainframe packages connect with external information via LAN.
3) New programs can be created which enables you to connect with outside statistics or source of statistics.

SQL Server 2008 Interview Questions
Question 12. Explain About The Mainframe Connect Tools From Sybase?

Answer :

This connectivity tool offers get right of entry to to excessive performance gear which connects you very fast to the principle frame information assets. It gives you study and write get right of entry to to databases. It additionally has a facility with the aid of which you may connect the main frame statistics to secondary records garage facilities.

IBM DB2 Interview Questions
Question 13. Explain About Power Designer Data Modeling Software?

Answer :

Power clothier has two particular equipment referred to as Link and Sync technology.This era gives Data base designers to design green statistics models through which one can provide efficient design. Also Data base designers can share sources amongst them with a purpose to enhance the productiveness and performance

Oracle 11g Tutorial
Question 14. Explain About The Data Integration Suite Features?

Answer :

Data integration suite gives advanced improvement and control gear. Integration of records may be very easy and green as you may navigate your records to a precise cope with with out a good deal trouble. The 5 crucial capabilities are ETL, Data federation, Replications, Real time activities and search activities.

Question 15. What Is The Difference In Storage Type Of Numeric And Decimal Data Types In Sybase?

Answer :

The numeric and decimal sorts are same in all respects but one:
Only numeric sorts with a scale of zero may be used for the IDENTITY column

Oracle 11g Interview Questions
Question 16. Explain About Enterprise Scalability And Roi Of Data Integration Suite?

Answer :

Enterprise scalability affords elevated capacity with none new addition of hardware. It will increase the capability by using increasing the supply within the organization facts layer.
ROI: – Streamlining of application tasks and decreasing information management fees, data federation increases ROI. Complexity and advanced choice making alternatives make ROI exceptional in its magnificence.

DB2 Using SQL Tutorial
Question 17. Give The Benefits Of Data Integration Suite?

Answer :

Some of the blessings which you may get from a Data integration suite are 
Flexibility: ­This suite offers a extra flexibility to comprise facts from various sources which includes internet, record systems, and many others and it can switch this information to third party applications including SQL, manufacturing systems, and many others.

DB2 Using SQL Interview Questions
Question 18. What Is Procedure Cache And Data Cache In Sybase?

Answer :

Procedure cache is the memory area in which compiled query tree run e.G, technique, batch question. Data Cache is the memory region wherein facts that is required for the cutting-edge querys strolling is offered from Disk directly to reminiscence for building result sets.

RDBMS Interview Questions
Question 19. Explain About Mirror Activator Disk Mirroring?

Answer :

This software program works with storage replication systems and replicates the database to an to be had ASE or any database lower back up devices such as oracle. It will increase the safety of applications and additionally reduces the fail through the years for information programs.

Java Tutorial
Question 20. Explain About Open Switch Business Continuity Software?

Answer :

Open switch enterprise software lets you paintings on the back up machine with none hassles making your number one database server secured. It offers you connectivity to the primary database from the secondary server even within the center of the utility.

MYSQL DBA Interview Questions
Question 21. Explanation About Replication Server Software?

Answer :

Replication server software makes you to manipulate more than one facts systems very without difficulty. Some of the capabilities which it presents are heterogeneous replication and synchronization throughout diverse programs bi directionally. It affords services from the client to server and server to customer.

Question 22. What Is A Coalesce? What Is The Equivalent Of Oracle/db2 Coalesce Function In Sybase?

Answer :

Coalesce is also to be had in Sybase This capabilities evaluates the indexed expressions and returns the primary non­null value. If all the expressions are null, coalesce returns null 
USAGE: coalesce(expression, expression [, expression]…)
EXAMPLE: coalesce(initialqty,finalqty,middleqty)
Returns the first occurrence of a non­NULL value in either the initialqty or finalqty or middleqty

 

Question 23. What Is The Relationship Between Jdbc And Sybase?

Answer :

JDBC is a Application programming Interface which allows Java Developers to have interaction with Database like Sybase via DML Statements (Insert, Update, Delete and so on).

Database Administration Interview Questions
Question 24. What Is The Command For Quitting From Sybase?

Answer :

syb_quit(zero) command can be used to go out from Sybase database .

 

DBMS Interview Questions
Question 25. How To Start/stop Ase When Cpu Reboots?

Answer :

Below is an example of the various documents (on Irix) which might be had to start/forestall an ASE. The records can without difficulty be prolonged to any UNIX platform. The idea is to allow as a whole lot flexibility to the 2 classes of directors who control the gadget:
* The System Administrator
* The Database Administrator
Any errors delivered with the aid of the DBA will not interfere with the System Administrator’s job. 
With that in thoughts we have the device startup/shutdown file /and many others/init.D/sybase invoking a script defined through the DBA: 
/usr/sybase/sys.Config/begin,forestall.Sybase 
/and so on/init.D/sybas

 

 

Question 26. What Is Open Server In Sybase?

Answer :

Sybase open server is a critical component of Sybase and Microsoft Open Data Services . The Sybase open server is a major issue for dealing with disbursed database structures and as a result forms a essential and powerful server side thing of Sybase systems . One of the important characteristic of this is Sybase open server is interoperability.

 

Autosys Interview Questions
Question 27. Does Table Partitioning Require User Defined Segments In Sybase?

Answer :

No. By design, every desk is intrinsically assigned to one phase, called the default segment. When a desk is partitioned, any partitions on that table are dispensed a number of the gadgets assigned to the default phase.In the instance beneath “How Do I Create A Partitioned Table That Spans Multiple Devices?”, the desk sits on a consumer­described segment that spans three gadgets

PHP Interview Questions
Question 28. How Do I Choose Which Tables To Partition In Sybase?

Answer :

You ought to partition heap tables which have huge quantities of concurrent insert hobby. (A heap table is a table with out a clustered index.) Here are some examples:
1. An “append­simplest” desk to which every transaction need to write.
2. Tables that offer a history or audit list of sports.
Three. A new table into which you load facts with bcp in. Once the records is loaded in, you may unpartition the desk. This allows you to create a clustered index on the table, or difficulty different commands now not accepted on a partition table.

Question 29. Can I Partition Any Table In Sybase?

Answer :

No. You can not partition the subsequent styles of tables:
1. Tables with clustered indexes (as of launch 11.Five it is feasible to have a clustered index on a partitioned desk).
2. ASE machine tables.
3. Work tables.
Four. Temporary tables.
Five. Tables which might be already partitioned. However, you may unpartition after which re­partition tables to alternate the range of walls.

Java Interview Questions
Question 30. How To View The Log Files In Sybase?

Answer :

cd $SYBASE/$SYBASE_ASE/deploy

Question 31. How To Save Space When Inserting Rows Monotonically?

Answer :

If the columns that incorporate the clustered index are monotonically increasing (this is, new row key values are extra than the ones previously inserted) the following System eleven dbcc track will no longer cut up the page when it’s half way complete. Rather it’ll let the web page fill after which allocate any other web page: 
dbcc music(ascinserts, 1, “my_table”) 
By the way, SyBooks is inaccurate while it states that the above needs to be reset whilst ASE is rebooted. This is a permanent placing.
 To undo it:
dbcc track(ascinserts, 0, “my_table”)

Question 32. Given A Table Which Contains Some Rows With Duplicate Keys, How Would You Remove The Duplicates?

Answer :

create brief table with equal desk structure and then create precise index on this transient desk with alternative ignore_dup_row. Now insert records into temp table from the desk in which duplicate facts exists. Even as inserting record into temp desk, replica rows gets ingored. Finally temp table can have precise information
Ex:
select awesome * from table_1 into temp_table_1
truncate table_1
insert into table_1
select * from temp_table_1
This is one of the methods to dispose of duplicates.

 

DB2 SQL Programming Interview Questions
Question 33. Can I Run Any Transact­sq. Command On A Partitioned Table In Sybase?

Answer :

No. Once you have partitioned a table, you can not use any of the following Transact­SQL instructions on the table till you unpartition it:
1. Drop table
2. Sp_placeobject
3. Truncate table
four. Alter desk table_name partition n 
On releases of ASE prior to 11.5 it changed into no longer possible to create a clustered index on a partitioned table either.

 

SQL Server 2008 Interview Questions
Question 34. How Will You Optimize A Query?

Answer :

Check the question plan.
Make certain that the previous columns of index are to be had in search criteria.
Make sure the Statistics are up-to-date: – Run update information at the tables in query if the records in these tables is changed drastically.
Check Search Arguments: – If feasible keep away from inequality operator. Avoid operations on columns and constant expressions that can't be evaluated at question assemble time.
If possible, use index masking.
If saved method accepts parameters, it's miles higher to recompile it at every execution.
Check the indexes are on proper columns.
Describe the tables in from clause in order the smaller desk occurs first and then the larger tables 
Question 35. What Is An Index? How Many Types Of Indexes Are There?

Answer :

Index is used to offer quicker get right of entry to to the facts in a desk than scanning every page. Sometimes index can be used as mechanism for implementing uniqueness.
There are 2 forms of indexes: Clustered and Non clustered

Question 36. What Is The Difference Between Clustered And Non-clustered Indexes?

Answer :

Clustered Index: – Data is physically sorted. The backside or leaf level of a clustered index includes the actual records pages of the desk. So there may be only one clustered index according to table.
Non-Clustered Index: – With a non-clustered index, the physical order of the rows isn't always the same as their indexed order. The leaf stage of a non-clustered index incorporates tips to rows on statistics pages. More precisely, every leaf web page carries an listed fee and a pointer to the row with that fee. Up to 249 non-clustered indexes are allowed in a desk.

Oracle 11g Interview Questions
Question 37. What Is Index Covering?

Answer :

When all of the keys of non-clustered index are utilized in select assertion and also in wherein clause then the non-clustered index does now not need to go to ultimate degree of index it simply pick the records from leaf-stage so it takes much less time to execute the question this is referred to as Index-Covering.

 

Question 38. How Can You Force An Index?

Answer :

Just write the name or the index variety in the bracket to pressure the index.

Question 39. What Are Different Types Of Locks, Explain?

Answer :

Shared Lock: – used by technique this is analyzing pages. Multiple shared locks can be hung on one page; a single shared lock prevents any unique lock from being received. Shared locks normally are held only at some point of the examine on a specific page. If holdlock is targeted, shared locks are held till the crowning glory of the command or the transaction it's miles in.
Update lock: – used by process that updates or deletes data, however have now not yet carried out so. Update locks are received because the set of rows to be up to date or deleted is being determined. Update locks are read-like minded with shared locks at some stage in the pre amendment section, however no other update lock or exclusive lock may be obtained at the page. Update locks automatically are up to date to distinctive locks when the data exchange happens.
Exclusive Lock: – used by procedure that currently adding, converting or deleting facts on information pages. Exclusive locks save you any other kind of lock (special, replace or shared) from being acquired. Exclusive locks are hung on all affected pages until an specific transaction or a command in the implicit transaction is complete.

Question 40. How Many Triggers Will Be Fired If Ore Than One Row Is Inserted?

Answer :

The numbers of rows you are putting right into a table, that many wide variety of instances cause receives hearth.

DB2 Using SQL Interview Questions
Question 41. What Are Advantage Of Using Triggers?

Answer :

To keep the referential integrity.

Question 42. How Do You Optimize A Stored Procedure?

Answer :

By growing suitable indexes on tables. Writing a query based at the index and how to choose up the correct index.

MYSQL DBA Interview Questions
Question forty three. How Do You Optimize A Select Statement?

Answer :

Using the SARG’s in the where clause, checking the question plan the usage of the set display plan on. If the question is not thinking about the right index, then will must force the perfect index to run the query quicker.

Question forty four. How Do You Force A Transaction To Fail?

Answer :

By killing a technique you may force a transaction to fail.

Question 45. What Are Constraints? Explain Different Types Of Constraints?

Answer :

Constraints enable the RDBMS put in force the integrity of the database automatically, with no need you to create triggers, rule or defaults.
Types of constraints: NOT NULL, CHECK, UNIQUE, PRIMARY KEY, FOREIGN KEY

Question 46. How Frequently You Defrag The Database?

Answer :

When ever there are insertions, updations & deletions in a desk we do defrag.

Question forty seven. How Do You Tell The Data Time Of Server Started?

Answer :

choose “Server Start Time” = crdate from master..Sydatabases in which name = “tempdb” or
select * from sysengines

 

Question forty eight. Is There Any Disadvantage Of Splitting Up Your Application Data Into A Number Of Different Databases?

Answer :

When there are members of the family among tables / items across the one of a kind databases, then there's a drawback indeed: if you'll repair a unload of one of the databases, the ones members of the family might not be consistent anymore. This method that you must usually returned up a constant set of databases is the unit of backup / repair. Therefore, when making this sort of layout selection, backup/restore issues must be taken into consideration (and the DBA ought to be consulted).

Question forty nine. What Are The Main Advantages And Disadvantages Of Using Identity Columns?

Answer :

The important benefit of an identification column is that it can generate precise, sequential numbers very efficiently,requiring most effective a minimal quantity of I/O. The drawback is that the generated values themselves are not transactional, and that the identity values may additionally soar surprisingly while the server is shutdown the difficult way (ensuing in “identification gaps”). 

Question 50. How Do You Bcp Only A Certain Set Of Rows Out Of A Large Table?

Answer :

If you’re in ASE 11.5 or later, create a view for those rows and BCP out from the view. In earlier ASE variations, you’ll ought to select the ones rows right into a separate table first and BCP out from that table. In both cases, the speed of copying the statistics depends on whether or not there is a appropriate index for retrieving the rows.