Oracle 1Z0-071 Quiz 65 Topic 14 Questions 321-325

Question: 1

Examine the SQL statement used to create the TRANSACTION table. (Choose the best answer.)

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

Evaluate this ALTER TABLE statement: (Choose the best answer.)

ALTER TABLE orders

SET UNUSED (order_date);

Which statement is true?

AAfter executing the ALTER TABLE command, a new column called ORDER_DATE can be added to the ORDERS table.

BThe ORDER_DATE column must be empty for the ALTER TABLE command to execute successfully.

CROLLBACK can be used to restore the ORDER_DATE column.

DThe DESCRIBE command would still display the ORDER_DATE column.

Show Answer

Question: 3

You must write a query that prompts users for column names and conditions every time it is executed. (Choose the best answer.)

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, &col2 FROM '&table'WHERE &condition =&cond;

CSELECT &col1, &col2 FROM &&tableWHERE &condition = &cond;

DSELECT &col1, &col2 FROM &&tableWHERE &condition = &&cond

Show Answer

Question: 4

View the Exhibit and examine the structure in the DEPARTMENTS tables. (Choose two.)

q4_1Z0-071

Examine this SQL statement:

SELECT department_id "DEPT_ID", department_name, 'b' FROM

departments

WHERE departments_id=90

UNION

SELECT department_id, department_name DEPT_NAME, 'a' FROM

departments

WHERE department_id=10

Which two ORDER BY clauses can be used to sort output?

AORDER BY DEPT_NAME;

BORDER BY DEPT_ID;

CORDER BY 'b';

DORDER BY 3;

Show Answer

Question: 5

You must create a table EMPLOYEES in which the values in the columns EMPLOYEES_ID and LOGIN_ID must be unique and not null. (Choose two.)

Which two SQL statements would create the required table?

ACREATE TABLE employees(employee_id NUMBER,Login_id NUMBER,Employee_name VARCHAR2(100),Hire_date DATE,CONSTRAINT emp_id_ukUNIQUE (employee_id, login_id));

BCREATE TABLE employees(employee_id NUMBER,login_id NUMBER,employee_name VARCHAR2(25),hire_date DATE,CONSTRAINT emp_id_pk PRIMARY KEY (employee_id, login_id));

CCREATE TABLE employees(employee_id NUMBER CONSTRAINT emp_id_pk PRIMARY KEY, Login_id NUMBER UNIQUE, Employee_name VARCHAR2(25),Hire_date DATE);

DCREATE TABLE employees(employee_id NUMBER,Login_id NUMBER,Employee_name VARCHAR2(100),Hire_date DATE,CONSTRAINT emp_id_uk UNIQUE (employee_id, login_id);CONSTRAINT emp_id_nn NOT NULL (employee_id, login_id));

ECREATE TABLE employees(employee_id NUMBER CONSTRAINT emp_id_nn NOT NULL, Login_id NUMBER CONSTRAINT login_id_nn NOT NULL,Employee_name VARCHAR2(100),Hire_date DATE,CONSTRAINT emp_id_ukUNIQUE (employee_id, login_id));

Show Answer

Oracle 1Z0-071 Quiz:65 Topic:14 Questions:321-325