Database And SQL Trivia Quiz!
12 Questions
| Attempts: 660
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
Correct Answer
D. Flight -
- 2.
The Database table is created as soon as we hit SAVE in the Data Dictionary
- A.
True
- B.
False
Correct Answer
B. False -
- 3.
Transaction Code ____ is the Data Dictionary
Correct Answer
SE11 - 4.
SELECT can be used in internal tables as well
- A.
True
- B.
False
Correct Answer
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
Correct Answer
transparent - 6.
This statement is used to retrieve data from the DB....__________
Correct Answer
select - 7.
In order to read data from a different client we must use this option of the SELECT statement (two words) ______ ______
Correct Answer
client specified - 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!?
Correct Answer
C. Missing ENDSELECT. -
- 9.
SELECT...... INTO ____ . .... is an array fetch
Correct Answer
TABLE - 10.
These statement can change DB entries....
- A.
REFRESH
- B.
MODIFY
- C.
DELETE
- D.
UPDATE
- E.
INSERT
Correct Answer(s)
B. MODIFY
C. DELETE
D. UPDATE
E. INSERT -
- 11.
What statement is used to check for authorization values of the user?
Correct Answer(s)
authority check
authority-check - 12.
This field holds the result of the AUTHORITY-CHECK statement.
- A.
SY-UZEIT
- B.
SY-AUTHORIZED
- C.
SY-SUBRC
- D.
SY-IDONTKNOW
Correct Answer
C. SY-SUBRC -
Quiz Review Timeline +
Our quizzes are rigorously reviewed, monitored and continuously updated by our expert board to maintain accuracy, relevance, and timeliness.
-
Current Version
-
Mar 19, 2022Quiz Edited by
ProProfs Editorial Team -
Nov 03, 2012Quiz Created by
Tmaharaj007
Back to top