0

databases Online Quiz - 46

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

Which SQL statement is used to delete data from a database table?

  1. DROP

  2. DELETE

  3. TRUNCATE

  4. REMOVE


Correct Option: B

What is a trigger

  1. A piece of logic written in PL/SQL

  2. Executed at the arrival of a SQL*FORMS event

  3. Both A & B

  4. None of the above


Correct Option: C

RENAME command is a :

  1. DCL command

  2. TCL command

  3. DDL command

  4. DML command


Correct Option: C
  1. Is a collection of tables created and maintained by oracle server.

  2. Contain user information.

  3. Contain database information.

  4. Both a and c

  5. All


Correct Option: E

A DML statement is executed when you:

  1. Modify existing rows in a table.

  2. Add a new column in a table

  3. Both a & b

  4. None


Correct Option: A
  1. FROM

  2. Columns defined by expression

  3. WHERE

  4. Both b & c


Correct Option: B

Fast Load can load the duplicate record in a multiset table.

  1. True

  2. False


Correct Option: A

Which of the following property is true about FAST LOAD.

  1. No more than 1 data type conversion is allowed per column during the Fastload

  2. If an AMP is down FL cannot be restarted untill that AMP is back online

  3. only load 1 empty table with one fast load job

  4. Fast load assembles data in 64K blocks and then loads it using mutltiple sessions

  5. Fast load supports triggers.


Correct Option: A,B,C

Which of the following utility is designed to allow OLTP trasactions to immediately load in Datawarehouse?

  1. Fast Load

  2. Multi Load

  3. Tpump

  4. Fast Export


Correct Option: C

For Fast load script to be restartable which of the following should hold true?

  1. Target table should not be created in the script

  2. target table should be created in the script

  3. Error tables should not be dropped in the script

  4. Checkpoint should be declared in the script

  5. Target table should not be dropped in the script


Correct Option: A,C,D,E

select the properties of TPUMP

  1. It is possible to stipulate how many updates may occur per minute

  2. It is possible to have tpump running in the background all the time and just control its flow rate

  3. It can load upto 60 tables at a time if using a single source

  4. It can be stopped any time and all locks dropped or released with no ill consequences.

  5. it uses macro to run the SQL statements

  6. It has more error tollerance than FL and ML


Correct Option: A,B,C,D,E

Sub-queries can be nested in

  1. DELETE statements only

  2. UPDATE, DELETE, INSERT and SELECT statements

  3. UPDATE statements only

  4. INSERT statements only


Correct Option: B

Which SQL statement inserts data into a table called Projects?

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

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

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

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


Correct Option: C

Which of the following SQL statements is correct?

  1. SELECT FROM Sales WHERE Date BETWEEN '10/12/2005' AND '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', '01/01/2006')

  4. All the above


Correct Option: B

Which of the following SQL clauses is used to sort a result set

  1. Order By

  2. Sort

  3. Arrange

  4. All the above


Correct Option: A
- Hide questions