Examine this product table's column definitions:
pid number primary key
pname varchar2(50)
You must display column headings as shown:
Product_ID Product Name
Which SELECT statement does this?
• SELECT pid AS Product_ID, pname AS Product Name FROM product;
• SELECT pid Product_ID, pname "Product Name" FROM product;
• SELECT pid @Product_ID, pname @"Product Name" FROM product;
• SELECT pid Product_ID, pname Product Name FROM product;
Which SELECT statement displays all employee table columns?
• SELECT FROM employee;
• SELECT *.* FROM employee;
• SELECT "empid", "empname" from employee;
• SELECT * FROM employee;
What are some of the features of Oracle Database, up to, and including Oracle 19c? (Choose three)
• Client-side data validation
• Performance-related features
• Game playing web application development API features
• High availability
• Security
Which are DDL statements? (Choose three)
• SAVEPOINT
• COMMIT
• GRANT
• CREATE
• DROP
• TRUNCATE
• ROLLBACK
