Tag: programming languages

Questions Related to programming languages

Choose the correct statements for creating a table?

technology programming languages

  1. Names are case sensitive.

  2. Names must not be oracle server reserve word.

  3. Table names and column names need not be start with a letter.

  4. We cannot use a column alias in a WHERE clause

Show answer
Correct Option: B,D

Table may also called as

technology programming languages

  1. Relation

  2. Entity

  3. Records

  4. Fields

Show answer
Correct Option: A,B

The process of modeling data into relational tables is called normalization.
technology programming languages

  1. True

  2. False

Show answer
Correct Option: A

Which of the following are Data manipulation language commands(DML)?
technology programming languages

  1. Select

  2. Insert

  3. Update

  4. Create

  5. Delete

  6. Alter

Show answer
Correct Option: A,B,C,E

At what situation you will create Index?
technology programming languages

  1. The column contain wide range of values.

  2. The column contain large number of Null values.

  3. The table is large.

  4. Columns which are not frequently used.

Show answer
Correct Option: A,B,C

Which operation code allows you to update only specified fields on a record?

technology programming languages

  1. EXFMT

  2. UPDAT

  3. EXCPT

  4. WRITE

Show answer
Correct Option: C

In RPG, how would you reverse the sign of a numeric field?
technology programming languages

  1. Z-SUB

  2. MULT -1

  3. 0 SUB

  4. all the above

Show answer
Correct Option: D

What is the maximum number of files that can be specified in a RPG400 program?
technology programming languages

  1. 40

  2. 60

  3. 100

  4. 50

Show answer
Correct Option: D

What is the value of RESULT after the following process: C Z-ADD3 T 20 C MOVEL'ABCDEF' STRING 10 C 2 SUBSTSTRING:T RESULT 90

technology programming languages

  1. CD

  2. BC

  3. DE

  4. EF

Show answer
Correct Option: A

CPF4131 message indicates a level check error?

technology programming languages

  1. True

  2. False

Show answer
Correct Option: B