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
