0

databases Online Quiz - 145

Description: databases Online Quiz - 145
Number of Questions: 20
Created by:
Tags: databases
Attempted 0/20 Correct 0 Score 0

Which SQL statement selects all rows from a table called Products and orders the result set by ProductID column?

  1. SELECT * FROM Products ORDER BY ProductID

  2. SELECT * FROM Products WHERE ProductID > 200

  3. SELECT * FROM Products ORDERED BY ProductID

  4. SELECT ProductID FROM Products


Correct Option: A
  1. Selects all Customers from the Sales table

  2. Selects all customers from table Sales that have made more than 5 orders.

  3. Selects the total number of orders from the Sales table, if this number is greater than 5

  4. Selects no records


Correct Option: B
  1. The foreign key is a column that can have NULL values.

  2. The foreign key is a SQL locking mechanism.

  3. A foreign key is a key field (column) in a database table, which relates the table to another table where the key is a primary key. The primary - foreign key relations are used to cross-reference database tables.

  4. The foreign key is a column that should be primary key for that table.


Correct Option: C
  1. INSERT Projects VALUES ('Content Development', 'Website content development project')

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

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

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


Correct Option: C
  1. SELECT FROM Sales WHERE Date BETWEEN ('10/12/2005', '01/01/2006')

  2. SELECT * FROM Sales WHERE Date BETWEEN '10/12/2005' AND '01/01/2006'

  3. SELECT FROM Sales WHERE Date BETWEEN '10/12/2005' AND '01/01/2006'

  4. SELECT * FROM Sales WHERE Date BETWEEN ('10/12/2005', '01/01/2006')


Correct Option: B
  1. Self Join

  2. Selective Join.

  3. Outer Join

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


Correct Option: A

Which of the following is a reserved SQL keyword?

  1. GROWN

  2. FROM

  3. UPDATING

  4. DELETING


Correct Option: B

How would you find out the total number of rows in a DB2 table?

  1. Use SELECT COUNT(*)...in db2 query

  2. Use SELECT DISTINCT...in db2 query

  3. Use SELECT MAX(...)...in db2 query

  4. Use SELECT ROWNUM(*)...in db2 query


Correct Option: A

What is the physical storage length of DB2 data types-DATE,TIME,TIMESTAMP?

  1. 8 bytes, 6 bytes, 26 bytes

  2. 4 bytes, 3 bytes, 13 bytes

  3. 4 bytes, 3 bytes, 10 bytes

  4. 10 bytes, 8 bytes, 26 bytes


Correct Option: D

How do you eliminate duplicate values in DB2 SELECT?

  1. Use SELECT UNION(*)...in db2 query

  2. Use SELECT DISTINCT...in db2 query

  3. Use SELECT UNION ALL(...)...in db2 query

  4. Use SELECT DISTINCT ALL(*)...in db2 query


Correct Option: B

DB2 is a relational database

  1. True

  2. False


Correct Option: A

SSIS uses connection managers to integrate different data sources into packages. IS Analysis Services Connection Manager is available?

  1. True

  2. False


Correct Option: A

To Connect to Oracle database from SSIS OLE DB Connection Manager is not used.

  1. True

  2. False


Correct Option: B

Script component is used in both Control Flow as well as Data Flow.

  1. True

  2. False


Correct Option: B
- Hide questions