What are the commands used in dcl? : sql server DBA
How do you find out from the RMAN catalog if a particular archive log has been backed-up?
Give two examples of how you might determine the structure of the table DEPT.
Give the stages of instance startup to a usable state where normal users may access it.
What is dcl? : sql server DBA
I have kept recovery catalog on same target database and taken backup of target DB to disk. deleted the target DB & tried to restore and revoer DB using the backup on disk but it is not possible, how do we restore & recover DB
How many files can a database contain in sql server?how many types of data files exists in sql server? How many of those files can exist for a single database? : sql server DBA
Query processing is slow(eg select query)how will u solve that
Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?
How will u copy the objects of one schema to another schema in datapump & export/import?
What view(s) do you use to associate a user's SQLPLUS session with his o/s process?
wat is global index and local indes
why do we give pctfree and pctused in create table statement?