Explain the difference between a data block, an extent and a
segment.
Answer Posted / wafa
data block is the smallest unit of logical storage for a database object. As objects grow they take chunks of additional storage that are composed of contiguous data blocks. These groupings of contiguous data blocks are called extents. All the extents that an object takes when grouped together are considered the segment of the database object.
Is This Answer Correct ? | 6 Yes | 0 No |
Post New Answer View All Answers
. I have my backup RMAN script called "backup_rman.sh". I am on the target database. My catalog username/password is rman/rman. My catalog db is called rman. How would you run this shell script from the o/s such that it would run as a background process?
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
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 are the differences of where and if in SAS?
How would you extract DDL of a table without using a GUI tool?
How would you go about verifying the network name that the local_listener is currently using?
Why would you use sql agent? : sql server DBA
Can you redefine a table online?
Other than making use of the statspack utility, what would you check when you are monitoring or running a health check on an Oracle 8i or 9i database?
What is the difference between the 2 operating modes of database mirroring? : sql server DBA
how can you initialize log miner?
what are the benefits of flashback feature?
What are the different types of database compression introduced in sql server 2008? : sql server DBA
How do you trace the traffic hitting a sql server? : sql server DBA
What is the cache hit ratio, what impact does it have on performance of an Oracle database and what is involved in tuning it?