Examine the following queries: 

Which statement is true regarding the above two queries?

Evaluate the business rule:

 ► Each project can have multiple students and each student can work on multiple projects. 

► You have to design an Entity Relationship (ER) model for optimal data storage and allow it to generate reports in the format: 

► STUDENT_ID FIRST_NAME LAST_NAME PROJECT_ID PROJECT_NAME PROJECT_TASK 

Which from the following statements are true? (Select two.)

In the sample below, analyze the details of PRODUCT_INFORMATION table. 

You must have displayed PRODUCT_NAME from the table wherein the CATEGORY_ID column has values 12 or 13, and the SUPPLIER_ID column has the value 102088. You issued the SQL statement: 

► SELECT product_name FROM product_information WHERE (category_id = 12 AND category_id = 13) AND supplier_id = 102088; 

Which from the following statements is true in regards of the query’s execution?

In your database, it exists the BOOKS_TRANSACTIONS table and you execute this SQL statement: 

>SELECT * FROM books_transactions ORDER BY 3; 

What is the result?

Analyze the structure of the EMPLOYEES table in the sample below. 

You must display all employees and their managers having 100 as the MANAGER_ID, and the output should be displayed in two columns: 

the first column would have the LAST_NAME of the managers and the second, would have LAST_NAME of the employees. 

Which from the following SQL statements would you execute?

Which from the following statements are true about multiple-row subqueries? (Select three.)

Analyze the following SQL statements that were issued in the given order: ► CREATE TABLE emp (emp_no NUMBER(2) CONSTRAINT emp_emp_no_pk PRIMARY KEY, ename VARCHAR2(15), salary NUMBER (8,2), mgr_no NUMBER(2) CONSTRAINT emp_mgr_fk REFERENCES emp(emp_no)); ► ALTER TABLE emp DISABLE CONSTRAINT emp_emp_no_pk CASCADE; ► ALTER TABLE emp ENABLE CONSTRAINT emp_emp_no_pk; Which statement is correct regarding the status of the foreign key EMP_MGR_PK?

Which from the following statements is true in regards of the ORDER BY clause’s default behavior?