1Z1-051 무료 덤프문제 온라인 액세스

Which three statements are true regarding views? (Choose three.)

• A.Both simple and complex views can use indexes existing on the underlying tables.
• B.Only simple views can use indexes existing on the underlying tables.
• C.Views can be created only from tables.
• D.Views can be created from tables or other views.
• E.Complex views can be created only on multiple tables that exist in the same schema.
• F.Complex views can be created on multiple tables that exist in the same or different schemas.

Examine these statements:
CREATE ROLE registrar;
GRANT UPDATE ON student_grades TO registrar;
GRANT registrar to user1, user2, user3;
What does this set of SQL statements do?

• A.It creates a role called REGISTRAR, adds the MODIFY privilege on the STUDENT_GRADES object to the role, and gives the REGISTRAR role to three users.
• B.The set of statements contains an error and does not work.
• C.It creates a role called REGISTRAR, adds the UPDATE privilege on the STUDENT_GRADES object to the role, and creates three users with the role.
• D.It creates a role called STUDENT_GRADES, adds the UPDATE privilege on three users, and gives the UPDATE role to the registrar.
• E.It creates a role called REGISTRAR, adds the UPDATE privilege on three users, and gives the REGISTRAR role to the STUDENT_GRADES object.
• F.It creates a role called REGISTRAR, adds the UPDATE privilege on the STUDENT_GRADES object to the role, and gives the REGISTRAR role to three users.

Which best describes an inline view?

• A.a sub query that can contain an ORDER BY clause
• B.another name for a view that contains group functions
• C.a sub query that is part of the FROM clause of another query
• D.a schema object

View the Exhibit and examine the structure of the PRODUCT, COMPONENT, and PDT_COMP tables.

In PRODUCT table, PDTNO is the primary key.
In COMPONENT table, COMPNO is the primary key.
In PDT_COMP table, (PDTNO,COMPNO) is the primary key, PDTNO is the foreign key referencing PDTNO in PRODUCT table and COMPNO is the foreign key referencing the COMPNO in COMPONENT table.
You want to generate a report listing the product names and their corresponding component names, if the component names and product names exist.
Evaluate the following query:
SQL>SELECT pdtno,pdtname, compno,compname
FROM product _____________ pdt_comp
USING (pdtno) ____________ component USING(compno)
WHERE compname IS NOT NULL;
Which combination of joins used in the blanks in the above query gives the correct output?

• A.RIGHT OUTER JOIN; LEFT OUTER JOIN
• B.FULL OUTER JOIN; FULL OUTER JOIN
• C.LEFT OUTER JOIN; RIGHT OUTER JOIN
• D.JOIN; JOIN

What is true regarding sub queries?

• A.The outer query always sorts the results of the inner query
• B.The inner query must always return a value or the outer query will give an error
• C.The outer query must return a value to the outer query
• D.The inner query always sorts the results of the outer query
• E.The inner query returns a value to the outer query