Tag: databases

Questions Related to databases

Which of the following SQL clauses is used to select data from 2 or more tables?
technology databases

  1. HAVING

  2. JOIN

  3. WHERE

  4. BETWEEN

Show answer
Correct Option: B

Which of the following commands cause a transaction to end?
technology databases

  1. DELETE

  2. ALTER

  3. INSERT

  4. UPDATE

  5. ROLLBACK

Show answer
Correct Option: E

Consider the following SELECT statement: SELECT dept_no "Departments", MAX(salary) "Max Salaries" FROM employee WHERE dept_no IN(200, 300, 400) GROUP BY Departments HAVING MAX(salary) > 60000; Due to which clause does this statement fail?
technology databases

  1. Group By

  2. Where

  3. Select

  4. Having

Show answer
Correct Option: A

Which SQL statement is used to extract data from a database?
technology databases

  1. OPEN

  2. GET

  3. SELECT

  4. EXTRACT

Show answer
Correct Option: C

Did row migration is caused by less pctfree space in datablock ?
technology databases

  1. True

  2. False

Show answer
Correct Option: A

Which background processes is not mandatory in Oracle server?
technology databases

  1. ARCH

  2. PMON

  3. SMON

  4. RECO

Show answer
Correct Option: A,D

We can not remove a row from view, if it contains
technology databases

  1. Group functions

  2. Group by clause

  3. Distinct keyword

  4. All of above

Show answer
Correct Option: D

We can not remove a row from view, if it contains
technology databases

  1. Group functions

  2. Group by clause

  3. Distinct keyword

  4. All of the above

Show answer
Correct Option: D

On dropping a view
technology databases

  1. respective table data is retained

  2. data is deleted from table

  3. depends on conditions

  4. all of above

Show answer
Correct Option: A

We can not modify data in view
technology databases

  1. Group by clause

  2. Distinct keyword

  3. Pseudo column ROWNUM keyword

  4. All of above

Show answer
Correct Option: D