This Quiz contains totally 10 Questions each carry 1 point for you.
1. Oracle database is a ?
Relational database
Centralised database
Commercial database
End user database
Correct!
Wrong!
2. How many editions of the Oracle database there?
2
3
4
5
Correct!
Wrong!
3. A __________ is a single field or combination of fields that contains a unique record.
primary key
foreign key
compound key
index
Correct!
Wrong!
4. Which statement is used to create a table from an existing table by copying the columns of existing table?
CREATE TABLE new_table AS (SELECT * FROM old_table);
CREATE TABLE new_table (SELECT * FROM old_table);
CREATE TABLE new_table WHERE (SELECT * FROM old_table);
CREATE TABLE new_table LIKE (SELECT * FROM old_table);
Correct!
Wrong!
5. A ________ is created by a query joining one or more tables.
Trigger
Procedure
Both 1 & 2
view
Correct!
Wrong!
6. Which query is used to add, modify, delete or drop colums of a table?
alter
update
truncate
drop
Correct!
Wrong!
7. Which clause is used to remove the duplicate records from the result set?
where
groupby
like
distinct
Correct!
Wrong!
8. How many CREATE TRIGGER statements are there?
4
5
6
7
Correct!
Wrong!
9. view is a virtual table that does not physically exist.
true
false
Can be true or false
cannot say
Correct!
Wrong!
10. Which is the smallest unit of storage in an Oracle database?
segment
Data Block
Data file
extent
Correct!
Wrong!
Share the quiz to show your results !
Subscribe to see your results
Ignore & go to results
Cassandra-Quiz-8
You got %%score%% of %%total%% right
%%description%%
%%description%%
Loading...