MS SQL Server developer interview

By admin | April 30, 2006
  1. Which of the following has the highest order of precedence?
    • Functions and Parenthesis
    • Multiplication, Division and Exponents
    • Addition and Subtraction
    • Logical Operations
  2. 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

  3. 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)
    • CREATE [UNIQUE] INDEX index_name ON tbl_name (index_columns)
  4. Which of the following is not a valid character datatype in SQL Server?
    • BLOB
    • CHAR
    • VARCHAR
    • TEXT
    • VARTEXT
  5. Which of the following statements about SQL Server comments is false?
    • /* … */ are used for multiline comments
    • // is used for single line comments
    • – is used for single line comments
    • Nested comments are allowed i.e. /* comment 1 /* comment 2 */ comment 1*/
    • ‘ is used for single line comments
  6. Consider the following transaction code:

    Begin Transaction
    Update names_table set employee_name = "Ramesh" where employee_name = "Mahesh"
    Save Transaction SAVE_POINT
    Update salaries set salary=salary + 900 where employee_job = "Engineer"
    Rollback transaction
    Commit transaction
    What will be the result produced by this transaction?

    • “Ramesh” will be updated to “Mahesh”, but salaries of engineers will not be

      • updated

    • Neither “Ramesh” will be updated to “Mahesh”, nor the salary of engineers will be updated.
    • “Ramesh” will be updated to “Mahesh” and salary of engineers will also be

      • updated.

  7. Which of the following constraints can be used to enforce the uniqueness of rows in a table?
    • DEFAULT and NOT NULL constraints
    • FOREIGN KEY constraints
    • PRIMARY KEY and UNIQUE constraints
    • IDENTITY columns
    • CHECK constraints
  8. Which of the following are not date parts?
    • quarter
    • dayofweek
    • dayofyear
    • weekday
  9. The IF UPDATE (column_name) parameter in a trigger definition will return
    TRUE in case of an INSERT statement being executed on the triggered table:

    • Yes
    • No
    • It returns TRUE only if an UPDATE query is executed
    • Both b and c
  10. Which one of the following must be specified in every DELETE statement?
    • Table Name
    • Database name
    • LIMIT clause
    • WHERE clause
    • Column Names
  11. 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
  12. Is this statement true or false:
    A cursor is a pointer that identifies a specific working row within a set

    • True
    • False
  13. Which of the following commands is used to change the structure of table?
    • CHANGE TABLE
    • MODIFY TABLE
    • ALTER TABLE
    • UPDATE TABLE
  14. Consider the following statements and pick the correct answer:

    1. ceiling() - returns the smallest integer greater than or equal to the specified value
    2. floor() - returns the largest integer less than or equal to the specified value

    • 1 is true and 2 is false
    • 1 is false and 2 is true
    • Both 1 and 2 are true
    • Both 1 and 2 are false
  15. What is the correct SQL syntax for returning all the columns from a table named “Persons” sorted REVERSE alphabetically by “FirstName”?
    • SELECT * FROM Persons WHERE FirstName ORDER BY FirstName DESC
    • SELECT * FROM Persons SORT REVERSE ‘FirstName’

      • c . SELECT * FROM Persons ORDER BY ‘FirstName’

    • SELECT * FROM Persons ORDER BY FirstName DESC

      • SELECT * FROM Persons ORDER BY DESC FirstName

  16. What is the maximum value that can be stored for a datetime field?
    • Dec 31, 9999
    • Jun 6, 2079
    • Jan 1, 2753
    • Jan 1, 2100
  17. Consider the following queries:
    1. select * from employee where department LIKE "[^F-M]%”;
    2. select * from employee where department = “[^F-M]%”;
    Select the correct option:

    • Query 2 will return an error
    • Both the queries will return the same set of records
    • Query 2 is perfectly correct
    • Query 2 would return one record less than Query 1
  18. How can you view the structure of a table named “myTable” in SQL Server?
    • desc myTable
    • desc table myTable
    • sp_columns myTable
    • None of the above
    • Using either option a or c
  19. What does referential integrity (also called relational integrity) prevent?
    • Loss of data from employee sabotage
    • Loss of data from any one corrupted table
    • Recursive joins
    • One-to-many or many-to-many relationships between columns in a table
    • Data redundancy
  20. Which of the following is not a global variable?
    • @@colcount
    • @@error
    • @@rowcount
    • @@version
    • All are valid global variables
  21. 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
  22. Which of the following is not a control statement?
    • if…else
    • if exists
    • do…while
    • while
    • begin…end
  23. Which of the following is not a valid Numeric datatypes in SQL Server?
    • INT
    • SMALLINT
    • TINYINT
    • BIGINT
    • MONEY
  24. Which of the following datatypes is not supported by SQL-Server?
    • Character
    • Binary
    • Logical
    • Date
    • Numeric
    • All are supported
  25. 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
  26. 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
  27. 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;
  28. 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
  29. Which of the following is not a valid binary datatype in SQL Server?
    • BINARY
    • VARBINARY
    • BIT
    • IMAGE
    • TESTAMP
  30. 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
This entry was posted in Database, VB. Bookmark the permalink. Post a comment or leave a trackback: Trackback URL.

23 Comments on MS SQL Server developer interview

  1. Baljeet Chawla
    Posted 5/5/2006 at 4:03 am | Permalink

    2. When designing a database table, how do you avoid missing column values for non-primary key columns?

    Ans. Use DEFAULT and NOT NULL constraints

    3. Which of the following is the syntax for creating an Index?

    Ans. CREATE [UNIQUE] INDEX ON tbl_name (index_columns)

    4. Which of the following is not a valid character datatype in SQL Server?

    Ans. VARTEXT

    6. Consider the following transaction code:

    Begin Transaction
    Update names_table set employee_name = “Ramesh” where employee_name = “Mahesh”
    Save Transaction SAVE_POINT
    Update salaries set salary=salary + 900 where employee_job = “Engineer”
    Rollback transaction
    Commit transaction
    What will be the result produced by this transaction?

    Ans. “Ramesh” will be updated to “Mahesh”, but salaries of engineers will not be
    updated.

    7. Which of the following constraints can be used to enforce the uniqueness of rows in a table?

    Ans. PRIMARY KEY and UNIQUE constraints

    8. Which of the following are not date parts?

    Ans. dayofweek

    10. Which one of the following must be specified in every DELETE statement?

    Ans. Table Name

    11. Which one of the following correctly selects rows from the table myTable that have null in column column1?

    Ans. SELECT * FROM myTable WHERE column1 is null

    12. Is this statement true or false:
    A cursor is a pointer that identifies a specific working row within a set

    Ans. True

    13. Which of the following commands is used to change the structure of table?

    Ans. ALTER Table

    14. Consider the following statements and pick the correct answer:

    1. ceiling() - returns the smallest integer greater than or equal to the specified value
    2. floor() - returns the largest integer less than or equal to the specified value

    Ans. Both 1 and 2 are true

    15. What is the correct SQL syntax for returning all the columns from a table named “Persons” sorted REVERSE alphabetically by “FirstName”?

    Ans. SELECT * FROM Persons ORDER BY FirstName DESC

    16. What is the maximum value that can be stored for a datetime field?

    Ans. Dec 31, 9999

    18. How can you view the structure of a table named “myTable” in SQL Server?

    Ans. desc myTable

    19.What does referential integrity (also called relational integrity) prevent?

    Ans. One-to-many or many-to-many relationships between columns in a table

    20.Which of the following is not a global variable?

    Ans.@@colcount

    21. 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

    Ans. none of all

    22. Which of the following is not a control statement?

    Ans. if exists

    23. Which of the following is not a valid Numeric datatypes in SQL Server?

    Ans.

    24.Which of the following datatypes is not supported by SQL-Server?

    Ans. Logical

    25. What will the output be if you try to perform arithmetic on NULL values?

    Ans.NULL

    26. What will the output be if you try to perform arithmetic on NULL values?

    Ans. It returns a signed integer value equal to first date part minus second date part

    27. 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?

    Ans. none of all

    29. Which of the following is not a valid binary datatype in SQL Server?

    Ans. TESTAMP

  2. Rajesh S. Chandan
    Posted 5/20/2006 at 7:29 am | Permalink

    Correct Answer of Question 3 is :
    CREATE [UNIQUE] INDEX index_name ON tbl_name (index_columns)
    bz it required the name of the index.

    Thanks.

  3. Rajesh S. Chandan
    Posted 5/20/2006 at 7:59 am | Permalink

    When designing a database table, how do you avoid missing column values for non-primary key columns?
    Use DEFAULT and NOT NULL constraints

    Which of the following is the syntax for creating an Index?
    CREATE [UNIQUE] INDEX index_name ON tbl_name (index_columns)

    Which of the following is not a valid character datatype in SQL Server?
    BLOB
    VARTEXT

    Which of the following statements about SQL Server comments is false?
    – is used for single line comments
    ‘ is used for single line comments

    Begin Transaction
    Update names_table set employee_name = “Ramesh” where employee_name = “Mahesh”
    Save Transaction SAVE_POINT
    Update salaries set salary=salary + 900 where employee_job = “Engineer”
    Rollback transaction
    Commit transaction
    What will be the result produced by this transaction?
    Neither “Ramesh” will be updated to “Mahesh”, nor the salary of engineers will be updated.

    Which of the following constraints can be used to enforce the uniqueness of rows in a table?
    PRIMARY KEY and UNIQUE constraints

    Which of the following are not date parts?
    dayofweek

    The IF UPDATE (column_name) parameter in a trigger definition will return
    TRUE in case of an INSERT statement being executed on the triggered table:
    No

    Which one of the following must be specified in every DELETE statement?
    Table Name

    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

    Is this statement true or false:
    A cursor is a pointer that identifies a specific working row within a set
    True

    Which of the following commands is used to change the structure of table?
    ALTER TABLE

    Consider the following statements and pick the correct answer:
    1. ceiling() - returns the smallest integer greater than or equal to the specified value
    2. floor() - returns the largest integer less than or equal to the specified value
    Both 1 and 2 are true

    What is the correct SQL syntax for returning all the columns from a table named “Persons” sorted REVERSE alphabetically by “FirstName”?
    SELECT * FROM Persons WHERE FirstName ORDER BY FirstName DESC

    What is the maximum value that can be stored for a datetime field?
    Dec 31, 9999

    Consider the following queries:
    1. select * from employee where department LIKE “[^F-M]%”;
    2. select * from employee where department = “[^F-M]%”;
    Select the correct option:
    Query 2 will return an error

    How can you view the structure of a table named “myTable” in SQL Server?
    None of the above

    What does referential integrity (also called relational integrity) prevent?
    Data redundancy
    Which of the following is not a global variable?
    @@colcount

    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 an error since * is used alone for one table only

    Which of the following is not a control statement?
    begin…end

    Which of the following is not a valid Numeric datatypes in SQL Server?
    TINYINT

    Which of the following datatypes is not supported by SQL-Server?
    Logical

    What will the output be if you try to perform arithmetic on NULL values?
    NULL

    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

    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?
    Nothing not possible through Query Analyzer.

    State which of the following are true
    Views are a logical way of looking at the logical data located in the tables

    Which of the following is not a valid binary datatype in SQL Server?
    IMAGE

    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:
    Pessimistic locking is a locking scheme handled by the server, whereas optimistic locking is handled by the application developer

    Please send me the comments by mail if you are not agree with me.
    Thank you very much for your passion.

    Rajesh

  4. Sudhir Malik
    Posted 5/23/2006 at 12:46 am | Permalink

    18. How can you view the structure of a table named “myTable” in SQL Server?
    a.desc myTable
    b.desc table myTable
    c.sp_columns myTable
    d.None of the above
    e.Using either option a or c

    Ans. c. sp_columns myTable
    (Verified and Tested Ok.) by Sudhir Malik (IIT Roorkee, Graduate)

  5. sumith
    Posted 7/6/2006 at 3:20 am | Permalink

    what is the difference between primarykey and foreignKey in mssql

  6. mdate
    Posted 7/17/2006 at 4:02 pm | Permalink

    Which of the following has the highest order of precedence?
    Functions and Parenthesis
    Multiplication, Division and Exponents
    Addition and Subtraction
    Logical Operations

    Functions and Parenthesis

  7. Joe Gakenheimer
    Posted 7/20/2006 at 3:22 pm | Permalink

    Which of the following commands is used to change the structure of table?
    * ALTER TABLE

  8. Prateek Arora
    Posted 8/3/2006 at 12:54 pm | Permalink

    18. How can you view the structure of a table named “myTable” in SQL Server?
    a.desc myTable
    b.desc table myTable
    c.sp_columns myTable
    d.None of the above
    e.Using either option a or c

    Ans. c. sp_columns myTable

    or else you can also use sp_help mytable

  9. srinivasa rao
    Posted 8/4/2006 at 7:38 am | Permalink

    How duplicate record will be delete in sql2000?

  10. Sudeep
    Posted 8/14/2006 at 6:40 am | Permalink

    Begin Transaction
    Update names_table set employee_name = “Ramesh” where employee_name = “Mahesh”
    Save Transaction SAVE_POINT
    Update salaries set salary=salary + 900 where employee_job = “Engineer”
    Rollback transaction
    Commit transaction
    What will be the result produced by this transaction?

    Question #6 If you try to execute this statement it will give you error saying “The COMMIT TRANSACTION request has no corresponding BEGIN TRANSACTION.”
    Please correct the question.
    this should be as
    ….
    ….
    Rollback transaction SAVE_POINT
    Commit transaction

    Then the answer will be “o“Ramesh” will be updated to “Mahesh”, but salaries of engineers will not be updated”
    Becasue the SAVE_POINT will save the transaction and rollback will effect only till the save point. so the second part of the query will be rolledback but the statement above the Save Point is saved and will be commited.

    Please correct me if i am wrong.

    Thanks,
    Sudeep Srivastava

  11. helper
    Posted 8/18/2006 at 7:04 pm | Permalink

    What will the output be if you try to perform arithmetic on NULL values?
    Ans:0
    Which of the following is not a valid binary datatype in SQL Server?
    TESTAMP
    Which one of the following correctly selects rows from the table myTable that have null in column column1?
    None

  12. helper
    Posted 8/18/2006 at 7:05 pm | Permalink

    Which of the following statements about SQL Server comments is false?
    Ans:
    // is used for single line comments
    – is used for single line comments
    ‘ is used for single line comments

  13. LM
    Posted 1/10/2007 at 2:28 pm | Permalink

    23.Which of the following is not a valid Numeric datatypes in SQL Server?

    * INT
    * SMALLINT
    * TINYINT
    * BIGINT
    * MONEY
    A: All are valid

  14. LM
    Posted 1/10/2007 at 2:29 pm | Permalink

    MONEY is not a numeric

  15. Rajesh.M
    Posted 1/23/2007 at 8:49 am | Permalink

    1.Which of the following has the highest order of precedence?
    Functions and Parenthesis

    2.When designing a database table, how do you avoid missing column values for non-primary key columns?

    Use DEFAULT and NOT NULL constraints

    3.Which of the following is the syntax for creating an Index?

    CREATE [UNIQUE] INDEX index_name OF tbl_name (index_columns)

    4.Which of the following is not a valid character datatype in SQL Server?

    VARTEXT

    5.Which of the following statements about SQL Server comments is false?

    ‘

    6.Consider the following transaction code:

    Begin Transaction
    Update names_table set employee_name = “Ramesh” where employee_name = “Mahesh”
    Save Transaction SAVE_POINT
    Update salaries set salary=salary + 900 where employee_job = “Engineer”
    Rollback transaction
    Commit transaction
    What will be the result produced by this transaction?

    “Ramesh” will be updated to “Mahesh”, but salaries of engineers will not be

    7.PRIMARY KEY and UNIQUE constraints

    8.quarter
    9.nnn
    10.table
    11.SELECT * FROM myTable WHERE column1 = null
    12.true
    13.ALTER TABLE
    14true
    15.SELECT * FROM Persons ORDER BY FirstName DESC
    16.Dec 31, 9999
    17.Query 2 will return an error
    18.sp_columns myTable
    19.One-to-many or many-to-many relationships between columns in a table
    20.All are valid global variables
    21.It will return the fields customer_id, customer_name, branch_id, branch_name
    22.begin…end
    23.MONEY
    24.All are supported
    25.NULL
    26.It returns a signed integer value equal to second date part minus first date part
    27.ALTER TABLE table1 ADD column2a varchar(50) AFTER column2;
    28.Views are a logical way of looking at the logical data located in the tables
    29.TESTAMP

  16. bsrd
    Posted 3/13/2007 at 6:57 am | Permalink

    23.Which of the following is not a valid Numeric datatypes in SQL Server?

    * INT
    * SMALLINT
    * TINYINT
    * BIGINT
    * MONEY
    A: MONEY (see data types overview in SQL Book)

  17. vigneshwaran.balu
    Posted 6/30/2007 at 2:30 am | Permalink

    .ALTER TABLE table1 ADD column2a varchar(50) AFTER column2;

    The above showned code is not correct code to add the new column inbetween the existing column

    if u know pls forward to my id

  18. Bhavin Parikh
    Posted 1/8/2008 at 4:01 am | Permalink

    17. Consider the following queries:
    1. select * from employee where department LIKE “[^F-M]%”;
    2. select * from employee where department = “[^F-M]%”;
    Select the correct option:
    * Query 2 will return an error
    * Both the queries will return the same set of records
    * Query 2 is perfectly correct
    * Query 2 would return one record less than Query 1
    Ans. Both the queries will return the same set of records

  19. Prabhat Jana
    Posted 1/8/2008 at 10:59 am | Permalink

    21. 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

    Ans. 3. It will return the fields customer_id, customer_name, branch_id, branch_name, branch_name

  20. RaiS
    Posted 1/16/2008 at 5:07 am | Permalink

    1. Which of the following has the highest order of precedence?
    Functions and Parenthesis

    2. When designing a database table, how do you avoid missing column values for non-primary key columns?
    Use DEFAULT and NOT NULL constraints

    3. Which of the following is the syntax for creating an Index?
    CREATE [UNIQUE] INDEX index_name ON tbl_name (index_columns)

    4. Which of the following is not a valid character datatype in SQL Server?
    BLOB
    VARTEXT

    5.Which of the following statements about SQL Server comments is false?
    – is used for single line comments
    ‘ is used for single line comments

    6.Consider the following transaction code:

    Begin Transaction
    Update names_table set employee_name = “Ramesh” where employee_name = “Mahesh”
    Save Transaction SAVE_POINT
    Update salaries set salary=salary + 900 where employee_job = “Engineer”
    Rollback transaction
    Commit transaction

    What will be the result produced by this transaction?

    Neither “Ramesh” will be updated to “Mahesh”, nor the salary of engineers will be updated.
    “Ramesh” will be updated to “Mahesh” and salary of engineers will also be
    updated.

    7. Which of the following constraints can be used to enforce the uniqueness of rows in a table?
    PRIMARY KEY and UNIQUE constraints

    8. Which of the following are not date parts?
    quarter
    dayofweek

    9. The IF UPDATE (column_name) parameter in a trigger definition will return
    TRUE in case of an INSERT statement being executed on the triggered table:

    Yes

    10. Which one of the following must be specified in every DELETE statement?
    Table Name

    11.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

    12. Is this statement true or false:
    A cursor is a pointer that identifies a specific working row within a set

    True

    13. Which of the following commands is used to change the structure of table?
    ALTER TABLE

    14.Consider the following statements and pick the correct answer:

    1. ceiling() - returns the smallest integer greater than or equal to the specified value
    2. floor() - returns the largest integer less than or equal to the specified value

    1 is true and 2 is false

    15. What is the correct SQL syntax for returning all the columns from a table named “Persons” sorted REVERSE alphabetically by “FirstName”?

    SELECT * FROM Persons ORDER BY FirstName DESC

    16.What is the maximum value that can be stored for a datetime field?
    Dec 31, 9999

    17. Consider the following queries:
    1. select * from employee where department LIKE “[^F-M]%”;
    2. select * from employee where department = “[^F-M]%”;
    Select the correct option:

    Query 2 will return an error

    18. How can you view the structure of a table named “myTable” in SQL Server?
    sp_columns myTable

    19.What does referential integrity (also called relational integrity) prevent?
    One-to-many or many-to-many relationships between columns in a table

    20.Which of the following is not a global variable?
    @@colcount

    21. 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 an error since * is used alone for one table only

    22. Which of the following is not a control statement?
    if exists

    23. Which of the following is not a valid Numeric datatypes in SQL Server?
    MONEY _ It is money type.

    24. Which of the following datatypes is not supported by SQL-Server?
    Logical

    25. What will the output be if you try to perform arithmetic on NULL values?
    NULL

    26. Which of the following options is not correct about the DATEDIFF() function?
    It returns a signed integer value equal to first date part minus second date part

    27.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?
    None of the above

    28.State which of the following are true
    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

    29.Which of the following is not a valid binary datatype in SQL Server?
    BIT
    TESTAMP

    30. Which of the following is false with regards to sp_help?
    All of the above are true
    31. 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

    32.Select the correct option:
    Optimistic locking is a locking scheme handled by the server, whereas pessimistic locking is handled by the application developer

  21. Anne Xu
    Posted 4/10/2008 at 11:40 am | Permalink

    1.Which of the following has the highest order of precedence?
    Functions and Parenthesis

    2.When designing a database table, how do you avoid missing column values for non-primary key columns?
    Use DEFAULT and NOT NULL constraints

    3.Which of the following is the syntax for creating an Index?
    CREATE [UNIQUE] INDEX index_name ON tbl_name (index_columns)
    4.Which of the following is not a valid character datatype in SQL Server?
    VARTEXT
    5.Which of the following statements about SQL Server comments is false?
    // is used for single line comments
    – is used for single line comments
    Nested comments are allowed i.e. /* comment 1 /* comment 2 */ comment 1*/
    ‘ is used for single line comments
    6.Consider the following transaction code:

    Begin Transaction
    Update names_table set employee_name = “Ramesh” where employee_name = “Mahesh”
    Save Transaction SAVE_POINT
    Update salaries set salary=salary + 900 where employee_job = “Engineer”
    Rollback transaction
    Commit transaction
    What will be the result produced by this transaction?

    “Ramesh” will be updated to “Mahesh”, but salaries of engineers will not be
    updated

    7.Which of the following constraints can be used to enforce the uniqueness of rows in a table?
    PRIMARY KEY and UNIQUE constraints
    8.Which of the following are not date parts?
    dayofweek
    9.The IF UPDATE (column_name) parameter in a trigger definition will return
    TRUE in case of an INSERT statement being executed on the triggered table:
    No
    It returns TRUE only if an UPDATE query is executed
    Both b and c
    10.Which one of the following must be specified in every DELETE statement?
    Table Name
    11.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
    12.Is this statement true or false:
    A cursor is a pointer that identifies a specific working row within a set

    True
    13.Which of the following commands is used to change the structure of table?
    ALTER TABLE
    14.Consider the following statements and pick the correct answer:

    1. ceiling() - returns the smallest integer greater than or equal to the specified value
    2. floor() - returns the largest integer less than or equal to the specified value

    Both 1 and 2 are true
    15.What is the correct SQL syntax for returning all the columns from a table named “Persons” sorted REVERSE alphabetically by “FirstName”?

    SELECT * FROM Persons ORDER BY FirstName DESC

    16.What is the maximum value that can be stored for a datetime field?
    Dec 31, 9999
    17.Consider the following queries:
    1. select * from employee where department LIKE “[^F-M]%”;
    2. select * from employee where department = “[^F-M]%”;
    Select the correct option:

    Query 2 is perfectly correct

    18.How can you view the structure of a table named “myTable” in SQL Server?
    sp_columns myTable
    19.What does referential integrity (also called relational integrity) prevent?
    ?One-to-many or many-to-many relationships between columns in a table
    ?Data redundancy
    20.Which of the following is not a global variable?
    All are valid global variables
    21.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 an error since * is used alone for one table only
    22.Which of the following is not a control statement?
    if exists
    23.Which of the following is not a valid Numeric datatypes in SQL Server?
    MONEY
    24.Which of the following datatypes is not supported by SQL-Server?
    Logical
    25.What will the output be if you try to perform arithmetic on NULL values?
    NULL
    26.Which of the following options is not correct about the DATEDIFF() function?
    It returns a signed integer value equal to first date part minus second date part
    27.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?
    None of them
    28.State which of the following are true
    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
    29.Which of the following is not a valid binary datatype in SQL Server?
    TESTAMP
    30.Which of the following is false with regards to sp_help?
    When a procedure name is passed to sp_help, it shows the parameters
    All of the above are true
    31.Which of the following are false for batches (batch commands)?

    None of the statements in the batch is executed if there are any parsing errors in the batch
    32.Select the correct option:
    Optimistic locking is a locking scheme handled by the server, whereas pessimistic locking is handled by the application developer

  22. hades
    Posted 4/22/2008 at 12:39 pm | Permalink

    What about problems like:
    Select the max values without using the max funtion, etc.

  23. thunder6
    Posted 1/24/2009 at 4:00 pm | Permalink

    6.Consider the following transaction code:

    Begin Transaction
    Update names_table set employee_name = “Ramesh” where employee_name = “Mahesh”
    Save Transaction SAVE_POINT
    Update salaries set salary=salary + 900 where employee_job = “Engineer”
    Rollback transaction
    Commit transaction
    What will be the result produced by this transaction?

    o Neither “Ramesh” will be updated to “Mahesh”, nor the salary of engineers will be updated.

    bcos the ROLLBACK TRANSACTION statement will undo everything as the save point is not mentioned. ‘ROLLBACK TRANSACTION save_point’ will only undo transaction made after the save point
    ref:- ms-help://MS.SQLCC.v10/MS.SQLSVR.v10.en/s10de_6tsql/html/b953c3f1-f96d-42f1-95a2-30e314292b35.htm

Post a Comment

Your email is never published nor shared. Required fields are marked *

*
*

tadalafil and mephedrone forum acquistare cialis in italia buy cialis generic viagra cialis cialis generic cialis feeling cialis acquista indian cialis cialis viagra vs cheap tadalafil from india tadalafil for high blood pressure cialis bathtub image buy canada cialis physician pharmaceutical samples cialis buy viagra cialis achat cialis cialis generika kaufen liquid cialis generic generic professional cialis order cialis cod regalis cialis tadalafil tadalafil versus sildenafil tadalafil ic levitra cialis viagra comparison inexpensive cialis 20 mg cialis and side effects of fatigue cialis overnight treatment of pulmonary hypertension in dogs using cialis cialis pills taladafil cialis uses comprare cialis in farmacia cialis generico online buy cialis online now comprare cialis in svizzera is there a generic cialis tadalafil and mephedrone buying generic cialis erections with cialis purchasing online generic cialis tadalafil tadalafil alternative 5mg cialis samples cialis g�.nstig is levitra better than cialis cheap tadalafil t large quanity 30mg tadalafil brand name buy soft cialis cialis levitra vs tadalafil forumdrugs ccrx pay for cialis annuaires des sites d emploie sp cialis cialis substitute cialis oralgel cialis 20 mg prices .video clips cialis v levitra tadalafil cheap canadian pharmacy cialis rezeptfrei kaufen ambrisentan tadalafil metroprolol combines with cialis safe? how much cialis to take generic cialis soft online is there a generic for cialis comperare cialis cialis online fruit tadalafil can't get off with cialis tadalafil manufacturers how to take cialis benefits of cialis cialis and zenerx cialis + nasonex cialis tadalafil work cialis femme cheap cialis generic comprare cialis generico cheap tadalafil canada generics macular degeneration cialis cialis tadalafil uk cialis oder viagra viagra vs cialis cialis 20mg generica cialis cheap cialis sale online cheap cialis tadalafil cialis from india online tadalafil dosage 'taking viagra and cialis together' cialis 20 mg can you take cialis and viagra together? cialis best prices tadalafil best price bulk levitra versus cialis viagra sildenafil cialis tadalafil dosage use cialis ingredients cheap tadalafil from middle east large quanity 30mg tadaga cialis phirst-1: tadalafil how does cialis work is cialis better than viagra generic cialis review cialis super active bayer cialis compare cialis viagra levitra tadalafil novi mumbai cialis effetti collaterali high dose of cialis tadalafil relative benefits adverse reactions of cialis cialis results review cheap cialis professional cialis works cialis fast delivery cialis without prescription cialis ricetta medica cialis daily use review buy cialis with discover card cialis basso dosaggio cialis samples cialis and enlarged prostate cialis 5 mg online cialis online description chemistry ingredients tadalafil tadalafil citrate 30mg ml 60ml 1800mg total tadalafil citrate where to go in amsterdam to buy cialis can i exercise when using cialis buying viagra assist cheap cialis cialis pills tadalafil mumbai cialis cheap canada cialis cheapest online prices cialis kauf cialis tadalafil 20 mg cialis prevent heart disease cheap generic cialis cialis vs. levitra female cialis review cialis floaters cialis buy online buy cialis soft tabs cheap cialis comment viagra buy generic cialis online cialis grzegorz marczak molestuje dzieci price of tadalafil generic viagra versus tadalafil cialis vente en ligne tadalafil blood pressure buy brand name cialis best time to take cialis cialis american express cialis low dose cialis commercial cialis -vs- viagra tadalafil test results taking viagra and cialis cialis costi can niacin be taken with cialis cialis acheter online pharmacy cialis tadalafil dosing tadalafil citrate senafi cialis assunzione cialis 2.5 mg muscle sore cialis spotting fake cialis cialis levitra viagra cialis headache cialis erection cialis picture 20 cialis mg tadalafil 10mg cialis daily dose cialis for sale new meds like tadalafil but better and lasts longer cialis en ligne compare ed medicines cialis and levitra comprar cialis internet cialis ohne rezept buy daily cialis cialis and marijuana viagra and cialis taken together best cialis price cialis discussion boards cheap cialis online cialis from european online drugstores cialis generique cialis soft gels free generic cialis cialis im internet cialis achat cialis vs viagara cialis sin receta medica cialis generic tadalafil best price compare low dose cialis cheap strength tadalafil t liquid cialis cialis flomax interaction cheap cialis tadalafil cialis from india online vidrgne cialis purchase cialis in british columbia brand cialis for sale cheap cialis si cialis soft tabs tadalafil natural how to increase the potency of cialis cialis without priction tadalafil generic cialis without a prescription cialis generika order cialis online drug administration food and hit bg cialis generic purchase what is using cialis like cialis in pattaya cost of cialis cialis in usa tadalafil erfahrungsberichte tadalafil sublingual cialis and fertility newspaper coupon for free cialis super active cialis what insurance formulaies list tadalafil cialis g�.nstig kaufen can cialis work against lorazepam? cialis alcohol generic tadalafil online cialis uk suppliers cialis pill description what does cialis look like domestic tadalafil tadalafil 40 mg buy cialis on saipan cialis o viagra how long does it take cialis to work mixing lorazepam and cialis tadalafil paypal non prescription cialis viagra cialis is it legal to order tadalafil from canada cialis cheap canadian pharmacy cialis from net drugstore cialis bathtub order cialis online no prescription cialis 5 mg tadalafil tastes like what cialis precautions cialis barata cialis cheap no prescription buy generic cialis 5mg online buy tadalafil 20 online comprar tadalafil cialis comprimidos cialis overnight shipping cheap cialis online canada child ingests cialis how does one order cialis online comparing cialis and viagra cialis for sale genuine cialis tadalafil order cialis from an online pharmacy when will cialis patent expire tadalafil natural substitute side affects of cialis free samples of cialis buy cialis no online prescription tadalafil producers lowcost cialis cialis 20mg tablet order cialis without prescription cod cialis versus viagra discount cialis buy generic cialis theusdrugs canadia rx drugs cialis take cialis and viagra together cialis headache relief buy cialis no prescription smallest effective doze of tadalafil cialis reaction how can i take cialis generic cialis 10mg cialis assuefazione cialis sample tadalafil 'what is it like to take tadalafil' cialis a roma cialis free sample what does cialis and viagra do? cialis tadalafil tadalis viagra cialis free sample ed pill store your ho off-label use tadalafil cialis consumer reviews generic generic viagra tadalafil buy cialis o female cialis viagra versus cialis cialis canada generic 10mg no prescription cialis for daily use cialis e alcol 20mg professional cialis cialis fast order generic cialis cialis dose viagra vs cialis vs levitra cialis vs viagra vs levitra overnight cialis is cialis available in generic viagra and cialis cialis bugiardino buy tadalafil tadalafil tablets 20mg sls tadalafil cialis vs viagra cialis legal take cabergoline and cialis together how to get cialis cialis on line order how much does tadalafil cost cialis 5mg daily price buy cialis with bonus viagra tadalafil & cardiotoxicity cialis 5mg cialis store online why the bathtubs in the cialis commercials? cheap large quantities of tadalafil cialis 5 mg prices cialis canada how cialis works tadalafil consumer comments buy cialis domain effects of cialis and peyronie's disease cialis gout cialis online uk cialis lawyer ohio tadalafil cialis viagra which is better more effective? buy cialis online canada cialis costs tadalafil 10 1 x tadalafil 20mg - 4's $19.95 cialis better than viagra buy cialis cialis and levitra cialis comparison viagra generic cialis e10 cialis and heart problems tadalafil strips genaric cialis cheap cialis generic levitra viagra lowest price generic cialis no perscription cat 6 cialis cialis news lilly icos llc cialis professional tadalafil dosage drug forum cialis canada generic cialis generic safety cialis dosage splitting pills get tadalafil cialis buy online cheap tadalafil cialis ambien cialis for men generic viagra levitra generic cialis pills cialis site cialis contains tadalafil cialis nebenwirkung cialis patent acquistare cialis originale who invented tadalafil drug screening for cialis average cost of tadalafil prescription cheapest generic cialis uk cialis kaufen cialis interaction with blood pressure lowering drugs cialis professional chemistry metroprolo combined with cialis cialis side effects cialis cost mint tadalafil cialis informacion en espanol cialis on line cialis compare 5mg cialis cialis online tadalafil and dopamine cialis 50mg cialis tadalafil reviews cooper pharma tadalafil 20 mg cialis buy cheap tadalafil tadalafil no prescription cialis frau cialis viagra soft tabs 10 mg cialis cialis 20 mg price tadalafil best price cialis brand online cialis next day cialis perscriptions tadalafil forum 5mg cialis generic cialis and viagra and what if i take both at the same time cialis columbus injury lawyer phirst-1: tadalafil in the treatment of pulmonary art cheap cialis no prescription required my insurance only pays for 3 cialis tadalafil oral jelly canadian pharmacies online cialis cialis cheap canada buy cialis online viagra cialis contains tadalafil side effects of cialis buy cialis from an anline pharmacy otc medicine with tadalafil free trial offer of cialis cialis comparison levitra viagra buy tadalafil india order cialis cialis barato cialis and women cialis rezeptfrei cialis effets secondaires is generic cialis real cialis raynaud's fingers vasodilators active ingredient in cialis cialis walmart pricing new jersey tadalafil canadian pharmacy cialis generique achat cialis dosierung generic cialis soft tabs 20mg cialis mastercard viagra cialis levitra cialis blue cross blue shield pay cialis for women generic cialis soft how does cialis compare to viagra cialis and lisinopril buy tadalafil capsules generic cialis viagra bargain cialis cialis canadian pharmacy cialis versus levitra when to take cialis cocaine with cialis compare viagra cialis tadalafil makers free cialis samples cialis bladder spasms cialis on-line tadalafil 40mg cialis message board buying cialis online discount tadalafil price of cialis cialis 20 mg purchase tadalafil cheap cialis tadalafil for pulmonary hypertension tadalafil ic-351 - 25 mg ml cialis pro online tadalafil cialis voucher review cialis professional cialis compared to viagra results of cialis and viagra difference between cialis and levitra tadalafil india brands does cialis work cialis to buy new zealand cialis 20mg non-generic how fast does cialis daily work taking cialis after expiration date dayly cialis cialis capsules cialis 10 mg tadalafil cialis from india tamsulosin tadalafil combination cialis non generic from canada cialis dosing instructions cialis tadalafil 20mg compare cialis 10 mg cialis online discount viagra cialis cialis story cialis splitting the pill who makes cialis cialis advertisement cialis free trial pack cialis and tinnitus canada cialis cialis generico forum cialis comment info personal remember cialis professional tadalafil navi mumbai cialis tadalafil side effects cialis and ace inhibitors generic versus genuine cialis tadalafil viagra alternatives cialis daily erections per cialis daily use cialis advers reactions cialis clock daily cialis cialis blindness cialis brand buy online cialis price history on line cialis delivered to ireland cialis effetti indesiderati cialis and diabetes cialis overnight shipping john morris cialis add purchase cialis online comprar cialis sin receta doses of cialis cialis forum cialis drug impotence tadalafil and prices cialis sample pack cialis vs viagra number of erections cialis free trial tadalafil effect aerobic activity acquistare cialis senza ricetta cialis injury lawyer columbus tadalafil online pharmacy cialis on line italia pattaya fake cialis anti cialis impotence 5 mg cialis cialis price cialis soft cialis work for women? cialis tadalafil in cialis for high blood pressure cialis and grapefruit juice cheap generic cialis tadalafil cialis half life cialis and poppers cialis tadalafil under tongue dissolve how to make cialis work faster generic cialis tadalafil canadian pharmacy for cialis cialis free samples 3.99 cialis n order tadalafil cooper pharma cheapest place to buy cialis generic tadalafil cheap cialis 20mg tadalafil prices keywords cialis tadalafil cialis pill pictures paypal cialis cialis 20 mg prices eye problems associated with taking cialis cialis online free overnight delivery cialis doses cipla effectiveness tadalafil next day cialis can i use cialis after expiration date cialis dangers cialis buy cialis purchase cialis lawyer columbus how does cialis work? cialis kaufen online buy cialis without a prescription can women use cialis what is the cost of cialis buy cialis usa tadalafil off label uses 5mg cialis generic low cost cialis cialis best price cialis purchase decreasing effects of raynaud's with cialis viagra or cialis canada cialis generic buy cialis doctor online cialis onset canadian pharm cialis cialis packaged as tadalafil soft gels tadalafil cheapest discount generic cialis tadalafil trip to nogales smallest effective dose of tadalafil buy 5mg cialis cialis advice cialis compresse cialis online kaufen soft cialis what is tadalafil does viagra contain tadalafil cialis generico 10 mg mexican cialis tadalafil pro best price for tadalafil 6viagra levitra cialis apcalis regalis zenegra cialis pill tadalafil capsules women taking tadalafil cialis bathtub couple cialis and hep c cialis efectos secundarios 36 hour cialis tadalafil without prescription ambrisentan tadalafil ambition cialis consumer comments buy cialis food and by the hit bg tadalafil soft 20mg tabs cialis drug description tadalafil healthscout liquid research chemicals tadalafil viagra cialis i will donate my cialis tadalafil professional beta blockers combined with cialis safe? cialis us pharmacy cialis 5mg once a day enhanced cialis cialis in canada genuine tadalafil cialis generico cialis overnight delivery cialis and caduet interaction cialis from india tadalafil 'does cialis or viagra get you harder' cialis and multiple orgasms in men cialis blue cross blue shield rxlist cialis tadalafil cialis in jamaica no prescription cialis por internet what is the generic name for cialis cialis sur le net compare cialis levitra viagra india generic cialis ceebis tadalafil cialis viagria levitra cheap cialis pharmacy online what is in cialis cialis dosing cialis cupons cialis pricing low dose tadalafil refractory cialis cialis or viagra fake cialis low price cialis lawrence walter tadalafil cialis lilly icos cialis order cialis lawyers cialis viagra levitra samples dosage for cialis cialis drug cialis prescrizione cialis discounts buy tadalafil cialis online research chemicals cialis acheter cialis free trial viagra cialis levitra achat cialis viagra over the counter cialis medicine4you pharma pvt ltd tadalafil cialis discount 20mg cialis versus 2.5mg cialis no prescription cialis order cialis online cialis professional canadian canada which is better cialis or viagra cialis 5 mg for sale exceed viagra and cialis legally buy cialis on line 4 generic cialis softtabs home made cialis does of cialis 20 cialis mg tadalafil sublingual tadalafil tadalafil buy discover cialis pharmacy how often can you take cialis viagra cialis extra cialis uk online cialis effects cialis reviews canadian pharmancy cialis cialis generico comprar cialis eli lilly order cialis online lowest prices for cialis tadalafil 20 mg 10mg call cialis refills manila pharmacy cialis cialis and professional cheap viagra cialis levitra macleods cialis mail order cialis cialis younger women one a day cialis generic cialis tadalafil php canadian cialis levitra vs cialis cheapest viagra cialis cheap cialis no prescription cialis online order brand cialis name cialis levitra online viagra non prescription tadalafil cialis 20mg for sale is tadalafil a nootropics buy cialis online 'how cialis works' cialis testimonials cialis pills taste like chalk buy tadalafil online cialis vs. viagra directions for using tadalafil cheapest candaian online pharmacy to buy tadalafil cialis does not work anymore cialis mexico cialis and grapefruit overnight cialis tadalafil buy cialis generic buy cialis cheap cooper pharma tadalafil tablets cialis ad cialis levitra sales viagra cialis results cialis coupon cialis india tadalafil soft tabs cialis and woman cialis - details cialis macular degeneration can you take viagra while taking cialis 24-hr. wikipedia cialis cialis bodybuilding cheapest generic drug store for tadalafil cialis contraindications cialis cialis genuinerx net viagra viagra cialis pilss in canada cialis day next cialis pictures of tadalafil cialis verkauf buy cialis without prescription is cialis or levitra better cialis hong kong christ god unhappy cialis discount canadian cialis cialis and fatigue buy cialis soft cautions using cialis republica dominicana tadalafil what do you take cialis 20mg cialis free shipping tadalafil for sale cheap cialis tadalafil treat generic cialis best price cialis cialis discount best buy cialis cialis acquisto cialis from india cheapest secure delivery cialis uk is a prescription needed for tadalafil tadalafil liquid real cialis test buy cialis online in usa cialis pills cialis canada cheap achat cialis generique cialis en france contraindications tadalafil viagra cialis online sales buy canada cialis lowest price cialis cialis for sale cialis and blood pressure medication cialis online no prescription cheap cialis 20 mg 60 pills buy cialis online cialis vs tadalafil generic cialis with no prescription cialis daily information cialis price with insurance cheap tadalafil in quanity cialis tablets buy cheap generic cialis tadalafil usa walgreen price for cialis tadalafil 5mg generic cialis ansia da prestazione generic for cialis acheter cialis original cialis daily mixing viagra and cialis addicted to cialis is cialis stronger than viagra acquistare cialis 30mg cialis generic cialis non prescription generac cialis cialis experiences order cialis online pro cialis cialis discount generic cialis comments cgi generic mt tadalafil tadalafil tadalafil testes cipla cialis tadalafil cheap in large amounts 30 to 40 mg. cialis daily 5 mg tablet wholsale cialis viagra levitra cialis chemistry cheapest cialis online canadian pharmacy cialis generic cialis overnight tadalafil prescription needed in canada?? cialis rezeptfrei aus deutschland need cialis shipped overnight cialis release news cialis shipped from canada fda approval tadalafil nicotinic acid with cialis side effect buy tadalafil in kowloon 91 olds cialis side marker lens farmacia nogales cialis cialis manufacturer 5mg tadalafil without perscription tadalafil substitutes multiple erections per cialis daily use cialis 10mg- compare prices cialis periapsis cialis generico paypal cialis blilig kaufen side effects of tadalafil tadalafil sale cialis 40 mg tadalafil from india cialis -plurisy -pain cialis use what insurance formularies list tadalafil what are the side effects of cialis does cialis increase my size cialis tips cialis online canada cialis store cialis useage cialis alternative cialis order cialis effectiveness hearing loss from using cialis viagra cialis levitra cialis in the uk tadalafil forum drugs tadalafil uk free postage cheap generic drugs viagra cialis levitra does cialis always work the first time lyrics for cialis commercial buy cialis uk cialis user forum cialis experience cialis 20 vs cialis 20 professional genuine cialis cheapest generic india tadalafil generic cialis online a href purchase cialis cialis 10mg cialis for heart health is tadalafil on sale in the usa generic cialis online cialis for high blood pressure? venta de tadalafil can i double the dose of daily use cialis cialis moment viagra and cialis side effects 5 tadalafil cialis tadalafil buy discover generic india 20 10 buy daily tadalafil cialis generic levitra review viagra what is the differance in tadalafil and sildenafil ace inhibitor cialis who invented cialis tadalafil cialis from india comprar cialis generico buy cialis online without prescription cialis generika forum where to buy cialis is generic cialis safe when should you take cialis venta de cialis tadalafil for daily use cialis prezzi re viagra cialis levitra comprare cialis does tadalafil occur in nature cialis compare levitra cheap cialis tadalafil 20 mg cialis performance cialis generic online cialis and high blood pressure free sample cialis generic cialis canada cialis fast delivery cialis prices levitra e cialis medicine4you pharma pvt ltd mumbai tadalafil cialis generika rezeptfrei cialis prescription tadalafil no rx generic tadalafil cialis tv commercial tadalafil 20mg atrial fibrillation and cialis buy generic viagra cialis herbal cialis buy cialis with paypal cialis large dose order cialis without perscription how well does tadalafil work? cialis da 5 mg non perscription cialis cialis daily use faq best free cialis softtabs online cialis info white finger disease cialis research cialis tadalafil beter dan viagra generic tadalafil best price cialis senza ricetta where can you buy cialis in negril? online cialis medicine4you tadalafil cialis contrassegno cialis commercials generic cialis from india tadalafil and lisinopril drug interactions 5 mg tadalafil pills can cialis be used for muscle building cialis online discount generic cialis and viagra combo buy cialis online without a prescription cialis dysfunction erectile levitra viagra tadalafil cheap from india and europe cialis generica tadalafil by post in uk tadalafil tablets cialis online paypal female cialis cheap the truth about cialis cialis pharmacy kowloon viagra cialis a vendre parwanoo hp manufacturing tadalafil cialis lowest price cialis back pain cialis attorneys cialis canada cialis viagra powerpack cialis cheap bath tubs and cialis cialis costo cialis tadalafil uk generic cialis reviews cialis order australia order cialis no prescription tadalafil india when does cialis patent lapse cialis levitra comparison cialis farmacia online cialis pill cutter discount cialis levitra viagra buy-best-k cialis -rsgdba cialis bathtubs low price tadalafil by what mechanism does cialis cause stomach pain ? acheter cialis en france comprar cialis generico en espa�.a acquistare cialis generico tadalafil what isit tadalafil vs vardenafil what insurance formularies list daily tadalafil tadalafil cialis vs viagra e 10 + tadalafil cialis 20mg toronto tadalafil 2.5mg and 5mg once a day ranbaxy tadalafil cialis comparisons cialis 20 mg tadalafil euphoria testimonials + cialis cialis acquisto on line cialis 20 5 mg tadalafil cialis and pomegranate interaction best generic cialis avodart cialis clomid diflucan dostinex gluco bbs inkjet printer cialis cialis super inthe uk cialis commenti tadalafil effects cialis e ipertensione cialis and trimix cialis tadalafil tadalis buying cialis tadalafil for hypertension cialis and alcohol cialis compare levitra viagra cialis generic tadalafil cialis and niacin tadalafil natural herb can woman take cialis can i take 10 mg of cialis 2 days in a row cipla tadalafil cialis us order cialis 5 mg coupon cialis soft order side effects if gernic cialis rapid tabs instant cialis cialis tadalafil 4 pack overnight cialis viagra best way to use cialis tadalafil vs viagra tadalafil chemical compound compare viagra and cialis cialis review best price for cialis uprima cialis viagra tadalafil use in pah french inventor of tadalafil buy cheap cialis generic cialis double cialis professional indian generic cialis professional cialis + levitra cheap cialis pill buy online tadalafil brand name cialis for sale buy cialis today alchohol and cialis tadalafil soft 20mg cialis online buy cialis analog how to use cialis order cialis from an anline pharmacy cialis 40 mg cialis 20mg tadalafil prices cialis taken with viagra cialis - long term side affects blood in urine with cialis cialis coupons cheap strength tadalafil t large quanity 30mg buy cialis professional best way to take tadalafil buy online levitra cialis viagra cialis online pharmacy cialis 20mg 60pills cheap cialis 20mg comprare cialis in italia cialis vs viagra cialis generico mexico herbal alternative to cialis comprar cialis outdated cialis what is it like to use cialis brian stackhouse cialis cialis ads experience with cialis cialis canadian tadalafil online men reviews of cialis cialis online free trial buy cialis online no prescription cialis and ruptured blood vessel in eye purchase cialis purchase tadalafil canada tadalafil cheap maximum effectiveness cialis cialis how fast cialis comprar cialis generic uk cialis confezione cialis prices at true pharmacies eating bananas taking cialis cialis mg dosage tadalafil generic viagra cialis levitra cheap cialis con receta fda tadalafil approval cialis vs levitra 5mg cialis cialis and pacemaker cialis billig 50mg cialis cheapest price for cialis buy cialis soft online cialis medication achat cialis en france cialis rezeptfrei europa cialis sin receta cialis and payment by insurance cialis for woman generic cialis from online pharmacies problems levitra cialis high doses of cialis results of cialis generic prescription cialis drug availability buy cheap cialis buy tadalafil cialis and citris cialis from canda cheap cialis viagra cialis dosage men that use cialis photos free cialis axio lab cialis sale tadalafil uk pharmacy cialis sans prescription cheapest cialis generic cialis buy cheap cheap cialis tadalafil 20 mg comprar cialis online lady cialis cialis scams cialis compra best soft cialis cialis search buy tadalafil cialis cialis advertisements tadalafil over counter buy discount cialis cheap tadalafil from overseas countries .video clips when using cialis tadalafil softsules where to order cialis online cialis order uk fruit flavored tadalafil cialis precio cialis uk chemist tadalafil achalasia cialis injury attorney columbus buy cialis professional online 20mg cialis find best price on cialis from u.s. drug stores cialis prezzo inexpensive cialis cialis alternatives discount price for cialis cialis daily use raynaud's with cialis online cialis purchase cialis injection photo where to buy tadalafil in hong kong forzest tadalafil cialis pictures tadalafil pill identification bathtub scene in cialis commercials viagra vs. cialis cialis and levitra ventajas desventajas chinese cialis compare viagra to cialis effect on women taking tadalafil buy cialis online in canada cialis soft online tadalafil nogales cialis dosages cialis uk tadalafil spier tadalafil 20mg tadalafil weekender cialis non generic buy tadalafil in hong kong viagra vs levitra vs cialis cialis preis cialis kosten brand cialis cialis paypal cialis side effects cialis after expiration date cialis brand prices cialis making liquid cialis cheap tadalafil very cheap cialis bulk cialis cialis online india blog approval cialis received use before and after cialis cialis overdose contraindications and information tadalafil acheter cialis generique side effects cialis best and safest buy cialis without prescr[ption cheap cialis tadalafil where to buy viagra cialis sosua cialis beijing cialis pay paypal cialis paypal tadalafil sale online viagra cialis daily use cialis tadalafil welfil 20 generic soft cialis cialis softtabs cialis composizione generic viagra levitra cialis cialis professional india history of tadalafil how to contact cialis tadalafil citrate cialis one a day daily tadalafil snl cialis cialis consultation delivery discount health man canadian discount pharmicies viagra cialis buy cialis tips and tricks for using cialis cialis femenino cheepest cialis genuine cialis 5mg buy cialis online levitra cialis viagra what medical plans pay for cialis medication where to find cialis without a prescription what to expect from cialis 10mg cialis white finger disease cialis canada cialis index buy cialis by the pill food to avoid while taking cialis cialis 5 mg online canada what is tadalafil 20mg tadalafil discount cialis no prescription cialis dosage amounts buy name brand cialis cialis pharmacy is cialis a blood thinner? generic cialis india cialis from india tadalafil cialis tadalafil cialis vietnam cheapest cialis prices buy cialis brand tadalafil sx sales tadalafil how well does it work sildenafil cialis generico cialis and viagra tadalafil for the treatment of raynaud's cialis official website generic cialis information cialis from canada generic cialis fedex tadalafil directions tadalafil for sale tadalafil medicine4you pharmacy cialis cheapest place online to buy tadalafil tadalafil comments tadalafil price in nogales selges cialis name brand cialis tadalafil tablet tamsulosin tadalafil interaction how long does cialis last cialis and viagra together viagra cialis generica what is cialis tadalafil is more better generic cialis uk natural cialis cialis e alcool by cialis online canada cialis tadalafil cialis half pill cialis online generic cialis soft comparison affects using cialis cheapest tadalafil discounted cialis tadalafil 20 mg cialis and online prescription free cialis sample cialis one a day cost cialis femenina cialis drug interactions tadalafil 50mg canadian pharmacy cialis cialis levitra viagra online cialis nebenwirkungen how fast does cialis 5mg once a day work buying cialis in uk cialis comparison levitra b cialis b cialis per donne tadalafil india brads tadalafil on line cheap cialis with overnight shipping generic form of cialis cialis levitra non prescription generic cialis cialis impotence drug eli lilly co tadalafil or cialis generic cialis no perscription tadalafil cialis india discount daily cialis cialis tablet what is the point of the bathtub in the cialis commercials cialis buy it online huge discount cialis injection video cialis shelf life best place to buy tadalafil order cialis without prescription cialis for order cialis 5mg cialis overnight delivery cialis usa cialis overdose buy cialis viagra buy cialis proffessional online buy cialis tadalafil buy cialis in the uk research prevention raynaud's white finger cialis research cialis information once cialis didn't work should i worry cialis cocaine cialis vs viagra pharmacology cheaper viagra levitra cialis use of cialis in women tadalafil raven cialis benefits how to decide viagra vs. cialis 10 mg cialis tadalafil from india] effect of cialis on women tadalafil 20 cialis canadian epharmacy