Answer Posted / guest
alter databse datafile 'location of datafile' resize 2000M
Regards
Abhinav Phadnis
| Is This Answer Correct ? | 13 Yes | 3 No |
Post New Answer View All Answers
Claims and Drains are the locks used to control the concurrency between SQL processes and utilities. Referring to the above statement, what is the maximum number of concurrent Claimers for a Subsystem? Choice 1 32 Choice 2 64 Choice 3 128 Choice 4 256 Choice 5 No limit
how can you get actual data change values from previous transactions in oracle?
how can you generate profile of pl/sql applications to identify performance bottlenecks?
how can you communicate with operating system files from oracle?
What is fill factor? : sql server DBA
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.
Why would you call update statistics? : sql server DBA
what is grd?
What is the importance of a recovery model? : sql server DBA
how can you create a user-defined lock?
What is a system database and what is a user database? : sql server DBA
what are the differences of where and if in SAS?
what are the types of connection load-balancing?
What view(s) do you use to associate a user's SQLPLUS session with his o/s process?
In which dictionary table or view would you look to determine at which time a snapshot or MVIEW last successfully refreshed?