Kopieren und bearbeiten

Ejemplo_1_3

Beschreibung

Quiz am Ejemplo_1_3, erstellt von alejandro lopez 8876 am 19/06/2015.
alejandro lopez 8876
Quiz von alejandro lopez 8876, aktualisiert more than 1 year ago Mehr Weniger
Mª Carmen Ruiz Garcia
Erstellt von Mª Carmen Ruiz Garcia vor mehr als 9 Jahre
ismael mesa domi
Kopiert von ismael mesa domi vor mehr als 9 Jahre
renanvkas
Kopiert von renanvkas vor mehr als 9 Jahre
mmorenonf
Kopiert von mmorenonf vor mehr als 9 Jahre
alejandrogarciah
Kopiert von alejandrogarciah vor mehr als 9 Jahre
rosamarozzi
Kopiert von rosamarozzi vor mehr als 9 Jahre
alejandro lopez 8876
Kopiert von alejandro lopez 8876 vor mehr als 9 Jahre
17
0
0

Zusammenfassung der Ressource

Frage 1

Frage
If the following command is executed: CREATE DATABASE test What is the page size (in kilobytes) of the database?
Antworten
  • 4
  • 8
  • 16
  • 32

Frage 2

Frage
Given 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?
Antworten
  • ALTER TABLE sales ADD COLUMN item CHAR(40);
  • ALTER TABLE sales ALTER COLUMN item CHAR(40);
  • ALTER TABLE sales MODIFY COLUMN item CHAR(40);
  • ALTER TABLE sales ALTER COLUMN item SET DATA TYPE CHAR(40);

Frage 3

Frage
Which DB2 object can be used to improve the execution performance of qualified SELECT statements?
Antworten
  • Trigger
  • SQL Procedure
  • Sequence Object
  • Materialized Query Table

Frage 4

Frage
When is it appropriate to use a sequence?
Antworten
  • When you want to control the order in which triggers are fired.
  • When you want to control the order in which stored procedures can be invoked.
  • When you want to automatically generate a numeric value that is not tied to any specific column or table.
  • When you want to automatically generate a numeric value for each row that is added to a specific table.

Frage 5

Frage
5.Which clause should be included in a ALTER TABLE statement to update a table definition with a new column?
Antworten
  • ADD COLUMN
  • ALTER COLUMN
  • APPEND COLUMN
  • RENAME COLUMN

Frage 6

Frage
Which object is a stored procedure defined into?
Antworten
  • Table
  • Schema
  • Package
  • Database

Frage 7

Frage
Which action needs to be performed in order to complete the definition of an application-period temporal table?
Antworten
  • A transaction-start-id column must be defined for the table.
  • A history table must be defined and associated with the base table.
  • A BUSINESS_TIME period must be specified in a CREATE or ALTER of the table.
  • A unique index must be created that prevents overlapping of the BUSINESS_TIME period of the table.

Frage 8

Frage
What functionality allows users to perform a UNION operation between a DB2 table and an Oracle view?
Antworten
  • Oracle connect
  • Trusted context
  • Oracle federation
  • Distributed request

Frage 9

Frage
You 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?
Antworten
  • CLI
  • XML
  • JDBC
  • RUBY

Frage 10

Frage
Which DB2 object is used to provide a logical grouping of other database objects?
Antworten
  • Alias
  • Index
  • Schema
  • Collection

Frage 11

Frage
What are two valid objects that can be created in DB2? (Choose two.)
Antworten
  • Tree
  • Node
  • Trigger
  • Contexts
  • Sequence

Frage 12

Frage
Which type of temporal table can be used to store only time-sensitive data?
Antworten
  • Bitemporal
  • Time-period
  • System-period
  • Application-period

Frage 13

Frage
When an index is created for a table, where is the metadata for that index stored?
Antworten
  • In the table definition
  • In the system catalog.
  • In the schema that the index resides in.
  • In the metadata of the table the index was created for.

Frage 14

Frage
Which 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?
Antworten
  • pureScale
  • Workload manager
  • Data partitioning feature
  • Self-tuning memory manager

Frage 15

Frage
What type of mechanism is a simple token value that is used to refer to a much bigger large object (LOB)?
Antworten
  • locator
  • pointer
  • address
  • reference

Frage 16

Frage
What 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?
Antworten
  • inline
  • binary
  • internal
  • partitioned

Frage 17

Frage
What is the purpose of the Query Tuner?
Antworten
  • To automatically capture and stop rogue queries.
  • To provide recommendations and analysis for tuning a single query.
  • To provide recommendations and analysis for tuning up to 100 queries.
  • To recommend indexes and to guide DBAs through the process of creating new indexes.

Frage 18

Frage
Which tool allows users to connect to a DB2 database using a wizard?
Antworten
  • Control Center
  • IBM Data Studio
  • Universal Connection Expert
  • DB2 Connection Pool Manager

Frage 19

Frage
Which two activities indicate the need for a data warehouse? (Choose two.)
Antworten
  • Confirm product inventory.
  • Monitor product availability.
  • Summarize sales by region.
  • Identify patterns for products sold in the last five years.
  • Associate one or more products with a purchase order.

Frage 20

Frage
What is the primary function of an Online Transaction Processing (OLTP) workload?
Antworten
  • To combine data from multiple sources.
  • To discover hidden relationships in data.
  • To analyze large amounts of data to find patterns.
  • To make changes to a small number of records within a single transaction.

Frage 21

Frage
Which isolation level offers the greatest protection of data but provides the least amount of concurrency?
Antworten
  • Read Stability (RS)
  • Cursor Stability (CS)
  • Repeatable Read (RR)
  • Uncommitted Read (UR)

Frage 22

Frage
What factor influences lock escalation?
Antworten
  • Table size
  • Buffer space
  • Number of locks
  • Available real storage

Frage 23

Frage
Which type of lock allows the lock owner and all concurrent applications to read, but not update, the locked data?
Antworten
  • Share (S)
  • Update (U)
  • Exclusive (X)
  • Intent Exclusive (IX)

Frage 24

Frage
Application 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?
Antworten
  • Read Stability (RS)
  • Repeatable Read (RR)
  • Uncommitted Read (UR)
  • Cursor Stability (CS)

Frage 25

Frage
Which statement will prevent concurrent application processes from performing anything other than read-only operations against a table named TAB1?
Antworten
  • LOCK TABLE tab1 IN READ MODE
  • LOCK TABLE tab1 IN SHARE MODE
  • LOCK TABLE tab1 IN EXCLUSIVE MODE
  • LOCK TABLE tab1 IN READ-ONLY MODE

Frage 26

Frage
When is an INTENT EXCLUSIVE (IX) lock required?
Antworten
  • When a transaction intends to read or change data.
  • When a transaction intends to change but not read data.
  • When a transaction intends to read but not change data.
  • When a transaction intends to change the system catalog.

Frage 27

Frage
What is the act of exchanging one lock an application holds on a resource for a more restrictive lock on the same resource known as?
Antworten
  • Lock escalation
  • Lock substitution
  • Lock switch/exchange
  • Lock conversion/promotion

Frage 28

Frage
What isolation level prevents dirty reads, nonrepeatable reads, and phantoms?
Antworten
  • Read stability (RS)
  • Cursor stability (CS)
  • Repeatable read (RR)
  • Uncommitted read (UR)

Frage 29

Frage
Which operation normally does NOT require an exclusive lock?
Antworten
  • BIND
  • DROP
  • GRANT
  • SELECT

Frage 30

Frage
When a COMMIT statement is executed, what happens?
Antworten
  • All locks held on the database are automatically released.
  • Data stored in global temporary tables is automatically deleted.
  • Open cursors defined WITH HOLD are closed, but their data is retained.
  • The current transaction is terminated and a new transaction boundary is started.

Frage 31

Frage
Which command is used to back out a subset of database changes that have been made within a unit of work?
Antworten
  • COMMIT
  • ROLLBACK
  • COMMIT TO SAVEPOINT
  • ROLLBACK TO SAVEPOINT

Frage 32

Frage
An 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?
Antworten
  • CALL conv_temp(climate_info.avg_temp);
  • CALL convert_ftoc(climate_info.avg_temp);
  • SELECT conv_temp(avg_temp) FROM climate_info;
  • SELECT convert_ftoc(avg_temp) FROM climate_info;

Frage 33

Frage
If 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?
Antworten
  • The last 5 rows in the table will be deleted.
  • The first 5 rows in the table will be deleted.
  • The statement will fail because a subquery cannot be used with a DELETE statement.
  • The statement will fail because a table name was not specified with the DELETE statement.

Frage 34

Frage
Given 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?
Antworten
  • SELECT employees.name, sales.revenue FROM employees INNER JOIN sales ON employees.id = sales.emp_id
  • SELECT employees.name, sales.revenue FROM employees INNER JOIN sales ON sales.emp_id = employees.id
  • SELECT employees.name, sales.revenue FROM sales LEFT OUTER JOIN employees ON employees.id = sales.emp_id
  • SELECT employees.name, sales.revenue FROM sales RIGHT OUTER JOIN employees ON employees.id = sales.emp_id

Frage 35

Frage
Which two operations are allowed in the body of an SQL scalar user-defined function? (Choose two.)
Antworten
  • CALL statements.
  • External file access.
  • Use of a scratch pad.
  • COMMIT statements.
  • SQL control statements.

Frage 36

Frage
Which command will delete all rows from a table without generating log records?
Antworten
  • TRIM
  • DROP
  • DELETE
  • TRUNCATE

Frage 37

Frage
Which function can be used to obtain values from XML documents that are to be inserted into one or more tables?
Antworten
  • XMLTABLE
  • XMLPARSE
  • XMLEXISTS
  • XMLATTRIBUTES

Frage 38

Frage
User 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?
Antworten
  • SELECT * FROM employee WHERE (hiredate < '1999-01-01' AND salary < 40000) OR (education ='University')
  • SELECT * FROM employee WHERE (hiredate < '1999-01-01') OR (salary < 40000) OR (education ='University')
  • SELECT * FROM employee WHERE (hiredate < '1999-01-01' OR (salary < 40000 AND (education ='University')
  • SELECT * FROM employee WHERE (hiredate < '1999-01-01' AND salary < 40000 AND (education ='University')

Frage 39

Frage
Which 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?
Antworten
  • SELECT empno, hiredate, salary FROM employee FOR hiredate < '1998-01-01' AND salary < 35000
  • SELECT empno, hiredate, salary FROM employee WHERE hiredate < '1998-01-01' AND salary < 35000
  • SELECT empno, hiredate, salary FROM employee WHERE hiredate < '1998-01-01' OR salary < 35000
  • SELECT empno, hiredate, salary FROM employee FOR hiredate < '1998-01-01' OR salary < 35000

Frage 40

Frage
If the following result set is desired: Which SQL statement must be executed?
Image:
5da97b86-353a-4b95-9bf5-61d00557bd00.PNG (image/PNG)
Antworten
  • SELECT lastname, firstnme, salary, job FROM employee ORDER BY 3 FETCH FIRST 5 ROWS ONLY
  • SELECT lastname, firstnme, salary, job FROM employee ORDER BY 3 DESC FETCH FIRST 5 ROWS ONLY
  • SELECT lastname, firstnme, salary, job FROM employee ORDER BY 3 FETCH FIRST 5 ROWS
  • SELECT lastname, firstnme, salary, job FROM employee ORDER BY 3 DESC FETCH FIRST 5 ROWS

Frage 41

Frage
Which statement about INSERT operations is true?
Antworten
  • The INSERT statement is used to insert rows into a table, view, or table function.
  • Inserted values must satisfy the conditions of any check constraints defined on the table.
  • If an INSERT statement omits any column from the inserted row that is defined as NULL or NOT NULL WITH DEFAULT, the statement will fail.
  • If 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.

Frage 42

Frage
Which statement about application-period temporal tables is true?
Antworten
  • Consists of explicitly-supplied timestamps and a separate associated history table.
  • Is based on explicitly-supplied timestamps that define the time periods during which data is valid.
  • Is useful when one wants to keep both user-based period information and system-based historical information.
  • Consists of a pair of columns with database-manager maintained values that indicate the period when a row is current.

Frage 43

Frage
Which SQL statement should be used to select the minimum and maximum salaries (SALARY), by job code (JOB), from a table EMPLOYEE?
Antworten
  • SELECT job, MIN(salary), MAX(salary) FROM employee GROUP BY job;
  • SELECT job, MIN(salary), MAX(salary) FROM employee ORDER BY job;
  • SELECT job, MIN(salary), MAX(salary) FROM employee GROUP BY job, MIN(salary), MAX(salary);
  • SELECT JOB, MIN(salary), MAX(salary) FROM employee ORDER BY job, MIN(salary), MAX(salary);

Frage 44

Frage
In 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?
Antworten
  • Locked
  • Waiting
  • Pending
  • Unconnected

Frage 45

Frage
If a user has been granted SYSCTRL authority, which activities can they perform?
Antworten
  • Load operations
  • Backup/copy table spaces
  • Create and drop databases
  • Monitor database performance

Frage 46

Frage
What is the purpose of a role?
Antworten
  • To define exactly what a specific user can do within a particular database once they have been authenticated.
  • To group a collection of privileges together so that they can be simultaneously granted to and revoked from multiple users.
  • To establish a credible relationship between DB2 and an external entity, such as a database administrator or a middleware server.
  • To group a collection of users together so that they can be simultaneously granted and revoked specific authorities and privileges.

Frage 47

Frage
Which SQL statement will give user USER1 the ability to assign a comment to a sequence named MYSEQ?
Antworten
  • GRANT ALTER ON SEQUENCE myseq TO user1
  • GRANT USAGE ON SEQUENCE myseq TO user1
  • GRANT SELECT ON SEQUENCE myseq TO user1
  • GRANT COMMENT ON SEQUENCE myseq TO user1

Frage 48

Frage
A 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?
Antworten
  • The column mask must be enabled; the EMPLOYEE table must be altered to activate column access control.
  • The column mask must be enabled (column access control for the EMPLOYEE table will be activated automatically).
  • The EMPLOYEE table must be altered to activate column access control (the column mask will be enabled automatically).
  • The EMPLOYEE table must be altered to activate column access control; row permission must be granted to everyone who needs to use thecolumn mask.

Frage 49

Frage
User 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?
Antworten
  • DBADM
  • DBCTRL
  • SECADM
  • DBMAINT

Frage 50

Frage
A table named EMPLOYEE was created as follows: Which action will prevent unauthorized users from accessing SSN data?
Image:
95a6f1b1-306d-427c-8c24-268b432e6917.PNG (image/PNG)
Antworten
  • Assign the SSN column to a restricted role that only authorized users can access.
  • Only grant ACCESSCTRL authority for the SSN column to users who need to access SSN data.
  • Alter the table definition so that SSN data is stored in a separate schema that only authorized users can access.
  • Create a view for the EMPLOYEE table that does not contain the SSN column and require unauthorized users to use the view.

Frage 51

Frage
Which SQL statement will allow user USER1 to create a view on a table named EMPLOYEE?
Antworten
  • GRANT CREATETAB ON DATABASE TO user1
  • GRANT SELECT ON TABLE employee TO user1
  • GRANT CREATEVIEW ON DATABASE TO user1
  • GRANT REFERENCES ON TABLE employee TO user1

Frage 52

Frage
A new user named USER1 needs to retrieve information from a database named MYDB. What authority must be granted to user USER1?
Antworten
  • DBCTRL authority
  • SQLADM authority
  • DATAACCESS authority
  • ACCESSCTRL authority

Frage 53

Frage
Which privilege is required to invoke a user defined function?
Antworten
  • CALL
  • USAGE
  • EXECUTE
  • REFERENCES

Frage 54

Frage
Which statement is true about an index that is used to support a UNIQUE constraint?
Antworten
  • It must not contain more than one column.
  • It cannot be used in a referential constraint.
  • It must be defined with the UNIQUE attribute.
  • It must be defined as UNIQUE WHERE NOT NULL.

Frage 55

Frage
Which statement regarding triggers is true?
Antworten
  • Only one INSERT, UPDATE, or DELETE trigger can be defined per table.
  • Triggers cannot be modified, they must be dropped and recreated with new definitions.
  • Adding a trigger to a table that already has rows in it will cause triggered actions to be fired.
  • Triggers can only be fired one time per statement irrespective of the number of rows affected.

Frage 56

Frage
A 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?
Antworten
  • An error will be returned and the operation will fail.
  • A warning will be returned and the unique index INDX1 will become the index for the primary key.
  • The primary key will be successfully added and the unique index INDX1 will be dropped and recreated as the primary key index.
  • The primary key will be successfully added, the unique index INDX1 will be dropped, and a new index will be created for the primary key.

Frage 57

Frage
When 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?
Antworten
  • The data in the table is deleted and the table persists.
  • The data in the table is deleted and the table is implicitly dropped.
  • The temporary table is converted to a base table and the data is deleted.
  • The temporary table is converted to a base table and the data is persistent.

Frage 58

Frage
When a user-defined function (UDF) is created and no schema is specified, what schema is used to store the UDF?
Antworten
  • The SYSIBM schema.
  • The SYSFUN schema.
  • A schema with the name of the UDF.
  • A schema with the userid of the UDF definer.

Frage 59

Frage
Which statement about triggers is true?
Antworten
  • A trigger is designed to return specific types of values and contains executable code.
  • A trigger is designed to return specific types of values but contains no executable code.
  • A trigger performs actions to capture details about an activity like a join operation against multiple tables.
  • A trigger performs actions in response to an event like an INSERT, UPDATE or DELETE operation on a table.

Frage 60

Frage
Which two statements are true about foreign key constraints? (Choose two.)
Antworten
  • The foreign key constraint columns must be supported by an index.
  • The foreign key constraint columns must be defined as NOT NULL.
  • The number and data types of foreign key constraint columns must match the parent key.
  • The columns of one foreign key constraint cannot be used in another foreign key constraint.
  • To define a foreign key constraint there must be an associated primary key or unique key in the same or different table.

Frage 61

Frage
What is the primary purpose of a view?
Antworten
  • To enable uniqueness.
  • To ensure data clustering.
  • To combine data from multiple tables.
  • To optimize queries ran against multiple tables.

Frage 62

Frage
By default, a column defined as a TIMESTAMP includes which attributes?
Antworten
  • No fractional digits or time zone.
  • 6 fractional digits and no time zone.
  • 12 fractional digits plus a time zone.
  • 12 fractional digits and no time zone.

Frage 63

Frage
Which is NOT a valid reason for creating an index?
Antworten
  • To allow queries to run more efficiently.
  • To enforce constraints such as uniqueness on index keys.
  • To order the columns of a table in ascending or descending sequence according to values in a row.
  • To order the rows of a table in ascending or descending sequence according to the values in a column.

Frage 64

Frage
To order the rows of a table in ascending or descending sequence according to the values in a column.
Antworten
  • Unique constraint
  • Primary key constraint
  • Informational constraint
  • Column default constraint

Frage 65

Frage
Which statement is true regarding constraints?
Antworten
  • A table can only have one unique key constraint.
  • A table can have multiple primary key constraints.
  • Informational constraints tell DB2 what rules the data conforms to, but the rules are not enforced.
  • Foreign 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.

Frage 66

Frage
By default, where is the data stored for a column defined with an XML data type?
Antworten
  • In an XML index.
  • In line with the rest of the data for the table.
  • In an XML storage object that is separate from the table.
  • In line with the rest of the data for the table, for XML columns less than 32KB.

Frage 67

Frage
Which statement about BEFORE triggers is FALSE?
Antworten
  • A BEFORE trigger can be used to perform validation of input data.
  • A BEFORE trigger can be used to automatically generate values for newly inserted rows.
  • A BEFORE trigger is fired for each row in the set of affected rows before the trigger event executes.
  • A BEFORE trigger is fired for each row in the set of affected rows instead of executing the trigger event.

Frage 68

Frage
What is used in conjunction with a foreign key to define a relationship between two tables?
Antworten
  • Primary key
  • Partitioning key
  • Check constraint
  • Unique constraint

Frage 69

Frage
Which case will require a sequence to be dropped and recreated instead of being modified by the ALTER SEQUENCE statement?
Antworten
  • Change the data type of the sequence.
  • Reset the sequence to its starting value.
  • Establish new minimum or maximum values.
  • Change the increment between future values.

Frage 70

Frage
Given the following statement: GRANT DELETE ON TABLE sales TO User1 WITH GRANT OPTION; Which statement is correct?
Antworten
  • USER1 can only remove the SALES table.
  • USER1 can only remove records from the SALES table.
  • USER1 can remove the SALES table and grant the privilege to remove the SALES table to other users.
  • USER1 can remove records from the SALES table and grant the privilege to remove records from the SALES table to other users.

Frage 71

Frage
Which method for restricting data access relies on a SQL search condition that describes what set of rows a user has access to?
Antworten
  • Authentication
  • Authorities and privileges
  • Label-based access control
  • Row and column access control

Frage 72

Frage
Which SQL statement will take the ability to create tables in a table space named MYTBSP away from user USER1?
Antworten
  • REVOKE USE OF TABLESPACE mytbsp FROM user1
  • REVOKE ALTER ON TABLESPACE mytbsp FROM user1
  • REVOKE UPDATE OF TABLESPACE mytbsp FROM user1
  • REVOKE CREATETAB ON TABLESPACE mytbsp FROM user1

Frage 73

Frage
In 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?
Antworten
  • Locked
  • Waiting
  • Pending
  • Unconnected

Frage 74

Frage
When is a mask used to limit access to data in a table?
Antworten
  • When mandatory access control (MAC) is used to protect the table.
  • When discretionary access control (DAC) is used to protect the table.
  • When label-based access control (LBAC) is used to protect the table.
  • When row and column access control (RCAC) is used to protect the table.

Frage 75

Frage
What privilege is required to create a view on a table that you are not the owner of?
Antworten
  • INSERT
  • SELECT
  • CREATE
  • TRIGGER

Frage 76

Frage
After 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?
Antworten
  • BIND
  • REBIND
  • BINDADD
  • BIND_REBIND

Frage 77

Frage
Which 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?
Antworten
  • GRANT EXECUTE ON APPLICATION benefits TO user1
  • GRANT EXECUTE ON PACKAGE corpdata.pkga TO user1
  • GRANT EXECUTE ON APPLICATION PACKAGE corpdata.pkga TO user1
  • GRANT EXECUTE ON APPLICATION benefits USING PACKAGE corpdata.pkga TO user1

Frage 78

Frage
Which of the following privileges allow a user to update the comment on a sequence?
Antworten
  • ALTER
  • USAGE
  • UPDATE
  • COMMENT

Frage 79

Frage
Which statement is valid about the Row and Column Access Control (RCAC) feature?
Antworten
  • A 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.
  • A 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.
  • A 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.
  • A 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.

Frage 80

Frage
Which type of table should you use if you want to define specific time periods when data is valid?
Antworten
  • Materialized query table
  • System-period temporal table
  • Declared global temporary table
  • Application-period temporal table

Frage 81

Frage
Which SQL statement will create a DB2 object that can be used to store numerical data as Canadian currency?
Antworten
  • CREATE DISTINCT ALIAS canadian_dollar AS DECIMAL (9,3) WITH COMPARISONS
  • CREATE DISTINCT TYPE canadian_dollar AS DECIMAL (9,3) WITH COMPARISONS
  • CREATE DISTINCT PROCEDURE canadian_dollar AS DECIMAL (9,3) WITH COMPARISONS
  • CREATE DISTINCT FUNCTION canadian_dollar AS DECIMAL (9,3) WITH COMPARISONS

Frage 82

Frage
Which object can be enabled for compression?
Antworten
  • View
  • Buffer pool
  • Storage group
  • Temporary table

Frage 83

Frage
What is the minimum product required for DB2 connectivity across all platforms?
Antworten
  • DB2 Personal Edition
  • DB2 Development Edition
  • DB2 Connect Personal Edition
  • DB2 Development Unlimited Edition

Frage 84

Frage
Given the SQL statement: CREATE ALIAS total_sales FOR sales Which statement is valid?
Antworten
  • SALES can be the name of a schema.
  • SALES can be the name of a package.
  • SALES can be the name of an existing alias.
  • SALES can be the name of a declared global temporary table.

Frage 85

Frage
Which DB2 object limits the user's ability to retrieve data from a table by defining a SQL statement in the object?
Antworten
  • View
  • Index
  • Trigger
  • Check constraint

Frage 86

Frage
A table named EMPLOYEES was created as follows, What will be the results?
Image:
13afe3f0-a190-4735-ae5a-01bf9160e9d6 (image/png)
Antworten
  • 0
  • 1
  • 2
  • 3

Frage 87

Frage
Which two DB2 objects can a view be derived from? (Choose two.)
Antworten
  • View
  • Index
  • Table
  • Trigger
  • Procedure

Frage 88

Frage
Which protocol provides applications the ability to connect to and update multiple DB2 databases within the same transaction?
Antworten
  • Type-1 connect
  • Type-2 connect
  • Type-3 connect
  • Type-4 connect

Frage 89

Frage
Which statement about bitemporal tables is valid?
Antworten
  • Bitemporal tables are system tables and can only be queried by the schema owner.
  • Creating a bitemporal table is similar to creating a regular table except users must specify a system time period column.
  • When data in a bitemporal table is updated, a row is added to it's associated history table.
  • Querying a bitemporal table will produce results for a complete timeline; a view must be created to obtain results for a specific time period.

Frage 90

Frage
Which object can a buffer pool be assigned to?
Antworten
  • Schema
  • Table space
  • Storage group
  • Stored procedure

Frage 91

Frage
Which DB2 object is associated with PREVIOUS VALUE and NEXT VALUE expressions?
Antworten
  • View
  • Table
  • Sequence
  • Identity Column

Frage 92

Frage
What needs to be defined in order to track changes made to a system-period temporal table over time?
Antworten
  • Once the row-begin, row-end, and transaction-start-id columns are created, all changes are tracked.
  • A 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.
  • A 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.
  • A 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.

Frage 93

Frage
Which object is used to cache table and index data as it is read from disk?
Antworten
  • Database
  • Buffer pool
  • Table space
  • Package cache

Frage 94

Frage
Which statement about large object (LOB) locators is true?
Antworten
  • A LOB locator is a data type that is used to store LOB data in binary files.
  • A LOB locator is a data type that is used to store LOB data in a database.
  • A LOB locator represents a value for a LOB resource that is stored in a database.
  • A LOB locator represents a value for a LOB resource that is stored in a binary file.

Frage 95

Frage
Which DB2 product is a database cluster solution for non-mainframe platforms and is best suited for Online Transaction Processing (OLTP) workloads?
Antworten
  • DB2 Connect
  • DB2 pureScale
  • Workload Manager
  • High Availability Disaster Recovery

Frage 96

Frage
What 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?
Antworten
  • inline
  • binary
  • internal
  • partitioned

Frage 97

Frage
Which product replaced the Control Center used in versions prior to DB2 v10?
Antworten
  • IBM Data Studio
  • IBM Administrator
  • IBM Data Manager
  • IBM Command Center

Frage 98

Frage
Which DB2 product is NOT suitable for very large data warehouse applications?
Antworten
  • DB2 for i
  • DB2 for AIX
  • DB2 for z/OS
  • DB2 for Linux

Frage 99

Frage
Which platform supports DB2 pureScale environments?
Antworten
  • AIX
  • iOS
  • z/OS
  • Windows

Frage 100

Frage
Which tool allows users to connect to a DB2 database using a wizard?
Antworten
  • Control Center
  • IBM Data Studio
  • Universal Connection Expert
  • DB2 Connection Pool Manager

Frage 101

Frage
A table named SALES contains a record for every sales transaction a company processes. A user wishes to see the number of transactions that are made by each salesman. Which SQL statement will produce the desired results?
Antworten
  • SELECT name, COUNT(*) AS transactions FROM sales
  • SELECT name, COUNT(DISTINCT name) AS transactions FROM sales
  • SELECT name, COUNT(*) AS transactions FROM sales GROUP BY name
  • SELECT DISTINCT name, COUNT(*) AS transactions FROM sales GROUP BY transactions

Frage 102

Frage
Which statement about roll back operations is correct?
Antworten
  • When a ROLLBACK statement is executed, all locks held by the terminating transaction are released.
  • When a ROLLBACK TO SAVEPOINT statement is executed, all locks acquired up to the savepoint are released.
  • When a ROLLBACK TO SAVEPOINT statement is executed, all locks acquired after the savepoint are released.
  • When a ROLLBACK statement is executed, all locks acquired for open cursors that were declared WITH HOLD, are held.

Frage 103

Frage
When a COMMIT statement is executed, what happens?
Antworten
  • All locks held on the database are automatically released.
  • Data stored in global temporary tables is automatically deleted.
  • Open cursors defined WITH HOLD are closed, but their data is retained.
  • The current transaction is terminated and a new transaction boundary is started.

Frage 104

Frage
Which SQL statement would be used to retrieve only salaries that are greater than $100,000.00 from a table named EMPLOYEE?
Antworten
  • SELECT * FROM employee WHERE salary < 100000
  • SELECT salary FROM employee WHERE salary > 100000
  • SELECT salary FROM employee WHERE salary > 100,000.00
  • SELECT * FROM employee WHERE salary GREATER THAN 100000

Frage 105

Frage
Which SQL statement should be used to retrieve the minimum and maximum salaries (SALARY) for each job code (JOB), sorted by job code, from a table named EMPLOYEE?
Antworten
  • SELECT job, MIN(salary), MAX(salary) FROM employee GROUP BY job ORDER BY job;
  • SELECT job, MIN(salary), MAX(salary) FROM employee ORDER BY job;
  • SELECT job, MIN(salary), MAX(salary) FROM employee GROUP BY SALARY ORDER BY job;
  • SELECT job, MIN(salary), MAX(salary) FROM employee GROUP BY MIN(salary), MAX(salary) ORDER BY job;

Frage 106

Frage
If a table named MY_TAB contains 100 rows and the following statement is executed:
Image:
e8a4490e-458b-4aa1-8551-3a305da76abc (image/png)
Antworten
  • 0
  • 1
  • 10
  • 99

Frage 107

Frage
An SQL function named DEPT_INFO was created as follows: What is the correct way to use this function in a query?
Image:
967d5395-5bca-4990-8937-423ef6e29e8f (image/png)
Antworten
  • SELECT dept_info(dept_id, dept_name)
  • SELECT dept_id, dept_name FROM dept_info()
  • SELECT TABLE dept_id, dept_name FROM dept_info()
  • SELECT dept_id, dept_name FROM TABLE(dept_info()) AS results

Frage 108

Frage
Which type of stored procedure is not associated with an external application program?
Antworten
  • A Java stored procedure.
  • A REXX stored procedure.
  • A native SQL stored procedure.
  • An external SQL stored procedure.

Frage 109

Frage
Which SQL statement will retrieve the department number (WORKDEPT) and average departmental salary (SALARY) for all departments in a table named EMPLOYEE and arrange the result set in ascending order by average departmental salary?
Antworten
  • SELECT workdept, AVG(salary) FROM employee ORDER BY workdept GROUP BY 2
  • SELECT workdept, AVG(salary) FROM employee ORDER BY workdept ARRANGE BY 2
  • SELECT workdept, AVERAGE(salary) FROM employee GROUP BY workdept ORDER BY 2
  • SELECT workdept, AVG(salary) FROM employee GROUP BY workdept ORDER BY 2

Frage 110

Frage
Which statement about system-period temporal tables is true?
Antworten
  • They store user-based period information.
  • They do not have a separate history table.
  • They can be queried without a time period specification.
  • They manage data based on time criteria specified by users or applications.

Frage 111

Frage
A table named DEPARTMENT contains the following data: What will happen?
Antworten
  • The statement will fail because a subquery cannot be used in an UPDATE statement.
  • The statement will fail because the result set produced by the subquery will contain more than one row.
  • The statement will succeed; the last record retrieved by the subquery will be used to provide a WORKDEPT value for the update operation.
  • The statement will succeed; the first record retrieved by the subquery will be used to provide a WORKDEPT value for the update operation

Frage 112

Frage
Which statement about UPDATE processing is FALSE?
Antworten
  • The UPDATE statement logs the before and after value of every column it modifies.
  • A searched UPDATE is used to update one or more rows and a positioned UPDATE is used to update exactly one row.
  • When the UPDATE statement modifies parent key columns, the value of corresponding foreign key columns are also modified.
  • The UPDATE statement modifies the values of specified columns in the rows of a table, view, or underlying table(s) of a specified fullselect.

Frage 113

Frage
Given the following statements: What will be the result?
Image:
d725da91-76fc-4113-918a-fed6a36bcbd4 (image/png)
Antworten
  • Joe Smith
  • <name>Joe Smith</name>
  • <name>Joe Smith></name><name>DB2</name>
  • <employeeinfo><name>Joe Smith</name></employeeinfo>

Frage 114

Frage
A table named STATES has the following columns: STATE_CD, REGION_CD, and STATE_NAME. Which SQL statement will return the number of states in each region, ordered by number of states?
Antworten
  • SELECT state_cd, COUNT(*) FROM states ORDER BY COUNT(*);
  • SELECT state_cd, COUNT(*) FROM states GROUP BY state_cd ORDER BY state_cd;
  • SELECT region_cd, COUNT(*) FROM states GROUP BY state_cd ORDER BY COUNT(*);
  • SELECT region_cd, COUNT(*) FROM states GROUP BY region_cd ORDER BY COUNT(*);

Frage 115

Frage
When a user-defined function (UDF) is created and no schema is specified, what schema is used to store the UDF?
Antworten
  • The SYSIBM schema.
  • The SYSFUN schema.
  • A schema with the name of the UDF.
  • A schema with the userid of the UDF definer.

Frage 116

Frage
What is a function of a table check constraint?
Antworten
  • To provide a method of avoiding duplicate entries for a column
  • To provide a method of ensuring a column's value are within a specific range
  • To ensure that XML columns are properly populated in an associated XML table space
  • To enforce relationships between tables by checking the existence of rows in one table against another.

Frage 117

Frage
which statement about foreign keys is true?
Antworten
  • A table can have only one foreign key
  • Foreign keys can only be defined when a table is created
  • A foreign key can be defined on a column or a set of columns in a table
  • Foreign keys are enforced only during the execution of INSERT statements

Frage 118

Frage
which type of table is best suited for recording results from application data manipulation that is not required to be persistent?
Antworten
  • Base table
  • Temporal table
  • Transition table
  • Temporary table

Frage 119

Frage
Which statement regarding referential integrity constraints is true?
Antworten
  • Multiple primary keys can be defined for a table
  • A foreign key can reference multiple primary keys
  • A primary key can be referenced by only one foreign key
  • Primary keys and foreign keys are used to define relationships

Frage 120

Frage
Which database object provides an alternative way of describing data that exists in one or more base tables?
Antworten
  • Alias
  • View
  • Index
  • Sequence

Frage 121

Frage
The WITH CHECK OPTION clause of the CREATE VIEW statement allows you to do which of the following?
Antworten
  • Define a view on one or more tables or views
  • Revalidate all invalid objects that are referenced on a view's fullselect
  • Ensure that any inserted or updated rows conform to the definition of the view
  • Define a view that only consists of columns that have check constraints defined

Frage 122

Frage
Which type of constraint can be used to tell the DB2 Optimizer that a parent-child relationship exists between two tables, but that the relationship is not enforced?
Antworten
  • Check
  • Unique
  • Referential
  • Informational

Frage 123

Frage
Which event will NOT cause a trigger to be fired?
Antworten
  • Execution of an INSERT statement
  • Execution of LOAD REPLACE operation
  • Execution of an INSERT operation of a MERGE statement
  • Execution of an UPDATE operation of a MERGE statement

Frage 124

Frage
What is the primary purpose for using the INCLUDE clause with a CREATE UNIQUE INDEX statement?
Antworten
  • To override the limit on index key columns
  • To further enforce the uniqueness of index values
  • To combine two or more indexes to create a single unique index
  • To improve performance of some queries by allowing index-only access

Frage 125

Frage
What are INSTEAD OF triggers used for?
Antworten
  • To update data in other tables
  • To perform insert, update and delete operations against complex views
  • To check or modify values before they are actually stored in a database
  • To run non-database operations that are coded in user-defined functions

Frage 126

Frage
User USER1 wants to store part numbers and part descriptions in a table named PARTS; user USER1 also wants to ensure that any comparisons of part descriptions that are made will be done so in binary, regardless of the database collating sequence used. Which statement should user USER1 execute to create the desired table?
Antworten
  • CREATE TABLE parts (part_no INTEGER, desc CLOB))
  • CREATE TABLE parts (part_no INTEGER, desc VARCHAR(200))
  • CREATE TABLE parts (part_no INTEGER, desc CLOB FOR BIT DATA))
  • CREATE TABLE parts (part_no INTEGER, desc VARCHAR(200) FOR BIT DATA)

Frage 127

Frage
What mechanism is typically used to automatically update other tables, generate or transform values for inserted or updated rows, and perform tasks such as issuing alerts?
Antworten
  • Trigger
  • Procedure
  • Table function
  • Scalar function

Frage 128

Frage
Which data type should be used to store data in a column that represents money and accurately returns a two position scale?
Antworten
  • BIGINT
  • BINARY
  • DOUBLE
  • DECIMAL

Frage 129

Frage
User USER1 wants to define a required relationship between two tables named TAB1 and TAB2 in such a way that whenever a record is deleted from table TAB1, any related records are deleted from table TAB2. What must user USER1 do to accomplish this?
Antworten
  • 1) Create a primary key on table TAB1; 2) Create a foreign key on table TAB2 that references the primary key on table TAB1 and adheres to the ON DELETE CASCADE rule.
  • Create a primary key on table TAB2; 2) Create a foreign key on table TAB1 that references the primary key on table TAB2 and adheres to the ON DELETE CASCADE rule.
  • 1) Create a primary key on table TAB1; 2) Create a foreign key on table TAB2 that references the primary key on table TAB1 and adheres to the ON DELETE RESTRICT rule.
  • 1) Create a primary key on table TAB2; 2) Create a foreign key on table TAB1 that references the primary key on table TAB2 and adheres to the ON DELETE RESTRICT rule.

Frage 130

Frage
Which statement about a deadlock is true?
Antworten
  • The victim will be rolled back.
  • The victim will read through the lock.
  • Both victim and holder are rolled back.
  • The victim must wait until the holder releases the lock.

Frage 131

Frage
What takes place when a process accesses a data object on which it already holds a lock, and the access mode requires a more restrictive lock than the one currently held?
Antworten
  • Lock wait
  • Lock timeout
  • Lock escalation
  • Lock conversion

Frage 132

Frage
What is the act of releasing a large number of row-level locks that an application holds on a single table to acquire a table-level lock known as?
Antworten
  • Lock exchange
  • Lock promotion
  • Lock escalation
  • Lock conversion

Frage 133

Frage
When is an INTENT EXCLUSIVE (IX) lock required?
Antworten
  • When a transaction intends to read or change data.
  • When a transaction intends to change but not read data.
  • When a transaction intends to read but not change data.
  • When a transaction intends to change the system catalog.

Frage 134

Frage
The EXCLUSIVE MODE option of the LOCK TABLE statement is used to prevent which of the following?
Antworten
  • Concurrent application processes from performing any operations on the table.
  • Concurrent application processes from performing any read-only operations on the table.
  • Concurrent applications processes that are running under the cursor stability (CS) isolation level from performing read-only operations on thetable.
  • Concurrent applications processes that are running under the uncommitted read (UR) isolation level from performing read-only operations onthe table.

Frage 135

Frage
What factor influences lock conversion/promotion?
Antworten
  • Lock size
  • Number of locks
  • Lock mode needed
  • Available real storage

Frage 136

Frage
Application APP_A is performing updates to table TAB1 using the read stability (RS) isolation level. Which isolation level will allow application APP_B to retrieve all rows from table TAB1 immediately, rather than have to wait until application APP_A has finished making updates?
Antworten
  • Read Stability (RS)
  • Cursor Stability (CS)
  • Repeatable Read (RR)
  • Uncommitted Read (UR)

Frage 137

Frage
If no isolation level is specified, what is the default isolation level used?
Antworten
  • Cursor Stability (CS)
  • Repeatable Read (RR)
  • Read Stability (RS) with Currently Committed semantics
  • Cursor Stability (CS) with Currently Committed semantics

Frage 138

Frage
What isolation level prevents dirty reads, nonrepeatable reads, and phantoms?
Antworten
  • Read stability (RS)
  • Cursor stability (CS)
  • Repeatable read (RR)
  • Uncommitted read (UR)
Zusammenfassung anzeigen Zusammenfassung ausblenden

Möchten Sie mit GoConqr kostenlos Ihre eigenen Quiz erstellen? eigenen Mehr erfahren.

ähnlicher Inhalt

Kognitive Lerntheorien
Inés Fernandez
Pflegehelfer SRK Modul 1
Taniwo
Zivilrecht - Streitigkeiten BGB AT
myJurazone
Stochastik
barbara91
Stimmungen in Englisch lernen
Michelle Eichinger
Analysis - Abiturvorbereitung Mathe
Laura Overhoff
Grundlagen der Stochastik - Zusammenfassung
Flo Rian
PuKW - GESKO WERB
Salome Jeong
Vetie Histopatho 2016
Alena Gesing
Vetie - Fleisch 2016
Kim Langner
Vetie - Milchhygiene 2012
steff Müller
Bibliothek durchsuchen