Quiz
Ejemplo_1_1
Questions in this quiz (95)
1If the following command is executed: CREATE DATABASE test What is the page size (in kilobytes) of
the database?- A4
- B8
- C16
- D32
2Given the following DDL statement: CREATE TABLE sales (item CHAR(20)); If a DBA wishes to
increase the size of the ITEM column, which SQL statement needs to be used?- AALTER TABLE sales ADD COLUMN item CHAR(40);
- BALTER TABLE sales ALTER COLUMN item CHAR(40);
- CALTER TABLE sales MODIFY COLUMN item CHAR(40);
- DALTER TABLE sales ALTER COLUMN item SET DATA TYPE CHAR(40);
3Which DB2 object can be used to improve the execution performance of qualified SELECT statements?
- ATrigger
- BSQL Procedure
- CSequence Object
- DMaterialized Query Table
4When is it appropriate to use a sequence?
- AWhen you want to control the order in which triggers are fired.
- BWhen you want to control the order in which stored procedures can be invoked.
- CWhen you want to automatically generate a numeric value that is not tied to any specific column or table.
- DWhen you want to automatically generate a numeric value for each row that is added to a specific table.
55.Which clause should be included in a ALTER TABLE statement to update a table definition with a new
column?- AADD COLUMN
- BALTER COLUMN
- CAPPEND COLUMN
- DRENAME COLUMN
6Which object is a stored procedure defined into?
- ATable
- BSchema
- CPackage
- DDatabase
7Which action needs to be performed in order to complete the definition of an application-period temporal
table?- AA transaction-start-id column must be defined for the table.
- BA history table must be defined and associated with the base table.
- CA BUSINESS_TIME period must be specified in a CREATE or ALTER of the table.
- DA unique index must be created that prevents overlapping of the BUSINESS_TIME period of the table.
8What functionality allows users to perform a UNION operation between a DB2 table and an Oracle
view?- AOracle connect
- BTrusted context
- COracle federation
- DDistributed request
9You have a business need to query DB2 10 and DB2 9 databases and you want to write an application
that can run on most platforms unchanged. Which interface would you use to achieve your goal?- ACLI
- BXML
- CJDBC
- DRUBY
10Which DB2 object is used to provide a logical grouping of other database objects?
- AAlias
- BIndex
- CSchema
- DCollection
11What are two valid objects that can be created in DB2? (Choose two.)
- ATree
- BNode
- CTrigger
- DContexts
- ESequence
12Which type of temporal table can be used to store only time-sensitive data?
- ABitemporal
- BTime-period
- CSystem-period
- DApplication-period
13When an index is created for a table, where is the metadata for that index stored?
- AIn the table definition
- BIn the system catalog.
- CIn the schema that the index resides in.
- DIn the metadata of the table the index was created for.
14Which product is used to customize execution environments for the purpose of controlling system
resources so that one department or service class does not overwhelm the system?- ApureScale
- BWorkload manager
- CData partitioning feature
- DSelf-tuning memory manager
15What type of mechanism is a simple token value that is used to refer to a much bigger large object
(LOB)?- Alocator
- Bpointer
- Caddress
- Dreference
16What type of large object (LOB) is used to store LOB data together with the formatted rows on data
pages, instead of in a separate LOB storage object?- Ainline
- Bbinary
- Cinternal
- Dpartitioned
17What is the purpose of the Query Tuner?
- ATo automatically capture and stop rogue queries.
- BTo provide recommendations and analysis for tuning a single query.
- CTo provide recommendations and analysis for tuning up to 100 queries.
- DTo recommend indexes and to guide DBAs through the process of creating new indexes.
18Which tool allows users to connect to a DB2 database using a wizard?
- AControl Center
- BIBM Data Studio
- CUniversal Connection Expert
- DDB2 Connection Pool Manager
19Which two activities indicate the need for a data warehouse? (Choose two.)
- AConfirm product inventory.
- BMonitor product availability.
- CSummarize sales by region.
- DIdentify patterns for products sold in the last five years.
- EAssociate one or more products with a purchase order.
20What is the primary function of an Online Transaction Processing (OLTP) workload?
- ATo combine data from multiple sources.
- BTo discover hidden relationships in data.
- CTo analyze large amounts of data to find patterns.
- DTo make changes to a small number of records within a single transaction.
21Which isolation level offers the greatest protection of data but provides the least amount of
concurrency?- ARead Stability (RS)
- BCursor Stability (CS)
- CRepeatable Read (RR)
- DUncommitted Read (UR)
22What factor influences lock escalation?
- ATable size
- BBuffer space
- CNumber of locks
- DAvailable real storage
23Which type of lock allows the lock owner and all concurrent applications to read, but not update, the
locked data?- AShare (S)
- BUpdate (U)
- CExclusive (X)
- DIntent Exclusive (IX)
24Application APP_A is performing updates to table TAB1 using the cursor stability (CS) isolation level. If
application APP_B wants to retrieve all rows from table TAB1 without waiting for application APP_A to
finish making updates, what isolation level must application APP_B use?- ARead Stability (RS)
- BRepeatable Read (RR)
- CUncommitted Read (UR)
- DCursor Stability (CS)
25Which statement will prevent concurrent application processes from performing anything other than
read-only operations against a table named TAB1?- ALOCK TABLE tab1 IN READ MODE
- BLOCK TABLE tab1 IN SHARE MODE
- CLOCK TABLE tab1 IN EXCLUSIVE MODE
- DLOCK TABLE tab1 IN READ-ONLY MODE
26When is an INTENT EXCLUSIVE (IX) lock required?
- AWhen a transaction intends to read or change data.
- BWhen a transaction intends to change but not read data.
- CWhen a transaction intends to read but not change data.
- DWhen a transaction intends to change the system catalog.
27What is the act of exchanging one lock an application holds on a resource for a more restrictive lock on
the same resource known as?- ALock escalation
- BLock substitution
- CLock switch/exchange
- DLock conversion/promotion
28What isolation level prevents dirty reads, nonrepeatable reads, and phantoms?
- ARead stability (RS)
- BCursor stability (CS)
- CRepeatable read (RR)
- DUncommitted read (UR)
29Which operation normally does NOT require an exclusive lock?
- ABIND
- BDROP
- CGRANT
- DSELECT
30When a COMMIT statement is executed, what happens?
- AAll locks held on the database are automatically released.
- BData stored in global temporary tables is automatically deleted.
- COpen cursors defined WITH HOLD are closed, but their data is retained.
- DThe current transaction is terminated and a new transaction boundary is started.
31Which command is used to back out a subset of database changes that have been made within a unit
of work?- ACOMMIT
- BROLLBACK
- CCOMMIT TO SAVEPOINT
- DROLLBACK TO SAVEPOINT
32An SQL function designed to convert temperatures from Fahrenheit to Celsius was created as follows:
CREATE FUNCTION conv_temp (IN temp_f FLOAT
RETURNS INTEGER
NO EXTERNALACTION
SPECIFIC convert_ftoc
RETURN INT ((temp_f -32)/1.8)
How can this function be used to convert average temperature (AVG_TEMP) data stored in a table called
CLIMATE_INFO?- ACALL conv_temp(climate_info.avg_temp);
- BCALL convert_ftoc(climate_info.avg_temp);
- CSELECT conv_temp(avg_temp) FROM climate_info;
- DSELECT convert_ftoc(avg_temp) FROM climate_info;
33If a table named MY_TAB contains 100 rows and the following statement is executed:
DELETE FROM (SELECT * FROM my_tab ORDER BY col1 DESC
FETCH FIRST 5 ROWS ONLY) AS tmp;
What will happen?- AThe last 5 rows in the table will be deleted.
- BThe first 5 rows in the table will be deleted.
- CThe statement will fail because a subquery cannot be used with a DELETE statement.
- DThe statement will fail because a table name was not specified with the DELETE statement.
34Given an EMPLOYEES table and a SALES table, a user wants to produce a list of all employees and
their associated revenue, even if no revenue exists. Which SQL statement will produce the desired list?- ASELECT employees.name, sales.revenue FROM employees INNER JOIN sales ON employees.id =
sales.emp_id - BSELECT employees.name, sales.revenue FROM employees INNER JOIN sales ON sales.emp_id =
employees.id - CSELECT employees.name, sales.revenue FROM sales LEFT OUTER JOIN employees ON
employees.id = sales.emp_id - DSELECT employees.name, sales.revenue FROM sales RIGHT OUTER JOIN employees ON
employees.id = sales.emp_id
- ASELECT employees.name, sales.revenue FROM employees INNER JOIN sales ON employees.id =
35Which two operations are allowed in the body of an SQL scalar user-defined function? (Choose two.)
- ACALL statements.
- BExternal file access.
- CUse of a scratch pad.
- DCOMMIT statements.
- ESQL control statements.
36Which command will delete all rows from a table without generating log records?
- ATRIM
- BDROP
- CDELETE
- DTRUNCATE
37Which function can be used to obtain values from XML documents that are to be inserted into one or
more tables?- AXMLTABLE
- BXMLPARSE
- CXMLEXISTS
- DXMLATTRIBUTES
38User USER1 wants to retrieve records from a table named EMPLOYEE that satisfy at least one of the
following criteria:
-The employee's hire date (HIREDATE) is before 1999 and the employee's salary (SALARY) is less than
$40,000.00 a year. -The employee has attended university
Which SQL statement will accomplish this?- ASELECT * FROM employee WHERE (hiredate < '1999-01-01' AND salary < 40000) OR (education ='University')
- BSELECT * FROM employee WHERE (hiredate < '1999-01-01') OR (salary < 40000) OR (education ='University')
- CSELECT * FROM employee WHERE (hiredate < '1999-01-01' OR (salary < 40000 AND (education ='University')
- DSELECT * FROM employee WHERE (hiredate < '1999-01-01' AND salary < 40000 AND (education ='University')
39Which SQL statement will retrieve the employee number (EMPNO), hire date (HIREDATE), and salary
(SALARY) for each employee from a table named EMPLOYEE who was hired before 1998 and earns a
salary of less than $35,000.00 per year?- ASELECT empno, hiredate, salary FROM employee FOR hiredate < '1998-01-01' AND salary < 35000
- BSELECT empno, hiredate, salary FROM employee WHERE hiredate < '1998-01-01' AND salary <
35000 - CSELECT empno, hiredate, salary FROM employee WHERE hiredate < '1998-01-01' OR salary <
35000 - DSELECT empno, hiredate, salary FROM employee FOR hiredate < '1998-01-01' OR salary < 35000
40If the following result set is desired:
Which SQL statement must be executed?
- ASELECT lastname, firstnme, salary, job FROM employee ORDER BY 3 FETCH FIRST 5 ROWS
ONLY - BSELECT lastname, firstnme, salary, job FROM employee ORDER BY 3 DESC FETCH FIRST 5
ROWS ONLY - CSELECT lastname, firstnme, salary, job FROM employee ORDER BY 3 FETCH FIRST 5 ROWS
- DSELECT lastname, firstnme, salary, job FROM employee ORDER BY 3 DESC FETCH FIRST 5
ROWS
- ASELECT lastname, firstnme, salary, job FROM employee ORDER BY 3 FETCH FIRST 5 ROWS
41Which statement about INSERT operations is true?
- AThe INSERT statement is used to insert rows into a table, view, or table function.
- BInserted values must satisfy the conditions of any check constraints defined on the table.
- CIf an INSERT statement omits any column from the inserted row that is defined as NULL or NOT NULL
WITH DEFAULT, the statement will fail. - DIf the underlying table of a view being referenced by an INSERT statement has one or more unique
indexes, each row inserted does not have to conform to the constraints imposed by those indexes.
42Which statement about application-period temporal tables is true?
- AConsists of explicitly-supplied timestamps and a separate associated history table.
- BIs based on explicitly-supplied timestamps that define the time periods during which data is valid.
- CIs useful when one wants to keep both user-based period information and system-based historical
information. - DConsists of a pair of columns with database-manager maintained values that indicate the period when
a row is current.
43Which SQL statement should be used to select the minimum and maximum salaries (SALARY), by job
code (JOB), from a table EMPLOYEE?- ASELECT job, MIN(salary), MAX(salary) FROM employee GROUP BY job;
- BSELECT job, MIN(salary), MAX(salary) FROM employee ORDER BY job;
- CSELECT job, MIN(salary), MAX(salary) FROM employee GROUP BY job, MIN(salary), MAX(salary);
- DSELECT JOB, MIN(salary), MAX(salary) FROM employee ORDER BY job, MIN(salary), MAX(salary);
44In a trusted context environment, if a switch request is made with an authorization ID that is not
allowed on a trusted connection, what state is the connection placed in?- ALocked
- BWaiting
- CPending
- DUnconnected
45If a user has been granted SYSCTRL authority, which activities can they perform?
- ALoad operations
- BBackup/copy table spaces
- CCreate and drop databases
- DMonitor database performance
46What is the purpose of a role?
- ATo define exactly what a specific user can do within a particular database once they have been
authenticated. - BTo group a collection of privileges together so that they can be simultaneously granted to and revoked
from multiple users. - CTo establish a credible relationship between DB2 and an external entity, such as a database
administrator or a middleware server. - DTo group a collection of users together so that they can be simultaneously granted and revoked
specific authorities and privileges.
- ATo define exactly what a specific user can do within a particular database once they have been
47Which SQL statement will give user USER1 the ability to assign a comment to a sequence named
MYSEQ?- AGRANT ALTER ON SEQUENCE myseq TO user1
- BGRANT USAGE ON SEQUENCE myseq TO user1
- CGRANT SELECT ON SEQUENCE myseq TO user1
- DGRANT COMMENT ON SEQUENCE myseq TO user1
48A column mask that is to be used for row and column access control (RCAC) was created with the
DISABLE option specified. What must be done if this mask is to be used to restrict access to data stored
in a table named EMPLOYEE?- AThe column mask must be enabled; the EMPLOYEE table must be altered to activate column access
control. - BThe column mask must be enabled (column access control for the EMPLOYEE table will be activated
automatically). - CThe EMPLOYEE table must be altered to activate column access control (the column mask will be
enabled automatically). - DThe EMPLOYEE table must be altered to activate column access control; row permission must be
granted to everyone who needs to use thecolumn mask.
- AThe column mask must be enabled; the EMPLOYEE table must be altered to activate column access
49User USER1 holds both DBADM and SECADM authority and you want to separate database
administration activities from security administration tasks. What authority must you have in order to
revoke SECADM authority from user USER1 and assign it to someone else?- ADBADM
- BDBCTRL
- CSECADM
- DDBMAINT
50A table named EMPLOYEE was created as follows:
Which action will prevent unauthorized users from accessing SSN data?
- AAssign the SSN column to a restricted role that only authorized users can access.
- BOnly grant ACCESSCTRL authority for the SSN column to users who need to access SSN data.
- CAlter the table definition so that SSN data is stored in a separate schema that only authorized users
can access. - DCreate a view for the EMPLOYEE table that does not contain the SSN column and require
unauthorized users to use the view.
51Which SQL statement will allow user USER1 to create a view on a table named EMPLOYEE?
- AGRANT CREATETAB ON DATABASE TO user1
- BGRANT SELECT ON TABLE employee TO user1
- CGRANT CREATEVIEW ON DATABASE TO user1
- DGRANT REFERENCES ON TABLE employee TO user1
52A new user named USER1 needs to retrieve information from a database named MYDB. What
authority must be granted to user USER1?- ADBCTRL authority
- BSQLADM authority
- CDATAACCESS authority
- DACCESSCTRL authority
53Which privilege is required to invoke a user defined function?
- ACALL
- BUSAGE
- CEXECUTE
- DREFERENCES
54Which statement is true about an index that is used to support a UNIQUE constraint?
- AIt must not contain more than one column.
- BIt cannot be used in a referential constraint.
- CIt must be defined with the UNIQUE attribute.
- DIt must be defined as UNIQUE WHERE NOT NULL.
55Which statement regarding triggers is true?
- AOnly one INSERT, UPDATE, or DELETE trigger can be defined per table.
- BTriggers cannot be modified, they must be dropped and recreated with new definitions.
- CAdding a trigger to a table that already has rows in it will cause triggered actions to be fired.
- DTriggers can only be fired one time per statement irrespective of the number of rows affected.
56A table named STATES was created as follows:
CREATE TABLE states
(state_cd CHAR(2) NOT NULL,
state_desc CHAR(20));
CREATE UNIQUE INDEX indx1 ON states (state_cd);
if the following ALTER statement is executed:
ALTER TABLE states ADD PRIMARY KEY (state_cd);
What will happen?- AAn error will be returned and the operation will fail.
- BA warning will be returned and the unique index INDX1 will become the index for the primary key.
- CThe primary key will be successfully added and the unique index INDX1 will be dropped and recreated
as the primary key index. - DThe primary key will be successfully added, the unique index INDX1 will be dropped, and a new index
will be created for the primary key.
57When an application using a temporary table terminates or disconnects from the database
unexpectedly, what happens to the temporary table and any data stored in it?- AThe data in the table is deleted and the table persists.
- BThe data in the table is deleted and the table is implicitly dropped.
- CThe temporary table is converted to a base table and the data is deleted.
- DThe temporary table is converted to a base table and the data is persistent.
58When a user-defined function (UDF) is created and no schema is specified, what schema is used to
store the UDF?- AThe SYSIBM schema.
- BThe SYSFUN schema.
- CA schema with the name of the UDF.
- DA schema with the userid of the UDF definer.
59Which statement about triggers is true?
- AA trigger is designed to return specific types of values and contains executable code.
- BA trigger is designed to return specific types of values but contains no executable code.
- CA trigger performs actions to capture details about an activity like a join operation against multiple
tables. - DA trigger performs actions in response to an event like an INSERT, UPDATE or DELETE operation on
a table.
60Which two statements are true about foreign key constraints? (Choose two.)
- AThe foreign key constraint columns must be supported by an index.
- BThe foreign key constraint columns must be defined as NOT NULL.
- CThe number and data types of foreign key constraint columns must match the parent key.
- DThe columns of one foreign key constraint cannot be used in another foreign key constraint.
- ETo define a foreign key constraint there must be an associated primary key or unique key in the same
or different table.
61What is the primary purpose of a view?
- ATo enable uniqueness.
- BTo ensure data clustering.
- CTo combine data from multiple tables.
- DTo optimize queries ran against multiple tables.
62By default, a column defined as a TIMESTAMP includes which attributes?
- ANo fractional digits or time zone.
- B6 fractional digits and no time zone.
- C12 fractional digits plus a time zone.
- D12 fractional digits and no time zone.
63Which is NOT a valid reason for creating an index?
- ATo allow queries to run more efficiently.
- BTo enforce constraints such as uniqueness on index keys.
- CTo order the columns of a table in ascending or descending sequence according to values in a row.
- DTo order the rows of a table in ascending or descending sequence according to the values in a column.
64To order the rows of a table in ascending or descending sequence according to the values in a column.
- AUnique constraint
- BPrimary key constraint
- CInformational constraint
- DColumn default constraint
65Which statement is true regarding constraints?
- AA table can only have one unique key constraint.
- BA table can have multiple primary key constraints.
- CInformational constraints tell DB2 what rules the data conforms to, but the rules are not enforced.
- DForeign key constraints are enforced on the values within the rows of a table, or between the rows of
two tables, by a unique index on a foreignkey.
66By default, where is the data stored for a column defined with an XML data type?
- AIn an XML index.
- BIn line with the rest of the data for the table.
- CIn an XML storage object that is separate from the table.
- DIn line with the rest of the data for the table, for XML columns less than 32KB.
67Which statement about BEFORE triggers is FALSE?
- AA BEFORE trigger can be used to perform validation of input data.
- BA BEFORE trigger can be used to automatically generate values for newly inserted rows.
- CA BEFORE trigger is fired for each row in the set of affected rows before the trigger event executes.
- DA BEFORE trigger is fired for each row in the set of affected rows instead of executing the trigger
event.
68What is used in conjunction with a foreign key to define a relationship between two tables?
- APrimary key
- BPartitioning key
- CCheck constraint
- DUnique constraint
69Which case will require a sequence to be dropped and recreated instead of being modified by the
ALTER SEQUENCE statement?- AChange the data type of the sequence.
- BReset the sequence to its starting value.
- CEstablish new minimum or maximum values.
- DChange the increment between future values.
70Given the following statement:
GRANT DELETE ON TABLE sales TO User1 WITH GRANT OPTION;
Which statement is correct?- AUSER1 can only remove the SALES table.
- BUSER1 can only remove records from the SALES table.
- CUSER1 can remove the SALES table and grant the privilege to remove the SALES table to other
users. - DUSER1 can remove records from the SALES table and grant the privilege to remove records from the
SALES table to other users.
71Which method for restricting data access relies on a SQL search condition that describes what set of
rows a user has access to?- AAuthentication
- BAuthorities and privileges
- CLabel-based access control
- DRow and column access control
72Which SQL statement will take the ability to create tables in a table space named MYTBSP away from
user USER1?- AREVOKE USE OF TABLESPACE mytbsp FROM user1
- BREVOKE ALTER ON TABLESPACE mytbsp FROM user1
- CREVOKE UPDATE OF TABLESPACE mytbsp FROM user1
- DREVOKE CREATETAB ON TABLESPACE mytbsp FROM user1
73In a trusted context environment, if a switch request is made with an authorization ID that is not
allowed on a trusted connection, what state is the connection placed in?- ALocked
- BWaiting
- CPending
- DUnconnected
74When is a mask used to limit access to data in a table?
- AWhen mandatory access control (MAC) is used to protect the table.
- BWhen discretionary access control (DAC) is used to protect the table.
- CWhen label-based access control (LBAC) is used to protect the table.
- DWhen row and column access control (RCAC) is used to protect the table.
75What privilege is required to create a view on a table that you are not the owner of?
- AINSERT
- BSELECT
- CCREATE
- DTRIGGER
76After creating several new indexes and executing RUNSTATS, user USER1 wants to re-create a
package that is stored in the database so it will take advantage of the new indexes. Which
authority/privilege must user USER1 be granted in order to re-create the package?- ABIND
- BREBIND
- CBINDADD
- DBIND_REBIND
77Which SQL statement will give a user named USER1 the ability to run an embedded SQL application
named BENEFITS that calls a package named CORPDATA.PKGA?- AGRANT EXECUTE ON APPLICATION benefits TO user1
- BGRANT EXECUTE ON PACKAGE corpdata.pkga TO user1
- CGRANT EXECUTE ON APPLICATION PACKAGE corpdata.pkga TO user1
- DGRANT EXECUTE ON APPLICATION benefits USING PACKAGE corpdata.pkga TO user1
78Which of the following privileges allow a user to update the comment on a sequence?
- AALTER
- BUSAGE
- CUPDATE
- DCOMMENT
79Which statement is valid about the Row and Column Access Control (RCAC) feature?
- AA row mask's access control rule is defined by an SQL CASE expression; a column permission's
access control rule is defined by an SQLsearch condition. - BA row permission's access control rule is defined by an SQL CASE expression; a column mask's
access control rule is defined by an SQLsearch condition. - CA row mask's access control rule is defined by an SQL search condition; a column permission's access
control rule is defined by an SQL CASEexpression. - DA row permission's access control rule is defined by an SQL search condition; a column mask's access
control rule is defined by an SQL CASEexpression.
- AA row mask's access control rule is defined by an SQL CASE expression; a column permission's
80Which type of table should you use if you want to define specific time periods when data is valid?
- AMaterialized query table
- BSystem-period temporal table
- CDeclared global temporary table
- DApplication-period temporal table
81Which SQL statement will create a DB2 object that can be used to store numerical data as Canadian
currency?- ACREATE DISTINCT ALIAS canadian_dollar AS DECIMAL (9,3) WITH COMPARISONS
- BCREATE DISTINCT TYPE canadian_dollar AS DECIMAL (9,3) WITH COMPARISONS
- CCREATE DISTINCT PROCEDURE canadian_dollar AS DECIMAL (9,3) WITH COMPARISONS
- DCREATE DISTINCT FUNCTION canadian_dollar AS DECIMAL (9,3) WITH COMPARISONS
82Which object can be enabled for compression?
- AView
- BBuffer pool
- CStorage group
- DTemporary table
83What is the minimum product required for DB2 connectivity across all platforms?
- ADB2 Personal Edition
- BDB2 Development Edition
- CDB2 Connect Personal Edition
- DDB2 Development Unlimited Edition
84Given the SQL statement: CREATE ALIAS total_sales FOR sales Which statement is valid?
- ASALES can be the name of a schema.
- BSALES can be the name of a package.
- CSALES can be the name of an existing alias.
- DSALES can be the name of a declared global temporary table.
85Which DB2 object limits the user's ability to retrieve data from a table by defining a SQL statement in
the object?- AView
- BIndex
- CTrigger
- DCheck constraint
86A table named EMPLOYEES was created as follows, What will be the results?
- A0
- B1
- C2
- D3
87Which two DB2 objects can a view be derived from? (Choose two.)
- AView
- BIndex
- CTable
- DTrigger
- EProcedure
88Which protocol provides applications the ability to connect to and update multiple DB2 databases
within the same transaction?- AType-1 connect
- BType-2 connect
- CType-3 connect
- DType-4 connect
89Which statement about bitemporal tables is valid?
- ABitemporal tables are system tables and can only be queried by the schema owner.
- BCreating a bitemporal table is similar to creating a regular table except users must specify a system
time period column. - CWhen data in a bitemporal table is updated, a row is added to it's associated history table.
- DQuerying a bitemporal table will produce results for a complete timeline; a view must be created to
obtain results for a specific time period.
90Which object can a buffer pool be assigned to?
- ASchema
- BTable space
- CStorage group
- DStored procedure
91Which DB2 object is associated with PREVIOUS VALUE and NEXT VALUE expressions?
- AView
- BTable
- CSequence
- DIdentity Column
92What needs to be defined in order to track changes made to a system-period temporal table over
time?- AOnce the row-begin, row-end, and transaction-start-id columns are created, all changes are tracked.
- BA history table must be created with identical columns to the base table and a unique index must be
defined on the transaction-start-id column. - CA history table must be created as a clone table of the base table after the row-begin, row-end, and
transaction-start-id columns have beendefined. - DA history table must be created with identical columns to the base table and then the base table altered
with the ADD VERSIONING clause torelate it to the history table.
93Which object is used to cache table and index data as it is read from disk?
- ADatabase
- BBuffer pool
- CTable space
- DPackage cache
94Which statement about large object (LOB) locators is true?
- AA LOB locator is a data type that is used to store LOB data in binary files.
- BA LOB locator is a data type that is used to store LOB data in a database.
- CA LOB locator represents a value for a LOB resource that is stored in a database.
- DA LOB locator represents a value for a LOB resource that is stored in a binary file.
95Which DB2 product is a database cluster solution for non-mainframe platforms and is best suited for
Online Transaction Processing (OLTP) workloads?- ADB2 Connect
- BDB2 pureScale
- CWorkload Manager
- DHigh Availability Disaster Recovery
Information
- Description
- Quiz on Ejemplo_1_1, created by alejandrogarciah on 17/06/2015.
- Author
- alejandrogarciah
- Language
- Español
- Views
- 35
- Rating
- No ratings yet Rate this quiz