Database And SQL Trivia Quiz!

12 Questions | By Tmaharaj007 | Last updated: Aug 7, 2019 | Total Attempts: 645

Questions

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