SQL interview questions and answers

By admin | May 3, 2004

Thanks to Sachin Rastogi for posting these.

  1. Which of the following statements contains an error?

    1. SELECT * FROM emp WHERE empid = 493945;
    2. SELECT empid FROM emp WHERE empid= 493945;
    3. SELECT empid FROM emp;
    4. SELECT empid WHERE empid = 56949 AND lastname = ‘SMITH’;
  2. Which of the following correctly describes how to specify a column alias?

    1. Place the alias at the beginning of the statement to describe the table.

    2. Place the alias after each column, separated by white space, to describe the column.
    3. Place the alias after each column, separated by a comma, to describe the column.
    4. Place the alias at the end of the statement to describe the table.
  3. The NVL function

    1. Assists in the distribution of output across multiple columns.

    2. Allows the user to specify alternate output for non-null column values.
    3. Allows the user to specify alternate output for null column values.
    4. Nullifies the value of the column output.
  4. Output from a table called PLAYS with two columns, PLAY_NAME and AUTHOR, is shown below. Which of the following SQL statements produced it?

    PLAY_TABLE
    ————————————-
    “Midsummer Night’s Dream”, SHAKESPEARE
    “Waiting For Godot”, BECKETT
    “The Glass Menagerie”, WILLIAMS

    1. SELECT play_name || author FROM plays;

    2. SELECT play_name, author FROM plays;
    3. SELECT play_name||’, ‘ || author FROM plays;
    4. SELECT play_name||’, ‘ || author PLAY_TABLE FROM plays;
  5. Issuing the DEFINE_EDITOR=”emacs” will produce which outcome?

    1. The emacs editor will become the SQL*Plus default text editor.

    2. The emacs editor will start running immediately.
    3. The emacs editor will no longer be used by SQL*Plus as the default text editor.
    4. The emacs editor will be deleted from the system.
  6. The user issues the following statement. What will be displayed if the EMPID selected is 60494?

    SELECT DECODE(empid,38475, “Terminated”,60494, “LOA”, “ACTIVE”)
    FROM emp;

    1. 60494

    2. LOA
    3. Terminated
    4. ACTIVE
  7. SELECT (TO_CHAR(NVL(SQRT(59483), “INVALID”)) FROM DUAL is a valid SQL statement.

    1. TRUE

    2. FALSE
  8. The appropriate table to use when performing arithmetic calculations on values defined within the SELECT statement (not pulled from a table column) is

    1. EMP

    2. The table containing the column values
    3. DUAL
    4. An Oracle-defined table
  9. Which of the following is not a group function?

    1. avg( )

    2. sqrt( )
    3. sum( )
    4. max( )
  10. Once defined, how long will a variable remain so in SQL*Plus?

    1. Until the database is shut down

    2. Until the instance is shut down
    3. Until the statement completes
    4. Until the session completes
  11. The default character for specifying runtime variables in SELECT statements is

    1. Ampersand

    2. Ellipses
    3. Quotation marks
    4. Asterisk
  12. A user is setting up a join operation between tables EMP and DEPT. There are some employees in the EMP table that the user wants returned by the query, but the employees are not assigned to departments yet. Which SELECT statement is most appropriate for this user?

    1. select e.empid, d.head from emp e, dept d;

    2. select e.empid, d.head from emp e, dept d where e.dept# = d.dept#;
    3. select e.empid, d.head from emp e, dept d where e.dept# = d.dept# (+);
    4. select e.empid, d.head from emp e, dept d where e.dept# (+) = d.dept#;
  13. Developer ANJU executes the following statement: CREATE TABLE animals AS SELECT * from MASTER.ANIMALS; What is the effect of this statement?

    1. A table named ANIMALS will be created in the MASTER schema with the same data as the ANIMALS table owned by ANJU.

    2. A table named ANJU will be created in the ANIMALS schema with the same data as the ANIMALS table owned by MASTER.
    3. A table named ANIMALS will be created in the ANJU schema with the same data as the ANIMALS table owned by MASTER.
    4. A table named MASTER will be created in the ANIMALS schema with the same data as the ANJU table owned by ANIMALS.
  14. User JANKO would like to insert a row into the EMPLOYEE table, which has three columns: EMPID, LASTNAME, and SALARY. The user would like to enter data for EMPID 59694, LASTNAME Harris, but no salary. Which statement would work best?
    1. INSERT INTO employee VALUES (59694,’HARRIS’, NULL);
    2. INSERT INTO employee VALUES (59694,’HARRIS’);
    3. INSERT INTO employee (EMPID, LASTNAME, SALARY) VALUES (59694,’HARRIS’);
    4. INSERT INTO employee (SELECT 59694 FROM ‘HARRIS’);
  15. Which three of the following are valid database datatypes in Oracle? (Choose three.)

    1. CHAR

    2. VARCHAR2
    3. BOOLEAN
    4. NUMBER
  16. Omitting the WHERE clause from a DELETE statement has which of the following effects?

    1. The delete statement will fail because there are no records to delete.

    2. The delete statement will prompt the user to enter criteria for the deletion
    3. The delete statement will fail because of syntax error.
    4. The delete statement will remove all records from the table.
  17. Creating a foreign-key constraint between columns of two tables defined with two different datatypes will produce an error.

    1. TRUE

    2. FALSE
  18. Dropping a table has which of the following effects on a nonunique index created for the table?

    1. No effect.

    2. The index will be dropped.
    3. The index will be rendered invalid.
    4. The index will contain NULL values.
  19. To increase the number of nullable columns for a table,

    1. Use the alter table statement.

    2. Ensure that all column values are NULL for all rows.
    3. First increase the size of adjacent column datatypes, then add the column.
    4. Add the column, populate the column, then add the NOT NULL constraint.
  20. Which line of the following statement will produce an error?

    1. CREATE TABLE goods

    2. (good_no NUMBER,
    3. good_name VARCHAR2 check(good_name in (SELECT name FROM avail_goods)),
    4. CONSTRAINT pk_goods_01
    5. PRIMARY KEY (goodno));
    6. There are no errors in this statement.
  21. MAXVALUE is a valid parameter for sequence creation.

    1. TRUE
    2. FALSE
  22. Which of the following lines in the SELECT statement below contain an error?

    1. SELECT DECODE(empid, 58385, “INACTIVE”, “ACTIVE”) empid

    2. FROM emp
    3. WHERE SUBSTR(lastname,1,1) > TO_NUMBER(’S')
    4. AND empid > 02000
    5. ORDER BY empid DESC, lastname ASC;
    6. There are no errors in this statement.
  23. Which function below can best be categorized as similar in function to an IF-THEN-ELSE statement?

    1. SQRT

    2. DECODE
    3. NEW_TIME
    4. ROWIDTOCHAR
  24. Which two of the following orders are used in ORDER BY clauses? (choose two)

    1. ABS

    2. ASC
    3. DESC
    4. DISC
  25. You query the database with this command

    SELECT name
    FROM employee
    WHERE name LIKE ‘_a%’;

    Which names are displayed?

    1. Names starting with “a”

    2. Names starting with “aR
    3. or “A”
    4. Names containing “aR
    5. as second character
    6. Names containing “aR
    7. as any letter except the first
This entry was posted in General. Bookmark the permalink. Post a comment or leave a trackback: Trackback URL.

18 Comments on SQL interview questions and answers

  1. db don
    Posted 5/16/2005 at 7:55 pm | Permalink

    1) “SELECT empid WHERE empid = 56949 AND lastname = ‘SMITH’;” is incorrect

    2) “Place the alias after each column, separated by white space, to describe the column.” Correct

    3) Ans is 3 it is same as isNull in T SQL

  2. Ajay Kumar Peddireddy
    Posted 2/6/2006 at 7:52 am | Permalink

    1)SELECT empid WHERE empid = 56949 AND lastname = ‘SMITH’;
    2)Place the alias after each column, separated by white space, to describe the column
    3)Allows the user to specify alternate output for null column values.
    4)SELECT play_name||’, ‘ || author PLAY_TABLE FROM plays;
    5)The emacs editor will become the SQL*Plus default text editor. (Not sure about this answer)
    6)LOA
    7)FALSE
    8)DUAL
    9)max( )
    10)Until the statement completes
    11)Ampersand
    12)select e.empid, d.head from emp e, dept d where e.dept# (+) = d.dept#;
    13)A table named ANIMALS will be created in the ANJU schema with the same data as the ANIMALS table owned by MASTER
    14)INSERT INTO employee VALUES (59694,’HARRIS’, NULL);
    15) VARCHAR2 , BOOLEAN ,NUMBER
    16) The delete statement will remove all records from the table.
    17) TRUE
    18) The index will be dropped.
    19) Ensure that all column values are NULL for all rows. (Not sure about this answer)
    20) SELECT statement is not allowed in CHeck constraint.
    21)
    22) No error if all the values are given in single quotes instead of double quotes.
    23) DECODE
    24) ASC, DESC
    25) will give all the enames that has ‘a’ in the second place and followed by any number of characters. _ specifies as a single character and % as many characters.

  3. Mrs Bisht
    Posted 10/17/2006 at 11:11 am | Permalink

    1)SELECT empid WHERE empid = 56949 AND lastname = ‘SMITH’;
    2)Place the alias after each column, separated by white space, to describe the column
    3)Allows the user to specify alternate output for null column values.
    4)SELECT play_name||’, ‘ || author PLAY_TABLE FROM plays;
    5)The emacs editor will become the SQL*Plus default text editor. (Not sure about this answer)
    6)LOA
    7)FALSE
    8)DUAL
    9)max( )
    10)Until the statement completes
    11)Ampersand
    12)select e.empid, d.head from emp e, dept d where e.dept# (+) = d.dept#;
    13)A table named ANIMALS will be created in the ANJU schema with the same data as the ANIMALS table owned by MASTER
    14)INSERT INTO employee VALUES (59694,’HARRIS’, NULL);
    15) VARCHAR2 , BOOLEAN ,NUMBER
    16) The delete statement will remove all records from the table.
    17) TRUE
    18) The index will be dropped.
    19) Ensure that all column values are NULL for all rows. (Not sure about this answer)
    20) SELECT statement is not allowed in CHeck constraint.
    21)
    22) No error if all the values are given in single quotes instead of double quotes.
    23) DECODE
    24) ASC, DESC
    25) will give all the enames that has ‘a’ in the second place and followed by any number of characters. _ specifies as a single character and % as many characters.

  4. Acrien
    Posted 10/28/2006 at 7:21 pm | Permalink

    some wrong answers up top.

    1. Which of the following statements contains an error?

    1. SELECT * FROM emp WHERE empid = 493945;
    2. SELECT empid FROM emp WHERE empid= 493945;
    3. SELECT empid FROM emp;
    *** 4. SELECT empid WHERE empid = 56949 AND lastname = ‘SMITH’;

    No from clause.

    2 Which of the following correctly describes how to specify a column alias?

    1. Place the alias at the beginning of the statement to describe the table.
    *** 2. Place the alias after each column, separated by white space, to describe the column.
    3. Place the alias after each column, separated by a comma, to describe the column.
    4. Place the alias at the end of the statement to describe the table.

    3 The NVL function

    1. Assists in the distribution of output across multiple columns.
    2. Allows the user to specify alternate output for non-null column values.
    ****3. Allows the user to specify alternate output for null column values.
    4. Nullifies the value of the column output.

    4 Output from a table called PLAYS with two columns, PLAY_NAME and AUTHOR, is shown below. Which of the following SQL statements produced it?

    PLAY_TABLE
    ————————————-
    “Midsummer Night’s Dream”, SHAKESPEARE
    “Waiting For Godot”, BECKETT
    “The Glass Menagerie”, WILLIAMS

    1. SELECT play_name || author FROM plays;
    2. SELECT play_name, author FROM plays;
    3. SELECT play_name||’, ‘ || author FROM plays;
    ***4. SELECT play_name||’, ‘ || author PLAY_TABLE FROM plays;

    1 will produce titleauthor
    2 will produce title author
    3 will produce title, author but column name will be play_name||’,'||author

    5 Issuing the DEFINE_EDITOR=”emacs” will produce which outcome?

    ****1. The emacs editor will become the SQL*Plus default text editor.
    2. The emacs editor will start running immediately.
    3. The emacs editor will no longer be used by SQL*Plus as the default text editor.
    4. The emacs editor will be deleted from the system.

    6 The user issues the following statement. What will be displayed if the EMPID selected is 60494?

    SELECT DECODE(empid,38475, “Terminated”,60494, “LOA”, “ACTIVE”)
    FROM emp;

    1. 60494
    *** 2. LOA
    3. Terminated
    4. ACTIVE
    decode says if(empid = 38475, output ‘terminated
    if(empid = 60409, output ‘loa’
    (for everything else, output ‘active’)

    7 SELECT (TO_CHAR(NVL(SQRT(59483), “INVALID”)) FROM DUAL is a valid SQL statement.

    1. TRUE
    **** 2. FALSE

    Cannot set value to another datatype when using NVL, hence if SQRT(59483) is null somehow, you must assign it a number, “invalid” is a string.

    8 The appropriate table to use when performing arithmetic calculations on values defined within the SELECT statement (not pulled from a table column) is

    1. EMP
    2. The table containing the column values
    ***3. DUAL
    4. An Oracle-defined table

    Dual is a dummy table.

    9 Which of the following is not a group function?

    1. avg( )
    *****2. sqrt( )
    3. sum( )
    4. max( )

    all other functions can work on more than one row of data.

    10 Once defined, how long will a variable remain so in SQL*Plus?

    1. Until the database is shut down
    2. Until the instance is shut down
    **** 3. Until the statement completes
    **** 4. Until the session completes

    This one depends on how you defined it. If you define variable using & then 3, && then 4.

    11 The default character for specifying runtime variables in SELECT statements is

    *** 1. Ampersand
    2. Ellipses
    3. Quotation marks
    4. Asterisk

    This is basic syntax. In pl/sql though, this is compile time, not run time.

    12 A user is setting up a join operation between tables EMP and DEPT. There are some employees in the EMP table that the user wants returned by the query, but the employees are not assigned to departments yet. Which SELECT statement is most appropriate for this user?

    1. select e.empid, d.head from emp e, dept d;
    2. select e.empid, d.head from emp e, dept d where e.dept# = d.dept#;
    *****3. select e.empid, d.head from emp e, dept d where e.dept# = d.dept# (+);
    4. select e.empid, d.head from emp e, dept d where e.dept# (+) = d.dept#;

    Always put the (+) on the deficient side, so since emp has more data that cannot be matched in dept table, dept table has less data than emp hence it is the deficient side!

    13 Developer ANJU executes the following statement: CREATE TABLE animals AS SELECT * from MASTER.ANIMALS; What is the effect of this statement?

    1. A table named ANIMALS will be created in the MASTER schema with the same data as the ANIMALS table owned by ANJU.
    2. A table named ANJU will be created in the ANIMALS schema with the same data as the ANIMALS table owned by MASTER.
    **** 3. A table named ANIMALS will be created in the ANJU schema with the same data as the ANIMALS table owned by MASTER.
    4. A table named MASTER will be created in the ANIMALS schema with the same data as the ANJU table owned by ANIMALS.

    refer to another’s table by using schemaname.objectname.

    14 User JANKO would like to insert a row into the EMPLOYEE table, which has three columns: EMPID, LASTNAME, and SALARY. The user would like to enter data for EMPID 59694, LASTNAME Harris, but no salary. Which statement would work best?

    ****1. INSERT INTO employee VALUES (59694,’HARRIS’, NULL);
    2. INSERT INTO employee VALUES (59694,’HARRIS’);
    3. INSERT INTO employee (EMPID, LASTNAME, SALARY) VALUES (59694,’HARRIS’);
    4. INSERT INTO employee (SELECT 59694 FROM ‘HARRIS’);

    The only statement that does not contain error.

    15 Which three of the following are valid database datatypes in Oracle? (Choose three.)

    ***1. CHAR
    ***2. VARCHAR2
    3. BOOLEAN
    ***4. NUMBER
    Oracle does not support boolean. Boolean can be represented by 0 or 1 and therefore no need to create a datatype for it.

    16 Omitting the WHERE clause from a DELETE statement has which of the following effects?

    1. The delete statement will fail because there are no records to delete.
    2. The delete statement will prompt the user to enter criteria for the deletion
    3. The delete statement will fail because of syntax error.
    ***4. The delete statement will remove all records from the table.

    If select statement does not have a where clause, it would select all rows. Hence delete without where clause would delete all rows.

    17 Creating a foreign-key constraint between columns of two tables defined with two different datatypes will produce an error.

    ***1. TRUE
    2. FALSE

    18 Dropping a table has which of the following effects on a nonunique index created for the table?

    1. No effect.
    ***2. The index will be dropped.
    3. The index will be rendered invalid.
    4. The index will contain NULL values.

    19 To increase the number of nullable columns for a table,

    ***1. Use the alter table statement.
    2. Ensure that all column values are NULL for all rows.
    3. First increase the size of adjacent column datatypes, then add the column.
    4. Add the column, populate the column, then add the NOT NULL constraint.

    Bad or badly phrased question, but to increase the number of any kind of column, you’d use alter table statement.

    20 Which line of the following statement will produce an error?

    1. CREATE TABLE goods
    2. (good_no NUMBER,
    ***3. good_name VARCHAR2 check(good_name in (SELECT name FROM avail_goods)),
    4. CONSTRAINT pk_goods_01
    5. PRIMARY KEY (goodno));
    6. There are no errors in this statement.

    Cannot have subquery in check.

    21 MAXVALUE is a valid parameter for sequence creation.

    ***1. TRUE
    2. FALSE

    22 Which of the following lines in the SELECT statement below contain an error?

    1. SELECT DECODE(empid, 58385, “INACTIVE”, “ACTIVE”) empid
    2. FROM emp
    ***3. WHERE SUBSTR(lastname,1,1) > TO_NUMBER(’S’)
    4. AND empid > 02000
    5. ORDER BY empid DESC, lastname ASC;
    6. There are no errors in this statement.

    cannot convert a letter to a number.

    23 Which function below can best be categorized as similar in function to an IF-THEN-ELSE statement?

    1. SQRT
    ***2. DECODE
    3. NEW_TIME
    4. ROWIDTOCHAR

    24 Which two of the following orders are used in ORDER BY clauses? (choose two)

    1. ABS
    ***2. ASC
    ***3. DESC
    4. DISC

    25 You query the database with this command

    SELECT name
    FROM employee
    WHERE name LIKE ‘_a%’;

    Which names are displayed?
    (should read as following I think)
    1. Names starting with “a”
    2. Names starting with “aR or “A”
    ***3. Names containing “aR” as second character
    4. Names containing “aR” as any letter except the first

    It still doesn’t make much sense as ‘aR’ cannot both be second character. the pattern would be to have lower case ‘a’ as second character, followed by anything and start with anything.

  5. pravasis
    Posted 3/6/2007 at 4:32 am | Permalink

    1.SELECT empid WHERE empid = 56949 AND lastname = ‘SMITH’; (no from)
    2.Place the alias after each column, separated by white space, to describe the column.
    3.Allows the user to specify alternate output for null column values.
    4.SELECT play_name||’, ‘ || author PLAY_TABLE FROM plays;
    5.The emacs editor will become the SQL*Plus default text editor.
    6.LOA(decode(column_name,if_value1,show_value1,if_value2,show_value2,rest)
    7.false(Datatype mismatch)
    8.DUAL
    9.sqrt(mathematical function)
    10.Until the session completes
    11.Ampersand
    12.select e.empid, d.head from emp e, dept d where e.dept# (+) = d.dept#; (left outer join)
    13.A table named ANIMALS will be created in the ANJU schema with the same data as the ANIMALS table owned by MASTER.
    14.INSERT INTO employee VALUES (59694,’HARRIS’, NULL);
    15.CHAR,VARCHAR2,NUMBER
    16.The delete statement will remove all records from the table.
    17.TRUE
    18.The index will be dropped.
    19.Ensure that all column values are NULL for all rows.
    20.good_name VARCHAR2 check(good_name in (SELECT name FROM avail_goods)), (select may not be allowed)
    21.TRUE
    22.WHERE SUBSTR(lastname,1,1) > TO_NUMBER(’S’) (datatype mismatch)
    23.DECODE
    24.ASC DESC
    25.a as second character

  6. Thiyagu
    Posted 3/24/2007 at 10:55 am | Permalink

    how to add salary of two tables and store into a result in any one table
    i need this output

    salarycolumn of emp salarycolumn of emp result
    1100 1200 1300

  7. johnny
    Posted 6/12/2007 at 8:30 am | Permalink

    Hi Thiyagu,

    This is johnny…
    the answer for ur query…
    if u hav any queries plz do let me know…
    leave a comment

    PRE-REQUISITE:
    CREATE 2 TABLES(EMP1,EMP2) BASED ON EMP TABLE.AND ADD COLUMN (result NUMBER(6)) in EMP1

    – PROGRAM STARTS FROM HERE
    DECLARE
    V_SAL1 NUMBER;
    V_SAL2 NUMBER;
    V_RESULT NUMBER;
    V_EMPNO1 NUMBER:=7654;
    V_EMPNO2 NUMBER:=7369;
    BEGIN
    SELECT SAL INTO V_SAL1 FROM EMP1 WHERE EMPNO=V_EMPNO1;
    SELECT SAL INTO V_SAL2 FROM EMP2 WHERE EMPNO=V_EMPNO2;
    V_RESULT := V_SAL1 + V_SAL2 ;
    DBMS_OUTPUT.PUT_LINE(’RESULT IS:’||V_RESULT);
    – SENDING THE RESULT INTO EMP1 TABLE
    UPDATE EMP1 SET RESULT = V_RESULT WHERE EMPNO=V_EMPNO1;
    END;

  8. Srikanth
    Posted 7/9/2007 at 7:47 am | Permalink

    1.
    4. SELECT empid WHERE empid = 56949 AND lastname = ‘SMITH’;

    2.
    2. Place the alias after each column, separated by white space, to describe the column.

    3. The NVL function

    3. Allows the user to specify alternate output for null column values.

    4.
    4. SELECT play_name||’, ‘ || author PLAY_TABLE FROM plays;

    5.
    1. The emacs editor will become the SQL*Plus default text editor.

    6.
    2. LOA

    7.
    2. FALSE ( invalid number error occurred checked).

    8.
    3. DUAL

    9.
    2. sqrt( )
    single row function

    10.
    4. Until the session completes

    11.
    1. Ampersand

    12.
    4. select e.empid, d.head from emp e, dept d where e.dept# (+) = d.dept#;

    13.
    3. A table named ANIMALS will be created in the ANJU schema with the same data as the ANIMALS table owned by MASTER.

    14.
    1. INSERT INTO employee VALUES (59694,’HARRIS’, NULL);

    15. Which three of the following are valid database datatypes in Oracle? (Choose three.)
    1. CHAR
    2. VARCHAR2
    4. NUMBER
    boolean is an pl/sql datatype in oracle.

    16.
    4. The delete statement will remove all records from the table.

    17.
    1. TRUE

    18.
    2. The index will be dropped.

    19.
    1. Use the alter table statement.

    20.
    3. good_name VARCHAR2 check(good_name in (SELECT name FROM avail_goods)),

    21.
    1. TRUE

    22.
    3. WHERE SUBSTR(lastname,1,1) > TO_NUMBER(’S’)

    23.
    2. DECODE

    24.
    2. ASC
    3. DESC

    25.
    5. as second character

  9. gaurav gaur
    Posted 10/22/2007 at 11:22 am | Permalink

    LTER procedure gaurav
    @tablename nvarchar(40)
    as
    declare @column_name nvarchar(34)
    declare @gencode nvarchar(234)
    declare @sqlstring varchar(234)
    declare @commandobjectname nvarchar(2345)
    set @gencode=”
    set @commandobjectname=’mycommand’
    select @gencode=@gencode +char(13)+’mycommand.parameters.addwithvalue(”@’+column_name+’”‘+column_name+’)’ from information_columns.columns where table_name=@tablename
    print @gencode

  10. gaurav gaur
    Posted 10/22/2007 at 11:26 am | Permalink

    aLTER procedure gaurav
    @tablename nvarchar(40)
    as
    declare @column_name nvarchar(34)
    declare @gencode nvarchar(234)
    declare @sqlstring varchar(234)
    declare @commandobjectname nvarchar(2345)
    set @gencode=”
    set @commandobjectname=’mycommand’
    select @gencode=@gencode +char(13)+’mycommand.parameters.addwithvalue(”@’+column_name+’”‘+column_name+’)’ from information_columns.columns where table_name=@tablename
    print @gencode
    “this stored procedure id best those who are working as asp.net developer bcz in .net we use to cm.parametrs.addwithvalue(”columnname’@columnname)
    we did not write any above code if we foolow above stored procedure just execute it
    with the help of command exe gaurav ‘tablename”
    happy coding

  11. masti
    Posted 12/2/2007 at 9:32 pm | Permalink

    .SELECT empid WHERE empid = 56949 AND lastname = ‘SMITH’; (no from)
    2.Place the alias after each column, separated by white space, to describe the column.
    3.Allows the user to specify alternate output for null column values.
    4.SELECT play_name||’, ‘ || author PLAY_TABLE FROM plays;
    5.The emacs editor will become the SQL*Plus default text editor.
    6.LOA(decode(column_name,if_value1,show_value1,if_value2,show_value2,rest)
    7.false(Datatype mismatch)
    8.DUAL
    9.sqrt(mathematical function)
    10.Until the session completes
    11.Ampersand
    12.select e.empid, d.head from emp e, dept d where e.dept# (+) = d.dept#; (left outer join)
    13.A table named ANIMALS will be created in the ANJU schema with the same data as the ANIMALS table owned by MASTER.
    14.INSERT INTO employee VALUES (59694,’HARRIS’, NULL);
    15.CHAR,VARCHAR2,NUMBER
    16.The delete statement will remove all records from the table.
    17.TRUE
    18.The index will be dropped.
    19.Ensure that all column values are NULL for all rows.
    20.good_name VARCHAR2 check(good_name in (SELECT name FROM avail_goods)), (select may not be allowed)
    21.TRUE
    22.WHERE SUBSTR(lastname,1,1) > TO_NUMBER(’S’) (datatype mismatch)
    23.DECODE
    24.ASC DESC
    25.a as second character

  12. preppy
    Posted 1/2/2008 at 2:20 am | Permalink

    Which of the following statements contains an error?

    SELECT empid WHERE empid = 56949 AND lastname = ‘SMITH’;

    Which of the following correctly describes how to specify a column alias?

    Place the alias after each column, separated by white space, to describe the column.

    The NVL function
    Allows the user to specify alternate output for null column values.

    Output from a table called PLAYS with two columns, PLAY_NAME and AUTHOR, is shown below. Which of the following SQL statements produced it?

    PLAY_TABLE
    ————————————-
    “Midsummer Night’s Dream”, SHAKESPEARE
    “Waiting For Godot”, BECKETT
    “The Glass Menagerie”, WILLIAMS

    SELECT play_name||’, ‘ || author PLAY_TABLE FROM plays;

    Issuing the DEFINE_EDITOR=”emacs” will produce which outcome?

    The emacs editor will become the SQL*Plus default text editor.

    The user issues the following statement. What will be displayed if the EMPID selected is 60494?

    SELECT DECODE(empid,38475, “Terminated”,60494, “LOA”, “ACTIVE”)
    FROM emp;

    LOA

    SELECT (TO_CHAR(NVL(SQRT(59483), “INVALID”)) FROM DUAL is a valid SQL statement.

    TRUE

    The appropriate table to use when performing arithmetic calculations on values defined within the SELECT statement (not pulled from a table column) is
    EMP
    DUAL

    Which of the following is not a group function?
    sqrt( )

    Once defined, how long will a variable remain so in SQL*Plus?

    Until the session completes

    The default character for specifying runtime variables in SELECT statements is

    Ampersand

    A user is setting up a join operation between tables EMP and DEPT. There are some employees in the EMP table that the user wants returned by the query, but the employees are not assigned to departments yet. Which SELECT statement is most appropriate for this user?

    select e.empid, d.head from emp e, dept d where e.dept# = d.dept# (+);

    Developer ANJU executes the following statement: CREATE TABLE animals AS SELECT * from MASTER.ANIMALS; What is the effect of this statement?

    A table named ANIMALS will be created in the ANJU schema with the same data as the ANIMALS table owned by MASTER.

    User JANKO would like to insert a row into the EMPLOYEE table, which has three columns: EMPID, LASTNAME, and SALARY. The user would like to enter data for EMPID 59694, LASTNAME Harris, but no salary. Which statement would work best?

    INSERT INTO employee (EMPID, LASTNAME, SALARY) VALUES (59694,’HARRIS’);

    Which three of the following are valid database datatypes in Oracle? (Choose three.)

    CHAR
    VARCHAR2
    NUMBER

    Omitting the WHERE clause from a DELETE statement has which of the following effects?

    The delete statement will remove all records from the table.

    Creating a foreign-key constraint between columns of two tables defined with two different datatypes will produce an error.

    TRUE

    Dropping a table has which of the following effects on a nonunique index created for the table?

    The index will be dropped.

    To increase the number of nullable columns for a table,

    Use the alter table statement.

    Which line of the following statement will produce an error?

    good_name VARCHAR2 check(good_name in (SELECT name FROM avail_goods)),

    MAXVALUE is a valid parameter for sequence creation.

    TRUE (not sure)

    Which of the following lines in the SELECT statement below contain an error?

    WHERE SUBSTR(lastname,1,1) > TO_NUMBER(’S’)

    Which function below can best be categorized as similar in function to an IF-THEN-ELSE statement?

    DECODE

    Which two of the following orders are used in ORDER BY clauses? (choose two)

    ASC
    DESC

    You query the database with this command

    SELECT name
    FROM employee
    WHERE name LIKE ‘_a%’;

    Which names are displayed?

  13. RaiS
    Posted 1/16/2008 at 6:37 am | Permalink

    1.Which of the following statements contains an error?
    SELECT empid WHERE empid = 56949 AND lastname = ‘SMITH’;

    2.Which of the following correctly describes how to specify a column alias?
    Place the alias after each column, separated by white space, to describe the column.

    3.The NVL function
    Allows the user to specify alternate output for non-null column values.

    4.Output from a table called PLAYS with two columns, PLAY_NAME and AUTHOR, is shown below. Which of the following SQL statements produced it?

    PLAY_TABLE
    ————————————-
    “Midsummer Night’s Dream”, SHAKESPEARE
    “Waiting For Godot”, BECKETT
    “The Glass Menagerie”, WILLIAMS
    None of the above

    5.Issuing the DEFINE_EDITOR=”emacs” will produce which outcome?

    The emacs editor will become the SQL*Plus default text editor.

    6. The user issues the following statement. What will be displayed if the EMPID selected is 60494?

    SELECT DECODE(empid,38475, “Terminated”,60494, “LOA”, “ACTIVE”)
    FROM emp;

    LOA

    Which of the following is not a group function?
    sqrt( )

    Once defined, how long will a variable remain so in SQL*Plus?
    Until the session completes

    The default character for specifying runtime variables in SELECT statements is
    Ampersand

    A user is setting up a join operation between tables EMP and DEPT. There are some employees in the EMP table that the user wants returned by the query, but the employees are not assigned to departments yet. Which SELECT statement is most appropriate for this user?
    select e.empid, d.head from emp e, dept d where e.dept# (+) = d.dept#;

    Developer ANJU executes the following statement: CREATE TABLE animals AS SELECT * from MASTER.ANIMALS; What is the effect of this statement?
    A table named ANIMALS will be created in the ANJU schema with the same data as the ANIMALS table owned by MASTER.

    User JANKO would like to insert a row into the EMPLOYEE table, which has three columns: EMPID, LASTNAME, and SALARY. The user would like to enter data for EMPID 59694, LASTNAME Harris, but no salary. Which statement would work best?
    INSERT INTO employee VALUES (59694,’HARRIS’);

    Which three of the following are valid database datatypes in Oracle? (Choose three.)
    CHAR
    VARCHAR2
    NUMBER

    Omitting the WHERE clause from a DELETE statement has which of the following effects?
    The delete statement will remove all records from the table.

    Creating a foreign-key constraint between columns of two tables defined with two different datatypes will produce an error.
    TRUE

    Dropping a table has which of the following effects on a nonunique index created for the table?
    The index will be dropped.

    Which line of the following statement will produce an error?
    CREATE TABLE goods
    (good_no NUMBER,
    good_name VARCHAR2 check(good_name in (SELECT name FROM avail_goods)),
    CONSTRAINT pk_goods_01
    PRIMARY KEY (goodno));
    There are no errors in this statement.
    PRIMARY KEY (goodno));

    MAXVALUE is a valid parameter for sequence creation.
    TRUE
    FALSE

    Which two of the following orders are used in ORDER BY clauses? (choose two)
    ASC
    DESC

    You query the database with this command

    SELECT name
    FROM employee
    WHERE name LIKE ‘_a%’;

    Which names are displayed?
    Names containing “aR
    as second character

  14. Sireesha
    Posted 3/6/2008 at 1:00 am | Permalink

    1. option 4 is an incorrect option.
    From Keyword is missing in the querry.

  15. Rambabu Makireddi
    Posted 4/23/2008 at 3:24 am | Permalink

    1. Ans 4: since query doesn’t have from clause

  16. Rambabu Makireddi
    Posted 4/23/2008 at 5:36 am | Permalink

    2. Ans:2. You can give alias using AS keyword.

    3.Ans:3

    4.Ans:4

    5.Ans:1. We use the DEFINE_EDITOR = command to define our favourite editor.

    6.Ans:2

    7.Ans:2, 1.first of all, INVALID string should be in single colon 2. Outcome of NVL function should be number

    8.Ans:3

    9.Ans:2

    10.Ans:3

    11.Ans:1

    12.Ans:3, if you want all records in A than B then use A=B(+)

    13.Ans:3

    14.Ans:1

    15.Ans: 1, 2 and 4, there is no BOOLEAN data type as far as Tables are concerned. But, procedures and functions can have.

    16.Ans:4

    17.Ans:1, the Foreign Key in detail table and its Primary or Unique Key in master table should have same datatype.

    18.Ans:2

    19.Ans:1

    20. The create statement is wrong. CHECK doesn’t allow the SELECT statement in it.

    21.Ans:1

    22.Ans: at line 1. Strings in Decode should be in single quotes.

    23.Ans: 2 we can use Case also

    24.Ans:2 and 3

    25.Ans:5

    16.

  17. Satyam
    Posted 5/15/2008 at 9:48 pm | Permalink

    Answer:
    1. 4.
    2. 2
    3. 3
    4. 4
    5. 1
    6. 2
    7. 2
    8. 3
    9. 2
    10. 4
    11. 1
    12. 4
    13. 3
    14. 1
    15. 1,2,4
    16. 4
    17. 1
    18. 2
    19. 1
    20. 3
    21. 1
    22. 3
    23. 2
    24. 2,3
    25. It will display the employee name starting by any character but second character must be ‘a’ and after that combination of many characters.
    Ex: satyam

  18. vishal
    Posted 9/25/2008 at 5:52 am | Permalink

    /*
    AUTHOR : VISHAL MEHRA
    DATE: 25/09/08

    */

    /******TO GET THE DATE’S DAY OF THE PERTICULAR DAY**************************/

    CREATE FUNCTION G4_WEEK_DAY_IN_MONTH_FUNC (@DATE DATETIME)
    RETURNS @TABLE TABLE
    (

    DATE DATETIME ,
    WEEK_DAY VARCHAR(30) ,
    WEEK_DAY_NO INT
    )

    AS

    BEGIN

    DECLARE @SRAT_DATE TABLE
    (

    START_DATE DATETIME,
    LAST_DATE DATETIME
    )

    DECLARE @WEEK_DAY_TABLE TABLE
    (
    DATE DATETIME,
    WEEK_DAY VARCHAR(30),
    WEEK_DAY_NO INT
    )

    INSERT INTO @SRAT_DATE
    SELECT CONVERT(DATETIME,’01/’+CONVERT(VARCHAR(12),MONTH(@DATE))+’/'+ CONVERT(VARCHAR(12),YEAR(@DATE)),103),
    LAST_DATE=DBO.G4_LAST_DATE_OF_MONTH_FUNC(@DATE)

    DECLARE @FIRST_DATE DATETIME,
    @LAST_DATE DATETIME

    SELECT @FIRST_DATE=START_DATE,
    @LAST_DATE=LAST_DATE
    FROM @SRAT_DATE

    WHILE @FIRST_DATE<=@LAST_DATE

    BEGIN

    INSERT INTO @WEEK_DAY_TABLE
    SELECT @FIRST_DATE, CASE DATEPART(DW,@FIRST_DATE)
    WHEN 1 THEN ‘SUNDAY’
    WHEN 2 THEN ‘MONDAY’
    WHEN 3 THEN ‘TUESDAY’
    WHEN 4 THEN ‘WEDNESDAY’
    WHEN 5 THEN ‘THURDSDAY’
    WHEN 6 THEN ‘FRIDAY’
    WHEN 7 THEN ‘SATURDAY’
    END, DATEPART(DW,@FIRST_DATE)

    SELECT @FIRST_DATE=@FIRST_DATE+1
    END

    INSERT INTO @TABLE

    SELECT *
    FROM @WEEK_DAY_TABLE

    RETURN

    END

    /*********HOW TO CALL***********/

    SELECT * FROM G4_WEEK_DAY_IN_MONTH_FUNC(’2008-01-01′)

    –OUTPUT

    DATE WEEK_DAY WEEK_DAY_NO
    —————————————————— —————————— ———–
    2008-01-01 00:00:00.000 TUESDAY 3
    2008-01-02 00:00:00.000 WEDNESDAY 4
    2008-01-03 00:00:00.000 THURDSDAY 5
    2008-01-04 00:00:00.000 FRIDAY 6
    .
    .
    .
    .
    .
    —————————————————————————————————–
    /*********TO GET THE NO OF WEEK DAYS IN A MONTH***********/

    CREATE FUNCTION G4_WEEK_DAYS_IN_MONTH_FUNC (@DATE DATETIME)
    RETURNS @TABLE TABLE
    (

    WEEK_DAY VARCHAR(30),
    WEEK_DAY_NO INT
    )

    AS

    BEGIN

    DECLARE @SRAT_DATE TABLE
    (

    START_DATE DATETIME,
    LAST_DATE DATETIME
    )

    DECLARE @WEEK_DAY_TABLE TABLE
    (
    DATE DATETIME,
    WEEK_DAY VARCHAR(30),
    WEEK_DAY_NO INT
    )

    INSERT INTO @SRAT_DATE
    SELECT CONVERT(DATETIME,’01/’+CONVERT(VARCHAR(12),MONTH(@DATE))+’/'+ CONVERT(VARCHAR(12),YEAR(@DATE)),103),
    LAST_DATE=DBO.G4_LAST_DATE_OF_MONTH_FUNC(@DATE)

    DECLARE @FIRST_DATE DATETIME,
    @LAST_DATE DATETIME

    SELECT @FIRST_DATE=START_DATE,
    @LAST_DATE=LAST_DATE
    FROM @SRAT_DATE

    WHILE @FIRST_DATE<=@LAST_DATE

    BEGIN

    INSERT INTO @WEEK_DAY_TABLE
    SELECT @FIRST_DATE, CASE DATEPART(DW,@FIRST_DATE)
    WHEN 1 THEN ‘SUNDAY’
    WHEN 2 THEN ‘MONDAY’
    WHEN 3 THEN ‘TUESDAY’
    WHEN 4 THEN ‘WEDNESDAY’
    WHEN 5 THEN ‘THURDSDAY’
    WHEN 6 THEN ‘FRIDAY’
    WHEN 7 THEN ‘SATURDAY’
    END, DATEPART(DW,@FIRST_DATE)

    SELECT @FIRST_DATE=@FIRST_DATE+1
    END

    INSERT INTO @TABLE

    SELECT WEEK_DAY, COUNT(WEEK_DAY_NO)NO_OF_DAYS
    FROM @WEEK_DAY_TABLE
    GROUP BY WEEK_DAY_NO,WEEK_DAY

    RETURN

    END

    ———————————————————————————————————–
    /**********TO GET THE LAST DAY IN A MONTH**********************/

    CREATE FUNCTION G4_LAST_DAY_IN_MONTH_FUNC (@LEAPE_DATE DATETIME)
    RETURNS INT
    AS
    BEGIN

    RETURN
    DATEPART(DAY,DATEADD(DAY,-DATEPART(DAY,@LEAPE_DATE),DATEADD(MM,1,@LEAPE_DATE)))

    END

    ————————————————————————————————————–
    /********TO GET THE LAST DATE OF THE MONTH********************/

    CREATE FUNCTION G4_LAST_DATE_OF_MONTH_FUNC (@LEAPE_DATE DATETIME)
    RETURNS DATETIME
    AS
    BEGIN

    RETURN DATEADD(DAY,-DATEPART(DAY,@LEAPE_DATE) , DATEADD(MM,1,@LEAPE_DATE))

    END

    ————————————————————————————————————–
    /*******TO GET THE LEAP YEAR **********************************/

    CREATE FUNCTION G4_LEAP_YEAR_FUNC (@LEAPE_DATE DATETIME)
    RETURNS VARCHAR(30)
    AS
    BEGIN

    RETURN
    CASE WHEN
    DATEPART(DY, CONVERT(DATETIME,’31/’+'12/’+CONVERT(VARCHAR(12),YEAR(@LEAPE_DATE)),103))=366
    THEN ‘LEAP YEAR’
    ELSE
    ‘NOT LEAP YEAR’
    END

    END

    —————————————————————————————————————
    /*********TO GET THE WEEK DAY***********************************/

    CREATE FUNCTION G4_WEEK_DAY_FUNC (@LEAPE_DATE DATETIME)
    RETURNS VARCHAR(20)
    AS
    BEGIN

    RETURN CASE DATEPART(DW,@LEAPE_DATE)
    WHEN 1 THEN ‘SUNDAY’
    WHEN 2 THEN ‘MONDAY’
    WHEN 3 THEN ‘TUESDAY’
    WHEN 4 THEN ‘WEDNESDAY’
    WHEN 5 THEN ‘THURDSDAY’
    WHEN 6 THEN ‘FRIDAY’
    WHEN 7 THEN ‘SATURDAY’
    END

    END
    ————————————————————-

    /********HOW TO CALL THESE FUNCTIONS*******/

    SELECT VALUE=DBO.G4_WEEK_DAY_FUNC (’2008-01-01′)

    –OUTPUT
    VALUE
    ——————–
    TUESDAY

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