Archive for the ‘DB2’ Category

000-732 Study Guide,solution courses learning 000-732 certification test papers

Friday, April 23rd, 2010

Download 000-732 free exam, solution courses 000-732 torrent ( training materials ) , Nowexam’s 000-732 study materials or DB2 certified 000-732 real Q&As , When you first started and used the DB2 9 for z/OS Database Administrator certifications 000-732 questions and answers / 000-732 exam simulator,nowexam GUARANTEES that you will pass your 000-732 exams on your first attempt after using nowexam Teaching Materials.Can help you 100% pass rate,guarantee your results.
According to the market needs,nowexam company provide the latest DB2 DB2 9 for z/OS Database Administrator [000-732].nowexam is committed to relevant 000-732 training material (or called 000-732 Exam Topics).
Passing IBM 000-732 exams: Passing DB2 9 for z/OS Database Administrator exam has never been faster or easier, now with actual questions and answers, without the messy braindumps that are frequently incorrect. nowexam Unlimited Access Exams promise pass exams in the first attempt, or will give a full defund.
Nowexam 000-732 practice exams topics and study questions are composed by current and active Information Technology experts, who use their experience in preparing you for your future in IT.Share the latest 000-732 Study Guide and witness 000-732 test papers follows:1.If an object  is created statically by a  role within a  trusted context and  the ROLE AS OBJECT OWNER clause is specified, who becomes the object owner when executing the package?
A.The role
B.The schema name
C.The owner keyword
D.The current SQLID (if set)
Correct:AÂ
2.A company uses TRUSTED CONTEXT “ERP1″ and ROLE “ERP_ROLE” as a security mechanism to limit security exposure for an application. All the DB2 objects (databases, table spaces, tables, indexes, views, plans and packages) have been created by  that ROLE. The ROLE “ERP_ROLE” has  been  assigned  to User  ID  “DBA01″  in  order  to  perform DBA  related  tasks. When  the user “DBA01″ leaves the company, the authorization ID is removed. Which of the following statements are correct? (Select two answers)
A.None of these DB2 objects need to be recreated to re-grant the privileges.
B.The related plans and packages have to be recreated and the privileges re-granted.
C.When removing user “DBA01″ privileges, none of these DB2 objects need to be dropped.
D.Only the related databases,table spaces,tables,indexes and views need to be recreated and the privileges re-granted.
E.To  remove  the  privileges  of  user  “DBA01″  on  these  related  plans  and  packages,  they  have  to  be dropped and as a result all associated privileges are revoked.
Correct:A CÂ
3.A DBA wishes  to audit all access  to  the non-audited  table OWNER.EMPLOYEE. Assuming no audit traces are started, which of the following steps are needed to audit access to this table?
A.-START TRACE AUDIT CLASS (5)
B.-START TRACE AUDIT CLASS (4, 5)
C.-START TRACE AUDIT CLASS (4, 5) and ALTER TABLE OWNER.EMPLOYEE AUDIT ALL
D.-START  TRACE  AUDIT  CLASS  (4,  5)  and  ALTER  TABLE  OWNER.EMPLOYEE  DATA CAPTURE CHANGES
Correct:CÂ
4.A DBA needs  to use  the DSN command processor  to delete DB2 packages  that are no  longer needed. Which of the following choices is correct for the DBA to use?
A.SPUFI or QMF with the DROP statement
B.FREE Package (..)
C.DROP Package (..)
D.DROP PLAN () PKLIST (..)
Correct:B
Share 000-732 pdf Braindumps the latest IBM courses and online DB2 training resources,for pass 000-732 Exam topics provide study guide and informations.when you study 000-732 pdf dumps of IBM publishing,000-732 from DB2 certification and you can easier to pass these certification, get for 000-732 materials identification.for certify nowexam’s Exam topics can pass 000-732 cetification,please you visit these demo DB2 9 for z/OS Database Administrator,when you needs for get 000-732 (DB2 9 for z/OS Database Administrator) identification.nowexam published 000-732 by IBM exam simulation questions,the exact nature to help the candidates to easily pass the exam, and get everyone’s praise.

000-731 Study Guide,solution courses learning 000-731 certification test papers

Friday, April 23rd, 2010

Download 000-731 free exam, solution courses 000-731 torrent ( training materials ) , Nowexam’s 000-731 study materials or DB2 certified 000-731 real Q&As , When you first started and used the DB2 9 DBA for Linux,UNIX and Windows certifications 000-731 questions and answers / 000-731 exam simulator,nowexam GUARANTEES that you will pass your 000-731 exams on your first attempt after using nowexam Teaching Materials.Can help you 100% pass rate,guarantee your results.
According to the market needs,nowexam company provide the latest DB2 DB2 9 DBA for Linux,UNIX and Windows [000-731].nowexam is committed to relevant 000-731 training material (or called 000-731 Exam Topics).
Passing IBM 000-731 exams: Passing DB2 9 DBA for Linux,UNIX and Windows exam has never been faster or easier, now with actual questions and answers, without the messy braindumps that are frequently incorrect. nowexam Unlimited Access Exams promise pass exams in the first attempt, or will give a full defund.
Nowexam 000-731 practice exams topics and study questions are composed by current and active Information Technology experts, who use their experience in preparing you for your future in IT.Share the latest 000-731 Study Guide and witness 000-731 test papers follows:1.A database administrator has HADR enabled and wants to do a LOAD WITH COPY NO option on the primary server. What happens on the standby server?
A.The Load is replicated without problems.
B.The Load will stop with an appropriate error message.
C.The Load will be automatically converted  to NONRECOVERABLE and  the standby database will be marked bad.
D.The  Load will  be  automatically  converted  to COPY YES  if  the  directory  or  device  specified  on  the primary server is accessible for the standby database.
Correct:CÂ
2.A DBA needs to set the DIAGLEVEL configuration parameter to 4 while users are connected to the database. How can  this change be  implemented  in a way that has a minimum  impact  to  the environment?
A.Quiesce the database and update the parameter.
B.Attach to the instance and update the parameter.
C.Connect to the database in a single user mode and update the parameter.
D.Attach to the instance, update the parameter, stop and restart the instance.
Correct:BÂ
3.A transaction that receives a log disk full error (SQL0968C) will fail and be rolled back. In order to prevent the roll back, which of the following should be done?
A.Set BLK_LOG_DSK_FUL to NO
B.Set BLK_LOG_DSK_FUL to YES
C.Decrease space for the active log directory
D.Reduce the LOGPRIMARY, LOGSECOND and LOGFILSIZ
Correct:BÂ
4.Recovering a single table space to a point in time:
A.requires archive log files from the last restorable backup.
B.is not possible, table spaces must be recovered to end of logs.
C.is not possible if the disks for that table space are not recoverable.
D.requires the sysadmin to connect to the target database prior to issuing the command.
Correct:AÂ
5.As part of a high availability takeover strategy using HADR,the LOG INDEX BUILD table attribute for the APPLICANT table is set to OFF. What is the most likely effect of this change?
A.After failover, the APPLICANT table index may be rebuilt.
B.An attempt to create a unique index on the APPLICANT table will fail.
C.Index builds for the APPLICANT table on the primary system will take longer.
D.The LOGINDEXBUILD database configuration parameter overrides the table attribute.
Correct:A
Share 000-731 pdf Braindumps the latest IBM courses and online DB2 training resources,for pass 000-731 Exam topics provide study guide and informations.when you study 000-731 pdf dumps of IBM publishing,000-731 from DB2 certification and you can easier to pass these certification, get for 000-731 materials identification.for certify nowexam’s Exam topics can pass 000-731 cetification,please you visit these demo DB2 9 DBA for Linux,UNIX and Windows,when you needs for get 000-731 (DB2 9 DBA for Linux,UNIX and Windows) identification.nowexam published 000-731 by IBM exam simulation questions,the exact nature to help the candidates to easily pass the exam, and get everyone’s praise.

000-730 Study Guide,solution courses learning 000-730 certification test papers

Friday, April 23rd, 2010

Download 000-730 free exam, solution courses 000-730 torrent ( training materials ) , Nowexam’s 000-730 study materials or DB2 certified 000-730 real Q&As , When you first started and used the DB2 9 Fundamentals certifications 000-730 questions and answers / 000-730 exam simulator,nowexam GUARANTEES that you will pass your 000-730 exams on your first attempt after using nowexam Teaching Materials.Can help you 100% pass rate,guarantee your results.
According to the market needs,nowexam company provide the latest DB2 DB2 9 Fundamentals [000-730].nowexam is committed to relevant 000-730 training material (or called 000-730 Exam Topics).
Passing IBM 000-730 exams: Passing DB2 9 Fundamentals exam has never been faster or easier, now with actual questions and answers, without the messy braindumps that are frequently incorrect. nowexam Unlimited Access Exams promise pass exams in the first attempt, or will give a full defund.
Nowexam 000-730 practice exams topics and study questions are composed by current and active Information Technology experts, who use their experience in preparing you for your future in IT.Share the latest 000-730 Study Guide and witness 000-730 test papers follows:1. A user invoking a user-defined function requires which DB2 privilege?
A. CALL
B. USAGE
C. EXECUTE
D. REFERENCES
Answer: CÂ
2. Which of the following statements is used to prevent user TOM from adding and deleting data in table TAB1?
A. REVOKE ADD, DELETE FROM USER tom ON TABLE tab1
B. REVOKE ADD, DELETE ON TABLE tab1 FROM USER tom
C. REVOKE INSERT, DELETE FROM USER tom ON TABLE tab1
D. REVOKE INSERT, DELETE ON TABLE tab1 FROM USER tom
Answer: DÂ
3. Which of the following privileges permits a user to update the comment on a sequence?
A. CONTROL
B. UPDATE
C. USAGE
D. ALTER
Answer: DÂ
4. Which of the following statements is used to revoke all DML privileges on table EMPLOYEE from user TOM?
A. REVOKE ALL PRIVILEGES FROM USER tom
B. REVOKE ALL ON EMPLOYEE FROM USER tom
C. REVOKE EXECUTE ON EMPLOYEE FROM USER tom
D. REVOKE PRIVILEGES ON EMPLOYEE FROM USER tom
Answer: B
Share 000-730 pdf Braindumps the latest IBM courses and online DB2 training resources,for pass 000-730 Exam topics provide study guide and informations.when you study 000-730 pdf dumps of IBM publishing,000-730 from DB2 certification and you can easier to pass these certification, get for 000-730 materials identification.for certify nowexam’s Exam topics can pass 000-730 cetification,please you visit these demo DB2 9 Fundamentals,when you needs for get 000-730 (DB2 9 Fundamentals) identification.nowexam published 000-730 by IBM exam simulation questions,the exact nature to help the candidates to easily pass the exam, and get everyone’s praise.

000-706 Study Guide,solution courses learning 000-706 certification test papers

Friday, April 23rd, 2010

Download 000-706 free exam, solution courses 000-706 torrent ( training materials ) , Nowexam’s 000-706 study materials or DB2 certified 000-706 real Q&As , When you first started and used the DB2 v8.1 for linux,unix and windows db admin upgrade certifications 000-706 questions and answers / 000-706 exam simulator,nowexam GUARANTEES that you will pass your 000-706 exams on your first attempt after using nowexam Teaching Materials.Can help you 100% pass rate,guarantee your results.
According to the market needs,nowexam company provide the latest DB2 DB2 v8.1 for linux,unix and windows db admin upgrade [000-706].nowexam is committed to relevant 000-706 training material (or called 000-706 Exam Topics).
Passing IBM 000-706 exams: Passing DB2 v8.1 for linux,unix and windows db admin upgrade exam has never been faster or easier, now with actual questions and answers, without the messy braindumps that are frequently incorrect. nowexam Unlimited Access Exams promise pass exams in the first attempt, or will give a full defund.
Nowexam 000-706 practice exams topics and study questions are composed by current and active Information Technology experts, who use their experience in preparing you for your future in IT.Share the latest 000-706 Study Guide and witness 000-706 test papers follows:1.The following command is issued: LOAD FROM staff.ixf OF IXF REPLACE INTO staff What locks are help during the execution of this load?
A.Share lock on table STAFF
B.Exclusive lock on table STAFF
C.Exclusive lock on all table spaces holding components of the STAFF table
D.Exclusive lock only on table space holding data component of the STAFF table
Correct:B
3.When using AUTOCONFIGURE and a workload that is of type OLTP, what should be used for the workload_type parameter?
A.dss
B.mixed
C.simple
D.complex
Correct:CÂ
4.To determine  the state of a  table space and  the  location of all containers  for  that  table space, which of the following commands would be used?
A.LIST TABLESPACES SHOW DETAIL
B.GET SNAPSHOT FOR TABLESPACES ONÂ
C.LIST TABLESPACE CONTAINERS FORÂ
D.GET SNAPSHOT FOR TABLESPACES ON SHOW DETAIL
Correct:BÂ
5.In  a  system  set  up  for  dual  logging,  to  change  the  location  of  the  second  set  of  logs  from c:\logpath2 to d:\seclogpath, which of the following commands should be used?
A.UPDATE DB CFG USING logpath2 d:\seclogpath
B.UPDATE DB CFG USING newlogpath d:\seclogpath
C.UPDATE DB CFG USING mirrorlogpath d:\seclogpath
D.UPDATE DB CFG USING overflowlogpath d:\seclogpath
Correct:CÂ
6.Following an ATTACH, to view the current values and the delayed values for database manager configuration, what command should be issued?
A.GET DATABASE MANAGER CONFIGURATION *
B.GET DATABASE MANAGER CONFIGURATION ALL VALUES
C.GET DATABASE MANAGER CONFIGURATION SHOW DETAIL
D.GET DATABASE MANAGER CONFIGURATION DELAYED VALUES
Correct:CÂ
7.Which of the following Command Line  Processer (CLP) commands will display and make changes to the database manager congfiguration?
A.AUTOCONFIGURE APPLY DBM
B.AUTOCONFIGURE CHANGE DBM ONLY
C.AUTOCONFIGURE APPLY DB AND DBM
D.AUTOCONFIGURE CHANGE DB AND DBM
Correct:C
Share 000-706 pdf Braindumps the latest IBM courses and online DB2 training resources,for pass 000-706 Exam topics provide study guide and informations.when you study 000-706 pdf dumps of IBM publishing,000-706 from DB2 certification and you can easier to pass these certification, get for 000-706 materials identification.for certify nowexam’s Exam topics can pass 000-706 cetification,please you visit these demo DB2 v8.1 for linux,unix and windows db admin upgrade,when you needs for get 000-706 (DB2 v8.1 for linux,unix and windows db admin upgrade) identification.nowexam published 000-706 by IBM exam simulation questions,the exact nature to help the candidates to easily pass the exam, and get everyone’s praise.

000-704 Study Guide,solution courses learning 000-704 certification test papers

Friday, April 23rd, 2010

Download 000-704 free exam, solution courses 000-704 torrent ( training materials ) , Nowexam’s 000-704 study materials or DB2 certified 000-704 real Q&As , When you first started and used the DB2 udb v8.1 advanced db admin for linux,unix+windwos certifications 000-704 questions and answers / 000-704 exam simulator,nowexam GUARANTEES that you will pass your 000-704 exams on your first attempt after using nowexam Teaching Materials.Can help you 100% pass rate,guarantee your results.
According to the market needs,nowexam company provide the latest DB2 DB2 udb v8.1 advanced db admin for linux,unix+windwos [000-704].nowexam is committed to relevant 000-704 training material (or called 000-704 Exam Topics).
Passing IBM 000-704 exams: Passing DB2 udb v8.1 advanced db admin for linux,unix+windwos exam has never been faster or easier, now with actual questions and answers, without the messy braindumps that are frequently incorrect. nowexam Unlimited Access Exams promise pass exams in the first attempt, or will give a full defund.
Nowexam 000-704 practice exams topics and study questions are composed by current and active Information Technology experts, who use their experience in preparing you for your future in IT.Share the latest 000-704 Study Guide and witness 000-704 test papers follows:1.Which of the following database configuration parameters must be set to allow automatic log file shipping within DB2?
A.USEREXIT
B.DB2UEXT2
C.LOGRETAIN
D.MIRRORLOGPATH
Correct:AÂ
2.A remote connection  is being established  from a Windows system  running DB2 Connect  to a DB2  for  z/OS subsystem called DBX1. The  following Node and database directory entries have already been cataloged: Node 1 entry: Node name = DBX1NODE Comment = Protocol = TCPIP Hostname = dbx1.company.com Service name = 2500 Database 1 entry: Database alias = DBX1 Database  name  =  TEST  Node  name  =  DBX1NODE  Database  release  level  =  9.00  Comment  = Directory entry type = Remote Authentication = SERVER Catalog node number = -1 Which of the following commands will catalog the DCS directory entry?
A.CATALOG DCS DATABASE test AS dbx1
B.CATALOG DCS DATABASE dbx1 AS test
C.CATALOG DCS DATABASE dbx1 AT dbx1node
D.CATALOG DCS DATABASE test AT dbx1node
Correct:AÂ
3.Which of the following settings for the DB2MAXFSCRSEARCH registry variable  ensures a complete search for space in the database tables, possibly making inserts slower?
A.1
B.5
C.-1
D.33554
Correct:CÂ
4.Defining a table as VOLATILE indicates which of the following to the DB2 optimizer?
A.The table is frequently dropped and recreated.
B.The number of rows in the table typically varies significantly.
C.The table is the target of SELECT statements from a large number of users.
D.The entire table should be kept in the buffer pool so that DB2 can access it using table scans.
Correct:BÂ
5.Given  the  content  of  the  services  file:  DB2_db2inst1  50500/tcp  DB2_db2inst2  50510/tcp DB2_db2inst3  50511/tcp  DB2_db2inst4  50512/tcp  DB2_db2inst5  50513/tcp  DB2_db2inst6 50514/tcp DB2_db2inst1_END 50505/tcp What must be changed to start eight database partitions on this server?
A.Add DB2_db2inst1_END 50507/tcp
B.Add DB2_db2inst7 50515/tcp DB2_db2inst8 50516/tcp
C.Change DB2_db2inst1_END 50505/tcp to DB2_db2inst1_END 50507/tcp
D.Change DB2_db2inst1_END 50505/tcp to DB2_db2inst8_END 50507/tcp
Correct:C
Share 000-704 pdf Braindumps the latest IBM courses and online DB2 training resources,for pass 000-704 Exam topics provide study guide and informations.when you study 000-704 pdf dumps of IBM publishing,000-704 from DB2 certification and you can easier to pass these certification, get for 000-704 materials identification.for certify nowexam’s Exam topics can pass 000-704 cetification,please you visit these demo DB2 udb v8.1 advanced db admin for linux,unix+windwos,when you needs for get 000-704 (DB2 udb v8.1 advanced db admin for linux,unix+windwos) identification.nowexam published 000-704 by IBM exam simulation questions,the exact nature to help the candidates to easily pass the exam, and get everyone’s praise.