9 Apr, 2007
VB Interview Questions
- 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?
- if…else
- if exists
- do…while
- while
- begin…end
- Which of the following is not a valid Numeric datatypes in SQL Server?
- INT
- SMALLINT
- TINYINT
- BIGINT
- MONEY
- Which of the following datatypes is not supported by SQL-Server?
- Character
- Binary
- Logical
- Date
- Numeric
- All are supported
- What will the output be if you try to perform arithmetic on NULL values?
- 0
- NULL
- It will generate an error message
- Can’t be determined
- Which of the following options is not correct about the DATEDIFF() function?
- It returns the difference between parts of two specified dates
- It takes three arguments
- It returns a signed integer value equal to second date part minus first date part
- It returns a signed integer value equal to first date part minus second date part
- Sample Code
CREATE TABLE table1(
column1 varchar(50),
column2 varchar(50),
column3 varchar(50),
column4 varchar(50));
Which one of the following is the correct syntax for adding the column named “column2a” after column2 to the table shown above?
- ALTER TABLE table1 ADD column2a varchar(50) AFTER column2;
- MODIFY TABLE table1 ADD column2a AFTER column2;
- INSERT INTO table1 column2a AS varchar(50) AFTER column2;
- ALTER TABLE table1 INSERT column2a varchar(50) AFTER column2;
- CHANGE TABLE table1 INSERT column2a BEFORE column3;
- State which of the following are true
- Views are a logical way of looking at the logical data located in the tables
- Views are a logical way of looking at the physical data located in the tables
- Tables are physical constructs used for storage and manipulation of data in databases
- Tables are logical constructs used for storage and manipulation of data in databases
- Which of the following is not a valid binary datatype in SQL Server?
- BINARY
- VARBINARY
- BIT
- IMAGE
- TESTAMP
- Which of the following is false with regards to sp_help?
- When a procedure name is passed to sp_help, it shows the parameters
- When a table name is passed to sp_help, it shows the structure of the table
- When no parameter is passed, it provides a list of all objects and user-defined datatypes in a database
- All of the above are true
- Which of the following are false for batches (batch commands)?
- Statements in a batch are parsed, compiled and executed as a group
- None of the statements in the batch is executed if there are any syntax errors in the batch
- None of the statements in the batch is executed if there are any parsing errors in the batch
- None of the statements in the batch is executed if there are any fatal errors in the batch
- Select the correct option:
- Optimistic locking is a locking scheme handled by the server, whereas pessimistic locking is handled by the application developer
- Pessimistic locking is a locking scheme handled by the server, whereas optimistic locking is handled by the application developer
