Database And SQL Trivia Quiz!
12 Questions
| Total Attempts: 634
Settings
Below are a database and SQL trivia quiz. It is designed to see your capability to store data conveniently in a computer with the help of the structured query language. We know for a fact that SQL is the language used for relational database management systems. See what else you know about it and various databases by taking this test!
Questions and Answers
- 1.The data model used in ABAP courses from SAP is the _______ Data Model.
- A.
ERP
- B.
NetWeaver
- C.
ABAP
- D.
Flight
- 2.The Database table is created as soon as we hit SAVE in the Data Dictionary
- A.
True
- B.
False
- 3.Transaction Code ____ is the Data Dictionary
- 4.SELECT can be used in internal tables as well
- A.
True
- B.
False
- 5.Tables MARA is one table and is created in the underlying DB as one table with the same name. therefore it is a ___________ table
- 6.This statement is used to retrieve data from the DB....__________
- 7.In order to read data from a different client we must use this option of the SELECT statement (two words) ______ ______
- 8.DATA: i_mara type table of mara, wa_mara like line of i_mara. Select * from MARA INTO wa_mara. What is syntactically wrong with this statement?
- A.
Missing WHERE
- B.
This is native SQL
- C.
Missing ENDSELECT.
- D.
What language is this!?
- 9.SELECT...... INTO ____ . .... is an array fetch
- 10.These statement can change DB entries....
- A.
REFRESH
- B.
MODIFY
- C.
DELETE
- D.
UPDATE
- E.
INSERT
- 11.What statement is used to check for authorization values of the user?
- 12.This field holds the result of the AUTHORITY-CHECK statement.
- A.
SY-UZEIT
- B.
SY-AUTHORIZED
- C.
SY-SUBRC
- D.
SY-IDONTKNOW
Back to top