Tag: programming languages

Questions Related to programming languages

Coding two INITIALIZATION events will cause a syntax error.
technology programming languages

  1. True

  2. False

Show answer
Correct Option: A

When creating a transparent table in the ABAP Dictionary, which step automatically creates the table in the underlying database?
technology programming languages

  1. Adding technical settings to the table

  2. Checking the table syntax

  3. Saving the table

  4. Activating the table

Show answer
Correct Option: D
Explanation:

To create a transparent table in the ABAP Dictionary, the user must perform several steps. However, only one of these steps automatically creates the table in the underlying database.

The user needs to know that transparent tables are used to store data in the database and can be accessed using SQL commands.

Now, let's go through each option and explain why it is right or wrong:

A. Adding technical settings to the table: This step is necessary in order to define the structure of the table, such as the fields and their data types, keys, and other technical settings. However, it does not automatically create the table in the database.

B. Checking the table syntax: This step checks the syntax of the table definition and ensures that it is valid. It does not create the table in the database.

C. Saving the table: This step saves the table definition in the ABAP Dictionary, but it does not create the table in the database.

D. Activating the table: This step automatically creates the table in the underlying database. When the user activates the table, the system generates the SQL code to create the table and execute it in the database.

Therefore, the correct answer is:

The Answer is: D

A field declared as type T has the following internal representation
technology programming languages

  1. SSMMHH

  2. HHMMSS

  3. MMHHSS

  4. HHSSMM

Show answer
Correct Option: B

If you use a RUN statement with a PROC SQL step
technology programming languages

  1. SAS ignores the RUN statement, executes the statements as usual.

  2. Stop running due to error.

  3. Executes the code with a warning note

  4. Unexpected Result.

Show answer
Correct Option: A

Complete the SELECT clause below to create a new column named Profit by subtracting the values of the column Cost from those of the column Price. select fruit,cost,price, ________________
technology programming languages

  1. Profit=price-cost

  2. price-cost as Profit

  3. profit=price-cost

  4. Profit as price-cost

Show answer
Correct Option: B

Which PROC SQL query will remove duplicate values of MemberType from the query output, so that only the unique values are listed?
technology programming languages

  1. proc sql nodup; select membertype from sasuser.frequentflyers;

  2. proc sql; select distinct(membertype) as MemberType from sasuser.frequentflyers;

  3. proc sql; select unique membertype from sasuser.frequentflyers group by membertype;

  4. proc sql; select distinct membertype from sasuser.frequentflyers;

Show answer
Correct Option: D

What happens if you use a GROUP BY clause in a PROC SQL step without a summary function?
technology programming languages

  1. The step does not execute.

  2. The first numeric column is summed by default.

  3. The GROUP BY clause is changed to an ORDER BY clause.

  4. The step executes but does not group or sort data.

Show answer
Correct Option: C

Which clause in the following program is incorrect? proc sql; select sex,mean(weight) as avgweight from company.employees company.health where employees.id=health.id group by sex;
technology programming languages

  1. SELECT

  2. FROM

  3. WHERE

  4. GROUP BY

Show answer
Correct Option: B

You are creating a PROC SQL query that will list all employees who have spent (or overspent) their allotted 120 hours of vacation for the current year. The hours that each employee used are stored in the existing column Spent. Your query defines a new column, Balance, to calculate each employee’s balance of vacation hours. Which query will produce the report that you want?

technology programming languages

  1. proc sql; select name, spent, 120-spent as calculated Balance from Company.Absences where balance <= 0

  2. proc sql; select name, spent, 120-spent as Balance from Company.Absences where calculated balance <= 0;

  3. proc sql; select name, spent, 120-spent as Balance from Company.Absences where balance <= 0;

  4. proc sql; select name, spent, 120-spent as calculated Balance from Company.Absences where calculated balance <= 0;

Show answer
Correct Option: B

AI Explanation

To answer this question, let's go through each option to understand why it is correct or incorrect:

Option A) proc sql; select name, spent, 120-spent as calculated Balance from Company.Absences where balance &lt;= 0

This option is incorrect because it references a column balance in the where clause, which does not exist in the table.

Option B) proc sql; select name, spent, 120-spent as Balance from Company.Absences where calculated balance &lt;= 0;

This option is correct because it calculates the balance of vacation hours using the expression 120-spent and assigns it to the column Balance. It then filters the records where the calculated balance is less than or equal to zero.

Option C) proc sql; select name, spent, 120-spent as Balance from Company.Absences where balance &lt;= 0;

This option is incorrect because it references a column balance in the where clause, which does not exist in the table.

Option D) proc sql; select name, spent, 120-spent as calculated Balance from Company.Absences where calculated balance &lt;= 0;

This option is incorrect because it references a column calculated balance in the where clause, which is not defined in the select statement.

The correct answer is Option B. This option correctly calculates the balance of vacation hours and filters the records where the calculated balance is less than or equal to zero.

What is the purpose of the following statement ---- PROC SQL INOBS= 10;
technology programming languages

  1. Restricts the number of rows (observations) that PROC SQL retrieves from any single source.

  2. Restricts the number of rows (observations) that PROC SQL can print.

  3. Directs the system to start reading the source from 10th observation.

  4. None of the above.

Show answer
Correct Option: A