3023new带答案.docx

1、3023new带答案IBM DB2 302_31. Which of the following is true about Table Spaces in DB2?A. A Table Space is a file managed by the operating system where DB2 can store data.B. A Table Space is always associated with a buffer pool.C. A Table Space to store users temporary table data is automatically create

2、d when a database is created.D. A Table Space can be managed by the database (DB2) or by an external application.2. Considering the SQL statement below, which option best describes what ABS is:UPDATE tb1 SET col1 = ABS(col2)A. Stored ProcedureB. Built-in functionC. TriggerD. User Defined Type3. Give

3、n the following two tables: TAB1-COL_1 COL_2- -A 10B 12C 14 TAB2-COL_A COL_B- -A 21C 23D 25Assuming the following results are desired:COL_1 COL_2 COL_A COL_BA 10 A 21B 12 - -C 14 C 23Which of the following joins will produce the desired results?A. SELECT * FROM tab1 INNER JOIN tab2 ON col_1 = col_aB

4、. SELECT * FROM tab1 LEFT OUTER JOIN tab2 ON col_1 = col_aC. SELECT * FROM tab1 RIGHT OUTER JOIN tab2 ON col_1 = col_aD. SELECT * FROM tab1 FULL OUTER JOIN tab2 ON col_1 = col_a4. Which of the following statements is FALSE about transactions?A. Operations inside a transaction are executed in paralle

5、l.B. Only 1 COMMIT statement can be executed inside the same transaction.C. Transactions guarantee atomicity of a group of operations.D. A ROLLBACK or COMMIT statement finalizes a transaction.5. Which of the following is true about the Information Model?A. Allows specification of objects in a detail

6、ed level.B. It can describe objects but not the relationships between them.C. It is a group of descriptions explaining objects of a data model.D. Data models can be used to map an Information Model to a software implementation.6. The authentication method in a DB2 server is defined within:A. The dat

7、abase configuration.B. The systems catalog.C. The DB2 registry.D. The database manager configuration.7. Which of the following options best describes a domain found in the table below?CREATE TABLE EMPLOYEE (ID INTEGER NOT NULL,NAME VARCHAR(30) NOT NULL,EXTENSION INTEGER NOT NULL,MANAGER VARCHAR(30)N

8、OT NULLPRIMARY KEY (ID);TERMINATE;ID NAMEEXTENSION MANAGER1 John S 53412 Y2 Susan P54123 N3 Jennifer L 51234 NA. Manager Domain = (N)B. Name Domain = (Set of all Possible Names)C. Extension Doman = (53412)D. ID Domain = (1, 2, 3)8. Which of the following is true about Relational Databases and the Re

9、lational Data Model?A. A table does not allow duplicates and a relation does.B. A domain is the smallest unit of data.C. A column is the equivalent to a tuple.D. A domain is the set of some possible values for a specific field.9. Which of the following is NOT true about Relational Databases?A. Each

10、column contains a specific type of information.B. Columns are where the individual pieces of information are stored.C. A primary key can be composed of only one attribute.D. Foreign keys are an attribute in one relation whose values match a primary key of another relation.10. Consider table TB1 defi

11、ned as below:CREATE TABLE TB1 ( C1 INTEGER PRIMARY KEY, C2 VARCHAR(10)Considering the following statements are successfully executed in CLP with auto-commit disabled, how many rows are INSERTED in table TB1INSERT INTO TB1 VALUES (1, John)INSERT INTO TB1 VALUES (1, John)COMMITINSERT INTO TB1 VALUES (

12、1, John)ROLLBACKA. 0B. 1C. 2D. 311. When creating a DB2 database, which of the following table spaces is NOT automatically created?A. User table spaceB. User temporary table spaceC. Catalog table spaceD. System temporary table space12. Which of the following events will NOT cause a trigger to be act

13、ivated?A. DELETEB. SELECTC. INSERTD. UPDATE13. Which of the following XML fragment correctly indicates the result of the given statement below?values (XMLELEMENT (name Name, XMLNAMESPACES(DEFAULT htpp:/), XMLATTRIBUTES (MALE as Gender), XMLCONCAT( XMLELEMENT (name FirstName, Amitabh), XMLELEMENT (na

14、me LastName, Patel)A. Amitabh Patel B. MALE Amitabh Patel C. Amitabh Patel D. None of the above14. Given the following table definition:SALES-SALES_DATE DATESALES_PERSON CHAR(20)REGION CHAR(20)SALES INTEGERWhich of the following SQL statements will remove all sales that occurred in 1995?A. DELETE *

15、FROM sales WHERE YEAR(sales_date) = 1995B. DELETE FROM sales WHERE YEAR(sales_date) = 1995C. REMOVE * FROM sales WHERE YEAR(sales_date) = 1995D. REMOVE FROM sales WHERE YEAR(sales_date) = 199515. Which of the following is NOT true?A. Structured Query Language is the standard language for manipulatin

16、g data in a Relational Database Management System.B. Database Management Systems act as an interface used to communicate with databases.C. The Hierarchical data model organizes data in tables with columns and rows.D. DB2 is a Database Management System.16. Which of the following is characteristic di

17、fference between Cursor Stability and Currently Committed?A. Reader blocks ReaderB. Reader blocks WriterC. Writer blocks ReaderD. Writer blocks Writer17. Which of the following is acharacteristicof High Availability?A. It allows compression of data.B. It allows definition of a policy to guarantee qu

18、ality of service to applications.C. It allows replication of data to a standby server that can take over in case of failureD. It allows high performance of a DB2 server by distributing workload across several machines.18. Which Data Model was created with the focus of providing better data independe

19、nce?A. Semi-structuredB. HierarchicalC. RelationalD. Entity-Relationship19. Which of the following privileges permits a user to update the comment associated with a table?A. ALTERB. CONTROLC. CREATEIND. REFERENCES20. Which of the following is NOT a Feature Pack that can add extra functionality to a

20、DB2 server?A. Advanced Access ControlB. Storage OptimizationC. Performance OptimizationD. pureXML21. Consider the following scenario. We have a table, table_1, which has only one column storing an integer value. The following statements are executed successfully in the order shown:CREATE SEQUENCE my

21、_seq START WITH 1 INCREMENT BY 1 CACHE 5INSERT INTO table_1 VALUES (NEXT VALUE FOR my_seq);INSERT INTO table_1 VALUES (NEXT VALUE FOR my_seq);After a db2 terminate and reconnection to the database, the following statement was issued:INSERT INTO table_1 VALUES (NEXT VALUE FOR my_seq);SELECT * FROM ta

22、ble_1What value will be the last value returned by the query?A. 1B. 2C. 3D. 622. If secondary log files are to be allocated until the unit of work commits or storage is exhausted, which type of logging is used?A. Circular loggingB. Archival loggingC. Infinite loggingD. It cannot be done in DB223. Wh

23、en does authentication takes place?A. Just before DB2 executes a SQL statement sent by a client application.B. When the user connects to the database.C. When the user disconnects from a database.D. It is part of DB2 server startup process24. Assuming that you are currently connected to a DB2 databas

24、e, which of the following commands will terminate your connection?A. db2 connect resetB. db2 connect endC. db2 connect killD. db2 connect finalize25. Which of the following options can be used to check the minimum point in time (PIT) for a table space restore?A. LIST TABLESPACES SHOW ALLB. RESTORE D

25、ATABASE SAMPLE TABLESPACE (MYTBSP) FROM /tbspbkpC. RESTORE DATABASE SAMPLE TABLESPACE (MYTBSP) ONLINE FROM /tbspbkp D. GET SNAPSHOT FOR TABLESPACE ON 26. Given the options below, which of the following statements can remove a table from a database?A. REMOVEB. DELETEC. DELD. DROP27. Your company has

26、asked you to create a database to store and organize data about the structure of the company. You want to store branch and employee data as well as data on the products that each employee in your company deals with. In order to reduce redundancy, how many tables should you create? Consider that your

27、 model should be tailored to reduce the possible number of NULL values in the table(s).A. 1B. 2C. 3D. 428. Which of the following statements revoke access to SAMPLE database from user TOM?A. REVOKE CONNECT ON sample FROM USER tomB. REVOKE ACCESS FROM USER tom ON DATABASEC. REVOKE ACCESS FROM USER to

28、m ON sampleD. REVOKE CONNECT ON DATABASE FROM USER tom29. Given the following UPDATE statement:UPDATE employees SET workdept = (SELECT deptno FROM department) WHERE workdept = NULLWhich of the following describes the result if this statement is executed?A. The statement will fail because an UPDATE statement cannot contain a subqueryB. The statement will fail because the WORKDEPT column appears in the SE