Databases | Practice Questions | Aliensbrain

Multiple choice technology databases

Which SQL statement is used to return only different values?

SELECT DIFFERENT
SELECT DISTINCT
SELECT UNIQUE
SELECT PRIMARY

Reveal answer Fill a bubble to check yourself

Multiple choice technology databases

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%'

Reveal answer Fill a bubble to check yourself

Multiple choice technology databases

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

Reveal answer Fill a bubble to check yourself

Multiple choice technology databases

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.

Reveal answer Fill a bubble to check yourself

Multiple choice technology databases

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.

Reveal answer Fill a bubble to check yourself

Multiple choice technology databases

Which is an /SQL*Plus command?

insert
update
select
describe

Reveal answer Fill a bubble to check yourself

Multiple choice technology databases

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

Reveal answer Fill a bubble to check yourself

Multiple choice technology databases

:new can be used in stament level trigger

True
False

Reveal answer Fill a bubble to check yourself

Multiple choice technology databases

Order by cause should be used only at end of query

True
False

Reveal answer Fill a bubble to check yourself

Multiple choice technology databases

union all is faster than union

True
False

Reveal answer Fill a bubble to check yourself

Tag: databases

Questions Related to databases