a) SELECT postcode FROM SuppliedBy WHERE weight>1000
b) SELECT postcode FROM Supplier WHERE NOT EXISTS (SELECT 1 FROM SuppliedBy WHERE Supplier.sid=SuppliedBy.sid AND weight>1000)
c) SELECT postcode FROM Supplier, SuppliedBy WHERE Supplier.sid=SuppliedBy.sid AND weight < 1000
d) SELECT DISTINCT postcode FROM Supplier WHERE EXISTS (SELECT 1 FROM SuppliedBy WHERE Supplier.sid=SuppliedBy.sid AND weight < 1)
e) SELECT DISTINCT postcode FROM Supplier, SuppliedBy WHERE Supplier.sid=SuppliedBy.sid AND weight < 1000
59. ? ( )
a) , .
b)
c) , .
d) .
e)
60. (view)?
a)
b)
c) -
d)
e) ,
61. SQL-: SELECT DISTINCT Emp.Ename, Dept.Loc FROM Emp, Dept
a)
b)
c)
d)
e)
62. (JOIN)? ( )
a) (INNER)
b) (LEFT OUTER)
c) (RIGHT OUTER)
d) (FULL OUTER)
e) (COMPOSITE OUTER)
63. SQL?
a)
b)
c)
d) , WHERE HAVING SQL
e) SQL
64. .. ?
a) Oracle
b) dBase
c)
d) Borland, BDE/IDAPI
e)
65. SQL- SELECT * FROM Emp, Dept?
a)
b)
c)
d)
e)
66. ?
a) ,
b) ( )
|
|
c) , , ,
d) ,
e)
67. ?
a) SQL-,
b) , SQL
c) , , ,
d) ,
e)
68. ?
a)
b)
c) ,
d)
e)