REAL QUESTIONS SUBMIT MATERIAL ADVERTISE
Braindumps

Microsoft

Cisco

Citrix

CIW

CompTia

CWNA

Apple

Adobe

HP

Legato

Exin

Filemaker

Brocade

Ericsson

TIA

Veritas

ISEB

SCP

IISFA

ISM

OMG

Apc

Mile2

Foundry

Huawei

McData

Symantec

TeraData

RedHat

Solar Winds

Blue Coat

Riverbed

 

 
 
Click on name of dumper to view the dump
 
Philip
 
 

 

Braindumps of 000-514
UDB V7.1 Family Application Development

Exam Questions, Answers, Braindumps (000-514)

Many thanks to all the dumpers, who submit their dumps on this site. Please submit more dumps. Coz everyone should contribute his share.

QUESTION 1
Given the table called NAME with the following column and data:
lname
----------
Smith
SMITH
SmiTh
smith
Which two of the following SQL statements will return all four rows in upper case?
A. SELECT CAPS(lname) FROM name
B. SELECT UCASE(lname) FROM name
C. SELECT STRUPR(lname) FROM name
D. SELECT TOUPPER(lname) FROM name
E. SELECT TRANSLATE(lname) FROM name
Answer: BE
QUESTION 2
Given the table:
COUNTRY
id name person cities
1 Argentina 1 -------
nd the code:
EXEC SQL DECLARE C1 CURSOR FOR SELECT id,name FROM country;
EXEC SQL OPEN C1;
EXEC SQL FETCH C1 INTO :id, :name;
EXEC SQL FETCH C1 INTO :id, :name;
Which of the following SQLCODE/SQLSTATEs will be contained in the SQLCA after the last fetch?
A. SQLCODE 0, SQLSTATE 00000
B. SQLCODE 100, SQLSTATE 02000
C. SQLCODE -100, SQLSTATE 00100
D. SQLCODE -501, SQLSTATE 24501
E. SQLCODE -1224, SQLSTATE 55032
Answer: B
QUESTION 3
Which two of the following Embedded SQL statements contain host variables?
A. DECLARE C1 CURSOR WITH HOLD FOR S1
B. CONNECT TO sample USER :userid USING :passwd
C. SELECT TABSCHEMA, TABNAME FROM SYSCAT.TABLES WHERE TABNAME=?
D. DECLARE C1 CURSOR FOR SELECT DEPT FROM STAFF WHERE JOB='Mgr'
E. DECLARE C1 CURSOR FOR SELECT * FROM EMPLOYEE WHERE LASTNAME=?
F. SELECT WORKDEPT INTO :wd:wdind FROM EMPLOYEE WHERE LASTNAME = 'SMITH'
Answer: BF
QUESTION 4
Given the following CLI Code:
SQLHANDLE henv,hdbc,hstmt1,hstmt2;
hstmt1=NULL;
hstmt2=NULL;
SQLAllocHandle(SQL_HANDLE_ENV,SQL_NULL_HANDLE,&henv);
SQLAllocHandle(SQL_HANDLE_DBC,henv,hdbc);
SQL_NTS);
SQLAllocHandle(SQL_HANDLE_STMT,hdbc, &hstmt1);
SQLConnect( * hdbc, "SAMPLE", SQL_NTS, "DB2CERT", SQL_NTS, "DB2CERT",
Assuming all of the above calls return SQL_SUCCESS, which of the following return codes would be expected from the following function call made immediately after the above?
SQLExecDirect(hstmt2, "SELECT * FROM SYSIBM.SYSTABLES",SQL_NTS);
A. SQL_ERROR
B. SQL_SUCCESS
C. SQL_INVALID_HANDLE
D. SQL_SUCCESS_WITH_INFO
Answer: C
QUESTION 5
Which two of the following lines of code would only be useful in SQLJ applications?
A.ResultSetMetaData rsmd=rs.getMetaData();
B.DefaultContext ctx=DefaultContext.getDefaultContext();
C.CallableStatement callStmt=con.prepareCall("CALL outcli(?)");
D.ResultSet rs=stmt.execute('SELECT * FROM ORG WHERE deptnumb=?");
E.#sql public iterator WithHoldCurs With (holdability=true) (String EmpNo);
Answer: BE
QUESTION 6
The following commands are issued against a database containing table USERID.ORG:
CREATE ALIAS user1.org FOR sample.org
CREATE TABLE org.sample ( c CHAR(1))
CREATE ALIAS sample.org FOR userid.org
CREATE ALIAS userid.sample FOR sample.org
The user SAMPLE issues the following statement on the command line processor:
SELECT * FROM sample
For which of the following database objects will access be attempted?
A. org.sample
B. sample.org
C. userid.org
D. sample.sample
Answer: D
QUESTION 7
The following commands are issued against a database containing table USERID.ORG:
CREATE ALIAS user1.org FOR userid.org
CREATE TABLE org.sample ( c CHAR(1))
CREATE ALIAS sample.org FOR userid.org
CREATE ALIAS userid.sample FOR sample.org
Which of the following statements will NOT have the same results as this SELECT statement:
SELECT * FROM org
when issued by USER1?
A. SELECT * FROM user1.org
B. SELECT * FROM org.sample
C. SELECT * FROM sample.org
D. SELECT * FROM userid.org
E. SELECT * FROM userid.sample
Answer: B
QUESTION 8
An embedded dynamic SQL application selects data from the CUST.ADD table. User FOO needs to bind the application using default options. User BAR needs to run this application after FOO has performed the bind. Which two of the following statements best describe the privileges/authorizations required for users BAR and FOO?
A. FOO needs BINDADD privilege on database
B. BAR needs EXECUTE privilege on the package
C. Both FOO and BAR need SELECT privilege for CUST.ADD
D. FOO needs BINDADD privilege on database and SELECT privilege for CUST.ADD
E. BAR needs SELECT privilege for CUST.ADD and EXECUTE privilege on the package
Answer: AE
QUESTION 9
User FOO needs to bind an application which uses embedded dynamic SQL using the DYNAMICRULES BIND option. The application selects data from the table CUST.ADD, and the application package already exists in the database. User BAR needs to run this application. Which two of the following statements describe the required privileges?
A. FOO needs BINDADD privilege on database
B. BAR needs EXECUTE privilege on the package
C. Both FOO and BAR need SELECT privilege for CUST.ADD
D. FOO needs BINDADD privilege on database and SELECT privilege for CUST.ADD
E. BAR needs SELECT privilege for CUST.ADD and EXECUTE privilege on the package
Answer: BD
QUESTION 10
Given the table T1, created by:
CREATE TABLE t1
(
id INTEGER GENERATED BY DEFAULT AS IDENTITY,
c1 CHAR(3)
)
The following SQL statements are issued:
INSERT INTO t1 VALUES (2, 'def')
INSERT INTO t1 VALUES (DEFAULT, 'abc')
INSERT INTO t1 VALUES (DEFAULT, 'ghi')
Which of the following rows are returned from the following SELECT? SELECT id FROM t1 ORDER BY id
A. 1 2 2
B. 1 2 3
C. 2 3 4
D. 0 1 2
Answer: A
QUESTION 11
Given the following table (C1 is INTEGER):
T1
C1
--
4321
and the stored procedure definition:
CREATE PROCEDURE proc(OUT o1 INT)
READS SQL DATA LANGUAGE SQL
BEGIN
DECLARE v1,v2,v3 INTEGER;
SELECT c1 FROM t1 ORDER BY c1;
DECLARE cur1 CURSOR FOR
SET o1 = v1;
OPEN cur1;
FETCH cur1 INTO v2;
FETCH cur1 INTO v3;
SET v1 = v2*2+v3;
DECLARE EXIT HANDLER FOR NOT FOUND
SET v2 = v3;
FETCH cur1 INTO v3;
SET v1 = v1 + v2*2+v3;
END LOOP fetch_loop;
fetch_loop:
LOOP
END
If the CALL proc(:hv) statement is embedded in an application, what is the value of :hv after it executes?
A. 24
B. 20
C. 21
D. 25
Answer: C

000-514


 

 

Braindumps Real exam questions and verified answers - 100% passing guarantee - cheap prices.

 

Free brain dumps Braindumps, notes, books for free

 

Braindumps and Exams - Instant download real exam questions - Passing guarantee.

Follow us on FaceBook
Braindumps on Facebook
 
 
 
 
 

CheckPoint

Linux

Novell

DB/2

Network Appliance

EC-Council

Nortel

McAfee

Juniper

ISACA

PMI

Sybase

EMC

HDI

SNIA

ISC

Sair

IBM

Lotus

Exam Express

3COM

BICSI

DeLL

Enterasys

Extreme Networks

Guidance Software

Computer Associates

Network General

SAS Institute

Alcatel Lucent

SeeBeyond

TruSecure

Polycom

Hyperion

Hitachi

Nokia

Fortinet

Vmware

Fujitsu

Tibco

Intel

PostgreSQLCE

BusinessObjects

RESSoftware

BlackBerry

AccessData

ICDL

Isilon

SAP

The Open Group

ACSM

Altiris

Avaya

Cognos

F5

Genesys

SDI

ACI

ASQ

Google

H3C

HIPAA

HRCI

SOA

IIBA

Zend