How many packages we have in db

Question Posted / 999ysuman

How many packages we have in db..

Answer / suman

we have 8 packages in our database that is
1.procedures
2.triggers
3.tables
4.indexes
5.synonyms
6.views

Is This Answer Correct ?

10 Yes

6 No

More DB Administration Interview Questions

How do you trace the traffic hitting a sql server? : sql server DBA

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

How do you add a data file to a tablespace?

Query processing is slow(eg select query)how will u solve that

Define the SGA and: How you would configure SGA for a mid-sized OLTP environment? What is involved in tuning the SGA?

What are the commands you'd issue to show the explain plan for "select * from dual"?

How would you edit your CRONTAB to schedule the running of /test/test.sh to run every other day at 2PM?

What questions might be they ask in managerial round in capgemini.

What are the different ways of moving data or databases between servers and databases in SQL Server?

Give the stages of instance startup to a usable state where normal users may access it.

As a part of your job, what are the DBCC commands that you commonly use for database maintenance?

Where do you find the default index fill factor and how to change it? : sql server DBA

For more DB Administration Interview Questions Click Here