------------------------------------------------------------------------------------------------------------------------------------------------
Q. What is DDIC
or ABAP Data Dictionary?
a. The ABAP dictionary
describes and manages all the data definitions used in the system
b.The ABAP dictionary is
completely integrated in the ABAP workbench
c. The ABAP
dictionary supports the definition user defined data types
d. All of the above
------------------------------------------------------------------------------------------------------------
Q. Explain Data
Element, Domain & Advantages?
a. Data Element =
Short Text + Domain( data type + length )
b. It is used to
define technical attributes (data type and length ) and the value ranges (
fixed values and intervals)
c. [a] and [b] both
d. None of the above
-----------------------------------------------------------------------------------------------------------
Q. What is
Primary Key & rules regarding primary key?
a. Primary key is
one or more than one field combination to identify the records
uniquely from the database table. Rules- 1.Each table should have
primary key,2.it should be data type INT,3.It should appear as the first
field
b. Primary key
is one or more than one field combination to identify the records
uniquely from the database table. Rules- 1.Each table should have
primary key,2. it should be data type FLOAT,3.It should appear as the first field
c. Primary
key is one or more than one field combination to identify the records
uniquely from the database table. Rules- 1.Each table should have
primary key,2. it should be data type CHAR,3.It should appear as the first field
---------------------------------------------------------------------------------------------------------
Q. Can we
have more than one primary key in a database table?
a. Yes
b.No, but we can
have more than one filed combination as primary key
c. Optional
d. None of the
above
----------------------------------------------------------------------------------------------------------
Q.
What is the difference between Append & Include structure?
a.
Include structure is used to include the structure to a custom table
and append structure is used to append fields in the standard table
b. Include
structure is used to include the structure to standard table and
append structure is used to append fields in the custom table
c. Include
structure is not used to include the structure to a custom table and
append structure is not used to append fields in the standard
table
d.
None of the above
------------------------------------------------------------------------------------------------------------
Q. Can we use same append structure in more than one
data base table?
a. No
b. Yes
c. Optional
d. None of the above
----------------------------------------------------------------------------------------------------------
Q. What is the importance of
Foreign key ?
a. It is a unique key
b. It is a alternate key
c. It is a field in one table
that is connected to another table via foreign key relationship
and is to validate the data being entered in one table with a
valid values from another table
d. None of the above
-----------------------------------------------------------------------------------------------------------
Q. What are the rules to define
the foreign key?
a. The domain names of the
field in the foreign key table and for the field in the check
table should be same.
b. The filed in the check table
should be a primary key.
c. None of the above
d. Both A & B are correct
------------------------------------------------------------------------------------------------------------
Q. What is Index in Data base
tables?
a. We can search a table of
data records that satisfy certain search criteria faster using
an Index
b. Indexing can be considered
as a copy of the database table that has been reduced to
certain fields
c. The index contains a
pointer to the corresponding records of the actual data base
table so that the fields not contained in the index
can also be read
d. All of the above
-----------------------------------------------------------------------------------------------------------
Q. What is table
maintenance generator?
a. The table
maintenance generator is used to create table maintenance program
only to add records in the data base table
b. The table
maintenance generator is used to create table maintenance
program only to add, modify or delete records in the data base table
c. The table
maintenance generator is used to create table maintenance
program only to delete records in he data base table
d. None of the above
-----------------------------------------------------------------------------------------------------------
Q. What is one step
and two step in table maintenance generator?
a.This specifies the
screens to be created in the table maintenance program
b. This specifies
the tables to be created in the table maintenance program
c. This specifies
the indexes to be created in the table maintenance
program
d. None of the above
----------------------------------------------------------------------------------------------------------
Q. What is a type
group?
a. We can define
type groups in the type group of the abap dictionary
instead of defining them in the ABAP program.
b. We can define
type groups in the type group of the abap program
instead of defining them in the ABAP dictionary.
c. Both A & B are
correct
d. None of the above
----------------------------------------------------------------------------------------------------------
Q. What is table maintenance?
a. It allows the user to maintain the
data manually and automatically
b. It allows the user to maintain
the data manually
c. It allows the user to maintain
the data automatically
d. None of the above
----------------------------------------------------------------------------------------------------------
Q. What is data class?
a. The data class defines in which
table segment(logical area) the table is stored
when it is created in the data base
b. The data class defines in
which table segment(physical area) the table is
stored when it is created in the data
base
c. Both A & B
d. None of the above
----------------------------------------------------------------------------------------------------------
Q. What is size category?
a. The size category describes the
probable space requirement of the field in the
database table
b. The size category describes
the probable space requirement of the record in
the database table
c. The size category describes
the probable space requirement of the table in
the database
d. None of the above
----------------------------------------------------------------------------------------------------------
Q. What is delivery class?
a. It defines the type of data
that is going to be stored and also the
delivery class controls the transport of table space data for
installation, upgrade and client copy and when
transporting between customer systems.
b. It defines the type of
data that is going to be created and also the delivery
class controls the transport of table space data for installation, upgrade and
client copy and when transporting between
customer systems.
c. It defines the type of
data that is going to be deleted and also the
delivery class controls the transport of table space data for installation,
upgrade and client copy and when transporting
between customer systems.
d. None of the above
--------------------------------------------------------------------------------------------------------
Q. What if Buffering?
a. Buffering a table improves
the performance when accessing the records
contained in the table
b. The table buffer resides
locally on each application server in the
system
c. Only transparent and cluster
table can be buffered
d. All of the above
------------------------------------------------------------------------------------------------------------
Q. What are different
buffering types?
a. Single record buffering,
Generic area buffering and fully buffering
b. Multiple record
buffering, Generic area buffering and fully
buffering
c. Single record
buffering, Generic area buffering and half
buffering
d. None of the above
------------------------------------------------------------------------------------------------------------
Q. What is a view?
a. A view is a
logical view on one or more tables where
the data is not physically stored instead
being derived
from one or more tables
b. A view is a
logical view on one or more tables where
the data is physically stored instead
being derived from one or
more tables
c. None of the above
------------------------------------------------------------------------------------------------------------
Q.
What are different types of
views?
a.
projection view, help view, database
view and maintenance view
b. Logical
view, help view, database view and
maintenance view
c.Physical view,
help view, database view and
maintenance view
d. None
of the above
------------------------------------------------------------------------------------------------------------
Q.
What is the use of projection
view?
a.
Retrieves some fields from single table
b. This
is used for search help
c. This
is inner join view on one or more
tables
d. None
of the above
------------------------------------------------------------------------------------------------------------
Q. What
is the use of help view?
a. Retrieves
some fields from single table
b. This
is used for search help
c. This
is inner join view on one or more
tables
d. None
of the above
------------------------------------------------------------------------------------------------------------
Q.
What is the purpose of database
view?
a. Retrieves
some fields from single table
b. This
is used for search help
c. This
is inner join view on one or more
tables
d.
Helps in creating and maintaining data
of the application. The data can be
distributed among several tables
------------------------------------------------------------------------------------------------------------
Q. What
is the purpose of Maintenance view?
a. Retrieves
some fields from single table
b. This
is used for search help
c. This
is inner join view on one or more
tables
d. Helps
in creating and maintaining data of the
application. The data can be
distributed among several tables
------------------------------------------------------------------------------------------------------------
Q. What
are different types of data base tales?
a.
Transparent Table, Pooled Table,
Cluster Table
b.
Pooled Table, child table, cluster
table
c.
Master table, transparent table and
cluster table
d. None
of the above
------------------------------------------------------------------------------------------------------------
Q. What
are the two methods of modifying sap
standard table to add new fields?
a.
Append structure
b.
Custom include
c.
Append structure and custom include
d. None
of the above
------------------------------------------------------------------------------------------------------------
Q. How
to restrict the value rages for a
domain?
a. By
specifying some value and by using
value field
b. By
specifying fixed value and by using
value table
c. By
specifying fixed value and by using
value field
d. None
of the above
------------------------------------------------------------------------------------------------------------
Q. What
are conversion routines?
a.
Standard conversions from display
format to sap internal format and
vice versa implemented with conversion
routines
b. Non
Standard conversions from display
format to sap internal format and
vice versa implemented with conversion
routines
c. Standard
conversions from display format
to non sap internal format and
vice versa implemented with conversion
routines
d. none
of the above
------------------------------------------------------------------------------------------------------------
Q. What
is the use of lock objects?
a. Lock
objects are used to synchronize access
to the same data by more than one user
b. Lock
objects are used to un-synchronize
access to the same data by more than
one user
c. Lock
objects are used to synchronize access
to the same application by more
than one user
d. None
of the above
------------------------------------------------------------------------------------------------------------
Q. What
is check table?
a.
check table is independent table to
which the relationship is defined using
primary keys
b. check
table is independent table to which the
relationship is defined using foreign
keys
c. check
table is independent table to which the
relationship is defined using candidate
keys
d. None
of the above
------------------------------------------------------------------------------------------------------------
Q. What
is value table?
a. The
value table is a table attached to a
field at the domain level where the
entry to the field can only be from the
value table
b.
Value table is the default check table
c. Both
A & B
d. None
of the above
------------------------------------------------------------------------------------------------------------
Q. What
is the difference between Database
table and views?
a. The
table has a physical storage of data
where as views do not have physical
storage of data
b. The
view has a physical storage of data
where as tables do not have physical
storage of data
c. The
view has a logical storage of data
where as tables do not have physical
storage of data
d. None
of the above
------------------------------------------------------------------------------------------------------------
Q.
Which views we can use in ABAP Program?
a. Only
projection view and database view
b.All
views can be used
c. Only
projection and maintenance view
d. None
of the above
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
No comments:
Post a Comment