Database And SQL Trivia Quiz!

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

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

Related Topics

More Sql Quizzes

The Ultimate Server Query Language Quiz

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: 8507 | Last updated: Mar 19, 2021

Sample Question
Which SQL function is used to count the number of rows in a SQL query?

COUNT()

NUMBER()

SUM()

Basic SQL Quiz For School Learners!

This is a quiz on the SQL system. needed for learning at school

Questions: 10 | Attempts: 3484 | Last updated: Mar 2, 2019

Sample Question
When did SQL appear

1974

1922

1977

1987

SQL Data Manipulation Language Trivia Quiz!

Welcome to the SQL data manipulation quiz. It is designed to test out just how much you understand when it comes to data manipulation, which is essentially editing, deleting, or changing the data as well as you can. It is perfect...

Questions: 20 | Attempts: 1342 | Last updated: Sep 2, 2019