Tag: databases

Questions Related to databases

What will be the output of following Select 8 from Emp ? Emp table has 10 rows
technology databases

  1. No Rows returned

  2. 10 rows of Emp table

  3. Error

  4. 8 is displayed 10 times

Show answer
Correct Option: D

Can we abbreviate keywords across lines?e.g. DESCRIBE

technology databases

  1. True

  2. False

Show answer
Correct Option: B

Is Century Information is recorded when Oracle data base stores the DATE internally into a table?
technology databases

  1. True

  2. False

Show answer
Correct Option: A

What is the correct use of the Trunc command on a date?
technology databases

  1. TRUNC=To_Date('09-Jan-02,DD-MON-YY,'YEAR',"Date" from Dual;

  2. Select TRUNC(To_Date('09-Jan-02,DD-MON-YY,YEAR')) "DATE" from Dual;

  3. Date =TRUNC(To_DATE('09-Jan-02','DD-MON-YY'),'YEAR'),'YEAR)"DATE: from DUAL;

  4. SELECT TRUNC(TO_DATE('12-Feb-99','DD-MON-YY'), 'YEAR') "Date " FROM DUAL;

Show answer
Correct Option: D

Which type of join should be written to perform an outer join of tables A and B that returns all rows from B?
technology databases

  1. Any outer join

  2. A left outer join

  3. A cross join

  4. A right outer join

Show answer
Correct Option: D

How many join conditions should be there to avoid a Cartesian Join for joining three tables?
technology databases

  1. 1

  2. 2

  3. 3

  4. None of these

Show answer
Correct Option: D

Examine the code given below: SELECT employee_id FROM employees WHERE commission_pct=.5 OR salary > 23000 Which of the following statement is correct with regard to this code?

technology databases

  1. It returns employees who have 50% of the salary greater than $23,000:

  2. It returns employees who have 50% commission rate or salary greater than $23,000:

  3. It returns employees who have 50% of salary less than $23,000:

  4. None of the above

Show answer
Correct Option: B

Which of the following tasks can be performed by using the TO_CHAR function?
technology databases

  1. Convert '10'to 10

  2. Convert 10 to '10'

  3. Convert 'TEN' to 10

  4. Convert a date to a character expression

Show answer
Correct Option: B,D

Which of the following SELECT statements will get the result 'elloworld' from the string 'HelloWorld'?
technology databases

  1. SELECT SUBSTR ('HelloWorld',1) FROM dual;

  2. SELECT LOWER (SUBSTR ('HellowWorld', 2,1) FROM dual;

  3. SELECT LOWER (SUBSTR('HellowWorld', 2,1) FROM dual;

  4. SELECT LOWER (TRIM ('H' FROM 'Hello World')) FROM dual;

Show answer
Correct Option: D

Where is the GROUP BY clause statement placed in a SELECT statement that includes a WHERE clause?

technology databases

  1. Immediately after the SELECT clause

  2. Before the WHERE clause

  3. After the ORDER BY clause

  4. After the WHERE clause

Show answer
Correct Option: D