0

databases Online Quiz - 164

Description: databases Online Quiz - 164
Number of Questions: 20
Created by:
Tags: databases
Attempted 0/20 Correct 0 Score 0
  1. SELECT * FROM Contest WHERE ContestDate >= '05/25/2006'

  2. SELECT * FROM Contest HAVING ContestDate >= '05/25/2006'

  3. SELECT * FROM Contest WHERE ContestDate < '05/25/2006'

  4. SELECT * FROM Contest IN ContestDate < '05/25/2006'


Correct Option: A
  1. INSERT INTO Projects (ProjectName, ProjectDescription) VALUES ('Content Development', 'Website content development project')

  2. INSERT Projects VALUES ('Content Development', 'Website content development project')

  3. INSERT Projects ('Content Development', 'Website content development project')

  4. SAVE INTO Projects (ProjectName, ProjectDescription) VALUES ('Content Development', 'Website content development project')


Correct Option: A
  1. SELECT * FROM Sales

  2. DELETE FROM Sales

  3. SELECT * FROM SALES WHERE OrderID < 1

  4. SELECT FROM Sales


Correct Option: A
  1. DELETE FROM SalesData

  2. DELETE * FROM SalesData

  3. DELETE SalesData

  4. DELETE ALL SalesData


Correct Option: A
  1. To return the minimum value of a numeric expression.

  2. To return the absolute, positive value of a numeric expression.

  3. To return the maximum value of a numeric expression.

  4. To return the average value of a numeric expression.


Correct Option: B

The HAVING clause can be used only with ...

  1. INSERT clause

  2. SELECT clause

  3. DELETE clause

  4. JOIN clause


Correct Option: B
  1. Selective Join.

  2. You can't join a table to itself.

  3. Self Join

  4. Outer Join


Correct Option: C
  1. Determines if a value matches any of the values in a list or a sub-query.

  2. Defines the tables we are selecting or deleting data from.

  3. Is used with the DISTINCT SQL keyword only.

  4. Is used to select data from a view


Correct Option: A
  1. a special type of table

  2. a special type of store procedure, executed when certain event occurs

  3. a special type of view

  4. an event


Correct Option: B

Which of the following is a SQL aggregate function

  1. LEFT

  2. LEN

  3. AVG

  4. JOIN


Correct Option: C

"select" - Belogns to

  1. DML

  2. MDL

  3. DDL

  4. All the above


Correct Option: A

"select E_Name,E_Number from EMP order by 2" This Query is

  1. True

  2. False


Correct Option: A

Which key word is used to remove a table from the database

  1. Delete

  2. Truncate

  3. Remove

  4. Drop


Correct Option: D

To Insert new a column in a table Tbl_Test which of the following query is used

  1. Alter table Tbl_Test Insert column New_Column varchar 20

  2. Alter table Tbl_Test Alter column New_Column varchar 20

  3. Alter table Tbl_Test add New_Column varchar 20

  4. Either a or b could be used


Correct Option: C

Calling a stored Procedure inside a view is Possible

  1. True

  2. False


Correct Option: A

In the following which is not a DDL ?

  1. Truncate

  2. Create

  3. Alter

  4. All the above


Correct Option: A
- Hide questions