Database And SQL Trivia Quiz!

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

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: 9507 | 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: 3571 | Last updated: Mar 2, 2019

Sample Question
When did SQL appear

1974

1922

1977

1987

Oracle Mock Test 2(SQL +arch)

Questions: 26 | Attempts: 3441 | Last updated: Jan 24, 2013

Sample Question
Which SELECT statement should you use if you want to display unique combinations of the POSITION and MANAGER values from the EMPLOYEE table?

SELECT DISTINCT position, manager FROM employee;

SELECT position, manager DISTINCT FROM employee;

SELECT position, manager FROM employee;

SELECT position, DISTINCT manager FROM employee;

More Sql Quizzes

Featured Quizzes

Are You Really Best Friends? Take The Quiz & Prove It Are You Really Best Friends? Take The Quiz & Prove It

What Anime Character Do I Look Like Quiz What Anime Character Do I Look Like Quiz

Are You Ready For IQ Quiz Are You Ready For IQ Quiz

Which Doraemon Character Are You? Which Doraemon Character Are You?

Types of Sentences Quiz Types of Sentences Quiz

What is The Perfect Gift for Your Best Friend Quiz What is The Perfect Gift for Your Best Friend Quiz

Back to top