If the SQL * Plus hangs for a long time, what is the reason?
How do you increase the performance of %LIKE operator?
Latest Answer: The wildcard char % can be placed in one of three ways: %searchwordhere% searchwordhere% %searchwordhere The searchwordhere% is the fastest because it can use an index if one is specified on that column. The other two %searchwordhere%, and %searchwordhere ...
Explain Dual table. Is any data internally stored in dual table. Lot of users are accessing select sysdate from dual and they getting some millisecond differences. If we execute SELECT SYSDATE FROM EMP;
Latest Answer: Dual is a system owned table created during database creation. Dual table consist of a single column and a single row with value xWe will not get any error if we execute select sysdate from scott.emp Instead sysdate will be treated as a psudo column ...
In exception handling we have some NOT_FOUND and OTHERS. In inner layer we have some NOT_FOUND and OTHERS. While executing which one whether outer layer or inner layer will check first?
What is mutated trigger? In single user mode we got mutated error, as a DBA how you will resolve it?
Latest Answer: If you are using before in trigger block, then replace it with afterMutated error, when same table access more than once in one state. ...
Schema A has some objects and created one procedure and granted to Schema B. Schema B has the same objects like Schema A. Schema B executed the procedure like inserting some records. In this case where
Latest Answer: Procedure will be executed with the authority of A and therfore data will go to the tables owned by A. If one wants the data to go to B, use the clause authid current_user while defining the procedure. ...
If the entire disk is corrupted how will you recover the database and what are the steps to recover the database?
Latest Answer: Things Useful For Complete Recovery :1- Last Valid Backup2- Dump Files3- Archive Logs- If You Have a Valid Backup on Another Disk Rather Than The Damaged One , You Can Recover The Database till The Time Of This Backup.- If You Have Archive Logs till The ...
There are about a 10,000 records in a table. A user 1 runs a query which is doing a full table scan. While doing the full table scan, user 2 changes some value x to y using a DML statement in record. What
Latest Answer: in full table scan, if another user updates the value for a given row does not affect the full table scan if the user finishes the update by the time the oracle reads that particular record will get updated value otherwise it has the old value. ...
A user has connect and resource privileges allocated by the DBA. He is been allocated quota on three tablespaces by the DBA - Default Tablespace Quota 500 M - Tablespace 1 Quota 100 M - Tablespace 2 Quota
Latest Answer: Yes he will be successful. because resource role grant user unlimited tablespace system privilege. quota ignored.
SQL> create user test identified by test1;
User created.
SQL> grant connect, resource to test;
Grant succeeded.
SQL> select * from ...
There are 100 datafiles, numbered from 1 to 100. File number 10 is deleted and it has 500 MB of data. The database is working in No-Archive log mode. How can the database be recovered?
Latest Answer: This can be easily done but you will loose the data if you don't restore from backup.If you have a backup of datafiles and controlfile then restore them.If you don't have the backup then you need to usealter database create datafile 'new_filename.dbf' ...
View page << Previous 1 2 [3] 4 5 6 7 8 9 10 Next >>
Go Top
