CoolInterview.com - World's Largest Collection of Interview Questions & Answers, FAQs, queries, sample papers, exam papers, dumps, what, why, how, where, when questions
Interview Success Kit - Get Success in Job Interviews Interview Success Kit - 30,000 Interview Que. & Ans.
Covers 30,000+ Interview Questions asked in actual MNC Interviews - all with model answers.

Sponsored Links

Interview Questions
Our Services

INTERVIEW QUESTIONS CERTIFICATION EXAMS IBM CERTIFICATION EXAMS DETAILS
Question :
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.

Category IBM Certification Exams Interview Questions
Rating (3.3) By 14 users
Added on 7/16/2015
Views 44
Rate it!


Answers:

Source: CoolInterview.com

D.Define a dependent table where TAB1 is the parent.
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.
  • Name :*
    Email Id :*
    Answer :*
    Verification Code Code Image - Please contact webmaster if you have problems seeing this image code Not readable? Load New Code
    Process Verification Enter the above shown code: *
    Inform me about updated answers to this question

    Related Questions
    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
    A stored procedure has been created with the following statement: CREATE PROCEDURE P1(INOUT VAR1 VARCHAR(10))� From the command line processor (CLP), which is the correct way to call this procedure?
    A.Call P1(?)
    B.Call P1(DB2)
    C.Call P1(�DB2′)
    D.Call P1(�DB2″)
    View Answer
    Which of the following is defined on the dependent table to implement a referential constraint?
    A.Primary key
    B.Foreign key
    C.Check constraint
    D.Update trigger
    View Answer
    Given a user defined function, U.UDF1, that takes an input parameter of type INTEGER, and
    USER6 running the following SQL statement: SELECT w.udf1(col6) FROM t.tab1 WHERE col4 =
    �ABC� Which of the following statement(s) would allow USER6 to execute the statement?
    A.GRANT ALL PRIVILEGES ON TABLE t.tab1 TO user6
    B.GRANT SELECT ON TABLE t.tab1 TO user6 GRANT USE ON FUNCTION u.udf1(INT) TO user6
    C.GRANT SELECT ON TABLE t.tab1 TO user6 GRANT REFERENCES ON FUNCTION u.udf1(INT) TO
    user6
    D.GRANT ALL PRIVILEGES ON TABLE t.tab1 TO user6 GRANT EXECUTE ON FUNCTION u.udf1(INT) TO user6
    View Answer
    Assuming the proper privileges, which two of the following would allow access to data in a table T1 using the name A1?
    A.CREATE ALIAS a1 FOR t1
    B.CREATE TABLE a1 LIKE t1
    C.CREATE INDEX a1 ON t1 (col1)
    D.CREATE VIEW a1 AS SELECT * FROM t1
    E.CREATE TRIGGER trig1 AFTER INSERT ON t1 FOR EACH ROW MODE DB2SQL INSERT INTO a1
    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
    What is the minimum privilege required to allow USER1 to access table data?
    A.READ privilege on the table
    B.SELECT privilege on the table
    C.REFERENCES privilege on the table
    D.SELECT privilege WITH GRANT OPTION on the table
    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
    Table T1 has a column C1 char(3) that contains strings in upper and lower case letters. Which
    of the following queries will find all rows where C1 is the string �ABC� in any case?
    A.SELECT * FROM t1 WHERE c1 = �ABC�
    B.SELECT * FROM t1 WHERE UCASE(c1) = �ABC�
    C.SELECT * FROM t1 WHERE IGNORE_CASE(c1 = �ABC�)
    D.SELECT * FROM t1 WHERE c1 = �ABC� WITH OPTION CASE INSENSITIVE
    View Answer
    Which of the following tools can be used to identify inefficient SQL statements without executing them?
    A.QMF
    B.Task Center
    C.Visual Explain
    D.Development Center
    View Answer
    Which of the following actions describes when SQL indexes can be explicitly referenced by name within an SQL statement?
    A.When dropping the index
    B.When altering the index
    C.When selecting on the index
    D.When inserting using the index
    View Answer
    Given the following SQL statements: CREATE TABLE birthday1 (day INT CHECK(day BETWEEN 1 AND 31), month INT CHECK(month BETWEEN 1 AND 6), year INT) CREATE TABLE birthday2 (day INT CHECK(day BETWEEN 1 AND 31), month INT CHECK(month BETWEEN 7 AND
    12), year INT) CREATE VIEW birthdays AS SELECT * FROM birthday1 UNION ALL SELECT * FROM
    birthday2 INSERT INTO birthday1 VALUES( 22,10, 1973) INSERT INTO birthday1 VALUES( 40, 8,
    1980) INSERT INTO birthday1 VALUES( 8, 3, 1990) INSERT INTO birthday1 VALUES( 22, 10, 1973) INSERT INTO birthday1 VALUES( 3, 3, 1960) What will be the result of the following SELECT statement? SELECT COUNT(*) FROM birthdays
    A.0
    B.2
    C.3
    D.5D.5

    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
    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
    An application bound with isolation level Uncommitted Read updates a row. Which of the following is true regarding the locking of this row?
    A.No row lock is acquired when the row is updated.
    B.The row lock is released when the cursor accessing the row is closed.
    C.The row lock is released when the application issues a COMMIT statement.
    D.The row lock is released when the cursor accessing the row is moved to the next row.
    View Answer
    Given that the following statements were executed in order: CREATE TABLE tab1 (c1 CHAR(1))

    INSERT INTO tab1 VALUES (�b�) CREATE VIEW view1 AS SELECT c1 FROM tab1 WHERE c1 =�a�
    INSERT INTO view1 VALUES (�a�) INSERT INTO view1 VALUES (�b�) How many rows would be returned from the following statement? SELECT c1 FROM tab1
    A.0
    B.1
    C.2
    D.3
    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 client application on OS/390 or OS/400 must access a DB2 server on AIX. At a minimum, which
    of the following products is required to provide DRDA Application Server functionality on the DB2
    server for AIX?
    A.DB2 Connect Enterprise Edition
    B.DB2 UDB Workgroup Server Edition
    C.DB2 Connect Enterprise Edition and DB2 UDB Workgroup Server Edition
    D.DB2 Connect Enterprise Edition and DB2 UDB Enterprise Server Edition
    View Answer
    Given the following statements from two embedded SQL programs: Program 1: CREATE TABLE mytab (col1 INT, col2 CHAR(24)) COMMIT Program 2: INSERT INTO mytab VALUES( 20989,�Joe Smith�) COMMIT INSERT INTO mytab VALUES( 21334,�Amy Johnson�) DELETE FROM mytab COMMIT INSERT INTO mytab VALUES( 23430,�Jason French�) ROLLBACK INSERT INTO mytab VALUES( 20993,�Samantha Jones�) COMMIT DELETE FROM mytab WHERE col1=20993
    ROLLBACK Assuming Program 1 ran to completion and then Program 2 ran to completion, which
    of the following records would be returned by the statement: SELECT * FROM mytab?
    A.20989, Joe Smith
    B.21334, Amy Johnson
    C.23430, Jason French
    D.20993, Samantha Jones
    E.No records are returned.
    View Answer
    Given the following two tables: TAB1 TAB2 C1 C2 CX CY ?????? ????? ????? ?????? A 11 A 21 B 12 C 22 C
    13 D 23 The following results are desired: C1 C2 CX CY ?????? ????? ????? ?????? A 11 A 21 B 12 ? ? C 13 C
    22 Which of the following joins will yield the desired results?
    A.SELECT * FROM tab1 INNER JOIN tab2 ON c1=cx B.SELECT * FROM tab2 LEFT OUTER JOIN tab1 ON c1=cx
    C.SELECT * FROM tab2 FULL OUTER JOIN tab1 ON c1=cx
    D.SELECT * FROM tab1 LEFT OUTER JOIN tab2 ON c1=cx
    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

    User Options
    India News Network

    Latest 20 Questions
    Gyan received Rs. 5,000 advance from a customer. He showed this amount as his income, which Accounting Concept is not followed? a) Money Measurement b) Accrual c) Consistency d) Conservatism

    Which is the accounting concept that requires the practice of crediting closing stock in the trading account? a) Cost b) Realization c) Going Concern d) Matching
    The proprietor of a business is treated as a creditor for capital introduced by him, according to:- a) Money Measurement Concept b) Cost Concept c) Entity Concept d) Dual Aspect Concept
    State the losses from which Insurance Claims can be made?
    What is the meaning of Insurance Claims?
    If owner's equity of a business are Rs.90,000 and profits are of Rs. 60,000 for the year calculate total assets of the business:- a) Rs. 1,50,000 b) Rs. 1,20,000 c) Rs. 30,000 d) Rs. 1,70,000
    What is Yield to Maturity in Futures and Options Trading Market?
    What is Yield Curve in Futures and Options Trading Market?
    Who is a Writer in Futures and Options Trading Market?
    What is Wire House in Futures and Options Trading Market?
    What is Warehouse Receipt in Futures and Options Trading Market?
    What is Vertical Spread in Futures and Options Trading Market?
    What is Variable Limit in Futures and Options Trading Market?
    What is Underlying Security in Futures and Options Trading Market?
    What is Underlying Futures Contract in Futures and Options Trading Market?
    What is Uncovered put writing in Futures and Options Trading Market?
    What is Uncovered call writing in Futures and Options Trading Market?
    What is U.S. Treasury Note in Futures and Options Trading Market?
    What is U.S. Treasury Bond in Futures and Options Trading Market?



    Fresher Jobs | Experienced Jobs | Government Jobs | Walkin Jobs | Company Profiles | Interview Questions | Placement Papers | Companies In India | Consultants In India | Colleges In India | Exams In India | Latest Results | Notifications In India | Call Centers In India | Training Institutes In India | Job Communities In India | Courses In India | Jobs by Keyskills | Jobs by Functional Areas

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

    Gate Articles | Gate Books | Gate Colleges | Gate Downloads | Gate Faqs | Gate Jobs | Gate News | Gate Sample Papers | Gate Training Institutes

    MBA Articles | MBA Books | MBA Case Studies | MBA Business Schools | MBA Current Affairs | MBA Downloads | MBA Events | MBA Notifications | MBA FAQs | MBA Jobs
    MBA Job Consultants | MBA News | MBA Results | MBA Courses | MBA Sample Papers | MBA Interview Questions | MBA Training Institutes

    GRE Articles | GRE Books | GRE Colleges | GRE Downloads | GRE Events | GRE FAQs | GRE News | GRE Training Institutes | GRE Sample Papers

    IAS Articles | IAS Books | IAS Current Affairs | IAS Downloads | IAS Events | IAS FAQs | IAS News | IAS Notifications | IAS UPSC Jobs | IAS Previous Question Papers
    IAS Results | IAS Sample Papers | IAS Interview Questions | IAS Training Institutes | IAS Toppers Interview

    SAP Articles | SAP Books | SAP Certifications | SAP Companies | SAP Study Materials | SAP Events | SAP FAQs | SAP Jobs | SAP Job Consultants
    SAP Links | SAP News | SAP Sample Papers | SAP Interview Questions | SAP Training Institutes |




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



    Cache = 0.004883 Seconds