Friday, 8 February 2013

SAP Basis/Netweaver Certification Question Set 4

Friends, please find below SAP Basis/Netweaver Certification question set4. Please note these are gathered from either browsing or from candidates who have taken exam. Please note that the answers are not provided/validated by me. I leave it for you.

All the best!!

1.       Parameter rdisp/mshost found in which profile
b)start profile
c)Central instance –instance profile
c)Application Instance – instance profile

2.       Parameter rdisp/vbname found in which profile
b)start profile
c)Central instance – instance profile
c)Application Instance – instance profile

3.       One screen dump of sytem status .  find the Database host name?

4.       Performance optimization
SQL statement given –screen dump of ST04à detail analysisà SQL request
& ST04 main screen dump-  Single choice only
To find SQL statement is expensive or not
a)buffer gets > 5% Total Reads  so Statement is expensive
b)buffer gets > 5% Physical Reads  so Statement is expensive
c)Statement is not expensive
d)Very high buffer gets so statement is expensive
e)High no of execution so statement is expensive

5.       Program ZZSLOW is there and it access ZZTABLE .And want to improve the performance
(multiple choice )
a) create an index on ZZTABLE and this is preferred over option of tuning SQL statement
b) Creating an index would definitely improve the performance
c)Tuning the SQL statement would solve the performance and is preferred over Index Creation
d)Optimizer may choose  wrong index after creation  of the index

6.       One screen dump of update termination .

7.       Sequence of Updates V1 & V2
a) both occur independently
b) first V1 and then v2
c)both simultaneously

8.       How many minimum V1 and V2 processes should be there?
If V1 process is only there and there are not V2 process then will V1 process will handle V2 updates as well ?? True/False

9.       Which of the foll. Traces can be started without restarting SAP system
a)Buffer Trace
b)SYSLOG Trace
c) Database Trace
d)Dispatcher Trace

10.    Analyse problem of system startup.  Before anyone could login system stops . Check using(multiple choice)
A)check sm21
b)/usr/sap/log directory
c)analyse database error log in details
d)check files in \usr\sap\<instance>instance_no\work folder
e)check files in sapbackup folder

11.    Sapdba –check is used to (multiple choice)
a) check & displays the status of all datafiles along with complete path name
b)lists  free space usage of index & tables
c)check for consistency of database
d)check for failed brbackup & brarchive backuop
e) check for values of active database parameters

12.    Update optimizer statistics jobs does … (multiple choice)
a) Not update statistics of pool and cluster tables
b)update statistics of all transparent tables.
C) update statistics of all transparent tables who doesn’t have any statictics
D) Check DBSTATCO for updation of selected  tables
E) updates only statictics for DBSTATCO

13.    One screen dump of sapdba…
Archive stuck situation is possible

14.    One screen dump of backup failure
trying to take offline backup while R/3 is on

15.    One screen dump on TIME_LIMIT_EXCEED explanations and some questions.

16.    What of the foll. Components are in mysap technology
b)mysap database
c) ITS

17.    Can Wgate and Webserver be on different boxes.

18.    From where can ITS be adminstrerd  -multiple choice
a) from within SAP system
B) from web server
c) from ITS admin instance

19.    Which of the following files are required for transport in to QAS system

20.    Which is the sapbda & brarchive parameter file

21.    Files Required to do full database & recovery

22.    File backed up during online backup

23.    File backup up during offline backup

24.    Questions  on RFC+CPIC time   & Roll Wait Time

25.    Uses of solution manager

26.    Sapdba supports following (multiple choice)
a)2 step backup, first disk then to tape
b)Replication database

27.    Enque table is stored in  (single choice)
a) Table Tlock in database
b)In Central instance   at file level
 c) in shared memory of the Central instance
d)In shared memory of each SAP instance

28.    Enque/deque is related to
a) lock & unlocking at Database level
b)Lock & unlock of SAP transactions

29.    Locking process of SAP transactions carried out by
a) Dialog process
b)enque process
c)Message server process

30.    A communication is to be done between 2 systems, such that none should use anonymous logon for misuse to do remote logon to target system (multiple choice)
a) if you do not give RFC target system,system no etc. then a default Logon is performed on to 000/own system with user SAPCPIC.
b)To create a communication user in su01 and specify it in target destination
c)to keep logon details blank so that each user has to specify the detials every time a connection is made

31.    Which process first connects to the database ?
a) Dispatcher
b) Message server
c)Work process

32.    What is the startup sequence of the SAP system?(multiple choice)
a)Database ,gateway ,dispatcher
b)Dispatcher ,gateway ,database
c)Database , dispatcher  ,gateway
d)etc.. etc…

33.    SCU0 along with SM30 can be used to (multiple choice)
a) compare clients within same system
b)compare different clients within different systems
c)Can be used to adjust customizing alongwith SM30
d)Can be used to comapare transaction tables

34.    User in 000 used to logon to a newly installed system
a)sap* ,pass

35.    Password of SAP Dictionary user

36.    User/Password in newly created client

37.    With OPS$connect mechanism
a)OS user need not enter the password  during database connection (T/F)
b)SAPDBA always uses ops$connect mechanism (T/F)

38.    At then end of prepare phase which log file is created

39.    Allocation sequence of DIA work process
a)rollfirst,heap memory until exhausted,remaining of roll area,then Extended memory
b)rollfirst,Extended memory until quota reached,remaining of Roll area, then Heap memory

40.    3-4 Questions on Device configuration …..( swap space,online logs,sapdata files on RAID5 or RAID1., on same disks,.. etc)

41.    To check &  avoid block corruption
a) Use RMAN level 0 backup with SAP tools for backup
b)brbackup and brarchive always check for coruption
c)use –w use_dbv option with brbackup
d)oracle automatically checks for block corruption

42.    How to create additional Sap service marketplace users (single choice)
a)one user Sapadm always there for every customer 
b)At  customer place the user with Administrator rights can create additional users
c)Create an oss message for creating additional users
d)has to check license& contract between SAP & customer

43.    Buffering for a frequently updated table should be (single choice)
a)single record buffered
b)generic buffered
c)No buffering
c)Full buffering

44.    For buffer synchronisation
a)In central system only way  is to make bufrefmode=sendon/exeauto
b)In central instance and all dialog instance it should be bufrefmode=sendoff/exeauto
c) In central system it should be bufrefmode=sendoff/exeauto
d)In central system and all dialog system in exceptional conditions may be set as bufrefmode=sendoff/exeauto

45.    One screen dump on Load average of ST06 screen (Single Choice)
a)Load average is the Average CPU utilisation of the server
b)No. of CPU processes waiting in front of the CPU

46.    Client copy
a)Remote copy creates huge file in operating system level in target systems (T/F)
b)Client copies can be done within same system(T/F)
c)Remote Client copy can be done using parallel processes (T/F)

47.    From external programs which process is used to trigger an event within an SAP system(Single Choice)

48.    From SAP system which process is used to start external program & external commands (Single Choice)

49.    How many spool work process can be configured (Single Choice)
a) one per sap instance
b)one per SAP system
c) more than one per SAP instance
d)one on the Central instance

50.    In 3 system landscape from where the request can be imported in QAS system (Single Choice)
a)Only from DEV
b)Only from QAS
c)From all of the 3 systems
d)only from PRD

51.    Some questions on TMS
a)TMSADM are automatically created in 000 client (T/F)
b)TMS* RFC’s are automatically generated

a)sapconnect only works with RFC destinations (T/F)
b)if you configure sapconnect in client 000 then it is available to all other clients(T/F)
c)for Auto reaction method sapconnect needs to be configured in client 000 (T/F)
d) for External mail configuration an connection has to be maintained in SCOT (T/F)
e)No extra setting required for Mail config(T/F)
f)An program has to be scheduled so that sapconnect send external mails . (T/F)

53.    RZ20/RZ21
a) in order to add create new monitor set you have to switch to ‘Activate Maintenance function mode’ (T/F)
b)It is recommended to copy Entire Monitor Set and then make changes to it (T/F)
c)It is recommended to keep monitor set with minimum monitoring objects so that loading time of the set is minimum (T/F)
d)You should maintain the threshold values of the monitor set (T/F)

54.    When you do a modification then (single choice)
a)The package /dev class of the object has to be changed to customer dev. Class
b) The package /dev class of the object is within that of SAP and cannot be changed

55.    A customer wants to restrict modification what should he do
a) change to not modifiable in Se06 system change option (T/F)
b)avoid modification by using enhancements & Business Addins(T/F)

56.    Further on modifications
a)Every modification has to be registered as SAP Service marketplace (T/F)
b)Every manual modification required Developer Acess key for the developer (T/F)
c)Modification request has to be sent to SAP thru FAX(T/F)
d) All modifications should be done in DEV system for techincal reasons (T/F)
e)If modifications done then further work is required during upgrades (T/F)

57.    Use of native SQL
a) Will always improve  the performance (T/F)
b)Will  remove the programs from being database independent(T/F)
c) data accessed will not be buffered (T/F)

58.    Operation mode switch from BTC to DIA
a)if jobs are running in BTC process then operation modes will be switched after the jobs are completed (T/F)
b) if jobs are running in BTC process then operation modes switch will be cancelled (T/F)
c)The running jobs would be temporarily put in suspended status (T/F)

Thursday, 7 February 2013

SAP Basis/Netweaver Certification Question Set 3

Friends, please find below SAP Basis/Netweaver Certification question set3. Please note these are gathered from either browsing or from candidates who have taken exam. Please note that the answers are not provided/validated by me. I leave it for you.

All the best!!

1)     Software Logistics provide: (Single Choice)
a.     Procedure for Central User Administration
b.    Procedure for Development / Customizing
c.     Procedure for Post Installation Steps
d.    Process to help you monitor your system externally

2)     The administrator wants to deactivate the import of all the requests in an import queue for a SAP System, he should set which parameter? (Single Choice)

3)     The area of CTS that schedules and monitors the importing of Change Request is: (Single Choice)
a.     Workbench Organizer
b.    Transport Organizer
c.     TMS
d.    CTS

4)     The transaction used for Cross-System Viewer and Client Transport – Export Processing is: (Single Choice)
a.     SUC0/SCC7
b.    SCU0/SCC7
c.     SUC0/SCC8
d.    SCU0/SCC8

5)     Types of Client Specific Data? (Multiple Choice)
a.     Dictionary Data
b.    User Data
c.     Master Data
d.    Transaction Data

6)     Select the correct statements pertaining to TMS configuration (Multiple Choice)
a.     Several transport groups can be in a transport domain
b.    Transports can take place in the different transport groups
c.     Transport layer is not required while defining transport routes
d.    Only one transport layer can be defined in the system at any given time

7)     Which of the following are the Transport directories? (Multiple Choice)
a.     bin
b.    actlogs
c.     profile
d.    tmp
e.     log

8)     List the Transport Requests that are generated during Client Export and the description of each request giving the type of data exported

Sr. No.
Request Name

9)     Transaction Code used for Transport Management System / Transport Organizer is: (Multiple Choice)
a.     STMS / SE09
b.    SMTS / SE10
c.     STMS / SE10
d.    STSM / SE01

10)  Which of the following is NOT a profile that can be used for client copies? (Multiple Choice)
a.     SAP_USER – User master records
b.    SAP_ACUST – Application & Customizing data
c.     SAP_EXBC – Client dependent/independent Customizing & Users
d.    SAP_MAST – Master data only

11)  You can get Support Packages from the following places (Multiple Choice)
a.     SAP Service Marketplace
b.    SAPNet-R/3 Frontend
c.     Online Documentation CD
e.     Collection CDs

12)  Why did SAP introduced CRTs?

13)  BW Support Package for Release 30B will be named according to which format? (Single Choice)
a.     SAPBW30B<serial no.>
b.    SAPKY30B<serial no.>
c.     SAPKW30B<serial no.>
d.    SAPKB30B<serial no.>

14)  Which tool is used for carrying out R/3 Upgrade (Single Choice)
a.     PREPARE
b.    SPAU
c.     R3UP
d.    SPDD

15)  List the differences between Local Client Copy & Remote Client Copy

Sr. No.
Local Client Copy
Remote Client Copy




16)  The logs generated by ‘tp’ tool are: (Multiple Choice)
a.     tp system log
b.    Transport Step Monitor
c.     ULOG
d.    <Source SID><Import Step><6 digit>.<Target SID>

17)  Which of the following statements are correct in regard to preliminary imports? (Multiple Choice)
a.     SAP recommends using preliminary imports rather than imports of the entire queue
b.    Preliminary imports should only be performed in exceptional cases
c.     Change request imported as preliminary imports remain in the queue and are imported again when an import of the entire queue is performed
d.    Change request are deleted from the import queue after a preliminary import is performed

18)  Parallel Processing in case of Client Copy is: (Single Choice)
a.     Performed in Local Client Copy
b.    Performed in Client Transport
c.     Performed when you want to do other client copy in parallel
d.    Not recommended by SAP

19)  Explain the meaning of Consolidation Route & Delivery Route (Not more than 30 words)

20)  Which are the two most frequently used Change Request Types available in Transport Organizer?  Give a short description of each one

21)  Which of the following best describes SAP Customizing? (Single Choice)
a.     Writing new ABAP Programs to satisfy business needs
b.    Entering Master data
c.     Configuring business process to meet the requirements
d.    Installing the R/3 software as per recommendations
e.     Creating users and granting authorizations

22)  The Customizing Client should have the option in SCC4 as: (Single Choice)
a.     No Changes Allowed
b.    Changes w/o automatic recording of changes
c.     Automatic recording of changes
d.    Changes w/o automatic recording, no transports allowed

23)  Before releasing a change request, the following tasks should be completed (Multiple Choice)
a.     All tasks must have previously been released
b.    SE09 needs to be installed
c.     TMs has to be configured
d.    All tasks must have previously been tested

24)  List at least three things that are automatically generated when a Transport Domain Controller is first created

25)   Draw a Transport Route (in Graphical Editor Mode) for a 3 system landscape with SIDs D01 (Development), Q01 (Quality), P01 (Production).  Include another Production system with SID P02 in the transport Route.  The IT Department decides to have the development changes to be transported to Training System with SID T01 for urgent training requirements.  Place the same in the Transport Route?  (Use assumptions wherever required)