Everything You Need to Pass: oracle 1Z0_061

Evaluate the SQL statement:TRUNCATE TABLE DEPT;Which three are true about the SQL statement? (Choose three.)

Which is a valid CREATE TABLE statement?

Evaluate this SQL statement:SELECT ename, sal, 12*sal+100 FROM emp;The SAL column stores the monthly salary of the employee. Which change must be made to the above syntax to calculate the annual compensation as "monthly salary plus a monthly bonus of $100, multiplied by 12"?

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, compnameFROM product _____________ pdt_compUSING (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?

Evaluate the following SQL statements:Exhibit:You issue the following command to create a view that displays the IDs and last names of the sales staff in the organization.Exhibit:Which two statements are true regarding the above view? (Choose two.)

Evaluate the following SQL statement:Which statement is true regarding the outcome of the above query?