Free Cheat-test Samples and Demo Questions Download
Adobe exams Adobe
Apple exams Apple
Avaya exams Avaya
Check Point exams Check Point
Cisco exams Cisco
Citrix exams Citrix
CIW exams CIW
CompTIA exams CompTIA
CWNP exams CWNP
EC-Council exams EC-Council
EMC exams EMC
Exin exams Exin
Fortinet exams Fortinet
GIAC exams GIAC
Hitachi exams Hitachi
HP exams HP
IBM exams IBM
Isaca exams Isaca
ISC exams ISC
ISEB exams ISEB
Juniper exams Juniper
LPI exams LPI
McAfee exams McAfee
Microsoft exams Microsoft
Oracle exams Oracle
PMI exams PMI
Riverbed exams Riverbed
SNIA exams SAP
Sun exams SAS
Symantec exams Symantec
VMware exams VMware
All certification exams

IBM 000-700 Exam - Cheat-Test.com

Free 000-700 Sample Questions:

1.When establishing client-server communication, which two of the following can be used to verify passwords?
A: Catalog Tables
B: Access Control List
C: Application Programs
D: DRDA Application Server
E: Client Operating System
Answer: D, E

2.Given the table T1 created by:
CREATE TABLE t1
(
id INTEGER NOT NULL GENERATED ALWAYS AS IDENTITY,
c1 CHAR(10) NOT NULL,
c2 CHAR(10)
)
Which of the following INSERT statements will succeed?
A: INSERT INTO t1 VALUES ('abc', NULL)
B: INSERT INTO t1 VALUES (1, 'abc', NULL)
C: INSERT INTO t1 (c1, c2) VALUES ('abc', NULL)
D: INSERT INTO t1 (c1, c2) VALUES (NULL, 'def')
Answer: C

3.Given table EMPLOYEE with columns EMPNO and SALARY, and table JOB with columns ID and TITLE, what is the effect of the following statement?
UPDATE employee SET salary = salary * 1.15
WHERE salary < 15000 OR
EXISTS (SELECT 1 FROM job WHERE job.id = employee.empno AND job.title = 'MANAGER')
A: Employees who make less than 15,000 and all managers are given salary increases.
B: Only employees who are managers that make less than 15,000 are given salary increases.
C: Employees who are not managers and who make less than 15,000 are given salary increases.
D: Only employees who are not managers or make less than 15,000 are given salary increases.
Answer: A

4.Which of the following DB2 UDB isolation levels will lock no rows during read processing?
A: Read Stability
B: Repeatable Read
C: Uncommitted Read
D: Cursor Stability
Answer: C

5.Table T1 has a column C1 char(3) that contains strings in upper and lower case letters. Which of the following queries will find all rows where C1 is the string 'ABC' in any case?
A: SELECT * FROM t1 WHERE c1 = 'ABC'
B: SELECT * FROM t1 WHERE UCASE(c1) = 'ABC'
C: SELECT * FROM t1 WHERE IGNORE_CASE(c1 = 'ABC')
D: SELECT * FROM t1 WHERE c1 = 'ABC' WITH OPTION CASE INSENSITIVE
Answer: B

6.Which two of the following result from a successful ROLLBACK statement?
A:The current unit of work is restarted.
B:Existing database connections are released.
C:Locks held by the current unit of work are released.
D:Tables in LOAD PENDING for the current unit of work are released.
E:Changes made by the current unit of work since the last COMMIT point are undone.
Answer: C, E

7.Given the two following table definitions:
ORG
deptnumbINTEGER
deptname CHAR(30)
manager INTEGER
division CHAR(30)
location CHAR(30)
STAFF
id INTEGER
name CHAR(30)
dept INTEGER
job CHAR(20)
years INTEGER
salary DECIMAL(10,2)
comm DECIMAL(10,2)
Which of the following statements will display each department, by name, and the total salary of all employees in the department?
A: SELECT a.deptname, SUM(b.salary)
FROM org a, staff b
WHERE a.deptnumb=b.dept
ORDER BY a.deptname
B: SELECT a.deptname, SUM(b.salary)
FROM org a, staff b
WHERE a.deptnumb=b.dept
GROUP BY a.deptname
C: SELECT a.deptname, SUM(b.salary)
FROM org a INNER JOIN staff b
ON a.deptnumb=b.dept
ORDER BY a.deptname
D: SELECT b.deptname, SUM(a.salary)
FROM org a INNER JOIN staff b
ON a.deptnumb=b.dept
GROUP BY a.deptname
Answer: B

8.Which of the following tools is used to create subscription sets and add subscription-set members to subscription sets?
A: Journal
B: License Center
C: Replication Center
D: Development Center
Answer: C

9.Given the following DDL statements:
CREATE TABLE tab1 (a INT, b INT, c INT)
CREATE VIEW v1 AS SELECT a, b, c FROM tab1
WHERE a > 250
WITH CHECK OPTION
Which of the following INSERT statements will fail?
A: INSERT INTO v1 VALUES (250, 2, 3)
B: INSERT INTO v1 VALUES (300, 2, 3)
C: INSERT INTO tab1 VALUES (350, 2, 3)
D: INSERT INTO tab1 VALUES (200, 2, 3)
Answer: A

10.Given the create statements:
CREATE DISTINCT TYPE kph AS INTEGER WITH COMPARISONS
CREATE DISTINCT TYPE mph AS INTEGER WITH COMPARISONS
CREATE TABLE speed_limits
(route_num SMALLINT,
canada_sl KPH NOT NULL,
us_sl MPH NOT NULL)
Which of the following is a valid query?
A: SELECT route_num FROM speed_limits WHERE canada_sl > 80
B: SELECT route_num FROM speed_limits WHERE canada_sl > kph
C: SELECT route_num FROM speed_limits WHERE canada_sl > us_sl
D: SELECT route_num FROM speed_limits WHERE canada_sl > kph(80)
Answer: D


© 2014 Cheat-Test.com, All Rights Reserved