ABAP Certification - SAP Questions and Answers


ABAP Certification - Developer Associate Certification

SQL Statements



1.   Update tasks are the only method of making changes to the database.

A. True
B. False
Correct answer: B


2.   Which statement is true?
A. A database LUW must be placed within an SAP LUW.
B. A SAP LUW must be placed within a database LUW.

Correct answer: B

3.  Which actions release a data base lock?
A. COMMIT  WORK
B.ROLLBACK WORK
C. The display of an SAP screen
D. The display of a dialog message type E
E. The display of a dialog message type A
F. ENOUEUE_<lock_object>
G.DEQUEUE_<Iock_object>
H. A call to a function module
I.A CALL TRANSACTION
J. A SUBMIT
K. An /n in the command field

Correct answers: A, B. C. D, E. I. J, K

4.   Which actions release a lock object (with a default value for _SCOPE)?
A. COMMIT  WORK
B.ROLLBACK WORK
C. The display of an SAP screen
D. The display of a dialog message type E
E. The display of a dialog message type A
F.  ENOUEUE_<lock_object>
G. DEOUEUE_<lock_object>
H. A call to a function module
I. A CALL TRANSACTION
J. A SUBMIT
K. An “/n” in the command field

Correct answers: A, B, E. G,  K


5.    How can you implement a table join other than the using the JOIN statement? (Fill in the blank.)

Correct answer: A database view

6.    The data buffered on each application server is:
A. Always the same
B. Never the same
C. Depends on the users

Correct answer: C


7.    The target structure of a SELECT statement requires the field names to match the columns selected and to be in the same left-justified order.

A. True
B. False

Correct answer: B

8.    When is an ENDSELECT not required for a select? 
A. When the FROM is a view
B. When you specify a join of tables
C. When you do a SELECT SINGLE
D. When you specify into a table
E. When you specify appending a table

Correct answer: C. D.E

9.    The database always uses the primary key when the WHERE clause contains any of the key fields.
A. True
B. False

Correct answer: B


10.  Open SQL does not allow you to specify a secondary index during a SELECT.
A. True
B. False

Correct answer:A


11.   You should  always  buffer  data base  tables  that  contain  fewer  than  100 records.
A. True
B. False

Correct answer: B

12. Buffering data can speed up access to data up to 100 times when compared to reading it from the database.
A. True
B. False

Correct answer: A


13. All Open SQL commands allow processing on multiple rows.
A. True
B. False

Correct answer: A


14. The _WAIT  para meter of a lock object waits for the lock to be successful.
A. True
B. False

Correct answer: B

15. Is recommended  to place the COMMIT  WORK in the update Task.
A. True
B. False

Correct answer: B

16. It is possible to PERFORM  <subroutine> ON COMMIT in an update TASk.
A. True
B. False

Correct answer: A


17.  The correct steps  for using a lock object is:
A. Read the data, set the lock, change the data. release the lock
B. Set the lock, read the data, change the data, release the lock
C. Set the lock, read the data, release the lock, change the da ta

Correct answer: B


18. Local update tasks are quicker because they stay within the same work process.
A. True
B. False

Correct answer: B

19. V1 update tasks are always non-restartable, whereas V2 update tasks are always restartable.
A. True
B. False

Correct answer: B


No comments:

Post a Comment