VB Interview Questions
9 Apr, 2007
- Which property of the form changes the form’s title?
- Name
- Heading
- Title
- Caption
- Logo
- Labels do not respond to _____ and ______ events.
- Got_Focus, Lost_Focus
- Click, DblClick
- Dragdrop, OLECompleteDrag
- Change, Link Error
- Which of the following statements is capable of abandoning a series of modifications made to a recordset locked with a BatchOptimistic lock?
- CancelUpdate
- CancelBatch
- CancelBatchUpdate
- AbandonBatch
- AbandonBatchUpdate
- Rollbackupdate
- Rollbackbatch
- None of the above
- Which three methods does the collection object support?
- Let, Get, Set
- Load, Unload, Count
- Add, Remove, Item
9 Apr, 2007
- Message Boxes can hold a maximum of _______ characters.
- 256
- 512
- 1024
- 2046
- 4092
- 5000
- 10000
- No limit
- Which parameter of the Execute method of the Connection object returns the number of records that the operation affected?
- RecordsAffected
- RowsAffected
- RecordsUpdated
- RowsOperated
- RecordsOperated
- Which of the following is not an element of the ADO model?
- Database
- Error
- Connection
- Parameter
- Recordset
- Field
- Driver
- What data type is the HelpContextID?
- String
- Integer
- Single
- Double
- Long
- Char
- Float
9 Apr, 2007
- Which of the following has the highest order of precedence?
- Functions and Parenthesis
- Multiplication, Division and Exponents
- Addition and Subtraction
- Logical Operations
- When designing a database table, how do you avoid missing column values for non-primary key columns?
- Use UNIQUE constraints
- Use PRIMARY KEY constraints
- Use DEFAULT and NOT NULL constraints
- Use FOREIGN KEY constraints
- Use SET constraints
- Which of the following is the syntax for creating an Index?
- CREATE [UNIQUE] INDEX index_name OF tbl_name (index_columns)
- CREATE [UNIQUE] INDEX OF tbl_name (index_columns)
- CREATE [UNIQUE] INDEX ON tbl_name (index_columns)
9 Apr, 2007
- Which one of the following correctly selects rows from the table myTable that have null in column column1?
- SELECT * FROM myTable WHERE column1 is null
- SELECT * FROM myTable WHERE column1 = null
- SELECT * FROM myTable WHERE column1 EQUALS null
- SELECT * FROM myTable WHERE column1 NOT null
- SELECT * FROM myTable WHERE column1 CONTAINS null
- Is this statement true or false:
A cursor is a pointer that identifies a specific working row within a set
- Which of the following commands is used to change the structure of table?
9 Apr, 2007
- Consider the following two tables:
1. customers( customer_id, customer_name)
2. branch ( branch_id, branch_name )
What will be the output if the following query is executed:
Select * branch_name from customers,branch
- It will return the fields customer_id, customer_name, branch_name
- It will return the fields customer_id, customer_name, branch_id, branch_name
- It will return the fields customer_id, customer_name, branch_id, branch_name, branch_name
- It will return an empty set since the two tables do not have any common field name
- It will return an error since * is used alone for one table only
- Which of the following is not a control statement?
Pages (5): « 1 2 [3] 4 5 »
