Oracle 1Z0-071 Quiz 51 Topic 13 Questions 251-255

Question: 1

Which two tasks can be performed by using Oracle SQL statements? (Choose two.)

Achanging the password for an existing database user

Bconnecting to a database instance

Cquerying data from tables in different databases

Dstarting up a database instance

Eexecuting operating system (OS) commands in a session

Show Answer

Question: 2

View the exhibit for the structure of the STUDENT and FACULTY tables.

q2_1Z0-071

You need to display the faculty name followed by the number of students handled by the faculty at the base location.

Examine the following two SQL statements:

Statement 1

SQL>SELECT faculty_name, COUNT(student_id)

FROM student JOIN faculty

USING (faculty_id, location_id)

GROUP BY faculty_name;

Statement 2

SQL>SELECT faculty_name, COUNT(student_id)

FROM student NATURAL JOIN faculty

GROUP BY faculty_name;

Which statement is true regarding the outcome?

AOnly statement 2 executes successfully and gives the required result.

BOnly statement 1 executes successfully and gives the required result.

CBoth statements 1 and 2 execute successfully and give different results.

DBoth statements 1 and 2 execute successfully and give the same required result.

Show Answer

Question: 3

Which statement correctly grants a system privilege?

AGRANT CREATE VIEWON table1 TOuser1;

BGRANT ALTER TABLETO PUBLIC;

CGRANT CREATE TABLETO user1,user2;

DGRANT CREATE SESSIONTO ALL;

Show Answer

Question: 4

View the exhibit and examine the structure of ORDERS and CUSTOMERS tables.

q4_1Z0-071

Which INSERT statement should be used to add a row into the ORDERS table for the customer whose CUST_LAST_NAME is Roberts and CREDIT_LIMIT is 600? Assume there exists only one row with CUST_LAST_NAME as Roberts and CREDIT_LIMIT as 600.

AINSERT INTO(SELECT o.order_id, o.order_date, o.order_mode, c.customer_id, o.order_totalFROM orders o, customers cWHERE o.customer_id = c.customer_id AND c.cust_last_name='Roberts' AND c.credit_limit=600)VALUES (1,'10-mar-2007', 'direct', (SELECT customer_idFROM customersWHERE cust_last_name='Roberts' AND credit_limit=600), 1000);

BINSERT INTO orders (order_id, order_date, order_mode,(SELECT customer_idFROM customersWHERE cust_last_name='Roberts' AND credit_limit=600), order_total)VALUES (1,'10-mar-2007', 'direct', &customer_id, 1000);

CINSERT INTO ordersVALUES (1,'10-mar-2007', 'direct',(SELECT customer_idFROM customersWHERE cust_last_name='Roberts' AND credit_limit=600), 1000);

DINSERT INTO orders (order_id, order_date, order_mode,(SELECT customer_idFROM customersWHERE cust_last_name='Roberts' AND credit_limit=600), order_total)VALUES (1,'10-mar-2007', 'direct', &&customer_id, 1000);

Show Answer

Question: 5

Which three statements are correct regarding indexes? (Choose three.)

AA non-deferrable PRIMARY KEY or UNIQUE KEY constraint in a table automatically attempts to create a unique index.

BIndexes should be created on columns that are frequently referenced as part of any expression.

CWhen a table is dropped, corresponding indexes are automatically dropped.

DFor each DML operation performed on a table, the corresponding indexes are automatically updated if required.

Show Answer

Oracle 1Z0-071 Quiz:51 Topic:13 Questions:251-255