A table is stored in a data dictionary managed tablespace. Which two columns are required from DBA_TABLES to determine the size of the extent when it extends? (Choose two)

By: Shailesh Singh Visen | 16 Mar 2008 4:31 am | 190 times viewed | 0 Comments

Q. A table is stored in a data dictionary managed tablespace. Which two columns are required from DBA_TABLES to determine the size of the extent when it extends? (Choose two)

A. BLOCKS
B. PCT_FREE
C. NEXT_EXTENT
D. PCT_INCREASE
E. INITIAL_EXTENT

Answer: CD

Comments

No Comments Posted for this Article.

Leave a comment

Submit Comment

Tutorials
Forum
Books
Interview Questions

FAQ: Database objects, segments and extents
1. What types of database objects exist? The most important types of database objects are as follows: CLUSTER: Oracle clusters These are not used by SAP (not to be confused with SAP cluster...
FAQ: Reorganizations
1. What is reorganization? The term reorganization refers to the reconstruction of objects in the database. A...
Database statistics
1. What are database statistics used for? The Cost Based Optimizer (CBO) requires database statistics in order to use the most suitable access path (for example, index access, full table scan, join...
Oracle: Common misconceptions
Some widely accepted information about the Oracle database is shown not to be entirely correct upon closer examination. 1. The Oracle cost-based optimizer always selects the...
INTRODUCTION TO DATA DICTIONARY
DATA DICTIONARY Type of a table or structure The table type determines how the logical table description defined in the ABAP/4 Dictionary is reproduced on the database. There are the following...
Oracle Database FAQ
1. On which component can I open an SAP message if there are problems with the Oracle database? The following components are available: BC-DB-ORA: Oracle BC-DB-ORA-DBA: BR*TOOLS for the database...
FAQ: Oracle
1. On which component can I open an SAP message if there are problems with the Oracle database? The following components are available: BC-DB-ORA: Oracle BC-DB-ORA-DBA: BR*TOOLS for the...
Detail Description of Data Dictionary.
Data Dictionary The ABAP/4 Dictionary describes the logical structure of the objects used in application development and shows how they are mapped to the underlying relational database...
FAQ: Oracle enqueues
1. What are Oracle enqueues? Oracle enqueues are locks at database level that coordinate parallel access to Oracle resources such as objects or data records. For example, enqueues are responsible...
FAQs: Oracle statspack
1. What is a statspack? Statspack is the abbreviation for statistics package. The statspack consists of a collection of SQL, PL/SQL and SQL*Plus scripts. The statspack helps you to collect, store...
Total Index and Buffering concept
i am giving total index and buffering concept details by seeing this you can understand how we can achive performance through these Performance during table access Indexes Primary and...
ABAP PERFORMANCE ISSUES
ABAP/4 Optimization Use the GET RUN TIME command to help evaluate performance. It's hard to know whether that optimization technique REALLY helps unless you test it out. Using this tool can help you...
User Managed Backup and Recovery Guide
Introduction to User-Managed Backup and Recovery This chapter introduces database concepts that are fundamental to user-managed backup and recovery. This chapter includes the following topics: ...
What is the functional module for drop down box ?
As well as input help, which appears in separate dialog boxes, you can also define input/output fields as dropdown boxes. A dropdown box offers the user a predefined set of input values from which to...
SAP User Exits and Enhancements.
Definition USEREXIT Userexit allow us to add our own functionality to SAP standard program without modifying it . These are implemented in the form of subroutines and hence are...

Showing logo in ALV report
ALV (ABAP LIST VIEWER) Sap provides a set of ALV (ABAP LIST VIEWER) function modules, which can be put into use to embellish the output of a report. This set of ALV functions is used to enhance...
SAPscript:Error in PC editor w. 2 consecutive commas
You use the PC editor to enter a text, which, among other things, contains two consecutive commas ( ).If you save this text and call it again at a later date to change or display it, the commas are...
Windows Terminal Server connection in remote support
You require a Windows Terminal Server connection for your system so that you can benefit from support sessions. Reason and Prerequisites You already have set up a SAProuter connection to SAP...
Bsc Computers and pursued MBA in Marketing for full two years now looking to switch sales line to SAP
hi friends you might have come across many a times but yes i am no different i graudated in bsc computers and pursued MBA in Marketing for full two years now looking to switch sales line to SAP i...
How much TR sequence is important for BASIS Person
Dear Friends, Sequence of Transport Request is very much important in SAP. If the sequence is improper then it will harm your live system. I experienced this thing very badly. We are...
Is there a way to tell if a cell in a table accepts input?
I need to update the Distribution Rules table for the Settlement Rule in TCode IW32. Normally we have two distribution rule lines, one for the FULL settlement and the second for PERIODIC settlement...
SNP heuristic and creation of purchase requisitions
I have got a question about the behaviour of the SNP heuristic in relation to the creation of purchase requisitions (PR's). 1) I plan both in daily and monthly buckets in the heuristic planning...
Change close to two thousand material numbers from K6***** numbers to 5million based numbers
We have about 2000 materials that we stock that are currently identified by ID numbers starting with a K6. All these items need to be updated with a new ID number that is a 5 million number. I...
Using BI / BW to Supply Data to External Planning Systems
i2 Demand Planner gets historical "demand" (actually historical sales) from a legacy system. SAP will replace the legacy system soon, and the question about how best to acquire data...
The problem due to incorrect insertion of condition records
The problem occurs if you transfer condition master data by delta download.The problem is caused by a program error. When you extract condition records from different condition tables and transfer...
Oracle recovery on HP-Unix
Hello Friends. I am stuck with a situation, I have a 46c Production server, which crashed . The database disks failed and the entire DB was gone. The only backup that I could get was an online...
Is there no hope for honesty?
Observing the work atmosphere in corporate MNCs involving SAP technologies has been a very derogatory experience. Looks like if I don't fake my resume with ramped up experience in...
How to fetch data from an ITAB to a search Help of a Screen Field In Modulepool?
In my Modulepool Screen i have two fields , Based on the data of the First field ,the second field will display the data. without using POV module hw to use dis ? and also using POV ,what are the...
GS01 - creating a hierarchy of accounts
I can not create a set with the hierarchy of accounts. I would like to create a set with the hierarchy of accounts, with T. GS01, in two ways: 1. Create a set without copying an existing...
Error on reading table
Hello, I have an inputscript that is called in two places. It reads the table in the Objects tab of a work order in display mode (t-code IW33). When this is called as an include...

Starter tips trickes
Starter tips trickes Contents 1 SAP R/3.................................................... 2 1.1 ...
Batch Communication Data (BDC) Procedure in Overview
Batch Communication Data (BDC) Procedure in Overview This section reviews batch input programming concepts and explains how to program data transfer and batch input processing programs. ...
ABAP/4 Performance Tuning
ABAP/4 Performance Tuning Table Of Contents 1) Incorporate CHECK statements for table fields into the WHERE clause of the SELECT statement ...
DB2 II: Performance Monitoring, Tuning and Capacity Planning Guide
DB2 II: Performance Monitoring, Tuning and Capacity Planning Guide DB2 Information Integrator architecture overview In this chapter we briefly describe the business needs driving the need for...
Microsoft SQL Server to IBM DB2 UDB Conversion Guide
Microsoft SQL Server to IBM DB2 UDB Conversion Guide Introduction Database management software is now the core of enterprise computing. Companies need access to a wide range of information such as...
SAP BC 400
SAP BC 400 BC400 ABAP Workbench Concepts and Tools.................................................. 1 ...
Creating forms quickly and easily
Creating forms quickly and easily Overview To reach the basic tools in form editing, use the SAP menu path Tools • Form print-out. Figure 3.1 shows the entries for the corresponding...
Branching to List Processing
Branching to List Processing Overview Often you want to produce a list from within your transaction. There are two ways you can do this. Submit a separate report Use the SUBMIT statement to...
SAP NetWeaver 04 Database Administration
SAP Database Guide: Oracle (BC-DB-ORA-DBA) ..........16 1 New Features.....................................................................................17 1.1 New Features in SAP Release 6.40...
The SAP R/3 Handbook, Second Edition
Chapter 1: What Is SAP R/3?...........................................................................................................................4 ...
white Paper - Rebate implementation Challenges
White Paper Abstract ; This is an abstract from white paper on usual challenges faced by implementation teams. Abstract of Challenges: Rebate recipient;...
Database Tuning with the Oracle Tuning Pack
Preface The Oracle Tuning Pack provides advanced tools that focus on tuning the highest impact database performance areas, such as: application SQL, indexing strategies, ...
Technical Consultant Training ORACLE Week 4
Technical Consultant Training ORACLE Week 4 Contents Course Overview ....................................................................1 Target Group...
Creating Dashboards with SAP BusinessObjectsTM
Contents \t \t\t \t\t\tForeword ......................................................................................................... \t\t\t17 \t\t \t\t \t\t\t1...
Applying Real-World BPM in an SAP Environment
Contents \t \t\t \t\t\tForeword ................................................................................................... \t\t\tIntroduction...

Oracle Certified Professional Exams IZ031 Questions Set 5
Q. Which three statements about the Oracle database storage structure are true? (Choose three) A. A data block is a logical structure B. A single data file can belong to multiple tablespaces. C...
Oracle Certified Professional Exams IZ031 Questions Set 9
Q. Examine the command: CREATE TABLE employee ( employee_id NUMBER CONSTRAINT employee_empid_pk PRIMARY KEY, employee_name VARCNAR2(30), manager_id NUMBER CONSTRAINT employee_mgrid_fk...
Oracle Certified Professional Exams IZ033 Questions Set 7
Q. Which component will NEVER allocate memory from the large pool? A. Oracle Library Cache. B. Oracle Parallel Query. C. Oracle Recovery Manager. D. Oracle Multithreaded Server. Answer:...
Oracle Certified Professional Exams IZ033 Questions Set 23
Q. The USERS table has thousands of rows and is accessed very often with an index (ISERID_NDX) on a primary key (USER_ID). Where should USERS and USERID_NDX be stored? A. Same tablespace. B...
Oracle Certified Professional Exams IZ031 Questions Set 8
Q. You created a tablespace SH_TBS. The tablespace consists of two data files: sh_tbs_datal .dbf and sh_tbs_data2.dbf. You created a nonpartitioned table SALES_DET in the SH_TBS tablespace. Which...
Oracle Certified Professional Exams IZ033 Questions Set 14
Q. You need some extra space in your database, so you issue this command:ALTER TABLE my_table DEALLOCATE UNUSED; What happens? A.All blocks of MY_TABLE that contain no rows are de-allocated. ...
Oracle Certified Professional Exams IZ031 Questions Set 6
Q. Which option lists the correct hierarchy of storage structures, from largest to the smallest? A. segment, extent, tablespace, data block B. data block, extent, segment, tablespace C...
Oracle Certified Professional Exams IZ033 Questions Set 11
Q. Which three guidelines should you follow regarding the performance of redo logs? (Choose three) A. Avoid using RAID 5 for redo logs. B. Place redo logs on disks without any other files. C...
Oracle Certified Professional Exams IZ031 Questions Set 1
Q. Which two statements are true about identifying unused indexes? (Choose two.) A. Performance is improved by eliminating unnecessary overhead during DML operations. B. V$INDEX_STATS displays...
Oracle Certified Professional Exams IZ033 Questions Set 6
Q. Which two statements are true of the buffer cache? (Choose two) A. The buffer pools in Oracle9i can be resized dynamically. B. The blocks in the buffer cache are managed using one list. C. The...
Oracle Certified Professional Exams IZ033 Questions Set 21
Q. A latch is defines as ______. A. A mechanism used by the Oracle optimizer to run user queries in parallel. B. A mechanism to prevent data files that make up the database from auto-extending. ...
Oracle Certified Professional Exams IZ033 Questions Set 13
Q. Which three actions avoid the disadvantages of dynamic extent allocation? (Choose three) A. Increase the PCTINCREASE on the table. B. Create locally managed tablespaces for the objects that...
Oracle Certified Professional Exams IZ033 Questions Set 9
Q. Which two views would you query to monitor sessions relates statistics? (Choose two) A. V$SESSTAT B. V$SESSION_EVENT C. V$SESSION_STATS D. V$SESSION_STATUS E. V$WAITS_PER_SESSION Answer: A...
Oracle Certified Professional Exams IZ032 Questions Set 15
Q. When importing a table into a database, the import process performs these tasks: 1. Triggers are imported. 2. Data is imported 3. New tables are created. 4. Indexes are built 5. Any bitmap...

Ask a Question!