If you are given access to a sql server, how do you find if the sql instance is a named instance or a default instance? : sql server DBA
No Answer is Posted For this Question
Be the First to Post Answer
hi, suppose i created one table after few days i did some insert,update how can i know when will i did ddl or dml operation is undergone on that table
Explain the difference between a FUNCTION, PROCEDURE and PACKAGE.
Give two examples of how you might determine the structure of the table DEPT.
Assuming today is Monday, how would you use the DBMS_JOB package to schedule the execution of a given procedure owned by SCOTT to start Wednesday at 9AM and to run subsequently every other day at 2AM.
What is a correlated sub-query? : sql server DBA
What command would you use to encrypt a PL/SQL application?
what are the benefits of flashback feature?
What view would you use to determine free space in a tablespace?
Which types of backups you can take in Oracle? 2. A database is running in NOARCHIVELOG mode then which type of backups you can take? 3. Can you take partial backups if the Database is running in NOARCHIVELOG mode? 4. Can you take Online Backups if the the database is running in NOARCHIVELOG mode?
I want to reuse a piece of code inside a stored procedure. This piece of code need to be invoked multiple times inside the procedure based on some different conditions. How to achieve this?
how can you find out if a table can be redefined?
deleted of control file how will u recover control file?