QUESTION: 33

Assume columns c1 and c2 have DATE data type.
What is the resulting data type when subtracting c1 from c2?

DATE
INTEGER
SMALLINT
INTERVAL DAY

Answer(s): A

Reveal Solution Next Question

QUESTION: 34

Which two are primary benefits to using views? (Choose two.)

It simplifies end-user access.
It requires less space to store the data.
It simplifies updates to the tables that make up the view.
It provides an easily maintained level of security and authorization.

Answer(s): A,B

Reveal Solution Next Question

QUESTION: 35

(In the Employee Data above, ? indicates null.)
Given the following query:
SELECT

The query completes with no rows found.
This query will fail because an alias name is used incorrectly.
Last_name Dept_name Job_desc
Butcher Admin Consultant
Last_name Dept_name Job_desc
Butcher Admin Consultant
Butcher Admin Designer
Butcher Admin Manager
Last_name Dept_name Job_desc
Butcher Admin Consultant
Last_name Dept_name Job_desc
Butcher Admin Consultant
Butcher Admin Designer
Butcher Admin Manager
Dietz Admin Consultant
Dietz Admin Designer
Dietz Admin Manager

Answer(s): B

Reveal Solution Next Question

Given the following table:

CREATE GLOBAL TEMPORARY TABLE database1.temp1
(
column1 INTEGER NOT NULL,
column2 INTEGER DEFAULT 100 COMPRESS ,
column3 CHAR(80))
PRIMARY INDEX (column1)
ON COMMIT PRESERVE ROWS;

Which statement is true about this table?

Inserted rows will use spool space.
Multiple sessions can use this definition to insert rows but not share rows.
Rows will be deleted after a transaction that inserted rows into this table is complete.
Rows will be preserved after a session that inserted rows into this table is logged off.

Answer(s): C

Reveal Solution Next Question

Free TE0-122 Exam Braindumps

QUESTION: 33

QUESTION: 34

QUESTION: 35

QUESTION: 36

Exam Discussions & Posts