NonStop Kemel Advanced (Level 2): HP0-760 Exam
HP0-760 Questions & Answers
Exam Code: HP0-760
Exam Name: NonStop Kemel Advanced (Level 2)
Q & A: 162 Q&As
Part: A
1: If a process does a PSEM and the semaphore is not available, what happens?
A.A dispatcher interrupt occurs.
B.The monitor process is invoked.
C.The process is trapped out.
D.The process sets a PCBWAIT bit.
Correct Answers: A
2: System globals (SGs) are primarily used to
A.contain pointers to kernel data structures
B.contain kernel data structures such as memory mapping tables
C.keep data structures for memory management and file system operations
D.allow shared memory
Correct Answers: A
3: Click the Exhibit button to view the GARTH output. (Click the Tile button to view the exhibit
while reading the question.) What is the halt code as an octal number? Put your answer in the
form 0XXXX or %XXXX. Answer: 05100
Correct Answers:
4: A process needs to dynamically allocate, use, and deallocate buffers of different sizes. Which
of the following is the most appropriate data structure?
A.pool
B.PCB entry
C.finder table
D.table
Correct Answers: A
5: How do Enscribe file partitions link?
A.The primary partition points to all secondary partitions.
B.Secondary partitions all point to the primary partition.
C.Primary and secondary partitions all point to each other.
D.The primary partition points to the first secondary partition, which points to the next secondary
partition, and so forth.
Correct Answers: A
6: Which of the following statements is true for SQL programs?
A.SQL programs are invalidated by UPDATE STATISTICS on tables the program access.
B.SQL programs are defined in SQL user catalogs in the PROGRAMS table only.
C.SQL programs contain SQL statements that can be recompiled dynamically at execution time.
D.SQL programs cannot be compiled unless all associated tables are closed.
Correct Answers: C
7: Which FUP ALTER command option is used to change the BROKEN flag in the file label,
allowing a non-audited file to be read?
A.RESETBROKEN
B.CLEARFLAG
C.SETRECOVERY
D.CLEARBROKEN
Correct Answers: A
8: What is the feature that distinguishes the SQL system catalog from other SQL catalogs?
A.The system catalog must be TM/MP protected, whereas other catalogs need not be.
B.The system catalog MUST reside on $SYSTEM.SQL.
C.The system catalog contains an additional table, CATALOGS.
D.The system catalog cannot contain references to user-defined tables.
Correct Answers: C
9: Which SQLCI command lists the contents of all rows in the table TEST?
A.GET * FROM TEST;
B.RETRIEVE * FROM TEST;
C.LIST * FROM TEST;
D.SELECT * FROM TEST;
Correct Answers: D
10: Which type of Enscribe file can contain multiple index levels?
A.relative
B.unstructured
C.entry-sequenced
D.key-sequenced
Correct Answers: D
…go to http://www.lead2pass.com/hp0-760.html to download the lastest full version.
