A UDT is a data type which:
A. must contain unique values.
B. cannot be CAST to other data types.
C. is created using the CREATE DISTINCT command.
D. contains a value that was automatically calculated from values in other
columns.
2.
Which of the following statements allows USER1 to take away read access on the table
ORG. TAB1 from USER2?
A. REVOKE SELECT FROM user2 ON TABLE org.tab1
B. REVOKE SELECT ON TABLE org.tab1 FROM user2
C. REVOKE READ ACCESS FROM user2 ON TABLE org.tab1
D. REVOKE READ ACCESS ON TABLE org.tab1 FROM user2
3.
Which of the following resources can be referenced in the LOCK statement?
A. Row
B. Table
C. Column
D. Table space
4.
Given the following table definition:
STOCK:
item VARCHAR (30)
status CHAR (1)
quantity INT
price DEC ( 7,2 )
If items are indicated to be out of stock by setting STATUS to NULL and QUANTITY and
PRICE to zero, which of the following statements would be used to update the STOCK
table to indicate that all the items whose description begins with the letter "S" are out of
stock?
A. UPDATE stock SET (status = NULLquantity, price = 0) WHERE item LIKE
'S%'
B. UPDATE stock SET (status, quantity, price) = (NULL, 0, 0) WHERE item
LIKE 'S%'
C. UPDATE stock SET status = NULL, SET quantity = 0, SET price = 0
WHERE item LIKE 'S%'
D. UPDATE stock SET (status = NULL), (quantity = 0), (price = 0) WHERE item
LIKE 'S%'
5.
Given that tables T1 and T2 contain the following rows:
Table Ti:Table T2:
C1 C2 C1 C2
-------------- ----------------
1 41 1
1 31 2
1 21 3
Which of the following queries will return only those rows that exist in both T1 and T27
A.SELECT * FROM tl
UNION
SELECT * FROM t2
B.SELECT * FROM tl
UNION DISTINCT
SELECT * PROM t2
C. SELECT * FROM tl
INTERSECT
SELECT * FROM t2
D. SELECT * FROM tl WHERE (cl,c2)= (SELECT cl,c2 FROM t2)
6.
A user utilizing an alias to update a subset of columns in a table must have UPDATE
privileges on which of the following DB2 objects?
A. Table
B. Columns
C. Table and Alias
D. Columns and Alias
7.
In which situation is shredding XML data recommended?
A. When the data is naturally tabular
B. When the number of nodes are volatile
C. When the data by nature has sparse attributes
D. When the data is of Iow volume and requires a complex star-schema topology
8.
Which of the following is TRUE for the DB2 isolation level Cursor Stability (CS)?
A. An application process acquires at least a share lock on the current row of
every cursor.
B. Any row that is read during a unit of work cannot be changed by other
application processes until the unit of work is complete.
C. Any row changed by another application process can be read, even if the
change has net been committed by that application process.
D. An application process that issues the same query more than once in a unit
of work will net see additional rows caused by other application processes appending new
information to the database.
9.
Which of the following DB2 products are required on an iSeries or System i server to
enable an application running on that server to retrieve data from a DB2 database on a
Linux server?
A. DB2 for i5/OS
B. DB2 Runtime Client
C. DB2 Connect Enterprise Edition
D. DB2 for i5/OS SQL Development Kit
10.
A user needs to create a trigger that will update table T2 whenever a row is added to table
T1. Assuming the user has all appropriate privileges for table T2, which privilege is
required on table T1 to create the trigger?
A. REFERENCES
B. SELECT
C. UPDATE
D. ALTER
11.
Application A is designed to execute the following SQL statements within a single Unit of
Work (UOW).
UPDATE employee SET salary = salary * 1.1 WHERE empno='000010'
UPDATE department SET deptname = 'NEW dept' WHERE deptno='A00'
Application B is designed to execute the following SQL statements within a single Unit of
Work (UOW).
UPDATE department SET deptname = ' OLD DEPT ' WHERE deptno= ' A00 '
UPDATE employee SET salary = salary * 0.5 WHERE empno=' 000010'
Application A and application B execute their first SQL statement at the same time. When
application A and application B try to execute their second SQL statement, a deadlock occurs. What will happen?
A. The database manager will rollback the transaction in both applications.
B. The database manager will rollback the transaction in one of the two applications.
C. Application B will successfully update the EMPLOYEE and DEPARTMENT
tablesApplication A will be placed in a lock wait state.
D. Application A will successfully update the EMPLOYEE and DEPARTMENT
tablesApplication B will terminate when the lock timeout value is reached.
12.
If application A issues the following SQL statement, which of the following statements
about concurrency is true?
SELECT deptno, deptname, mgrno
FROM dept
WHERE admrdept = 'A00'
FOR READ ONLY WITH RS
A. Rows accessed by application A can be seen by other applications.
B. Rows accessed by application A cannot be seen by other applications.
C. Application A can see uncommitted changes made by other applications.
D. Results produced by re-execution of the statement by application A will not
be affected by other applications.
13.
Which of the following tools for DB2 V9 allows a user to create and debug a SQL stored
procedure?
A. Control Center
B. Development Center
C. Developer Workbench
D. Stored Procedure Builder
14.
Which of the following is the lowest cost DB2 product that can be legally installed on an
AIX server?
A. DB2 Express Edition
B. DB2 Personal Edition
C. DB2 Workgroup Server Edition
D. DB2 Enterprise Server Edition
15.
A DRDA host database resides on a z/OS or an i5/OS system and listens on port 446. The
TCP/IP address for this system is 192.168.10.1 and the TCP/IP host name is myhost.
Which of the following commands is required to update the local node directory so that a
DB2 client can access this DRDA database?
A. CATALOG TCPIP NODE myhost REMOTE db2srv SERVER 446
B. CATALOG TCPIP NODE mydb2srv REMOTE myhost SERVER 446
C. CATALOG TCPIP NODE myhost REMOTE db2srv SERVER 192.168.10.1
D. CATALOG TCPIP NODE mydb2srv REMOTE myhost SERVER
192.168.10.1
16.
Given the following query:
SELECT quantity,
CASE WHEN itemcode = '099' THEN 'SILVER'
WHEN itemcode = '788' THEN 'GOLD'
WHEN itemcode = '899' THEN 'PLATINUM'
ELSE ' ERROR'
END
FROM supplier
What will be the result of the query if the following data is evaluated by the CASE
expression?
SUPPLIER
..........................................
QUANTITY ITEMCODE
3 099
4 099
1 788
1 899
5 009
3 788
1 899
A.3,SILVER
4,GOLD
1,SILVER
1,GOLD
5,PLATINUM
3,SILVER
1,GOLD
B.3,SILVER
4,SILVER
1,GOLD
1,PLATINUM
S,ERROR
3,GOLD
1,PLATINUM
C.3,SILVER
4,SILVER
1,PLATINUM
1,ERROR
5,SILVER
3,GOLD
1,PLATINUM
D.3,SILVER
4,SILVER
1,GOLD
1,GOLD
5,SILVER
3,ERROR
1,PLATINUM
17.
A "trusted" client needs to communicate with a sewer that has been configured to use
CLIENT authentication. Which of the following will be used to verify passwords?
A. User ID/password file
B. Communications layer
C. Client applications
D. Operating system
18.
Within the application MY_APP the following PREVIOUS VALUE expression references
the sequence MY_SEQ:
PREVIOUS VALUE FOR my_seq
After which of the following events will the most recently generated value of MY_SEQ
persist so that it can be returned to the active MY_APP application?
A. After a ROLLBACK is issued
B. After the sequence is altered
C. After the sequence is dropped
D. After the current session ends
19.
Given the following ALTER SEQUENCE statement:
ALTER SEQUENCE myseq RESTART WITH 0 INCREMENT BY 1 NO MAXVALUE CACHE
S ORDER
Assuming that the sequence had reached a value of 100 prior to the RESTART, which of
the following is true?
A. The next value will be 0 and the sequence will never use the values 101 to
105.
B. The next value will be 101 to ensure uniqueness between existing and newly
generated sequence values.
C. Previously cached values are retained by DB2, and after the restart, will be
used for values 101 to 105.
D. The next value will be 0 and DB2 will not ensure uniqueness between
existing and newly generated values.
20.
To which of the following resources can a lock be applied?
A. Row
B. Alias
C. Bitmap
D. Column
21.
Which of the following statements is used to grant user TOM and Application team
APPGRP the ability to add data to table TAB1?
A. GRANT ADD DATA ON TABLE tab1 TO GROUP tom appgrp
B. GRANT INSERT TO USER tom, GROUP appgrp ON TABLE tab1
C GRANT INSERT ON TABLE tab1 TO USER tom, GROUP appgrp
D. GRANT ADD DATA ON TABLE tab1 TO USER appgrp, GROUP tom
22.
Assuming PUBLIC has been granted all privileges on table T1, which of the following
statements would continue to permit any user to add rows to table T1, but not remove
them?
A. REVOKE DROP ON tl FROM PUBLIC
B. REVOKE UPDATE ON tl FROM PUBLIC
C. REVOKE DELETE ON tl FROM PUBLIC
D. REVOKE CONTROL ON tl FROM PUBLIC
23.
On which of the following database objects may the SELECT privilege be controlled?
A. Sequence
B. Schema
C. Group
D View
24.
The opening of cursor CSR01 produces the following result set:
STUDENT LASTNM FIRSTNMCLASSNO
123 Brown JohnT100
213 Bailey James T100
312 Carter Arlene T210
465 Chase Devon T305
546 Davis Steven T405
If this Fetch statement is executed:
FETCH csr01 INTO :studnum, :firstname, :lastname, :class
Which of the following DELETE statements will cause this row- to be deleted?
A. DELETE ALL FROM tab01 FOR CURRENT OF cst01
B. DELETE FROM tab01 FOR CURRENT cst01 WITH RS
C. DELETE * FROM tab01 WHERE CURRENT csr01 WITH CS
D. DELETE FROM tab01 WHERE CURRENT OF csr01 WITH RR
25.
Given the following statements:
CREATE TABLE tabl (coll INT)
CREATE TABLE tab2 (coll INT)
CREATE TRIGGER trigl AFTER UPDATE ON tabl
REFERENCING NEW AS newl
FOR EACH ROW MODE DB2SQL
INSERT INTO tab2 VALUES(newl.coll)
INSERT INTO tabl VALUES(2) , (3)
What is the result of the following query?
SELECT count(*) FROM tab2
A3
B2
C1
D0
26.
An application needs a table for each connection that tracks the ID and Name of all items previously ordered and committed within the connection. The table also needs to be cleaned up and automatically removed each time a connection is ended. Assuming theITEMS table was created with the following SQL statement:
CREATE TABLE items
item no INT,
item name CHAR(5),
item_qty INT)
Which of the following SQL statements will provide the table definition that meets the
specified requirements?
A. DECLARE GLOBAL TEMPORARY TABLE tracker
AS (SELECT item_no, item_name FROM items) WITH NO DATA
ON COMMIT PRESERVE ROWS
ON DISCONNECT DROP TABLE
B. DECLARE GLOBAL TEMPORARY TABLE tracker
AS (SELECT item_no, item_name FROM items) WITH NO DATA
ON COMMIT PRESERVE ROWS
C. CREATE TABLE systmp.tracker
AS (SELECT item_num, item_name FROM items) WITH NO DATA
ON COMMIT PRESERVE ROWS
D. CREATE TABLE tracker
AS (SELECT item_num, item_name FROM items)
ON COMMIT PRESERVE ROWS
ON DISCONNECT DROP TABLE
27.
Which of the following SQL statements will return the year and average salaW for all
employees hired within a given year that have a salaW greater than $30,000?
A. SELECT hyear, AVG(salary)
FROM (SELECT YEAR(datehired) AS hyear, salary
FROM employee) newgrp
HAVING salary > 30000
GROUP BY hyear
B. SELECT hyear, AVG(salary)
FROM (SELECT YEAR(datehired) AS hyear, salary
FROM employee WHERE salary >30000) newgrp
GROUP BY hyear
C. SELECT hyear, AVG(salary)
FROM (SELECT YEAR(datehired) AS hyear, salary
FROM employee WHERE salary >30000) newgrp
GROUP BY YEAR(datehired)
D. SELECT hyear, AVG(salary)
FROM (SELECT YEAR(datehired) AS hyear, salary
FROM employee HAVING salary >30000) newgrp
GROUP BY YEAR(datehired)
28.
Which of the following DB2 tools allows a user to execute an SQL statement and view a
graphical representation of the access plan?
A. Task Center
B. Command Editor
C. Developer Workbench
D. Command Line Processor
29.
Which of the following database objects is considered executable using SQL?
A. View
B. Table
C. Routine
D. Package
30.
Which of the following queries will correctly return the manager information sorted by the
manager's last name, department and project name?
A. SELECT lastname, dept, projname, manager, startdate
FROM (SELECT name, dept, proj AS proj name, manager,
startdate
FROM employee, project
WHERE empno = empno) AS empproj
ORDER BY name, dept, projname
B. SELECT lastname, dept, projname, manager, startdate
FROM (SELECT name AS lastname, dept, proj AS projname,
manager, startdate
FROM employee, project
WHERE empno = mgrno) AS empproj
SORT BY lastname, firstname, dept, projname
C. SELECT lastname, dept, projname, manager, startdate
FROM (SELECT name AS lastname, dept, proj AS projname,
manager, startdate
FROM employee, project
WHERE empno = mgrno) AS empproj
ORDER BY lastname ASC
SORT BY dept, projname DESC
D. SELECT lastname, dept, projname, manager, startdate
FROM (SELECT name AS lastname, dept, proj AS projname,
manager, startdate
FROM employee, project
WHERE empno = mgrno) AS empproj
ORDER BY lastname, dept, projname
31.
Application A holds an Update lock on a single row and application B is trying to read that
row. If both applications are using isolation level UR, which of the following will occur?
A. Application B will read the row.
B. Applications A and B will cause a deadlock situation.
C. Application B will wait until application A releases the Update lock.
D. Application A will be terminated so that application B can read the row.
32.
The following statements:
CREATE TABLE t 1 ( co 11 INT NOT NULL, PR IMARY
KEY(coil) )
CREATE TABLE t2 (coil INT NOT NULL, cci2 CHAR(i) NOT NULL, PRIMARY
KEY (coil, cci2),
FOREIGN KEY (coil) REFERENCES tl (coil)
ON DELETE CASCADE ON UPDATE RESTRICT)
CREATE TABLE t3 (coil INT NOT NULL, cci2 INT NOT NULL, PRIMARY KEY
(coil, cci2) ,
FOREIGN KEY (coil) REFERENCES tl (coil)
ON DELETE NO ACTION ON UPDATE RESTRICT)
INSERT INTO tl VALUES (1), (2)
INSERT INTO t2 VALUES (1, 'a'), (1, 'b'), (2,'c')
INSERT INTO t3 VALUES (1, 100), (2, 200), (2,300)
How many rows will be deleted by the following DELETE statement?
DELETE FROM tl WHERE coll = 1
A4
B3
C1
D0
软件已经成为众所瞩目的焦点。而SAP以其专业的水准、强大的功能以及标准的业务流程成为了业内的一个标准。其产品用户主要集中在全球性的大企业和大型的国内企业。据统计，目前在全球500强的企业中有80%以上均使用了SAP的产品。·SAP认证是被全球公认和赞誉的。持有SAP认证的人员通过严谨的学习来获取SAP的产品知识和技术，他们通过了严格的、面向过程的考试，展现出自己的能力，从而获得业内的认可。
·SAP顾问认证证书是一种证明，它说明持有SAP认证的人已经具备了成功 *** 作SAP系统所必需的知识。
·它可以提高您在企业管理中的地位。
·认证顾问将可以直接访问SAP的service网站，获取更多的资源，用高质量、最新的资讯使客户受益。
·SAP认证是钻石人生的起点。博克教育联合国内大型企业开辟了就业通道，为顺利完成课程学习，符合用工条件的学员提供3~6个月的企业实习，为将来就业开辟通道。这一举措对于没有SAP相关知识和技能，但又希望通过培训获得SAP的产品知识从而成为咨询顾问的人来说，参加SAP顾问学院的课程是一条捷径。
·SAP认证是迈向金领的阶梯。中国SAP认证顾问平均年薪在20至30万人民币，而且呈现持续上涨的态势。其中不乏年薪为50至100万的SAP高级咨询顾问。在欧美，这类专门人才的平均年薪是其它同等学历专门人才的两倍左右。可以预见，在未来10年内SAP人才紧缺状况和SAP人才的高收入状态都不会改变。
·SAP认证顾问有着良好的职业前景和个人发展。认证顾问可以从事项目经理、应用模块咨询顾问(FI,MM,SD,PP,HR…)、技术顾问、讲师、售前顾问和技术支持等SAP相关职位。既可以作为企业内部的实施参谋，又可以在行业中做业务咨询。如果英文好的话，还可以到国外就业发展。更有一些SAP的自由职业咨询人员随着项目在周游各国，体验着别样的人生。可以说加入SAP产业是改变职业和人生的一次机遇。
SAP顾问认证考试，在各个国家都不一样，有些国家不需要参加SAP的培训课程就可以直接参加认证考试，如美国，加拿大，香港，马来西亚．但大部分国家还是要求先接受SAP顾问学院的培训课程，在最后一天的下午考试．基本上考试分120题, 80题和40题，即认证考试，和delta认证考试，Delta认证考试是内容变化部分的升级考试, 通常为40题，就是你已拥有旧的执照，只需考新的版本部分的考试．
认证考试（component）大概分为两种：
第一种称为SAP技术顾问(SAP Technology Consultant) 考试．是包含技术部门，所说的BASIS, Security, BW Technical, 或EP Technical等技术顾问方面的认证考试．另外一种叫development, Functional或solution consultant的认证考试．是企业的业务功能或ERP中各个模块,如MM, PP, SD, FI, CO, CRM, CS, SM, QM等项目的认证考试.
参加考试，如果没有通过，必须在6-8星期后才可以重新考试，不能马上再重考．每次费用大约在500美元左右, 各国不太相同．考试v必须先注册，告诉考试机构你要考哪个认证，因为认证分很多种．在技术方面的认证考试分BASIS, BW, Enterprise Portal,在BASIS技术方面又分三部份:一是数据库, 如ORACLE,SAPDB, DB2,或SQL-Server等,第二是系统方面,分 OS/390,WINDOWS, AS/400 与,UNIX等第三是版本, SAP还分不同的版本, 如3.X, 4.X, 2002, 2003, 与NW04等等.
对BASIS而言,最重要的考试是BASIS技术顾问认证，而SAP NETWEAVER 04是最新的课程与认证．它包括两部份，一是SAP WAS640技术核心与系统整合,另一部份是数据库: 可选择 Oracle 9.2, DB2 8, 与SQL Server 2003等等．
每一种认证都有一个认证ID, 以NETWEAVER 04 for Oracle技术认证考试为例是C_DADM51_04，考试时间是3小时，一共是120题，通过70%,即84个题目就通过了考试．
考试的内容，要求95％以上包含在SAP的培训课程中．课程包含
TADM10,即SAP WAS Implementation and Operation one,
TADM12,即SAP WAS Implementation and Operation two,
TADM51,即SAP WAS DB operatoin for oracle. 这三部分课程是顾问学院的课程，其实也就是ADM100,ADM102,ADM110,ADM106,ADM505.考试内容会在网页上告诉你考哪些东西，哪些是重点和比例，你可以SAP的服务网站service.sap.com/certification下找到．
举例而言:SAP技术认证考试NETWEAVER 2004, SAP 为WAS for Oracle920的考试内容分两部分：
第一部分是BASIS, 第二部分是数据库Oracle, BASIS部分有60题，Oracle部分有40题．你必须两部分都通过(超过70%),才可以拿到认证．
如果考过for Oracle的，想考for DB2的，可以略过前面的80题，而只考DB2数据库部分的40题．
BASIS部分的考试包含哪些内容呢：
第一个包含SAP NetWeaver的基础架构及ESA: 大约10-25题. 问题如SAP最新架构ESA是什么？SAP新的解决方案提供什么？NetWeaver的概览等.
第二部分是WAS的管理:内容占比例较多，大约20-30题,包含如何启动SAP系统，如何配置ABAP,如何设定,如何归档SAP的数据，如何做用户的基本管理，如何做调度,如何应用补丁，如何设v打印机，如何监视一个系统等等，主要内容是着重在ADM100,ADM102课程中．
第三部分是WAS管理二: 包含系统接口管理与设定用户接口集中管理,即CUA还有SAP与微软LDAP的整合还有SSO(SINGLE SIGN ON), 与新的安全管理嶲，这些包含在ADM102与ADM940中，
第三部分是JAVA的管理:这部分是新的NETWEAVER 04的认证,也是ADM200课程,它包含了JAVA的基本观念与管理如何启动和停止JAVA的系统如何安装与建制JAVA系统如何在JAVA系统做使用者管理如何在JAVA系统上打补丁在JAVA系统中如何做TSM(Change Management Control)及如何监控JAVA系统．
第四部分系统的安装即ADM110课程包含如何安装系统计划安装系统安装的过程包含哪些如何升级kernel什么是UNICODE,怎样转换码，即万国码，国标码转换怎样解决安装问题(trouble shooting).
第五部分software logistic,
怎样建立设置TSM,怎样做Client Copy, 什么是ABAP的开发，如何制定开发的流程, 如何将程序变更自开发系统传输至质量保证系统，以至传入生产系统怎样作系统整体的架构如何用新的Solution Manager提供的各项功能去做系统管理．
第六部分：系统的分析和优化(workload analyze) 即BC315．包含如何分析监控系统的性能，如何调整管理内存，内存的参数怎样改， *** 作系统的参数调整，怎样做sizing, 如何去做硬件能力的确认和计划如何计划一个长期系统的成长计划，怎样一分析并找出一些差的SQL语句，如何检查表的buffering,以达到系统优化的目的, 如何设定系统状态监控等?.
以上是BASIS上考试的内容，而在数据库方面要求下面5点：
1. 数据库的概览：Oracle的基架构是什么，如何连接oracle,如何管理，管理工具有哪些．620版本之前SAPDBA，在620版本后是BRtool,或者是BRtool的图形接口．
2. 系统的备份和恢复：备份的策略是什么，用什么工具做，备份到哪里，是备份到磁带还是硬盘，如何调度，如何恢复，怎样作HA和DR．
3. 监控数据库：如何监控数据库，如何确认数据库的效率是最好的，什么时候需要加硬盘，什么时候去做重组等．
4. 表空间的管理和问题解决．
5. Oracle Cache方面的分析．怎样分析一个差的SQL语句，怎样去做搜寻优化，安排统计资料的更新，怎样找出哪些编码是有问题的．
以上是以SAP NetWeaver 04加Oracle为例子，来说明SAP的认证怎样进行，包含哪些东西．
总之要注意, 认证分好多种，在你决定认证前，要确定要考哪一种，确定目标．比如你报SAP Netweaver 04 for Oracle, 你只准备了Oracle 8，但实际上是考Oracle 9, 这有一些内容是不一样的．Netweaver上也包含一些JAVA方面的管理，这在以前的BASIS 4.x, 2000, 2002，2003年都没有这部分．明确了目标，这样才好做准备．
待考试完后约等4-6周，即可知通过与否. 时间视各个国家不同. 所有成绩及结果会送至德国SAP总部教育中心认证. 故许多国家现己可立刻知道自已的成绩, 但仍然需等待4周,才能拿到有雷射封印,SAP教育部长签名的认证证书. 许多在美通过认证考试的顾问也会得到一个名片大小的塑料认证证书,但是一般SAP内部的认证考试,没有ID卡仅有认证证书.
更多参考资料：
欢迎分享，转载请注明来源：内存溢出
微信扫一扫
支付宝扫一扫
评论列表（0条）