Home › Quizzes › Informatics Practices

Informatics Practices

Covers Visual Basic 6.0 programming fundamentals and Oracle database concepts including SQL, functions, transactions, views, and joins. Suitable for Informatics Practices revision.

25 Questions Published
Play Quiz Practise this topic out loud

Questions

Question 1 Multiple Choice (Single Answer)

In VB 6.0, SDI stands for

  1. Standard Data Interface
  2. Single Document Interface
  3. Single Data Interface
  4. Standard Data Information
Question 2 Multiple Choice (Single Answer)

Sgn ( ) function is a numeric library function used to

  1. assign a sign to a number
  2. tally the sign of two numbers
  3. determine the sign of a number
  4. find out the special characters in a number
Question 3 Multiple Choice (Single Answer)

Which of the following is a selection statement in VB?

  1. For … Next Statement
  2. Do… While Statement
  3. If …Then Statement
  4. None of these
Question 4 Multiple Choice (Single Answer)

In Oracle, LPAD ( ) is a

  1. character function
  2. date function
  3. miscellaneous function
  4. numeric function
Question 5 Multiple Choice (Single Answer)

COMMIT, ROLLBACK and SAVEPOINT belong to

  1. DML
  2. DDL
  3. TCL
  4. 1NF
Question 6 Multiple Choice (Single Answer)

Which of the following is not a View in Oracle?

  1. Simple View
  2. Complex View
  3. Insert View
  4. Read Only View
Question 7 Multiple Choice (Single Answer)

A subquery is same as ______________

  1. join
  2. natural query
  3. outer query
  4. nested query
Question 8 Multiple Choice (Single Answer)

When one of the two identical columns is removed in join query, this is called________ query.

  1. Equi Join
  2. Natural Join
  3. Inner Join
  4. Unconditional Join
Question 9 Multiple Choice (Single Answer)

The container for procedures and declarations, commonly accessed by other modules within the application, is known as

  1. form module
  2. class module
  3. basic module
  4. standard module
Question 10 Multiple Choice (Single Answer)

Which of the following is the static variable?
Static Function trial() As String
Static i As String
Dim d As Double
i = A
trial = i
End Function

  1. i
  2. d
  3. i and d
  4. none of these
Question 11 Multiple Choice (Single Answer)

Format (5675.445, “00000.00”) will give the result as

  1. 05675.45
  2. 5675.4
  3. 005675.40
  4. 5,675.44
Question 12 Multiple Choice (Single Answer)

How many values do a Procedure in VB 6 returns?

  1. Many
  2. One
  3. Two
  4. No value
Question 13 Multiple Choice (Single Answer)

General Sub-procedure

  1. is created with an event
  2. tells the application how to perform specific tasks
  3. is linked to a command button
  4. can be triggered by the system
Question 14 Multiple Choice (Single Answer)

Identify the return type of the following function declaration
Public Triangle$ (Dim side as Single)

  1. String
  2. Integer
  3. Variant
  4. Double
Question 15 Multiple Choice (Single Answer)

A schema is a collection of _____________

  1. tables
  2. stored procedures
  3. tablespaces
  4. all of these
Question 16 Multiple Choice (Single Answer)

Identify the correct function declaration.

  1. Private Pseudo ( )
  2. Private Function Pseudo ( )
  3. Pseudo ( )
  4. Function Pseudo@ ( )
Question 17 Multiple Choice (Single Answer)

Which of the following is an invalid declaration of arrays?

  1. Dim arrstu (20) as Integer
  2. Dim arr(k) as Double
  3. Dim arrstu ( 1 To 20) as String
  4. Dim arrstu (2)
Question 18 Multiple Choice (Single Answer)

A library function used for producing a string with a certain number of repeating characters is

  1. string function
  2. instr function
  3. mid function
  4. left function
Question 19 Multiple Choice (Single Answer)

A bar on a menu that divides menu items into logical groups is called ____________

  1. Menu Bar
  2. Tool Bar
  3. Separator Bar
  4. Status Bar
Question 20 Multiple Choice (Single Answer)

Which of the following is the correct Sub-procedure declaration?

  1. Private Sub Month( )
  2. Call Month ( )
  3. Sub Dis_statement ( ) As Integer
  4. Sub FindError (intsal as Integer)
Question 21 Multiple Choice (Single Answer)

How many beeps will you hear in the following example?
Private Sub Command1_Click()
For i = 5 To 30 Step 5
For j = 6 To 12 Step 3
Print “Beep
Next j
Next i
End Sub

  1. 0
  2. 15
  3. 16
  4. 20
Question 22 Multiple Choice (Single Answer)

NVL ( ) function

  1. substitutes NULL value for a given value in a query result
  2. substitutes NULL value with a specified value in a query result
  3. substitutes NULL value with '00' in a query result
  4. substitutes space for NULL value in a query result
Question 23 Multiple Choice (Single Answer)

A menu which can grow and shrink at runtime is known as ___________

  1. dynamic menu
  2. shortcut menu
  3. popup menu
  4. dropdown menu
Question 24 Multiple Choice (Single Answer)

TRUNCATE command is used to

  1. delete table definition
  2. delete information from tables
  3. delete constraint on tables
  4. delete index on tables
Question 25 Multiple Choice (Single Answer)

What will be the output of the following code segment?
Static Function trial( ) As String
Static i As String
Dim d As Double
i = A
trial = i
End Function
Private Sub Command1_Click( )
Dim res As Integer
res = Val(trial())
Print res
End Sub

  1. A
  2. 0
  3. Error
  4. No output
← Back to Quizzes