Olete.in – MCQs, Mock Tests & Government Job Prep | SAP HANA Sap Hana Multiple Choice Questions Set 2

How many perspectives are available in SAP HANA Studio (SPS03)?

1. 4
2. 8
3. 9
4. 10

✅ Correct Answer: 2

Which perspective is used to create joins?

1. Administration & Modeling
2. Debug & Modelling
3. Modeler
4. All of the above

✅ Correct Answer: 3

The SAP HANA system can be created within _____

1. Modeler
2. Resource
3. Navigator
4. SAP GUI

✅ Correct Answer: 3

The login user who has maximum authorizations in an SAP HANA database is ______

1. SYS
2. SYSTEM
3. Administrator
4. Root

✅ Correct Answer: 2

By default, the maximum number of rows displayed from a table is ______

1. 1000
2. 5000
3. Unlimited
4. None of the Above

✅ Correct Answer: 2

When the Administration Console is the perspective selected, which of the following can be viewed under the HANA system?

1. Catalog
2. Content
3. Both of them
4. None of Them

✅ Correct Answer: 1

In the SAP HANA Studio, the physical tables are stored ______

1. Under Catalogs
2. Under Content
3. In both
4. Nowhere

✅ Correct Answer: 1

When deleting a table, what options can be selected? (

1. When deleting a table, what options can be selected? (2 correct answers) A. Delete Catalog Object B. C. D. All of the above
2. Delete All Rows
3. Drop The Table
4. Both (A) and (B)

✅ Correct Answer: 4

Users are created under ______

1. Catalog
2. Content
3. Any of them
4. None of them

✅ Correct Answer: 1

To create a user, we have to ________

1. Use T-Code SU01
2. Use T-Code SU10
3. Use Users folder under Authorization in Catalog
4. Use Users folder under Authorization in Content

✅ Correct Answer: 3

Which user has privileges to Root Package?

1. SYS
2. SYSTEM
3. Both of the above
4. Administrator

✅ Correct Answer: 2

Which role is specifically assigned to a user involved in creating views?

1. SAPSR3_POWER_USER
2. PUBLIC
3. MODELING
4. None of the above

✅ Correct Answer: 3

SAP HANA database is ______

1. Oracle based
2. Sybase based
3. MS SQL based
4. Informix based

✅ Correct Answer: 2

Joins are created under ______

1. Content
2. Catalog
3. Schema
4. Authorization

✅ Correct Answer: 1