CoolInterview.com - World's Largest Collection of Interview Questions
Start Your Own website Now
Sponsored Links

Interview Questions
Our Services

Get 9,000 Interview Questions & Answers in an eBook.


  • 9500+ Pages
  • 9000 Question & Answers
  • All Tech. Categories
  • 14 MB Content

    Get it now !!



    Send your Resume to 6000 Companies


  • Advertisements IBM Certification Exams Interview Questions
    COOLINTERVIEW.COM CERTIFICATIONS INTERVIEW QUESTIONS IBM CERTIFICATION EXAMS INTERVIEW QUESTIONS QUESTIONS LISTING

    IBM Certification Exams Interview Questions & Answers

    Below we have listed all the IBM Certification Exams Interview Questions and answers. Feel free to comment on any IBM Certification Exams Interview Questions or answer by the comment feature available on the page.

    To buy an eBook containing 9000 Interview Questions, with Answers, Click Here.

    Subcategories for IBM Certification Exams Interview Questions - The following are sub categories for which Interview Questions are available under this category. Please select the appropriate sub-category:

    IBM DB2 DBA Certification Exam Interview Questions (12)

    1 2 3 4 5 6 Next

    Sort By :   Latest First  |  Oldest First  |  By Rating

    Question
    Rating
    View Answer
    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
    View Answer
    Which statement correctly changes the next extent size? A. ALTER TABLE customer MODIFY NEXT SIZE 300 B. ALTER TABLE customer MODIFY NEXT EXTENT SIZE 300 C. ALTER TABLE customer MODIFY EXTENT SIZE 300 D. ALTER TABLE customer NEXT SIZE 300
    View Answer
    An iSeries administrator is planning a disaster recovery restore. What is the correct restore sequence to assure that the Linux partition will start? A After completing Restore menu option 21, restore the NWSD followed by the storage spaces. B Restore the system with Restore menu option 21. C Restore the storage spaces followed by the Linux NWSD. D After completing Restore menu option 21, re-create the NWSD from a RTVCFGSRC member.
    View Answer
    Given the following table definition: COUNTRY c1 INTEGER name CHAR(20) Which of the following SQL statements will remove all rows from the table named COUNTRY? A.DELETE FROM country B.DELETE * FROM country C.DELETE FROM TABLE country D.DELETE FROM country WHERE c1 IS NOT NULL
    View Answer
    A Linux on iSeries administrator is setting up the OS/400 programmers with user IDs in the Linux partition. Which of the following describes how to set up these profiles in Linux? A � Change the QRETSVRSEC system value to 2 to enable user security mirroring. B � Set up the Linux NES autoloader with the OS/400 partition as the central server. C � Use the CHGNWSUSRA on the Linux NWSD to enable Linux user profile management from OS/400. D � Create a Linux group profile and individual user profiles for each of the programmers referencing the group profile.
    View Answer
    What are three advantages of fragmentation? A. higher availability B. reduced disk space requirements C. parallel scans are possible with PDQ D. finer granularity of archives and resources
    View Answer
    Given these columns from the DEPARTMENT table: deptno CHAR(3) NOT NULL deptname CHAR(20) NOT NULL mgrno CHAR(6) admrdept CHAR(3) location CHAR(20) NOT NULL Which of the following will select the rows that do not have a value in the MGRNO column? A.SELECT * FROM department WHERE mgrno = � B.SELECT * FROM department WHERE mgrno = NULL C.SELECT * FROM department WHERE mgrno IS NULL D.SELECT * FROM department WHERE mgrno IS UNKNOWN
    View Answer
    Given the following table definitions: CREATE TABLE employee (empid INT NOT NULL PRIMARY KEY, emp_fname CHAR(30), emp_lname CHAR(30) ) CREATE TABLE payroll (empid INTEGER, weeknumber INTEGER, paycheck DECIMAL(6,2), CONSTRAINT fkconst FOREIGN KEY (empid) REFERENCES employee (empid) ON DELETE SET NULL, CONSTRAINT chk1 CHECK (paycheck>0 AND weeknumber BETWEEN 1 and 52)) The appropriate indexes exist to support the tables created with the previous CREATE statements. Which two of the following operations can cause the enforcement of a constraint defined on PAYROLL? A.Update of a row in PAYROLL B.Deletion of a row in PAYROLL C.Deletion of a row in EMPLOYEE D.Addition of a new column to PAYROLL E.Rollback of a row deletion on PAYROLL
    View Answer
    When using the SAN Volume Controller (SVC) as a host for a full 15 module XIV Storage System, how many ports are recommended to be connected to the SVC? A. 8 B. 12 C. 16 D. 24
    View Answer
    Given the following SQL statement: GRANT REFERENCES ON TABLE tab1 TO USER usera Which of the following describes what USERA is allowed to do? A.Create a read?only view using TAB1. B.Alter TAB1 to add a check constraint. C.Define a primary key or unique constraint on TAB1. D.Define a dependent table where TAB1 is the parent.
    View Answer
    Which two solutions, once installed and configured, can be used to move workloads without disruption? (Choose two) A. XIV partitions B. XIV Data Mover (XDM) C. SAN Volume Controller D. XIV Data Migration Function E. Tivoli Storage Productivity Center for Replication V4
    View Answer
    When defining a volume on a thin-provisioned pool on an XIV System, the size of the volume is limited by A. the hard capacity of the volume B. the 2 TB maximum volume size on XIV C. the hard capacity of the storage pool D. the soft capacity of the storage pool
    View Answer
    What is a requirement to connect a V6R1 IBM i host to an XIV Storage System? A. XIV firmware V10.0.8 B. Host Attachment Kit V1.0.1 C. SAN Volume Controller (SVC)V4.2 D. Virtual I/O Server (VIOS) V2.1.1
    View Answer
    Given the SQL statement: ALTER TABLE table1 ADD col2 INT WITH DEFAULT Which of the following is the result of the statement? A.The statement fails because no default value is specified. B.A new column called COL2 is added to TABLE1 which would have a null value if selected. C.A new column called COL2 is added to TABLE1 which would have a value of zero if selected. D.A new column called COL2 is added to TABLE1 which would require the default value to be set before working with the table.
    View Answer
    A customer has ordered a 10 module XIV System. How many interface modules are active in this configuration? A. 3 B. 4 C. 5 D. 6
    View Answer
    An iSeries Linux partition has been created without a physical network card assigned. When signed on to OS/400, users are able to use FTP and Telnet to the Linux partition. However, attempts to establish a terminal connection to Linux from their PCs fail. Which of the following is the most likely cause of the problem? A Datagram forwarding was not enabled in OS/400 TCP/IP. B The Linux configuration did not have proxy ARP enabled. C The Linux Ethernet adapter was not enabled. D The Linux feature code was not ordered.
    View Answer
    Given the following table definition: STAFF id INTEGER name CHAR(20) dept INTEGER job CHAR(20) years INTEGER salary DECIMAL(10,2) comm DECIMAL(10,2) Where the job column contains job types: manager, clerk, and salesperson. Which of the following statements will return the data with all managers together, all clerks together, and all salespeople together in the output? A.SELECT * FROM staff ORDER BY job B.SELECT job, name FROM staff GROUP BY name, job C.SELECT * FROM staff GROUP BY name, job, id, dept, years, salary, comm D.SELECT * FROM staff ORDER BY name, job, id, dept, years, salary, comm
    View Answer
    Certkiller .com has asked for a proposal to combine several computing groups within their company. They have an i810 that is fully utilized, a small HP/UX system with an engineering application, and almost 40 Microsoft Windows servers with very low utilization. They also plan to add a Linux firewall. Which of the following will establish the requirements? A. Use Workload Estimator to establish the requirements for the i5/OS, AIX, Linux, and Windows workloads. B. Use Pilot Predict to model the existing and proposed workloads. Factor in the mutually agreed growth factor. C. Propose an iSeries running LPAR with i5/OS, Linux, AIX, and IXS to handle the combined and proposed workloads. D. Propose a study to review the applications, processing, storage, communications, and other considerations for all existing and proposed systems.
    View Answer
    An iSeries administrator sets: ? *PUBLIC authority *USE on all program libraries. ? *PUBLIC Object Operational authority and *EXECUTE data authority on programs. Which of the following authorities would implement comparable restrictions in a Linux on iSeries implementation? A Public directory access authority to r-x and public authority x on the program files B Public directory access authority to r-x and public authority r-x on the program files C Public directory access authority to x and public authority x on the program files D Public directory access authority to r-x and public authority r on the program files
    View Answer
    Which of the following commands will allow a Linux on iSeries administrator to quickly scan backup tapes for files saved via a tar command on a Linux system? A The Linux command mt B The Linux command cpio C The OS/400 command RST option(*print) D The OS/400 command DSPTAP option(*savrst)
    View Answer

    1 2 3 4 5 6 Next

    A D V E R T I S E M E N T





    User Options
    Sponsored Links


    Copyright ©2003-2014 CoolInterview.com, All Rights Reserved.
    Privacy Policy | Terms and Conditions

    Download Yahoo Messenger | Placement Papers| FREE SMS | ASP .Net Tutorial | Web Hosting | Dedicated Servers | C Interview Questions & Answers

    Testing Articles | Testing Books | Testing Certifications | Testing FAQs | Testing Downloads | Testing Interview Questions | Testing Jobs | Testing Training Institutes


    Cache = 0.015625 Seconds