CoolInterview.com - World's Largest Collection of Interview Questions & Answers, FAQs, queries, sample papers, exam papers, dumps, what, why, how, where, when questions
Our Services
Get 9,000 Interview Questions & Answers in an eBook.




Get it now !!
Send your Resume to 6000 Companies

Search Interview Questions

Question: Where are table spaces (tblspaces) created?

A. in dbspaces
B. in pages
C. in extents
D. in chunks

Answer: A.in dbspaces



Category IBM Certification Exams Interview Questions & Answers - Exam Mode / Learning Mode
Rating (0.5) By 523 users
Added on 7/16/2015
Views 5547
Rate it!
Question: Where are table spaces (tblspaces) created?

A. in dbspaces
B. in pages
C. in extents
D. in chunks

Answer:

A.in dbspaces Source: CoolInterview.com



If you have the better answer, then send it to us. We will display your answer after the approval

Rules to Post Answers in CoolInterview.com:-

  • There should not be any Spelling Mistakes.
  • There should not be any Gramatical Errors.
  • Answers must not contain any bad words.
  • Answers should not be the repeat of same answer, already approved.
  • Answer should be complete in itself.

Post your answer here

Inform me about updated answers to this question.
Related Questions
View Answer
A redistribute command fails during processing of database partition group DPG1. Which
of the following commands will return the database partition group to its original partition map?

A. RESTART DATABASE
B. REDISTRIBUTE DATABASE PARTITION GROUP dpg1 RESET
C. REDISTRIBUTE DATABASE PARTITION GROUP dpg1 ROLLBACK
D. REDISTRIBUTE DATABASE PARTITION GROUP dpg1 USING ORIGINAL TARGETMAP.

View Answer
Which of the following can be kept in memory when the DB2 configuration parameter
KEEPFENCED is enabled?

A. SQLDAS after their cursor is closed. B. Referential integrity maps after a join.
C. Stored procedure processes after they are run.
D. Tables after they have been read into the buffer pool.
View Answer
The DBA can set the registry variable DB2_HASH_JOIN on or off because:
A. hash joins may require more resources to run.
B. hash joins are not used unless outer joins are requested.
C. If hash joins are enabled, no other join method can be used.
D. Hash joins are only needed when the tables are portioned using hash keys.
View Answer
Which two of the following table space attributes can be changes after the table space has been created?

A. Page size
B. Extent size
C. Transfer rate
D. Table space type
E. Table space name
View Answer
Which of the following is required for the DB2 optimizer to consider a hash join strategy?

A. Equijion predicates
B. Optimization level 1 or above
C. Registry variable DB_ANTIJOIN=YES
D. SORTHEAP large enough to contain the tables being joined

View Answer
Given the following DDL statement
CREATE TABLE RMW TABEL46″
11″ INTEGER
D11″ DECIMAL (1′0)NOT NULL
D12″ DECIMAL (1′0) NOT NULL
S7″ SMALLINT
C8″ CHAR(1) WITH DEFAULT)
organize by (
(D12″ ;D11″))
How many indexes will be created?

A. 1
B. 2
C. 3
D. 4

View Answer
A table is defined using DMS table spaces with its index, data, and long data separated into different table spaces. The table space containing the table data is restored from a backup image.
Which of the table's other table spaces must also be restored in order to roll forward to a point in time prior to the end of the logs?

A. Long table space
B. Index table space
C. Temporary table space

D. Index and long table spaces

View Answer
Given the following table definition and SQL statement
CREAT TABLE company
(company_id INTEGER company_name VARCHAR (40) amount_due Decimal (15,2) SELECT company_id
From company
WHERE amount_due =
SELECT MAX (amount_due) FROM company)
Which index definition would provide the best performance for the SQL statement?

A. CREATE INDEX i1 ON company (amount_due ASC)
B. CREATE INDEX i1 ON company (amount_due DESC)
C. CREATE INDEX i1 ON company (company_id,amount_due)
D. CREATE INDEX i1 ON company
(amount_due DESC) INCLUDE(company_id)
View Answer
When creating a regular DMS table space, what is the minimum number of extents that must be specified?

A. 1
B. 3
C. 4
D. 6
E. 8
View Answer
A customer created a hosted Linux partition on a 4-way i820 with iStar processors. The partition was created to utilize one shared processor unit, 1024MB of memory, and no other hardware. It
railed immediately when IPLed. The SRC code indicated that the partition does not have the
proper resources to IPL. What must be done to IPL this partition?

A Assign a dedicated LAN resource to this partition.
B Assign a dedicated CD/DVD device to this partition.
C Assign a dedicated console resource to this partition.
D Assign a dedicated processor to this partition.
View Answer
A customer is planning to create a non-hosted Linux partition on an i825. Linux will have only direct-attach devices. What is the Linux console option?

A Use OS/400 VNC support.
B Telnet to the virtual console.
C Share the primary partitions console.
D Allocate a console IOA to the Linux partition.
View Answer
A new Linux IOA has been added into a system, but it is not reporting into the hyper visor as
viewed through the primary partition display I/O resources screen. Which of the following is the most likely cause of the problem?

A The IOA is incorrectly installed.
B The bus is not allocated to the Linux partition.
C Empty slots on a shared bus are defaulted to unallocated, so it will not report in until the slot
is allocated to a running partition.
D For IOAs to report in, the IOA must first be allocated to the primary partition, then the hyper visor can register them as a resource.
View Answer
A customer is attempting to determine what failed during the last boot sequence of the Linux
partition. Which of the following can be used to determine the error condition?

A /var/log/messages
B /proc/startup
C /usr/sbin/log
D /etc/boot
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
A Linux partition running in a non-hosted environment has only a QIC50GB tape drive. They need
to send a tape of data to a vendor in LTO format to be loaded onto a UNIX system, but the only LTD drive they have is attached to an i5/OS partition. Which of the following will accomplish this goal?

A Create an LTD format tape on the QIC50GC drive and have this tape duped onto a LTO
drive.
B Save the data to disk, FTP it to the iSeries, and use the SAV command to save it to the LTO
drive.
C In the i5/OS partition, change the LTO tape drive device description to shared by changing the Device Model to *VRT.
D Create a NWSD in the i5/OS partition to control the Linux partition. Shut down the Linux partition, vary on the NWSD, and vary off the tape drive.
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
An iSeries installation is using Linux as a firewall between the public Internet and an OS/400
WebSphere server, and as a DMZ between the WebSphere server and the production OS/400

partitions. Which of the following ports and protocols should be allowed through the DMZ so
WebSphere can access the production data with JDBC?

A TOP port 8471
B UDP ports below 1024
C TOP ports between 63900 and 64500
D UDP port 8471 and TCP ports 6390 to 6450
View Answer
On an i810 with V5R3, what is the largest Network Server Storage Space (*NWSSTG) that can
be created?
A 10GB
B 64GB
C 100GB
D 1TB
View Answer
An i825 customer has three processors active. Performance measurements show that 2.5
processors are needed to maintain acceptable iSeries application performance. The addition of a
Linux partition requiring 0.75 of a processor is being planned. Which of the following describes the lowest cost solution to adding a Linux partition for this workload to the iSeries?

A Activate a fourth processor for Linux only and assign the processor to a Linux partition.
B Activate and license a fourth processor for OS/400. Create a guest partition of .75 processor for Linux.
C Activate 0.5 processor and share with the remaining 0.25 of the OS/400 processors in the
Linux partition.
D Assign 0.25 processor to the Linux partition and set QPFRADJ to 3 in OS/400 to dynamically balance the workload.
View Answer
Which of the following commands will format a new disk drive partition in Linux on iSeries?

A mkts -e2 <path to device>
B mkfs.ext2 <path to device>
C mkfs -ext2 &It;path to device >
D mkfs format -e2 <path to device>
View Answer

Please Note: We keep on updating better answers to this site. In case you are looking for Jobs, Pls Click Here Vyoms.com - Best Freshers & Experienced Jobs Website.

View All IBM Certification Exams Interview Questions & Answers - Exam Mode / Learning Mode




India News Network
Latest 20 Questions
Payment of time- barred debt is: (a) Valid (b) Void (c) Illegal (d) Voidable
Consideration is defined in the Indian Contract Act,1872 in: (a) Section 2(f) (b) Section 2(e) (c) Section 2(g) (d) Section 2(d)
Which of the following is not an exception to the rule, "No consideration, No contract": (a) Natural love and affection (b) Compensation for involuntary services (c) Completed gift (d) Agency
Consideration must move at the desire of: (a) The promisor (b) The promisee (c) The promisor or any other party (d) Both the promisor and the promisee
An offer which is open for acceptance over a period of time is: (a) Cross Offer (b) Counter Offer (c) Standing Offer (d) Implied Offer
Specific offer can be communicated to__________ (a) All the parties of contract (b) General public in universe (c) Specific person (d) None of the above
_________ amounts to rejection of the original offer. (a) Cross offer (b) Special offer (c) Standing offer (d) Counter offer
A advertises to sell his old car by advertising in a newspaper. This offer is caleed: (a) General Offer (b) Special Offer (c) Continuing Offer (d) None of the above
In case a counter offer is made, the original offer stands: (a) Rejected (b) Accepted automatically (c) Accepted subject to certain modifications and variations (d) None of the above
In case of unenforceable contract having some technical defect, parties (a) Can sue upon it (b) Cannot sue upon it (c) Should consider it to be illegal (d) None of the above
If entire specified goods is perished before entering into contract of sale, the contract is (a) Valid (b) Void (c) Voidable (d) Cancelled
______________ contracts are also caled contracts with executed consideration. (a) Unilateral (b) Completed (c) Bilateral (d) Executory
A offers B to supply books @ Rs 100 each but B accepts the same with condition of 10% discount. This is a case of (a) Counter Offer (b) Cross Offer (c) Specific Offer (d) General Offer
_____________ is a game of chance. (a) Conditional Contract (b) Contingent Contract (c) Wagering Contract (d) Quasi Contract
There is no binding contract in case of _______ as one's offer cannot be constructed as acceptance (a) Cross Offer (b) Standing Offer (c) Counter Offer (d) Special Offer
An offer is made with an intention to have negotiation from other party. This type of offer is: (a) Invitation to offer (b) Valid offer (c) Voidable (d) None of the above
When an offer is made to the world at large, it is ____________ offer. (a) Counter (b) Special (c) General (d) None of the above
Implied contract even if not in writing or express words is perfectly _______________ if all the conditions are satisfied:- (a) Void (b) Voidable (c) Valid (d) Illegal
A specific offer can be accepted by ___________. (a) Any person (b) Any friend to offeror (c) The person to whom it is made (d) Any friend of offeree
An agreement toput a fire on a person's car is a ______: (a) Legal (b) Voidable (c) Valid (d) Illegal
Cache = 0 Seconds