databases Online Quiz - 13

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

With SQL, how can you insert a new record into the "Persons" table?

  1. INSERT INTO Persons VALUES ('Jimmy', 'Jackson')

  2. INSERT ('Jimmy', 'Jackson') INTO Persons

  3. INSERT VALUES ('Jimmy', 'Jackson') INTO Persons

  4. INSERT ('Jimmy', 'Jackson') INTO Persons

Correct Option: A
  1. INSERT ('Olsen') INTO Persons (LastName)

  2. INSERT INTO Persons (LastName) VALUES ('Olsen')

  3. INSERT INTO Persons ('Olsen') INTO LastName

  4. INSERT FROM Persons ('Olsen') INTO LastName

Correct Option: B
  1. UPDATE Persons SET LastName='Hansen' INTO LastName='Nilsen'

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

  3. MODIFY Persons SET LastName='Hansen' INTO LastName='Nilsen

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

Correct Option: B
  1. DELETE FROM Persons WHERE FirstName = 'Peter'

  2. DELETE FirstName='Peter' FROM Persons

  3. DELETE ROW FirstName='Peter' FROM Persons

  4. DELETE FROM Persons WHERE FirstName <> 'Peter'

Correct Option: A
  1. SELECT COUNT() FROM Persons



  4. SELECT COUNT(*) FROM Persons

Correct Option: D

In how many ways the Funnel Stage can operate?

  1. Four

  2. Three

  3. Two

  4. Only one

Correct Option: B

Select statement in Sybase can include columns not specified in the GROUP BY clause

  1. True

  2. False

Correct Option: A
  1. SQL Developer

  2. SQLWays

  3. Both a and b

  4. Only a

Correct Option: C
  1. MYSQL

  2. SQL Server

  3. DB2

  4. Oracle

  5. All of the above/ Any database suggested by client

Correct Option: B,D

What is a child stored procedure?

  1. A procedure that is very small

  2. A procedure being invoked by another procedure

  3. A procedure that is not used by application

  4. System stored procedures

Correct Option: B

Choose the datatypes not supported by Oracle

  1. timestamp

  2. varchar

  3. datetime

  4. number

  5. raw

Correct Option: C

Magic tables in Sybase are

  1. inserted

  2. updated

  3. deleted

  4. created

Correct Option: A,C

Identify the background process which, is responsible for writing data from buffer cache to the datafiles to make changes permanent

  1. Checkpoint (CKPT)

  2. Database Writer (DBWR)

  3. Process Monitor (PMON)

  4. Log Writer (LGWR)

Correct Option: B

Identify the parts of System Global Area. Choose all that apply.

  1. Database Buffer Cache

  2. Shared Pool

  3. Data Dictionary

  4. Redolog Group

  5. Redolog Buffer

Correct Option: A,B,E

Identify the physical components of the database. Choose all that apply

  1. Database

  2. Controlfile

  3. Table

  4. Datafile

  5. Index

  6. Redolog Group

Correct Option: B,D,F
- Hide questions