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
  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 Sybase we can not compare a date column with a varchar value.

  1. True

  2. False


Correct Option: B
  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 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