Home
Skill Test
Program Languages
Java
php
Python
Pyspoke
Database Management
Sql
Oracle
snowflex
NoSQL
UI/UX Design
Html
Css
Angular
React
App Development
Android
Flutter
Framework7
Xamarin
interview questions
Programe Languages
Java
PHP
Python
Pyspoke
Database Management
Sql
Oracle
snowflex
NoSQL
UI/UX Design
Html
Css
Angular
React
App Development
Android
Flutter
Framework7
Xamarin
Job Post
Employer Login
Candidates login
Call us
123 456 7890
329 Queensberry Street, North Melbourne VIC
3051, Australia.
support@superio.com
Employer Login /
Candidates login
Database Management
Oracle
Oracle Home
Oracle Quiz
Time Left:
30:00
Total Questionss:
Question 1
1. Which of the following commands is used to create a new user in an Oracle database?
ADD USER username IDENTIFIED BY password;
INSERT USER username VALUES password;
CREATE USER username IDENTIFIED BY password;
NEW USER username password;
2. Which of the following is used in Oracle to automatically generate a unique value for a column?
AUTO_INCREMENT
IDENTITY
SEQUENCE
TRIGGER
3. Which of the following is used to create a new table in Oracle?
MAKE TABLE
CREATE TABLE
NEW TABLE
INSERT TABLE
4. Which SQL command is used to remove all rows from a table without removing the table structure?
DELETE
TRUNCATE
DROP
ERASE
5. Which of the following is a valid Oracle data type for storing variable-length character strings?
CHAR
VARCHAR2
STRING
TEXT
6. In Oracle, which clause is used to filter the results of a query?
SORT BY
WHERE
FILTER
GROUP
7. What does the COMMIT command do in Oracle?
Rolls back the last transaction
Saves all changes made during the transaction permanently
Deletes all records
Ends the session
8. Which of the following commands is used to remove a table permanently from the database?
REMOVE TABLE
ERASE TABLE
DROP TABLE
DELETE TABLE
9. Which of the following keywords is used to sort query results in Oracle?
SORT BY
ORDER BY
GROUP BY
ARRANGE BY
10. What is a PRIMARY KEY in Oracle?
A key that can contain duplicate and null values
A column that uniquely identifies each row in a table
A column used only for sorting
A backup key for indexing
Previous
Next
Submit Quiz
© 2021 Superio. All Right Reserved.
