Examine the structure of ORD and ORD_ITEMS tables in the Exhibit below. In the ORD table, the ORD_NO column is the primary key. In the ORD_ITEMS table, the ORD_NO and ITEM_NO columns are composite primary key. 

Which of the following CREATE INDEX statements would be valid? (Select two.)

The administrator of an academic database has to create a role which allows several users to modify existing rows in the STUDENT_GRADES table. 

Which set of statements would accomplish the task?

You must perform the following tasks: 

1. Create a MANAGER role and assign it to Blake and Clark. 

2. Grant to Blake and Clark the CREATE TABLE and CREATE VIEW privileges. 

Which set of SQL statements would achieve the required results?

Which of the following SQL statements would accept user input for table name and WHERE condition, as well as for the columns to be displayed?

Examine the following SQL statement: 

► SELECT ename, sal, 12*sal+100 FROM emp; The SAL column stores employees’ monthly salary. 

Which change has to be made to the syntax above in order to calculate the annual compensation as "monthly salary incremented in $100, and multiplied by 12"?

Which of the following SQL statements would you use in order to remove from your schema a view called EMP_DEPT_VU?

The following SQL command is issued by the database administrator: 

► CREATE USER Scott -IDENTIFIED by tiger; 

What privileges are granted to the user Scott at this point?

Which from the following arithmetic operations can be performed on a column by using a SQL function which is built into Oracle database? (Select three.)