What are the Capabilities of SELECT Statement?
Selection
Projection
Joining
None of these
To join n tables together, you need a minimum of ________ join conditions
N-2
N
N-1
Equijoins are also called______ or __________
simple joins
outer joins
inner joins
inner and outer joins
How many columns are presented after executing this query: SELECT address1||','||address2||','||address2 "Adress" FROM employee;
1
2
3
0
4
Which Oracle access method is the fastest way for Oracle to retrieve a single row?
Primary key access
Access via unique index
Table access by ROWID
Full table scan
Which of the following can be a valid column name?
Column
1966_Invoices
Catch_#22
#Invoices
None of the above
Which command will delete all data from a table and will not write to the rollback segment?
drop
delete
cascade
truncate
Which character function can be used to return a specified portion of a character string?
INSTR
SUBSTRING
SUBSTR
POS
The primary key on table EMP is the EMPNO column. Which of the following statements will not use the associated index on EMPNO?
select * from EMP where nvl(EMPNO, '00000') = '59384';
select * from EMP where EMPNO = '59384';
select EMPNO, LASTNAME from EMP where EMPNO = '59384';
select 1 from EMP where EMPNO = '59834';
When a user creates an object without a TABLESPACE clause, where will Oracle store the segment?
System tablespace
Users tablespace
Default tablespace for the user
Oracle will give an error
Undefined