Ejemplo_1

Question

If the following command is executed: CREATE DATABASE test What is the page size (in kilobytes) of the database?

Answer 1

ALTER TABLE sales ADD COLUMN item CHAR(40);

Answer 2

ALTER TABLE sales ALTER COLUMN item CHAR(40);

Answer 3

ALTER TABLE sales MODIFY COLUMN item CHAR(40);

Answer 4

ALTER TABLE sales ALTER COLUMN item SET DATA TYPE CHAR(40);

Answer 5

SQL Procedure

Answer 6

Sequence Object

Answer 7

Materialized Query Table

Answer 8

When you want to control the order in which triggers are fired.

Answer 9

When you want to control the order in which stored procedures can be invoked.

Answer 10

When you want to automatically generate a numeric value that is not tied to any specific column or table.

Answer 11

When you want to automatically generate a numeric value for each row that is added to a specific table.

Answer 12

ADD COLUMN

Answer 13

ALTER COLUMN

Answer 14

APPEND COLUMN

Answer 15

RENAME COLUMN

Answer 16

A transaction-start-id column must be defined for the table.

Answer 17

A history table must be defined and associated with the base table.

Answer 18

A BUSINESS_TIME period must be specified in a CREATE or ALTER of the table.

Answer 19

A unique index must be created that prevents overlapping of the BUSINESS_TIME period of the table.

Answer 20

Oracle connect

Answer 21

Trusted context

Answer 22

Oracle federation

Answer 23

Distributed request

Answer 24

Collection

Answer 25

Bitemporal

Answer 26

Time-period

Answer 27

System-period

Answer 28

Application-period

Answer 29

In the table definition

Answer 30

In the system catalog.

Answer 31

In the schema that the index resides in.

Answer 32

In the metadata of the table the index was created for.

Answer 33

Workload manager

Answer 34

Data partitioning feature

Answer 35

Self-tuning memory manager

Answer 36

partitioned

Answer 37

To automatically capture and stop rogue queries.

Answer 38

To provide recommendations and analysis for tuning a single query.

Answer 39

To provide recommendations and analysis for tuning up to 100 queries.

Answer 40

To recommend indexes and to guide DBAs through the process of creating new indexes.

Answer 41

Control Center

Answer 42

IBM Data Studio

Answer 43

Universal Connection Expert

Answer 44

DB2 Connection Pool Manager

Answer 45

Confirm product inventory.

Answer 46

Monitor product availability.

Answer 47

Summarize sales by region.

Answer 48

Identify patterns for products sold in the last five years.

Answer 49

Associate one or more products with a purchase order.

Answer 50

To combine data from multiple sources.

Answer 51

To discover hidden relationships in data.

Answer 52

To analyze large amounts of data to find patterns.

Answer 53

To make changes to a small number of records within a single transaction.

Answer 54

Read Stability (RS)

Answer 55

Cursor Stability (CS)

Answer 56

Repeatable Read (RR)

Answer 57

Uncommitted Read (UR)

Answer 58

Table size

Answer 59

Buffer space

Answer 60

Number of locks

Answer 61

Available real storage

Answer 62

Update (U)

Answer 63

Exclusive (X)

Answer 64

Intent Exclusive (IX)

Answer 65

Read Stability (RS)

Answer 66

Repeatable Read (RR)

Answer 67

Uncommitted Read (UR)

Answer 68

Cursor Stability (CS)

Answer 69

LOCK TABLE tab1 IN READ MODE

Answer 70

LOCK TABLE tab1 IN SHARE MODE

Answer 71

LOCK TABLE tab1 IN EXCLUSIVE MODE

Answer 72

LOCK TABLE tab1 IN READ-ONLY MODE

Answer 73

When a transaction intends to read or change data.

Answer 74

When a transaction intends to change but not read data.

Answer 75

When a transaction intends to read but not change data.

Answer 76

When a transaction intends to change the system catalog.

Answer 77

Lock escalation

Answer 78

Lock substitution

Answer 79

Lock switch/exchange

Answer 80

Lock conversion/promotion

Answer 81

Read stability (RS)

Answer 82

Cursor stability (CS)

Answer 83

Repeatable read (RR)

Answer 84

Uncommitted read (UR)

Answer 85

All locks held on the database are automatically released.

Answer 86

Data stored in global temporary tables is automatically deleted.

Answer 87

Open cursors defined WITH HOLD are closed, but their data is retained.

Answer 88

The current transaction is terminated and a new transaction boundary is started.

Answer 89

COMMIT TO SAVEPOINT

Answer 90

ROLLBACK TO SAVEPOINT

Answer 91

CALL conv_temp(climate_info.avg_temp);

Answer 92

CALL convert_ftoc(climate_info.avg_temp);

Answer 93

SELECT conv_temp(avg_temp) FROM climate_info;

Answer 94

SELECT convert_ftoc(avg_temp) FROM climate_info;

Answer 95

The last 5 rows in the table will be deleted.

Answer 96

The first 5 rows in the table will be deleted.

Answer 97

The statement will fail because a subquery cannot be used with a DELETE statement.

Answer 98

The statement will fail because a table name was not specified with the DELETE statement.

Answer 99

SELECT employees.name, sales.revenue FROM employees INNER JOIN sales ON employees.id = sales.emp_id

Answer 100

SELECT employees.name, sales.revenue FROM employees INNER JOIN sales ON sales.emp_id = employees.id

Answer 101

SELECT employees.name, sales.revenue FROM sales LEFT OUTER JOIN employees ON employees.id = sales.emp_id

Answer 102

SELECT employees.name, sales.revenue FROM sales RIGHT OUTER JOIN employees ON employees.id = sales.emp_id

Answer 103

CALL statements.

Answer 104

External file access.

Answer 105

Use of a scratch pad.

Answer 106

COMMIT statements.

Answer 107

SQL control statements.

Answer 108

XMLATTRIBUTES

Answer 109

SELECT * FROM employee WHERE (hiredate < '1999-01-01' AND salary < 40000) OR (education ='University')

Answer 110

SELECT * FROM employee WHERE (hiredate < '1999-01-01') OR (salary < 40000) OR (education ='University')

Answer 111

SELECT * FROM employee WHERE (hiredate < '1999-01-01' OR (salary < 40000 AND (education ='University')

Answer 112

SELECT * FROM employee WHERE (hiredate < '1999-01-01' AND salary < 40000 AND (education ='University')

Answer 113

SELECT empno, hiredate, salary FROM employee FOR hiredate < '1998-01-01' AND salary < 35000

Answer 114

SELECT empno, hiredate, salary FROM employee WHERE hiredate < '1998-01-01' AND salary < 35000

Answer 115

SELECT empno, hiredate, salary FROM employee WHERE hiredate < '1998-01-01' OR salary < 35000

Answer 116

SELECT empno, hiredate, salary FROM employee FOR hiredate < '1998-01-01' OR salary < 35000

Answer 117

SELECT lastname, firstnme, salary, job FROM employee ORDER BY 3 FETCH FIRST 5 ROWS ONLY

Answer 118

SELECT lastname, firstnme, salary, job FROM employee ORDER BY 3 DESC FETCH FIRST 5 ROWS ONLY

Answer 119

SELECT lastname, firstnme, salary, job FROM employee ORDER BY 3 FETCH FIRST 5 ROWS

Answer 120

SELECT lastname, firstnme, salary, job FROM employee ORDER BY 3 DESC FETCH FIRST 5 ROWS

Answer 121

The INSERT statement is used to insert rows into a table, view, or table function.

Answer 122

Inserted values must satisfy the conditions of any check constraints defined on the table.

Answer 123

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.

Answer 124

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.

Answer 125

Consists of explicitly-supplied timestamps and a separate associated history table.

Answer 126

Is based on explicitly-supplied timestamps that define the time periods during which data is valid.

Answer 127

Is useful when one wants to keep both user-based period information and system-based historical information.

Answer 128

Consists of a pair of columns with database-manager maintained values that indicate the period when a row is current.

Answer 129

SELECT job, MIN(salary), MAX(salary) FROM employee GROUP BY job;

Answer 130

SELECT job, MIN(salary), MAX(salary) FROM employee ORDER BY job;

Answer 131

SELECT job, MIN(salary), MAX(salary) FROM employee GROUP BY job, MIN(salary), MAX(salary);

Answer 132

SELECT JOB, MIN(salary), MAX(salary) FROM employee ORDER BY job, MIN(salary), MAX(salary);

Answer 133

Unconnected

Answer 134

Load operations

Answer 135

Backup/copy table spaces

Answer 136

Create and drop databases

Answer 137

Monitor database performance

Answer 138

To define exactly what a specific user can do within a particular database once they have been authenticated.

Answer 139

To group a collection of privileges together so that they can be simultaneously granted to and revoked from multiple users.

Answer 140

To establish a credible relationship between DB2 and an external entity, such as a database administrator or a middleware server.

Answer 141

To group a collection of users together so that they can be simultaneously granted and revoked specific authorities and privileges.

Answer 142

GRANT ALTER ON SEQUENCE myseq TO user1

Answer 143

GRANT USAGE ON SEQUENCE myseq TO user1

Answer 144

GRANT SELECT ON SEQUENCE myseq TO user1

Answer 145

GRANT COMMENT ON SEQUENCE myseq TO user1

Answer 146

The column mask must be enabled; the EMPLOYEE table must be altered to activate column access control.

Answer 147

The column mask must be enabled (column access control for the EMPLOYEE table will be activated automatically).

Answer 148

The EMPLOYEE table must be altered to activate column access control (the column mask will be enabled automatically).

Answer 149

The EMPLOYEE table must be altered to activate column access control; row permission must be granted to everyone who needs to use thecolumn mask.

Answer 150

Assign the SSN column to a restricted role that only authorized users can access.

Answer 151

Only grant ACCESSCTRL authority for the SSN column to users who need to access SSN data.

Answer 152

Alter the table definition so that SSN data is stored in a separate schema that only authorized users can access.

Answer 153

Create a view for the EMPLOYEE table that does not contain the SSN column and require unauthorized users to use the view.

Answer 154

GRANT CREATETAB ON DATABASE TO user1

Answer 155

GRANT SELECT ON TABLE employee TO user1

Answer 156

GRANT CREATEVIEW ON DATABASE TO user1

Answer 157

GRANT REFERENCES ON TABLE employee TO user1

Answer 158

DBCTRL authority

Answer 159

SQLADM authority

Answer 160

DATAACCESS authority

Answer 161

ACCESSCTRL authority

Answer 162

REFERENCES

Answer 163

It must not contain more than one column.

Answer 164

It cannot be used in a referential constraint.

Answer 165

It must be defined with the UNIQUE attribute.

Answer 166

It must be defined as UNIQUE WHERE NOT NULL.

Answer 167

Only one INSERT, UPDATE, or DELETE trigger can be defined per table.

Answer 168

Triggers cannot be modified, they must be dropped and recreated with new definitions.

Answer 169

Adding a trigger to a table that already has rows in it will cause triggered actions to be fired.

Answer 170

Triggers can only be fired one time per statement irrespective of the number of rows affected.

	Erstellt von Mª Carmen Ruiz Garcia vor mehr als 9 Jahre

	Kopiert von ismael mesa domi vor mehr als 9 Jahre

	Kopiert von renanvkas vor mehr als 9 Jahre

Nächster

Ejemplo_1

Beschreibung

Zusammenfassung der Ressource

Frage 1

Frage 2

Frage 3

Frage 4

Frage 5

Frage 6

Frage 7

Frage 8

Frage 9

Frage 10

Frage 11

Frage 12

Frage 13

Frage 14

Frage 15

Frage 16

Frage 17

Frage 18

Frage 19

Frage 20

Frage 21

Frage 22

Frage 23

Frage 24

Frage 25

Frage 26

Frage 27

Frage 28

Frage 29

Frage 30

Frage 31

Frage 32

Frage 33

Frage 34

Frage 35

Frage 36

Frage 37

Frage 38

Frage 39

Frage 40

Frage 41

Frage 42

Frage 43

Frage 44

Frage 45

Frage 46

Frage 47

Frage 48

Frage 49

Frage 50

Frage 51

Frage 52

Frage 53

Frage 54

Frage 55

ähnlicher Inhalt