Data Triggs Round 1

Herman Hollerith

Raymond F Boyce

Charles Babbage

Edgar F Codd

Herman Hollerith

Raymond F Boyce

Charles Babbage

Edgar F Codd

Herman Hollerith

Raymond F Boyce

Charles Babbage

Edgar F Codd

SELECT * FROM Persons WHERE FirstName='a';

SELECT * FROM Persons WHERE FirstName LIKE 'a%';

SELECT * FROM Persons WHERE FirstName LIKE '%a';

SELECT * FROM Persons WHERE FirstName LIKE'%a'%;

NULL=0

NULL

NULL>0

NULL0

Oracle

SQL

DBase

Microsoft Access

Key

Determinant

Tuple

Relation

SELECT

UNION

RENAME

PROJECT

NULL

NOT NULL

Function NVL2 is not defined

None of the Above

Atomicity, Consistency, Isolation, Database

Atomicity, Consistency, Isolation, Durability

Atomicity, Concurrency, Inconsistent, Durability

Atomicity, Concurrency, Isolation, Durability

Asterisk(*) ; percent sign(%)

Percent sign(%) ; underscore(_)

Underscore(_) ; question mark(?)

Question mark(?) ; asterisk(*)

Access

Oracle

FoxPro

All of these

Implicit Lock

Explicit Lock

Exclusive Lock

Shared Lock

Yup

Nope

Null

Error

UPDATE

ALTER

CREATE

RENAME

Unify

Ingress

IDMS

None of the above

Select name from students where email = 0;

Select name from students where email = ' ';

Select name from students where email is null;

Select name from students where email = 'null';

COMMIT TRANSACTION

ROLLBACK TRANSACTION

Either by COMMIT TRANSACTION or by ROLLBACK TRANSACTION

NONE

FROM

GET

CHOOSE

SELECT

Relation

Attribute

Tuple

Domain

INSERT

MERGE

UPDATE

None of the above

SELECT TOP 1 SALARY FROM ( SELECT TOP 3 SALARY FROM employee_table ORDER BY SALARY ASC) AS EMP ORDER BY SALARY DESC;

SELECT TOP 1 SALARY FROM ( SELECT TOP 3 SALARY FROM employee_table ORDER BY SALARY DESC) AS EMP ORDER BY SALARY ASC;

SELECT TOP 3 SALARY FROM ( SELECT TOP 1 SALARY FROM employee_table ORDER BY SALARY DESC) AS EMP ORDER BY SALARY ASC;

SELECT TOP 3 SALARY FROM ( SELECT TOP 1 SALARY FROM employee_table ORDER BY SALARY ASC) AS EMP ORDER BY SALARY DESC;