Oracle 1Z0-071 Quiz 35 Topic 6 Questions 171-175

Question: 1

Examine the SQL statement used to create the TRANSACTION table.

SQL > CREATE TABLE transaction

(trn_id char(2) primary key,

start_date date DEFAULT SYSDATE,

end_date date NOT NULL);

The value 'A1' does not exist for trn_id in this table.

Which SQL statement successfully inserts a row into the table with the default value for START_DATE?

AINSERT INTO transaction VALUES ('A1', DEFAULT, TO_DATE(DEFAULT+10));

BINSERT INTO transaction VALUES ('A1', DEFAULT, TO_DATE('SYSDATE+10'));

CINSERT INTO transaction (trn_id, end_date) VALUES ('A1', '10-DEC-2014');

DINSERT INTO transaction (trn_id, start_date, end_date) VALUES ('A1',, '10-DEC-2014');

Show Answer

Question: 2

Which three SQL statements would display the value 1890.55 as $1,890.55? (Choose three.)

ASELECT TO_CHAR (1890.55, '$99G999D00')FROM DUAL

BSELECT TO_CHAR (1890.55, '$9,999V99')FROM DUAL;

CSELECT TO_CHAR (1890.55, '$0G000D00')FROM DUAL;

DSELECT TO_CHAR (1890.55, '$99,999D99')FROM DUAL;

ESELECT TO_CHAR (1890.55, '$99G999D99')FROM DUAL

Show Answer

Question: 3

A subquery is called a single-row subquery when _______.

AThere is only one subquery in the outer query and the inner query returns one or more values

BThe inner query returns a single value to the outer query.

CThe inner query uses an aggregating function and returns one or more values.

DThe inner query returns one or more values and the outer query returns a single value.

Show Answer

Question: 4

You must write a query that prompts users for column names and conditions every time it is executed.

The user must be prompted only once for the table name.

Which statement achieves those objectives?

ASELECT &col1, '&col2'FROM &tableWHERE &&condition = '&cond';

BSELECT &col1, &col2FROM '&table'WHERE &condition = &cond;

CSELECT &col1, &col2FROM &&tableWHERE &condition = &cond;

DSELECT &col1, &col2FROM &&tableWHERE &condition = &&cond

Show Answer

Question: 5

Which three statements are true regarding single-row functions? (Choose three.)

AThe data type returned, can be different from the data type of the argument that is referenced.

BThey can return multiple values of more than one data type.

CThey can accept only one argument.

DThey can be nested up to only two levels.

EThey can be used in SELECT, WHERE, and ORDER BY clauses.

FThey can accept column names, expressions, variable names, or a user-supplied constants as arguments.

Show Answer

Oracle 1Z0-071 Quiz:35 Topic:6 Questions:171-175