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
a)default
b)start profile
c)Central instance –instance profile
c)Application Instance – instance profile

2.       Parameter rdisp/vbname found in which profile
a)default
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
e)Authorization

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
a) SAPGUI
b)mysap database
c) ITS
d)SAPDB
e)

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
a)transport.pfg
b)DOMAIN_DEV.cfg
c)TP_DOMAIN_<SID>.pfl
d)tpimport.pfg

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
c)

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
c)

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
d) SAPGUI
e)Gateway

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
b)sap*,19920706
c)ddic,06071992
d)ddic,19920706
c)system/pass

35.    Password of SAP Dictionary user
a)DDIC,06071992
b)SAP*,pass
c)DDIC,19920706
d)SAP*,06071992

36.    User/Password in newly created client
a)DDIC,06071992
b)SAP*,pass
c)DDIC,19920706
d)SAP*,06071992

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)
c)
d)

38.    At then end of prepare phase which log file is created
a)R3up.log
b)prepare.log
c)Checks.log
d)upgrade.log

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
c)

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
c)
d)

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)
d)

47.    From external programs which process is used to trigger an event within an SAP system(Single Choice)
a)sapxpg
b)gwrd
c)dpmon
d)sapevt
e)disp+work.exe

48.    From SAP system which process is used to start external program & external commands (Single Choice)
a)sapxpg
b)gwrd
c)dpmon
d)sapevt
e)disp+work.exe

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
c)

52.    SAPCONNECT
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
c)
d)

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)
d)

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)
d)