Hello Friends if you are looking SAP C_ABAPD_2309 Free Practise Test | C_ABAPD_2309 Certification Exam Test | SAP C_ABAPD_2309 Free Test | C_ABAPD_2309 SAP Back-End Developer – ABAP Cloud Online Test then you will get the Test Here.
Note : The questions which are given here are for practise purpose only. In Your Certification Exam this type of Questions may Occur. So please Study wisely and go for Exam. All the Best!!!
For More Practise Test of SAP – Join Our Telegram Channel
You have two internal tables itab1 and itab2.What is true for using the expression itab1 = corresponding #( itab2 )? Note: There are 2 correct answers to this question.
A Fields with the same name but with different types may be copied from itab2 to itab1.
B itab1 and itab2 must have at least one field name in common.
C Fields with the same name and the same type will be copied from itab2 to itab1.
D itab1 and itab2 must have the same data type.
Ans: B C
In RESTful Application Programming, a business object contains which parts? Note: There are 2 correct answers to this question.
A CDS view
B Behavior definition
C Authentication rules
D Process definition
Ans: A B
What are the effects of this annotation? Note: There are 2 correct answers to this question.
A The value of sy-langu will be passed to the CDS view automatically both when you use the -1 CDS view in ABAP and in another CDS view entity (view on view).
B You can still override the default value with a value of your own.
C The value of sy-langu will be passed to the CDS view automatically when you use the CDS view in ABAP but not when you use it in another view entity
D It is no longer possible to pass your own value to the parameter.
Ans: A B
What are some characteristics of secondary keys for internal tables? Note: There are 3 correct answers to this question.
A Secondary keys must be chosen explicitly when you actually read from an internal table.
B Multiple secondary keys are allowed for any kind of internal table.
C Hashed secondary keys do NOT have to be unique.
D Sorted secondary keys do NOT have to be unique.
E Secondary keys can only be created for standard tables.
Ans: A B D
Which of the following are incomplete ABAP types? Note: There are 2 correct answers to this question.
A String
B T
C C
D P
Ans: C D
Which statement can you use to change the contents of a row of data in an internal table?
A Append table
B Modify table
C Insert table
D Update table
Ans: B
You want to provide a short description of the data definition for developers that will be attached to the database viewWhich of the following annotations would do this if you inserted it on line #27
A @UI headerinto description label
B @UI.badge.title.label
C @EndUserText.quickInfo
D @EndUserText label
Ans: D
To adhere to the most recent ABAP SQL syntax conventions from SAP, on which line must you insert the “INTO TABLE @gt flights” clause to complete the SQL statement?
A #15
B #4
C #6
D #8
Ans: B
Which of the following ON conditions must you insert in place of “???”?
A ON Z_Sourcel.camer_id = 7_Source2 carrier_id
B ON Sprojection Camer=Source2 carrier_id
C ON Sprojection. Carrier Source2.carrier
D ON Sprojection.carrier_id=Z_Source2.carrier_id
Ans: D
What are valid statements? Note: There are 3 correct answers to this question
A In class CL1, the interface method is named if-ml.
B Class CL2 uses the interface.
C Class CL1 uses the interface.
D In class CL2, the interface method is named ifl-ml.
E Class CL1 implements the interface.
Ans: CDE
when you attempt to activate the definition, what will be the response?
A Activation error because the field names of the union do not match
B Activation error because the field types of the union do not match
C Activation error because the key fields of the union do not match
D Activation successful
Ans: A
Which of the following are ABAP Cloud Development Model rules?
Note: There are 2 correct answers to this question.
A Use public SAP APIs and SAP extension points.
B Build ABAP RESTful application programming model-based services.
C Reverse modifications when a suitable public SAP API becomes available.
D Build ABAP reports with either ABAP List Viewer (ALV) or SAP Fiori.
Ans: A
Which function call returns 0?
A Count_any_of ( val – `ABAP ABAP abap’ sub “AB” )
B Count (val – ‘ABAP ABAP abap’ sub – ‘AB’ )
C find_any_of (val = “ABAP ABAP abap’ sub = “AB”)
D find_any_not_of( val ‘ABAP ABAP abap’ sub = ‘AB’)
Ans: D
In which products must you use the ABAP Cloud Development Model?
Note: There are 2 correct answers to this question.
A SAP S/4HANA Cloud, private edition
B SAP BTP, ABAP environment
C SAP S/4HANA on premise
D SAP S/4HANA Cloud, public edition
Ans: A B
Which RESTful Application Programming object can be used to organize the display of fields in an app?
A Data model view
B Metadata extension
C Service definition
D Projection view
Ans: B
When accessing the subclass instance through go_super, what can you do?
Note: There are 2 correct answers to this question.
A. Accss the inherited private components.
B. Access the inherited public components.
C.Call a subclass specific public method
D. Call inherited public redefined methods.
Ans: A B
Given the following code in an SAP S/4HANA Cloud private edition tenant:
The class zcl_demo_class is in a software component with the language version set to “ABAP Cloud”. The function module ZF1′ is in a different software component with the language version set to “Standard ABAP”. Both the class and function module are customer created. Regarding line #6, which of the following are valid statements?
Note: There are 2 correct answers to this question.
A ZF1′ can be called only if it is released for cloud development.
B ‘ZF1’ can be called if a wrapper is created for it and the wrapper itself is released for cloud development.
C “ZF1” can be called whether it is released or not for cloud development
D ZF1″ can be called if a wrapper is created for it but the wrapper itself is not released for cloud development.
Ans: A B
Which restrictions exist for ABAP SQL arithmetic expressions?
Note: There are 2 correct answers to this question.
A Floating point types and integer types can NOT be used in the same expression.
B The operator/is allowed only in floating point expressions.
C Decimal types and integer types can NOT be used in the same expression.
D The operator is allowed only in floating point expressions.
Ans: BD
What are valid statements?
Note: There are 2 correct answers to this question.
A ##NEEDED is checked by the syntax checker.
B The pragma is not checked by the syntax checker.
C #EC_NEEDED is not checked by the syntax checker.
D The pseudo-comment is checked by the syntax checker
Ans: AB
Which internal table type allows unique and non-unique keys?
- Sorted
- Hashed
- Standard
Ans: 3
In this nested join below in which way is the join evaluated?
Which extensibility type does SAP recommend you use to enhance the existing UI for an SAP Fiori app?
A Key user
B Classic
C Side-by-side
D Developer
Ans: D
In the following ABAP SQL code, what are valid case distinctions?
Note: There are 2 correct answers to this question.
A)
B)
C)
D)
Ans: AB
What are some features of a unique secondary key?
Note: There are 2 correct answers to this question.
- It is created when a table is filled.
- It is updated when the modified table is read again.
- It is created with the first read access of a table.
- It is updated when the table is modified.
Ans: 3 4
Refer to the exhibit.
Which of the following types are permitted to be used for <source> on line #4?
Note: There are 2 correct answers to this question.
- A database table from the ABAP Dictionary
- A CDS DDIC-based view
- An external view from the ABAP Dictionary
- A database view from the ABAP Dictionary
Ans:1 2
When processing a loop with the statement DO… ENDDO, what system variable contains the implicit loop counter?
- sy-linno
- sy-labix
- sy-subrc
- sy-index
Ans:4
Which patterns raise an exception?
Note: There are 3 correct answers to this question.
- DATA: gv_target TYPE p DECIMALS 2. CONSTANTS: go intl TYPE i VALUE 3. gv_target -U EXACT (2 gcojntl).
- DATA: gv_target TYPE string. CONSTANTS: gco_string TYPE LENGTH 16 VALUE 0123456789ABCDEF*. gv_target = EXACT # gco_string+5 (5) ).
- DATA: gv_target TYPE c LENGTH 5. V CONSTANTS: ECO string TYPE string VALUE 0123456789ABCDEF”. gv_target – EXACT (gco_string + 5 (6) ).
- DATA: Ev target TYPE p DECIMALS 3. CONSTANTS: gcojntl TYPE i VALUE 2. Ev_target -U EXACT #2 / gcojntl ).
- DATA: gv_target TYPE d. s/ CONSTANTS: gco_date TYPE d VALUE ‘20331233*. gv_target EXACT ( geo_date).
Ans:1 3 5
Which of the following are features of Core Data Services?
Note: There are 3 correct answers to this question.
- Inheritance
- Associations
- Annotations
- Delegation
- Structured Query Language (SQL)
Ans:2 3 5
What is the purpose of a foreign key relationship between two tables in the ABAP Dictionary?
- To document the relationship between the two tables
- To ensure the integrity of data in the corresponding database tables
- To create a corresponding foreign key relationship in the database
Ans:2
When does SAP recommend to use a sorted or a hashed table respectively?
Note: There are 2 correct answers to this question.
- A hashed table, when you read a single record and specify the complete key.
- A hashed table, when you read a subset in a loop and specify a part of the key from the left without gaps.
- A sorted table, when you read a subset in a loop and specify a part of the key from the left ^ without gaps.
- A sorted table, when you read a single record and specify non key fields.
Ans:1 2
Class super has subclass sub.
Which rules are valid for the sub constructor?
Note: There are 2 correct answers to this question.
- The method signature can be changed.
- Import parameters can only be evaluated after calling the constructor of super.
- The constructor of super must be called before using any components of your own instance.
- Events of your own instance cannot be raised before the registration of a handler in super.
Ans:1 3
In an Access Control Object, which clauses are used?
Note: There are 3 correct answers to this question.
- Where (to specify the access conditions)
- Crant (to identify the data source)
- Return code (to assign the return code of the authority check)
- Define role (to specify the role name)
- Revoke (to remove access to the data source)
Ans:1 4 5
What are some of the reasons that Core Data Services are preferable to the classical approach to data modeling?
Note: There are 2 correct answers to this question.
- They implement code pushdown.
- They avoid data transfer completely.
- They transfer computational results to the application server.
- They compute results on the application server.
Ans:1 3
Which of the following statements are correct?
Note: There are 2 correct answers to this question.
- FOR defines a loop that runs over the content of source_itab
- source_itab is only visible within the loop.
- row is a predefined name and cannot be chosen arbitrarily.
- row is only visible within the loop.
Ans:1 4
Class super has subclass sub.
Which rules are valid for the sub constructor?
Note: There are 2 correct answers to this question.
- The method signature can be changed.
- Import parameters can only be evaluated after calling the constructor of super.
- The constructor of super must be called before using any components of your own instance.
- Events of your own instance cannot be raised before the registration of a handler in super.
Ans:1 3
What are some of the reasons that Core Data Services are preferable to the classical approach to data modeling?
Note: There are 2 correct answers to this question.
- They implement code pushdown.
- They avoid data transfer completely.
- They transfer computational results to the application server.
- They compute results on the application server.
Ans:1 3
Which of the following statements are correct?
Note: There are 2 correct answers to this question.
- FOR defines a loop that runs over the content of source_itab
- source_itab is only visible within the loop.
- row is a predefined name and cannot be chosen arbitrarily.
- row is only visible within the loop.
Ans:1 4
Which of the following ABAP SQL statements are valid?
Note: There are 2 correct answers to this question.
- SELECT FROM /dmo/connection FIELDS carrid O airpfrom,
MAX(distance) AS dist_max, MIN( distance) AS dist_min GROUP BY carrid, airpfrom INTO TABLE @DATA(It_hits) - SELECT FROM /dmo/connection FIELDS \/ O carrid, airpfrom, MAX( distance) AS dist_max, MIN(distance) AS dist_min INTO TABLE @DATA(It_hits)
- SELECT FROM /dmo/connection FIELDS V D MAX(distance) AS dist_max MIN(distance) AS dist_min INTO TABLE @DATA(It_hits).
- SELECT FROM /dmo/connection FIELDS r–i carrid, airpfrom u GROUP BY carrid, connid INTO TABLE @DATA(It_hits).
Ans:1 2
In ABAP SQL, which of the following retrieves the association field_Airline-Name of a CDS view?
- \_Airline-Name
- /_Airline Name
- @_Airline-Name
- “_Airline Name
Ans:3
What are valid statements?
Note: There are 2 correct answers to this question.
- “zcxl” is a dictionary structure, and “paraml” and “param2” are this structure.
- “paraml11 and “param2” are predefined names.
- The code creates an exception object and raises an exception.
- “previous” expects the reference to a previous exception
Ans:3 4
What RESTful Application Programming object contains only the fields required for a particular app?
- Database view
- Metadata extension
- Projection View
- Data model view
Ans:3
In a RESTful Application Programming application, in which objects do you bind a CDS view to create a value help?
Note: There are 3 correct answers to this question.
- Data model view
- Behavior definition
- Metadata Extension
- Service Definition
- Projection View
Ans:1 3 5
What are advantages of using a field symbol for internal table row access?
Note: There are answers to this question.
- The field symbol can be reused for other programs.
- A MODIFY statement to write changed contents back to the table is not required.
- The row content is copied to the field symbol instead to a work area
- Using a field symbol is faster than using a work area.
Ans:2 4
In what order are objects created to generate a RESTful Application Programming application?
- Database table 1
- Service binding Projection view 4
- Service definition 3
- Data model view 2
Ans:1 4 3 2
In a program you find this source code
AUTHORITY-CHECK OBJECT ‘/DWO/TRVL ( ID ‘CNTRY’ FIELD ‘DE* ID ACTVT FIELD ’03”.
Which of the following apply?
Note: There are 2 correct answers to this question.
- If the user is authorized for ‘CNTRY = ‘DE’ then the return code is always 0.
- If the user is NOT authorized for ‘CNTRY’ = ‘DE’ OR for ‘ACTVT’ = ’03 then the program will terminate.
- If the user is authorized for ‘CNTRY = ‘DE’ AND for ‘ACTVT = ’03 then the return code is 0.
- AUTHORITY CHECK verifies whether a user is authorized for/DMO/TRVL” with the listed field values.
Ans: 3 4
You are given the following information:
1.
The data source “spfli” on line #2 is an SAP HANA
database table
2.
“spfli” will be a large table with over one million rows.
3.
This program is the only one in the system that accesses the table.
4.
This program will run rarely.
Based on this information, which of the following general settings should you set for the spfli database table?
Note:
There are 2 correct answers to this question.
- “Storage Type” to “Column Store”
- “Load Unit to “Column Loadable”
- “Storage Type” to “Row Store”
- “Load Unit’ to ‘Page Loadable”
Ans: 3 4
Which of the following actions cause an indirect change to a database table requiring a table conversion?
Note: There are 2 correct answers to this question.
- Renaming a field in a structure that is included in the table definition
- Changing the field labels of a data element that is used in the table definition.
- Deleting a field from a structure that is included in the table definition.
- Shortening the length of a domain used in a data element that is used in the table definition.
Ans: 1 3
Which of the following are parts of answers to this question.
- Partitioning attributes
- Extension
- Field list
- Semantic table attributes
Ans: 2 3
What are some properties of database tables?
Note: There are 2 correct answers to this question.
- They store information in two dimensions.
- They may have key fields.
- They can have any number of key fields.
- They can have relationships to other tables.
Ans: 1 4
Which type of legacy code does SAP recommend you eliminate when you review modifications as part of an SAP S/4HANA system conversion?
Note: There are 2 correct answers to this question.
- Code that supports a critical business process
- Code that now is identical to a standard SAP object
- Code that has less than 10% usage according to usage statistics
- Code that can be redesigned as a key user extension
Ans: 2 4
Why would you use Access Controls with CDS Views?
Note: There are 2 correct answers to this question.
- Only the data corresponding to the user’s authorization is transferred from the database to the application layer.
- The system field sy-subrc is set, giving you the result of the authorization check
- You do not have to remember to implement AUTHORITY CHECK statements.
- All of the data from the data sources is loaded into your application automatically and filtered there according to the user’s authorization.
Ans: 1 3
Which ABAP SQL clause allows the use of inline declarations?
- FROM
- INTO CORRESPONDING FIELDS OF
- INTO
- FIELDS
Ans: 3
In class ZCL_CLASS_A, you use the statement DATA var TYPE ***
What may stand in place of ***?
Note: There are 2 correct answers to this question.
- The name of a type defined privately in class ZCL_CLASS_A
- The name of a data element from the ABAP Dictionary
- The name of a type defined privately in another class
- The name of a domain from the ABAP Dictionary
Ans: 2 4
The ‘demo_ods_assoc_spfi data source referenced in line #4 contains a field ‘connid’ which you would like to expose in the element list.
Which of the following statements would do this if inserted on line #8?
A) demo_ods_assoc_spfli.connid,
B) demo_ods_assoc_spfli-connid/
C) spfli-connid,
D) _spfli.connid/
Ans: A
Which of the following ABAP SQL snippets are syntactically correct ways to provide a value for the parameter on line #4? Note: There
are 2 correct answers to this question
A) …SELECT * FROM deno_cds_param_view_entity (p_date = @ (cl_abap_context_info->get_system_date ())…
B) …SELECT * FROM deno_cds_param_view_entity (p_date – ‘20230101’)… )
C) …SELECT * FROM demo_cds_param_view_entity (p_date: 20238181′)… )
D) …SELECT * FROM demo_cds_param_view entity (p_date: $session.system_date)…
Ans: A B
with which predicate condition can you ensure that the CAST will work?
A) IS SUPPLIED
B) IS NOT INITIAL
C) IS INSTANCE OF
D) IS BOUND
Ans: C
Using ABAP SQL, which select statement selects the mat field on line #17?
A) SELECT mat FROM Material…
B) SELECT mat FROM demo_sales_cds_so_i_ve…
C) SELECT mat FROM demo_sales_so_i…
D) SELECT mat FROM demo sales cds material ve…
Ans: B
When accessing the subclass instance through go_super, what can you do? Note: There are 2 correct answers to this question
A) Access the inherited private components.
B) Access the inherited public components.
C) Call a subclass specific public method
D) Call inherited public redefined methods.
Ans: AB
The “demo_ods_assoc_spfi data source referenced in line #4 contains a field “connid” which you would like to expose in the element list.
Which of the following statements would do this if inserted on line #8?
A- demo_ods_assoc_spfli.connid,
B- demo_ods_assoc_spfli-connid/
C- spfli-connid,
D- _spfli.connid/
Ans: A
As a consultant you are posed the following question from a client who is using SAP S/4HANA Cloud,
public edition and also SAP BTP, ABAP environment.
“We are currently using an SAP Fiori app based on SAP Fiori elements that analyzes open orders. We
have determined that it should be extended via a new button on the UI which will perform an onthe-fly calculation and display the result in a quick popup for the enduser. We have been informed by
SAP that all underlying stack layers for the SAP Fiori app have been extensibility enabled.”
Based on this which of the following extension types would you recommend to the customer to add the new button?
A- RAP BO Behavior Extension
B- SAP HANA database table extension
C- RAP BO Node Extension
D- Business Service Extension
Ans: C
Which of the following are valid sort operations for internal tables? Note: There are 3 correct answers to this question.
A- Sort a standard table using
SORT itab ASCENDING.
Sort a sorted table using
B- SORT itab BY fieldl ASCENDING field2 DESCENDING.
Sort a standard table using
C- SORT itab BY field1 field2.
Sort a standard table using
D- SORT itab.
Sort a sorted table using
E.
SORT itab DESCENDING
Ans: ACD
Which of the following ABAP SQL snippets are syntactically correct ways to provide a value for the parameter on line #4? Note: There
are 2 correct answers to this question
A- …SELECT * FROM deno_cds_param_view_entity (p_date = @ (cl_abap_context_info->get_system_date ())…
B- …SELECT * FROM deno_cds_param_view_entity (p_date – ‘20230101’)… )
C- …SELECT * FROM demo_cds_param_view_entity (p_date: 20238181′)… )
D- …SELECT * FROM demo_cds_param_view entity (p_date: $session.system_date)…
Ans: A B
/DMO/I_Connection is a CDS view.
What variable type is connection full based on the following code? DATA connection full TYPE
/DMD/I_Connection.
A- Simple variable
B- Structure
C- Internal Table
Ans: B
In ABAP SQL, which of the following can be assigned an alias? Note: There are 2 correct answers to this question.
A- order criterion (from order by clause)
B- field (from field list)
C- database table
D- group criterion (from group by clause)
Ans: B C
with which predicate condition can you ensure that the CAST will work?
A- IS SUPPLIED
B- IS NOT INITIAL
C- IS INSTANCE OF
D- IS BOUND
Ans: C
For what kind of applications would you consider using on-stack developer extensions? Note: There are 2 correct answers to this question.
A- Applications that provide APIs for side by side SAP BTP apps
B- Applications that access SAP S/4HANA data using complex SQL
C- Applications that integrate data from several different systems
D- Applications that run separate from SAP S/4HANA
Ans: AB
When processing an internal table with the statement LOOP AT itab… ENDLOOP, what system variable contains the current row number?
A- sy-index
B- sy-subrc
C- sy-linno
D- sy-tabix
Ans: D
What RESTful Application Programming feature is used to ensure the uniqueness of a semantic key?
A- Validation
B- Action
C- Determination
Ans: C
In the assignment, data (gv_result) = 1/8. what will be the data type of gv_result?
A- OTYPE I
B- TYPE DEFLOAT 16
C- TYPE P DECIMALS 3
D- TYPE P DECIMALS 2
Ans: B
You want to define the following CDS view entity with an input parameter:
Define view entity Z_CONVERT With parameters currency : ???
Which of the following can you use to replace “???? Note: There are 2 correct answers to this question.
A- built-in ABAP type
B- A built-in ABAP Dictionary type
C- A data element
D- A component of an ABAP Dictionary structure
Ans: A C
For the assignment, gv_target = gv_source.
which of the following data declarations will always work without truncation or rounding? Note: There
are 2 correct answers to this question.
A- DATA gv_source TYPE string, to DATA gv_target TYPE c.
B- DATA gv_source TYPE c. to DATA gv_target TYPE string.
C- DATA gv_source TYPE d. to DATA gv_target TYPE string.
D- DATA gv_source TYPE p LENGTH 8 DECIMALS 3. to DATA gv_target TYPE p LENGTH 16 DECIMALS 2
Ans: B C
In RESTful Application Programming, which EML statement retrieves an object?
A- Find entity
B- Select entity
C- Get entity
D- Read entity
Ans: C
Which of the following is a generic internal table type?
A- SORTED TABLE
B- INDEX TABLE
C- STANDARD TABLE
D- HASHED TABLE
Ans: B
Given the following Core Data Service View Entity Data Definition:
1 @AccessControl.authorizationCheck: #NOT_REQUIRED
2 DEFINE VIEW ENTITY demo_flight_info_join
3 AS SELECT
4 FROM scarr AS a
5 LEFT OUTER JOIN scounter AS c
6 LEFT OUTER JOIN sairport AS p
7 ON p.id = c.airport
8 ON a.carrid = c.carrid
9 {
10 a.carrid AS carrier_id,
11 p.id AS airport_id,
12 c.countnum AS counter_number
13 }
In what order will the join statements be executed?
A- scarr will be joined with scounter first and the result will be joined with sairport.
B- sairport will be joined to scounter first and the result will be joined with scarr.
C- scarr will be joined with sairport first and the result will be joined with scounter.
D- scounter will be joined to sairport first and the result will be joined with scarr.
Ans: A
After you created a database table in the RESTful Application Programming model, what do you create next?
A- A metadata extension
B- A projection view
C- A data model view
D- A service definition
Ans: B
Which of the following string functions are predicate functions? Note: There are 2 correct answers to this question
A- find_any_not_of()
B- contains_any_of()
C- count_any_of()
D- matchesQ
Ans: B D
With Icl_super being superclass for Icl_subl and Icl_sub2 and with methods subl_methl and sub2_methl being subclass-specific
methods of Id_subl or Icl_sub2, respectivel. What will happen when executing these casts? Note:
There are 2 correct answers to this question
A- go subl = CAST # go super), will not work
B- go_sub2 = CAST # go super), will work. go_subl CAST #go_super), will work
C- go_sub2 = CAST #(go_super). will not work. ] go sub2->sub2 meth 1(…). will work
D- go_subl->subl_meth !(…)* w’ll work.
Ans: A D
In a subclass subl you want to redefine a component of a superclass superl. How do you achieve this? Note: There are 2 correct
answers to this question.
A- You add the clause REDEFINITION to the component in subl.
B- You implement the redefined component for a second time in superl.
C- You implement the redefined component in subl.
D- You add the clause REDEFINITION to the component in superl.
Ans: A C
What would be the correct expression to change a given string value ‘mr joe doe’ into ‘JOE’ in an ABAP SQL field list?
A- SELECT FROM TABLE dbtabl FIELDS
Of1,
upper(left( ‘mr joe doe’, 6)) AS f2_up_left, f3,
B- SELECT FROM TABLE dbtabl FIELDS
Of1,
left(lower(substring( ‘mr joe doe’, 4, 3)), 3) AS f2_left_lo_sub, f3,
C- SELECT FROM TABLE dbtabl FIELDS
Of1,
substring(upper(‘mr joe doe’), 4, 3) AS f2_sub_up, f3,…
D- SELECT FROM TABLE dbtabl FIELDS
Of1,
substring(lower(upper( ‘mr joe doe’ ) ), 4, 3) AS f2_sub_lo_up, f3,
Ans: C