DB2考试自测题(页 1) - DB2

页: [1]

孤云野鹤

2006-10-9 07:24

DB2考试自测题

[b][color=blue]关于DB2认证相关信息（试题、考试等）可以到这儿查阅或交流！[/color][/b]

[url=http://www-900.ibm.com/developerWorks/cn/dmdd/library/techarticles/dm-0401fosdick/index.shtml][color=blue]db2认证的IBM官方站点[/color][/url]

[b]DB2考试自测题1 [/b]

1) Which of the following products is required to be installed in order to bu ild an application on AIX, which will access a DB2 UDB for OS/390 database?
a) DB2 Connect Personal Edition
b) DB2 Universal Database Workgroup Edition
c) DB2 Personal Developer's Edition
d) DB2 Universal Developer's Edition

2) Which of the following tools can be used to catalog a database?
a) Journal
b) Alert Center
c) License Center
d) Client Configuration Assistant

3) Which of the following utilities would you run to order data and reclaim s
pace from deleted rows in a table:
a) reorg
b) db2look
c) db2move
d) runstats

4) The purpose of the USE privilege is to:
a) query data in a table.
b) load data into a table.
c) create tables within a table space.
d) create table spaces within a database.

5) Which two of the following authorities can create a database?
a) DBADM
b) SYSADM
c) DBCTRL
d) SYSCTRL
e) SYSMAINT

6) Cataloging a remote database is:
a) Performed on a PC or UNIX machine to identify the server the DB2 data base manager is on.
b) Performed on a PC or UNIX machine to identify the DB2 database to use rs and applications.
c) Never performed in DB2, as only one database per node is allowed, so cataloging a node automatically catalogs the database at that node.
d) Performed on a PC or UNIX machine to open the catalogs in the DB2 dat abase and present a user with a list of all accessible tables in that database.

7) 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)

8) If, for a given table, the Control Center does not show the choice Generate DDL, which of the following describes the reason?
a) The table is a system object.
b) The table is a summary table.
c) The table is in LOAD PENDING.
d) The table is a replicated table.
e) The table was created by a different user.

9) Given the tables:
COUNTRY
ID NAME          PERSON CITIES
1 Argentina             1          10
2 Canada             2          20
3 Cuba                2          10
4 Germany             1          0
5 France                7          5

STAFF
ID LASTNAME
1    Jones
2    Smith

Which of the following statements removes the rows from the COUNTRY table that have PERSONS in the STAFF table?
  a) DELETE FROM country WHERE id IN (SELECT id FROM staff)
  b) DELETE FROM country WHERE id IN (SELECT person FROM staff)
  c) DELETE FROM country WHERE person IN (SELECT id FROM staff)
  d) DELETE FROM country WHERE person IN (SELECT person FROM staff)

10) The table STOCK has the following column definitions:
type          CHAR (1)
status          CHAR(1)
quantity       INTEGER
price          DEC (7,2)

Items are indicated to be out of stock by setting STATUS to NULL and QUANTITY and PRICE to zero. Which of the following statements updates the STOCK table to indicate that all the items except for those with TYPE of "S" are temporarily out of stock?
  a) UPDATE stock SET status='NULL', quantity=0, price=0 WHERE type ; 'S'
  b) UPDATE stock SET (status, quantity, price) = (NULL, 0, 0) WHERE type ; 'S'
  c) UPDATE stock SET (status, quantity, price) = ('NULL', 0, 0) WHERE type; 'S'
  d) UPDATE stock SET status = NULL, SET quantity=0, SET price = 0 WHERE type ; 'S'

11) Which of the following products can be used to store image data in a DB2 database?
  a) Net.Data
  b) Net Search
  c) DB2 AVI Extenders
  d) DB2 XML Extenders
  e) DB2 Text Extenders

12) Which of the following CANNOT have an autocommit setting?
  a) Embedded SQL
  b) The Command Center
  c) The Command Line Processor
  d) The DB2 Call Level Interface

13) Which of the following statements eliminates all but one of each set of d
uplicate rows in the final result table?
a) SELECT UNIQUE * FROM t1
b) SELECT DISTINCT * FROM t1
c) SELECT * FROM DISTINCT T1
d) SELECT UNIQUE (*) FROM t1
e) SELECT DISTINCT (*) FROM t1

14) Given the table:
STAFF
ID  LASTNAME
1 Jones
2 Smith
3 ;
Which of the following statements removes all rows from the table where there is a NULL value for LASTNAME?
  a) DELETE FROM staff WHERE lastname IS NULL
  b) DELETE ALL FROM staff WHERE lastname IS NULL
  c) DELETE FROM staff WHERE lastname = 'NULL'
  d) DELETE ALL FROM staff WHERE lastname = 'NULL'

15) Given the following table definitions:
DEPARTMENT
deptno          CHAR(3)
deptname          CHAR(30)
mgrno          INTEGER
admrdept          CHAR(3)
EMPLOYEE
empno          INTEGER
firstname       CHAR(30)
midinit          CHAR
lastname       CHAR(30)
workdept       CHAR(3)
Which of the following statements will list every employee's number and last name with the employee number and last name of their manager, including employees without a manager?
  a) SELECT e.empno, e.lastname, m.empno, m.lastname FROM employee e LEFT INNER JOIN department INNER JOIN employee m ON mgrno = m.empno ON e.workdept = deptno
  b) SELECT e.empno, e.lastname, m.empno, m.lastname, FROM employee e LEFT OUTER JOIN department INNER JOIN employee m ON mgrno = m.empno ON e.workdept = deptno
  c) SELECT e.empno, e.lastname, m.empno, m.lastname FROM employee e RIGHT OUTER JOIN department INNER JOIN employee m ON mgrno = m.empno ON e.workdept = deptno
  d) SELECT e.empno, e.lastname, m.empno, m.lastname FROM employee e RIGHT INNER JOIN department INNER JOIN employee m ON mgrno = m.empno ON e.workdept = deptno

16) Given the following tables:
NAMES
Name                   Number
Wayne Gretzky          99
Jaromir Jagr             68
Bobby Orr                4
Bobby Hull             23
Brett Hull                16
Mario Lemieux          66
Steve Yzerman          19
Claude Lemieux          19
Mark Messier             11
Mats Sundin             13

POINTS
Name                   Points
Wayne Gretzky             244
Jaromir Jagr             168
Bobby Orr                129
Bobby Hull                93
Brett Hull                121
Mario Lemieux          189

PIM
Name             PIM
Mats Sundin       14
Bobby Orr       12
Mark Messier       32
Brett Hull          66
Mario Lemieux    23
Joe Sakic          94
Which of the following statements will display the player's Names, numbers, points and PIM for all players with an entry in all three tables?
  a) SELECT names.name, names.number, points.points, pim.pim FROM names INNER JOIN points ON names.name=points.name INNER JOIN pim ON pim.name=names.name
  b) SELECT names.name, names.number, points.points, pim.pim FROM names OUTER JOIN points ON names.name=points.name OUTER JOIN pim ON pim.name=names.name
  c) SELECT names.name, names.number, points.points, pim.pim FROM names LEFT OUTER JOIN points ON names.name=points.name LEFT OUTER JOIN pim ON pim.name=names.name
  d) SELECT names.name, names.number, points.points, pim.pim FROM names RIGHT OUTER JOIN points ON names.name=points.name RIGHT OUTER JOIN pim ON pim.name=names.name

17) Given the tables:
EMPLOYEE
emp_num       emp_name    dept
1             Adams       1
2             Jones          1
3             Smith          2
4             Williams       1

DEPT
dept_id    dept_name
1          Planning
1          Support
and the statement:
ALTER TABLE employee
ADD FOREIGN KEY (dept) REFERENCES (dept_id)
ON DELETE CASCADE

How many units of work will be needed to process this statement:
DELETE FROM dept WHERE dept_id=1
  a) 0
  b) 1
  c) 2
  d) 3
  e) 4
  f) 6

18) Given the requirements to store names, employee numbers, and when the employees were hired, which of the following DB2 data types CANNOT be used to contain the day the employee was hired?
  a) CLOB
  b) TIME
  c) VARCHAR
  d) TIMESTAMP

19) Given the transaction:
"CREATE TABLE t1 (id INTEGER,CONSTRAINT chkid CHECK (id; 1will insert how many rows into the STAFF table?
a)       0
b)       1
c)       2
d)       3

30) Given the following table definition and SQL statements:
CREATE TABLE table1 (col1 INT, col2 CHAR(40), col3 INT)
GRANT INSERT, UPDATE, SELECT, REFERENCES ON TABLE table1 TO USER usera

Which of the following SQL statements will revoke privileges for user USERA on COL1 and COL2?
a)       REVOKE UPDATE ON TABLE table1 FROM USER usera
b)       REVOKE ALL PRIVILEGES ON TABLE table1 FROM USER usera
c)       REVOKE ALL PRIVILEGES ON TABLE table1 COLUMNS (col1, col2) FROM USERA
d)       REVOKE REFERENCES ON TABLE table1 COLUMNS (col1, col2) FROM USER usera

31) Given, CREATE TABLE t1 (c1 CHAR(4) NOT NULL). Which of the following can be inserted into this table?
a)       4
b)       NULL
c)       ‘abc’
d)       ‘abcde’

32) A declared temporary table is used for which of the following purposes:
a)       backup purposes
b)       storing intermediate results
c)       staging area for the load utility
d)       sharing result sets between applications

33) Which of the following delete rules will not allow a row to be deleted from the parent table if a row with the corresponding key value still exists inthe child table?
a)       DELETE
b)       CASCADE
c)       RESTRICT
d)       SET NULL

34) Which of the following processing can occur for a unit of work using an isolation level of Uncommitted Read and scanning through the table more than once within the unit of work?
a)       Access uncommitted changes made by other processes
b)       Update uncommitted changes made by other processes
c)       Update rows of a return set and have those updates changed by other processes from one scan to the next
d)       Update rows of a return set and have those updates committed by other processes from one scan to the next
35) Which of the following database authorities is required to add a new package?
a)       BINDADD
b)       CREATETAB
c)       CREATEPKG
d)       PACKAGEADD

36) Given the successfully executed embedded SQL:
INSERT INTO staff VALUES (1, 'Colbert','Dorchester', 1)
COMMIT
INSERT INTO staff VALUES (6, 'Anders', 'Cary', 6)
INSERT INTO staff VALUES (3, 'Gaylord', 'Geneva',
ROLLBACK WORK

Which of the following indicates the number of new rows that would be in the STAFF table?
a)       0
b)       1
c)       2
d)       3

37) Given the two table definitions:

ORG
deptnumb    INTEGER
deptname    CHAR(30)
manager    INTEGER
division       CHAR(30)
location       CHAR(30)

STAFF
id                INTEGER
name          CHAR(30)
dept          INTEGER
job             CHAR(30)
years          CHAR(30)
salary       DECIMAL(10,2)
comm       DECIMAL(10,2)

Which of the following statements will display each department, alphabetically by name,and the name of the manager of the department?
a) SELECT a.deptname, b.name FROM org a, staff b WHERE a.manager=b.id
b) SELECT a.deptname, b.name FROM org a, staff b WHERE b.manager=a.id
c) SELECT a.deptname, b.name FROM org a, staff b WHERE a.manager=b.id GROUP BY a.deptname, b.name
d) SELECT a.deptname, b.name FROM org a, staff b, WHERE b.manager=a.id GROUP BY a.deptname, b.name

38) Which of the following DDL statements creates a table where employee idsare unique?
a)       CREATE TABLE t1 (employid INTEGER)
b)       CREATE TABLE t1 (employid UNIQUE INTEGER)
c)       CREATE TABLE t1 (employid INTEGER NOT NULL)
d)       CREATE TABLE t1 (employid INTEGER NOT NULL, primary key (employid))

39) A client application on OS/390 must access a DB2 server on Unix, Windows or OS/2. At a minimum, which of the following is required to be the DB2 server machine?
a)       DB2 Connect Enterprise Edition
b)       DB2 Universal Database Enterprise Edition
c)       DB2 Connect and DB2 Universal Database Workgroup Edition
d)       DB2 Connect and DB2 Universal Database Enterprise Edition

40) Given the statements and operations:
"CREATE TABLE t1 (c1 CHAR(1))"
Six rows are inserted with values of: a, b, c, d, e and f
"SET CONSTRAINTS FOR t1 OFF"
"ALTER TABLE t1 ADD CONSTRAINT con1 CHECK (c1 ='a')"
"SET CONSTRAINTS FOR t1 IMMEDIATE CHECKED FOR EXCEPTION IN t1 USE t1exp"

Which of the following describes what happens to the rows with values of b, c, d, e and f?
a)       deleted from T1 only
b)       deleted from T1 and written into the t1exp file
c)       deleted from T1 and inserted into the table t1exp
d)       deleted from T1 and written into the db2diag.log file
e)       deleted from T1 and inserted into the table syscat.checks

41) Given the requirement of providing a read-only database, applications accessing the database should be run with which of the following isolation levels to allow for the most read concurrency?
a)       Read stability
b)       Repeatable read
c)       Cursor stability
d)       Uncommitted read

孤云野鹤

2006-10-9 07:32

Given table EMPLOYEE with columns EMPNO and SALARY and table JOB with

columns ID and TITLE, what is the effect of the statement:
UPDATE employee SET salary = salary * 1.15
WHERE salary

孤云野鹤

2006-10-9 07:37

DB2考试自测题3

（1/55） Given two embedded SQL programs and the following actions:
            Pgm1                      Pgm2
         INSERT INTO mytab VALUES DELETE FROM mytab
         (...)
         COMMIT                   ROLLBACK
         DELETE FROM mytab       (...)
         ROLLBACK                COMMIT
If there exists one (1) row in table mytab before the programs are executed concurrently, how many records will be in the table once the programs complete? (Select the correct response)
A.       0
B.       1
C.       2
D.       3
E.       4

（2/55）Which of the following DB2 CLP options specify the file that contains the statements to be executed?  (Select the correct response)
A.       –F
B.       –B
C.       –O
D.       –W

（3/55）A view is used instead of a table for users to do which of the following?  (Select the correct response)
A.       Avoid allocating more disk space per database
B.       Provide users with the ability to define indexes
C.       Restrict user's access to a subset of the table data
D.       Avoid allocating frequently used query result tables

（4/55） Given the table definition:
CREATE TABLE student (name CHAR(30), age INTEGER)
To list the names of the 10 youngest students, which of the following index definition statements on the student table may improve the query performance?

(Select the correct response)
A.       CREATE INDEX youngest ON student (age, name)
B.       CREATE INDEX youngest ON student (name, age)
C.       CREATE INDEX youngest ON student (name, age DESC)
D.       CREATE INDEX youngest ON student (name DESC) INCLUDE (age)

（5/55） Given the following UPDATE statement:
UPDATE address2 SET housenumber_buildingname=(SELECT buildingname FROM address1 WHERE address2.id = address1.id)
WHERE HOUSENUMBER_BUILDINGNAME IS NULL
Which of the following describes the result of the statement?
(Select the correct response)
A.       The statement will succeed.
B.       The statement will fail because a subquery cannot exist in an UPDATE statement.
C.       The statement will succeed only if ADDRESS1.ID and ADDRESS2.ID are definedas primary keys.
D.       The statement will succeed if the data retrieved from the subquery does not have duplicate values for ADDRESS1.ID.

（6/55） Given the following column requirements:
Col1 Numeric Identifier - From 1 to 1000000
Col2 Job Code - Variable, 1 to 2 characters long
Col3 Job Description - Variable, 1 to 100 characters long
Col4 Job Length - Length of Job in seconds
Which of the following will minimize the disk space allocated to store the records if Job Description has an average length of 45?
(Select the correct response)
A.       CREATE TABLE tab1 (col1 INT, col2 CHAR(2), col3 CHAR(100), col4 INT)
B.       CREATE TABLE tab1 (col1 INT, col2 VARCHAR(2), col3 CHAR(100), col4 INT)
C.       CREATE TABLE tab1 (col1 INT, col2 CHAR(2), col3 VARCHAR(100), col4 INT)
D.       CREATE TABLE tab1 (col1 INT, col2 VARCHAR(2), col3 VARCHAR(100), col4 INT)

（7/55） Which of the following will rebuild a package in the database from the existing catalog information?  (Select the correct response)
A.       bind
B.       rebind
C.       update
D.       rebuild

（8/55）With tables defined as:
   Table1
   col1    INT
   col2    CHAR(30)

   Table2
      col1       INT
      col2       CHAR(30)
Which of the following statements will insert all the rows in TABLE2 into TABLE1?
(Select the correct response)
A.       INSERT INTO table1 SELECT col1, col2 FROM table2
B.       INSERT INTO table1 AS SELECT col1, col2 FROM table2
C.       INSERT INTO table1 VALUES (table2.col1, table2.col2)
D.       INSERT INTO table1 VALUES (SELECT col1, col2 FROM table2)
E.       INSERT INTO table1 (col1,col2) VALUES (SELECT col1,col2 FROM table2)

（9/55） Given an embedded SQL program with a single connection, two threads and the following actions:
Thread 1: INSERT INTO mytab VALUES (...)
Thread 2: INSERT INTO mytab VALUES (...)
Thread 1: COMMIT
Thread 2: INSERT INTO mytab VALUES (...)
Thread 1: ROLLBACK
How many records will be successfully inserted and retained in the table mytab?
(Select the correct response)
A.       0
B.       1
C.       2
D.       3

（10/55）Which of the following can be used to determine the views that are affected by a DROP TABLE statement?  (Select the correct response)
A.       DB2 Script Center
B.       DB2 Performance Monitor
C.       DB2 Control Center, Show Related
D.       DB2 Control Center, Sample Contents

（11/55） Which of the following is the implicit qualifier for a declared temporary table?  (Select the correct response)
A.       The schema name SYSCAT.
B.       The schema name SESSION.
C.       The schema name TEMPUSER.
D.       The userid specified with the BIND command.
E.       The userid who established the connection to the database and declared the temporary table.

（12/55） Given table EMPLOYEE with columns EMPNO and SALARY and table JOB with columns ID and TITLE, what is the effect of the statement:
UPDATE employee SET salary = salary * 1.15
WHERE salary ; 250
WITH CHECK OPTION
Which of the following INSERT statements will fail?
(Select the correct response)
A.       INSERT INTO t1 VALUES (200, 2, 3)
B.       INSERT INTO v1 VALUES (200, 2, 3)
C.       INSERT INTO t1 VALUES (300, 2, 3)
D.       INSERT INTO v1 VALUES (300, 2, 3)

（52/55）Given table T1 with 100 rows, which of the following queries will retrieve 10 rows from table T1?  (Select the correct response)
A.       SELECT * FROM t1 MAXIMUM 10 ROWS
B.       SELECT * FROM t1 READ 10 ROWS ONLY
C.       SELECT * FROM t1 OPTIMIZE FOR 10 ROWS
D.       SELECT * FROM t1 FETCH FIRST 10 ROWS ONLY

（53/55）Given the following:
A table containing a list of all seats on an airplane. A seat consists of a seat number and whether or not it is assigned. An airline agent lists all the unassigned seats on the plane. When the agent refreshes the list from the table, it should only change if another agent unassigns a currently assigned seat.

Which of the following isolation levels should be used for this application?

(Select the correct response)
A.       Read stability
B.       Repeatable read
C.       Cursor stability
D.       Uncommitted read

（54/55）With tables defined as:
Table1
col1 INT
col2  CHAR(30)

Table2
col1 INT
col2  CHAR(30)
Which of the following statements will insert all the rows in TABLE2 into TABLE1?
(Select the correct response)
A.       INSERT INTO table1 SELECT col1, col2 FROM table2
B.       INSERT INTO table1 AS SELECT col1, col2 FROM table2
C.       INSERT INTO table1 VALUES (table2.col1, table2.col2)
D.       INSERT INTO table1 VALUES (SELECT col1, col2 FROM table2)
E.       INSERT INTO table1 (col1,col2) VALUES (SELECT col1,col2 FROM table2)

（55/55）Given the following table definitions:
DEPARTMENT
Deptno CHAR(30)
Deptname  CHAR(30)
Mgrno    INTEGER
Admrdept  CHAR(3)

EMPLOYEE
Empno    INTEGER
Firstname  CHAR(30)
Midinit CHAR
Lastname CHAR(30)
Workdept CHAR(3)

Which of the following statements will list the employee's employee number, last name, and department name ONLY for those employees who have a department?

(Select the correct response)
A.       SELECT e.empno, e.lastname, d.deptname FROM employee e, department d WHERE e.workdept = d.deptno
B.       SELECT e.empno, e.lastname, d.deptname FROM employee e LEFT OUTER JOIN department d ON e.workdept = d.deptno
C.       SELECT e.empno, e.lastname, d.deptname FROM employee e FULL OUTER JOIN department d ON e.workdept = d.deptno
D.       SELECT e.empno, e.lastname, d.deptname FROM employee e RIGHT OUTER JOIN department d WHERE e.workdept = d.deptno

孤云野鹤

2006-10-9 07:48

DB2考试自测题4 Given a table T1, with a column C1 char(3), that contains strings inupper and lower case letters, which of the following queries will find all rows where C1 is the string 'ABC' in any case?  (Select the correct response)
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

孤云野鹤

2006-10-9 08:00

DB2考试自测题5 Given two embedded SQL program executions with the following actions
:
Pgm1
INSERT INTO mytab VALUES (...)
COMMIT
INSERT INTO mytab VALUES (...)
ROLLBACK

Pgm2
INSERT INTO mytab VALUES (...)
ROLLBACK
INSERT INTO mytab VALUES (...)
COMMIT
How many records will be successfully inserted and retained in the table mytab?
(Select the correct response)
A.    1
B.    2
C.    3
D.    4

孤云野鹤

2006-10-9 08:11

DB2考试自测题6

1. With DBADM authority on the database and given the statements:
CREATE TABLE t1 (c1 CHAR(1))
INSERT INTO t1 VALUES ('b')
CREATE VIEW v1 AS SELECT c1 FROM t1 WHERE c1='a' WITH CHECK OPTION
INSERT INTO v1 VALUES ('a')
INSERT INTO v1 VALUES ('b')
How many rows would be returned from the statement, SELECT c1 FROM t1?
(Select the correct response)
A.0
B.1
C.2
D.3

2. Which of the following Control Center features can be used to update information for the optimizer to choose the best path to data? (Select the correct response)
A Show Related
B. Generate DDL
C. Run Statistics
D. Reorganize Table

3. Given the tables:
TABLEA          TABLEB
Empid  name       empid  weeknumber  paycheck
  1    JOE          1       1    1000.00
  2    BOB          1       2    1000.00
                     2       1    1000.00
TABLEB was defined as follows:
CREATE TABLE tableb (empid CHAR(3), weeknumber CHAR(3), paycheck DECIMAL(6,2)
,
CONSTRAINT const1 FOREIGN KEY (empid)
REFERENCES tablea (empid) ON DELETE SET NULL)
How many rows would be deleted from tableb if the following command is issued
:
DELETE FROM tablea WHERE empid = '2'?
(Select the correct response)
A.0
B.1
C.2
D.3

4. Which of the following DB2 UDB isolation levels will NOT lock any rows during read processing?  (Select the correct response)
A. Read Stability
B. Repeatable Read
C. Uncommited Read
D. Cursor Stability

5. Which of the following processing can occur for a unit of work using an isolation level of Read Stability and scanning through the table more than oncewithin the unit of work?  (Select the correct response)
A. Access uncommitted changes made by other processes
B. Update uncommitted changes made by other processes
C. Rows added to a result set by other processes from one scan to the next
D. Rows changed in a result set by other processes from one scan to the next

6. Which of the following describes when indexes can be explicitly referencedby name within an SQL statement?  (Select the correct response)
A. When dropping the index
B. When updating the index
C. When selecting on the index
D. When inserting using the index

7. Given an embedded SQL program with a single connection, two threads and the following actions:
Thread 1: INSERT INTO mytab VALUES (...)
Thread 2: INSERT INTO mytab VALUES (...)
Thread 1: COMMIT
Thread 2: INSERT INTO mytab VALUES (...)
Thread 1: ROLLBACK
How many records will be successfully inserted and retained in the table mytab?
(Select the correct response)
A.0
B.1
C.2
D.3

8. A user creates the table TABLE1. Which of the following statements would explicitly give USER1 the ability to read rows from the table?  (Select the correct response)
A. GRANT VIEW TO user1 ON TABLE table1
B. GRANT READ TO user1 ON TABLE table1
C. GRANT SELECT ON TABLE table1 TO user1
D. GRANT ACCESS ON TABLE table1 TO user1
9. Given the following:
TAB1          TAB2
C1 C2    CX CY
---  ---    --- ---
A 11    A    21
B 12    C    22
C 13    D    23
The following results are desired:
C1 C2 CX CY
-- -- -- --
A  11  A 21
B  12  -- --
C  13  C  22
Which of the following joins will yield the desired results?
(Select the correct response)
A.       SELECT * FROM tab1, tab2 WHERE c1=cx
B.       SELECT * FROM tab1 INNER JOIN tab2 ON c1=cx]
C.       SELECT