首页 IBM Information Management DB2 Academic Associate FormA_2010-05-16

IBM Information Management DB2 Academic Associate FormA_2010-05-16

举报
开通vip

IBM Information Management DB2 Academic Associate FormA_2010-05-16// IBM Information Management DB2 Academic Associate FormA v1 // 1 Relational Data Model item 1.1 options response_type = alphabetic correct _answer = “B” question text{ What are the entities used to model data in the Relational Model? ^^^^A. A colle...

IBM Information Management DB2 Academic Associate FormA_2010-05-16
// IBM Information Management DB2 Academic Associate FormA v1 // 1 Relational Data Model item 1.1 options response_type = alphabetic correct _answer = “B” question text{ What are the entities used to model data in the Relational Model? ^^^^A. A collection of instances of entities. ^^^^B. Relations, attributes and tuples ^^^^C. A collection of instances of record types. ^^^^D. Table, rows and columns} item 1.2 options response_type = alphabetic correct _answer = “B” question text{ Which of the following is true about Relational Databases? ^^^^A. A column can store values of different data types. ^^^^B. A table consists of columns and rows. ^^^^C. Rows in the same table can have a different set of columns. ^^^^D. Rows are also known as fields of the table.} item 1.3 options response_type = alphabetic correct _answer = “D” question text{ A company has a large amount of data to store and wants to be able to do the following with the data: Have a standard interface for accessing the data. Have multiple users with the ability to insert, update and delete data. Make changes to the data without risk of losing data and its consistency. Have the capability to handle huge volumes of data and users. Have tools for data backup, restore and recovery. What data storage method is the most optimal solution for the company? ^^^^A. Text files ^^^^B. Comma delimited data files ^^^^C. Spreadsheets ^^^^D. Database} item 1.4 options response_type = alphabetic correct _answer = “C” question text{ When using a Relational Database, which of the following does not apply? ^^^^A. Accesses data using Data Manipulation Language (DML) such as SQL. ^^^^B. Define your database schema using a Data Definition Language (DDL). ^^^^C. Data is stored in a hierarchical model. ^^^^D. You can use normalization to avoid redundant data in your tables.} item 1.5 --- options response_type = alphabetic correct _answer = “C” question text{ Which of the following is not true about the Information Model? ^^^^A. Abstract management of objects at a conceptual level. ^^^^B. Defines relationships between managed objects. ^^^^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.} item 1.6 --- options response_type = alphabetic correct _answer = “A” question text{ Which Data Model was created with the focus of providing better data independence? ^^^^A. Relational ^^^^B. Hierarchical ^^^^C. Semantic ^^^^D. Network} Item 1.7 options response_type = alphabetic correct _answer = “A” question text{ Which of the following is NOT true about columns? ^^^^A. Each column consists of one or more fields ^^^^B. Each column contains a specific type of information ^^^^C. Columns must be designated a specific data type ^^^^D. Columns are also known as fields} Item 1.8 --- ??? FormB 1.4 options response_type = alphabetic correct _answer = “B” question text{ Which of the following is true about columns? ^^^^A. Each column consists of one or more records ^^^^B. Columns are where the individual pieces of information are stored for each record ^^^^C. Columns must be designated a specific data type ^^^^D. Columns are also known as records} Item 1.9 --- options response_type = alphabetic correct _answer = “D” question text{ You are tasked with designing a model that can be used by the software developer to implement a given application. Which of the following is NOT true about your model? ^^^^A. The model is a low level of abstraction with concrete and detailed design. ^^^^B. The model includes specific implementation and protocol details. ^^^^C. The model should define relationships between the managed objects. ^^^^D. The model being designed is an Information Model.} // 2 DB2 Fundamentals item 2.1 --- options response_type = alphabetic correct_answer = “A” question text{ Using DB2’s CLP , to access a remote database for the first time, it is necessary to: ^^^^A. First catalog the remote system or node, and then catalog the database within the remote node ^^^^B. First register the remote system user in the system catalog, and then setup a SSH communication to the remote node ^^^^C. DB2 cannot use databases in remote systems unless SYSADM authority is granted to the local user ^^^^D. First list all the remote databases with the db2 list database directory command, and then select the remote database from the list} item 2.2 options response_type = alphabetic correct_answer = “C” question text{ Which of the following statements is not true regarding Table Spaces on DB2? ^^^^A. A Table Space is a logical object in between logical table and physical containers ^^^^B. All tables, indexes, and other data are stored in a table space ^^^^C. A Table Space is a logical object required to store data, indexes and tables in temporary memory ^^^^D. A Table Space is always associated to a Buffer Pool} item 2.3 options response_type = alphabetic correct_answer = “B” question text{ Assuming that you are currently connected to TESTDB, which of the following will allow the view of the database settings with details? ^^^^A. db2 get db cfg with detail ^^^^B. db2 get db cfg show detail ^^^^C. db2 get dbm cfg with detail ^^^^D. db2 get dbm cfg show detail} item 2.4 options response_type = alphabetic correct_answer = “D” question text{ Which of the following commands would delete the SAMPLE database? ^^^^A. db2 drop sample ^^^^B. db2 delete database sample ^^^^C. db2 drop sample db ^^^^D. db2 drop database sample} item 2.5 options response_type = alphabetic correct_answer = “B” question text{ What is the purpose of a DB2 Access Plan? ^^^^A. SQL developers can define Access Plans to tell DB2 the best way to retrieve the data from a SQL query ^^^^B. Describes the order of operations to access data necessary to execute a SQL or XQuery statement ^^^^C. To replicate data between a DB2 database and relational databases from other vendors ^^^^D. To visually construct complex DML statements and examine the results of their execution} item 2.6 --- options response_type = alphabetic correct_answer = “A” question text{ How does automatic storage work in DB2? ^^^^A. Automatic storage simplifies storage management by allowing you to specify storage paths where the database manager can place table space data, and where the database manager allocates space for various uses. ^^^^B. Automatic storage is an option which is set when you create a DB2 database. It allows transactions that are written to the database to be automatically committed. ^^^^C. Automatic storage is a function of DB2 that allows tables to be backed up automatically on a set schedule. ^^^^D. Automatic Storage can be used to automatically reorganize the data on the physical media in order to improve performance.} item 2.7 --- options response_type = alphabetic correct_answer = “A” question text{ Which of the following is the lowest cost DB2 product that can be legally installed on a Linux server that has 2 CPUs? ^^^^A. DB2 Express Edition ^^^^B. DB2 Enterprise Server Edition ^^^^C. DB2 Everyplace ^^^^D. DB2 Workgroup Server Edition} item 2.8 --- options response_type = alphabetic correct_answer = “B” question text{ You were assigned the task of importing a large amount of data into a DB2 database. Considering you must have logged information about the rows imported and that you want to perform the load as fast as possible, which of the tools would you be the best choice for the job? ^^^^A. DB2 INSERT ^^^^B. DB2 IMPORT ^^^^C. DB2 LOAD ^^^^D. DB2 CLP} item 2.9 --- options response_type = alphabetic correct_answer = “D” question text{ Which of the following is the lowest cost DB2 product that can be legally installed on a windows server that has 4 CPUs capable of performing row compression? ^^^^A. DB2 Express Edition ^^^^B. DB2 Workgroup Edition ^^^^C. DB2 Express-C Edition ^^^^D. DB2 Enterprise Edition } // 3 pureXML item 3.1 options response_type = alphabetic correct_answer = “C” question text{ Which of the following is true about a well-formed XML document? ^^^^A. Has one or more root nodes ^^^^B. Tags can have at most one attribute ^^^^C. Always has a single document node ^^^^D. End tags are optional} item 3.2 --- options response_type = alphabetic correct_answer = “A” question text{ Which of the following is a well-formed XML document? ^^^^A. Amitabh Patel ^^^^B. Amitabh Patel ^^^^C. Amitabh Patel ^^^^D. Jaya Patel } item 3.3 --- options response_type = alphabetic correct_answer = “D” question text{ What is SQL/XML? ^^^^A. SQL/XML is a communication protocol for DB2 databases ^^^^B. A.SQL/XML is part of the XQuery standard and provides various publishing functions to transform XML data into relational form and vice versa ^^^^C. SQL/XML is a language that provides various publishing functions to transform XML data into relational form and vice versa ^^^^D. SQL/XML is an extension to SQL standard and provides various publishing functions to transform XML data into relational form and vice versa} item 3.4 --- @@??? options response_type = alphabetic correct_answer = “D” question text{ Which of the following is not part of the XQuery FLWOR expression: ^^^^A. FOR clause ^^^^B. LET clause ^^^^C. ORDER BY clause ^^^^D. WITH clause} item 3.5 --- @@??? options response_type = alphabetic correct_answer = “A” question text{ Consider the following XML document: John Smith Fourth Calgary Alberta M1T 2A9 963-289-4136 Consider the following UPDATE expression: update xmlcustomer set info = xmlquery( 'transform copy $new := $i modify ( do insert 777-555-3333 after $new/customerinfo/addr, for $j in $new/customerinfo/addr/phone return do rename $j as "telephone" ) return $new' passing info as "i") where cid = 1000; Which of the following represents the XML document after the TRANSFORM expression has been executed: ^^^^A. John Smith Fourth Calgary Alberta M1T 2A9 777-555-3333 963-289-4136 ^^^^B . John Smith Fourth Calgary Alberta M1T 2A9 777-555-3333 963-289-4136 ^^^^C. John Smith Fourth Calgary Alberta M1T 2A9 777-555-3333 963-289-4136 ^^^^D. John Smith Fourth Calgary Alberta M1T 2A9 777-555-3333 963-289-4136 item 3.6 options response_type = alphabetic correct_answer = “B” question text{ Which of the following is an XML-based language for transforming XML documents? ^^^^A. XHTML ^^^^B. XSLT ^^^^C. HTML ^^^^D. Java} // 4 Transactions on DB2 item 4.1 --- options response_type = alphabetic correct_answer = “B” question text{ Which of the following properties is related to the fact that a committed transaction guarantees that all of the operations are completed and in a roll backed transaction the effect of all operations are reverted? ^^^^A. Consistency ^^^^B. Atomicity ^^^^C. Isolation ^^^^D. Durability} item 4.2 options response_type = alphabetic correct_answer = “A” question text{ Which of the following best define what a transaction is? ^^^^A. A sequence of one or more SQL operations grouped together, also known as a single unit of work ^^^^B. A set of independent operations that can be executed in parallel ^^^^C. A data isolation level that can help prevent deadlocks by allowing reads on previously committed data. ^^^^D. An object of a DB2 database} item 4.3 --- options response_type = alphabetic correct_answer = “A” question text{ Which of the following statements is FALSE about transactions? ^^^^A. Operations inside a transaction are executed in parallel. ^^^^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 Data Concurrency item 5.1 --- options response_type = alphabetic correct_answer = “C” question text{ Application B wants to read a subset of rows from table EMPLOYEE multiple times inside the same transaction. Which isolation level should be used in order to guarantee that every time the same set of rows is returned? ^^^^A. Currently Committed ^^^^B. Read Stability ^^^^C. Repeatable Read ^^^^D. Uncommitted Read} item 5.2 --- options response_type = alphabetic correct_answer = “C” question text{ A Dirty Read occurs when? ^^^^A. A transaction read the same row of data twice and returns different data values with each read ^^^^B. A search based on some criterion returns additional rows after consecutive searches during a transaction ^^^^C. Uncommitted data is returned, but the transaction that originated them was rolled back ^^^^D. Two transactions read and then attempt to update the same data, the second update will overwrite the first update before it is committed} item 5.3 --- options response_type = alphabetic correct_answer = “A” question text{ How can an application modify the isolation level of operations running against a DB2 database? ^^^^A. Isolation level can be changed for a particular SQL statement. ^^^^B. Isolation level can only be changed for the whole user session and all operations in that session will be affected. ^^^^C. Isolation level to be used can be specified when executing the COMMIT operation. ^^^^D. Isolation level is determined at the moment an application connects to the database. To change the isolation level, an application is required to create a new connection specifying the desired level.} // 6 Working with Database Objects item 6.1 --- options response_type = alphabetic correct_answer = “D” question text{ Consider the following scenario. You have 3 tables with the same name (TABLE_1) under 3 different schemas (SYSIBM, DEFAULT and DB2INST1). You are connected to a DB2 database in your Linux server as db2inst1 and issue the following statement: SELECT * FROM table_1 Which table will you be selecting data from: ^^^^A. You get an error because your query is ambiguous, as the table schema is not specified ^^^^B. SYSIBM.table_1 ^^^^C. DEFAULT.table_1 ^^^^D. DB2INST1.table_1} item 6.2 options response_type = alphabetic correct_answer = “C” question text{ Which of the following is NOT a supported type of trigger? ^^^^A. AFTER ^^^^B. BEFORE ^^^^C. DURING ^^^^D. INSTEAD OF} item 6.3 --- options response_type = alphabetic correct_answer = “A” question text{ When attempting to establish a connection to a database residing on your local machine, which command can help you determine why the following message was displayed: SQL1013N The database alias name or database name "SAMPLE" could not be found. SQLSTATE=42705 ^^^^A. list database directory ^^^^B. list admin node directory ^^^^C. list node directory ^^^^D. list dcs directory} item 6.4 options response_type = alphabetic correct_answer = “B” question text{ Which of the following is FALSE about views? ^^^^A. Do not contain real data ^^^^B. Any view can be updated, independent of its definition ^^^^C. When changes are made to data through a view, the data is changed in the underlying table ^^^^D. Can be used interchangeably with tables when retrieving data} item 6.5 options response_type = alphabetic correct_answer = “C” question text{ Given the options below, which of the following statements can add records to a table? ^^^^A. ADDREC ^^^^B. ADDRECORD ^^^^C. INSERT ^^^^D. ADD} item 6.6 options response_type = alphabetic correct_answer = “D” question text{ Consider the following command: CREATE TABLESPACE MYTBSP1 MANAGED BY AUTOMATIC What will the command result in? ^^^^A. Creation of a normal table space called mytbsp1 that is managed automatically ^^^^B. Creation of a user table space called mytbsp1 that is managed automatically. ^^^^C. Creation of a temporary table space called mytbsp1 that is managed automatically. ^^^^D. This command will return an error to the user.} // 7 Database Security in DB2 item 7.1 --- options response_type = alphabetic correct_answer = “A” question text{ What is authorization? ^^^^A. Authorization is a process that checks whether you have sufficient privileges to perform the desired database operation ^^^^B. Authorization is the process where the DBA gathers information to see who will have access to the database ^^^^C. Authorization is the process where the DB2 database checks with Windows security to see if you have access to the DB2 database ^^^^D. Authorization is a process that validates that you are who you claim to be by verifying your user ID and password} item 7.2 options response_type = alphabetic correct_answer = “D” question text{ Which of the following statements grants user John the ability to insert data to table tab1? ^^^^A. GRANT ADD ON TABLE tab1 TO John ^^^^B. GRANT INSERT ON TABLE tab1 TO John ^^^^C. GRANT ADD ON TABLE tab1 TO USER John ^^^^D. GRANT INSERT ON TABLE tab1 TO USER John} item 7.3 --- options response_type = alphabetic correct_answer = “B” question text{ Assume a table which contains the following columns: EMP_ID EMP_NAME PHONE EMAIL SALARY Which of the following is the simplest way to restrict users from viewing SALARY information, while still allowing them to see the other values? ^^^^A. Encrypt the table's data ^^^^B. Create a view that does not contain the SALARY column. Grant access to the view and revoke access from the original table ^^^^C. Revoke SELECT access for the SALARY column from users who should not see SALARY data ^^^^D. Store SALARY data in a separate table and grant SELECT privilege for that table to the appropriate users} item 7.4 options response_type = alphabetic correct_answer = “B” question text{ What is a Trusted Context? ^^^^A. It is a special area in a buffer pool that can be written only by a selected set of users. ^^^^B. It is a DB2 capability that allows applications to change users without breaking the connection to the database. ^^^^C. It is a DB2 capability that allows users t
本文档为【IBM Information Management DB2 Academic Associate FormA_2010-05-16】,请使用软件OFFICE或WPS软件打开。作品中的文字与图均可以修改和编辑, 图片更改请在作品中右键图片并更换,文字修改请直接点击文字进行修改,也可以新增和删除文档中的内容。
该文档来自用户分享,如有侵权行为请发邮件ishare@vip.sina.com联系网站客服,我们会及时删除。
[版权声明] 本站所有资料为用户分享产生,若发现您的权利被侵害,请联系客服邮件isharekefu@iask.cn,我们尽快处理。
本作品所展示的图片、画像、字体、音乐的版权可能需版权方额外授权,请谨慎使用。
网站提供的党政主题相关内容(国旗、国徽、党徽..)目的在于配合国家政策宣传,仅限个人学习分享使用,禁止用于任何广告和商用目的。
下载需要: 免费 已有0 人下载
最新资料
资料动态
专题动态
is_522179
暂无简介~
格式:doc
大小:138KB
软件:Word
页数:33
分类:工学
上传时间:2012-07-16
浏览量:18