0

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

  2. SELECT COLUMNS() FROM Persons

  3. SELECT COLUMNS(*) 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