12 Questions |
By Tmaharaj007 | Last updated: Aug 7, 2019
| Total Attempts: 656
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
The data model used in ABAP courses from SAP is the _______ Data Model.
The Database table is created as soon as we hit SAVE in the Data Dictionary
Transaction Code ____ is the Data Dictionary
SELECT can be used in internal tables as well
Tables MARA is one table and is created in the underlying DB as one table with the same name. therefore it is a
This statement is used to retrieve data from the DB....__________
In order to read data from a different client we must use this option of the SELECT statement (two words) ______ ______
DATA: i_mara type table of mara, wa_mara like line of i_mara.
Select * from MARA
What is syntactically wrong with this statement?
This is native SQL
What language is this!?
SELECT...... INTO ____ .
.... is an array fetch
These statement can change DB entries....
What statement is used to check for authorization values of the user?
This field holds the result of the AUTHORITY-CHECK statement.
A server query language is designed so that users can retrieve specific information from a database. As a software developer, you should have some knowledge of the use of such languages. Do you believe you understand SQL...
Questions: 42 | Attempts: 9507 | Last updated: Mar 19, 2021
Which SQL function is used to count the number of rows in a SQL query?