Which SQL statement is used to return only different values?
SELECT DIFFERENT
SELECT DISTINCT
SELECT UNIQUE
SELECT PRIMARY
With SQL, how do you select all the records from a table named "Persons" where the value of the column "FirstName" starts with an "a"?
SELECT * FROM Persons WHERE FirstName LIKE '%a'
SELECT * FROM Persons WHERE FirstName='a'
SELECT * FROM Persons WHERE FirstName LIKE 'a%'
SELECT * FROM Persons WHERE FirstName='%a%'
With SQL, how do you select all the columns from a table named "Persons"?
SELECT [all] FROM Persons
SELECT Persons
SELECT *.Persons
SELECT * FROM Persons
Which two are attributes of iSQL*Plus? (Choose two)
iSQL*Plus commands manipulate table definitions in the database.
iSQL*Plus is the Oracle proprietary interface for executing SQL statements.
iSQL*Plus commands cannot be abbreviated.
iSQL*Plus commands are accesses from a browser.
You need to perform certain data manipulation operations through a view called EMP_DEPT_VU, which you previously created. You want to look at the definition of the view (the SELECT statement on which the view was create.) How do you obtain the definition of the view?
Use the DESCRIBE command in the EMP_DEPT VU view.
Use the DEFINE VIEW command on the EMP_DEPT VU view.
Query the USER_VIEWS data dictionary view to search for the EMP_DEPT_VU view.
Query the USER_SOURCE data dictionary view to search for the EMP_DEPT_VU view.
Which is an /SQL*Plus command?
insert
update
select
describe
Evaluate this SQL statement: SELECT e.EMPLOYEE_ID,e.LAST_NAME,e.DEPARTMENT_ID, d.DEPARTMENT_NAME. FROM EMP e, DEPARTMENT d WHERE e.DEPARTMENT_ID = d.DEPARTMENT_ID; In the statement, which capabilities of a SELECT statement are performed?
Selection, projection, join
Difference, projection, join
Selection, intersection, join
Intersection, projection, join
:new can be used in stament level trigger
True
False
Order by cause should be used only at end of query
union all is faster than union