0

databases Online Quiz - 228

Description: databases Online Quiz - 228
Number of Questions: 20
Created by:
Tags: databases
Attempted 0/20 Correct 0 Score 0
  1. we are joining more than 2 tables

  2. we are joining table to itself

  3. we are using left and right join together

  4. none of the above


Correct Option: D
  1. The HAVING keyword specifies a search condition for an aggregate or a group

  2. The HAVING keyword is used to select distinct values

  3. The HAVING keyword is used to join 2 or more tables.

  4. None of the above


Correct Option: D

What does follow after the SQL SELECT clause?

  1. The JOIN SQL clause.

  2. List of columns that will be selected or the * symbol.

  3. The name of the table we are selecting from.

  4. None of the above


Correct Option: D
  1. An index is the same as alias.

  2. An index is a special way to join 2 or more tables.

  3. An index is a database table attribute, which speeds-up data search within a table.

  4. None of the above


Correct Option: D
  1. A view is a special stored procedure executed when certain event occurs.

  2. A view is a database diagram.

  3. A view is a virtual table which results of executing a pre-compiled query. A view is not part of the physical database schema, while the regular tables are

  4. None of the above


Correct Option: D
  1. UPDATE Persons SET LastName='Hansen' WHERE LastName='Nilsen'

  2. MODIFY Persons SET LastName='Hansen' WHERE LastName='Nilsen'

  3. UPDATE Persons SET LastName='Nilsen' WHERE LastName='Hansen'

  4. MODIFY Persons SET LastName='Nilsen' WHERE LastName='Hansen'


Correct Option: C
  1. SELECT * FROM Persons WHERE FirstName='%a%'

  2. SELECT * FROM Persons WHERE FirstName='a'

  3. SELECT * FROM Persons WHERE FirstName LIKE '%a'

  4. SELECT * FROM Persons WHERE FirstName LIKE 'a%'


Correct Option: D
  1. SELECT * FROM Persons WHERE FirstName='Peter',LastName='Jackson'

  2. SELECT * FROM Persons WHERE FirstName='Peter' OR LastName='Jackson'

  3. SELECT * FROM Persons WHERE FirstName='Peter' AND LastName='Jackson'

  4. SELECT * FROM Persons WHERE FirstName<>'Peter' AND LastName<>'Jackson'


Correct Option: C
  1. SELECT * FROM Persons ORDER BY FirstName DESC

  2. SELECT * FROM Persons SORT BY 'FirstName' DESC

  3. SELECT * FROM Persons SORT 'FirstName' DESC

  4. SELECT * FROM Persons ORDER FirstName DESC


Correct Option: A
  1. SELECT DIFFERENT

  2. SELECT DISTINCT

  3. SELECT COUNT

  4. SELECT UNIQUE


Correct Option: B
  1. you save and close the file

  2. you save excel in XML format

  3. you create an excel template

  4. you save it in Excel 2007 version


Correct Option: C

When you press Shift + Space bar

  1. An entire column gets selected in MS Excel

  2. The entire worksheet gets selected in MS Excel

  3. An entire row gets selected in MS Excel

  4. Nothing happens


Correct Option: C
  1. Column

  2. 123_Invoices

  3. Catch_#22

  4. #Invoices

  5. None of the above


Correct Option: C
  1. The cell gets formatted to Number category with 2 decimal places

  2. The cell gets formatted to Number category with 4 decimal places

  3. The cell gets formatted into different font

  4. Nothing happens


Correct Option: A

To produce a meaningful result set without any cartesian products, what is the minimum number of conditions that should appear in the WHERE clause of a that joins 'N' tables?

  1. 4

  2. 3

  3. N - 1

  4. N + 1


Correct Option: C
  1. System tablespace

  2. Users tablespace

  3. Default tablespace for the user

  4. Oracle will give an error


Correct Option: C
- Hide questions