1. What is Oracle?
a) A programming language
b) A database management system
c) An operating system
d) An application server
Answer: b) A database management system
2. What does SQL stand for?
a) Structured Query Language
b) Simple Query Language
c) Sequential Query Language
d) Static Query Language
Answer: a) Structured Query Language
3. What is a database instance in Oracle?
a) A collection of schemas
b) A collection of data files
c) A running Oracle database
d) A tablespace
Answer: c) A running Oracle database
4. What is the purpose of the Oracle Data Dictionary?
a) To store user data
b) To manage the database instance
c) To store metadata about the database
d) To perform data validation
Answer: c) To store metadata about the database
5. What is an Oracle tablespace?
a) A collection of database files
b) A logical storage unit within a table
c) A group of related tables
d) A data structure to store indexes
Answer: a) A collection of database files
6. What is an Oracle schema?
a) A collection of database objects owned by a user
b) A collection of data files
c) A group of related tables
d) A database instance
Answer: a) A collection of database objects owned by a user
7. What is PL/SQL?
a) A programming language for Oracle database
b) A tool for database design
c) A query language
d) A database server
Answer: a) A programming language for Oracle database
8. Which statement is used to retrieve data from a database in Oracle?
a) INSERT
b) UPDATE
c) SELECT
d) DELETE
Answer: c) SELECT
9. Which statement is used to insert data into a table in Oracle?
a) INSERT
b) UPDATE
c) SELECT
d) DELETE
Answer: a) INSERT
10. What is a primary key in Oracle?
a) A unique identifier for a row in a table
b) A key that allows duplicate values
c) A foreign key constraint
d) A key used for encryption
Answer: a) A unique identifier for a row in a table
11. What is the purpose of an index in Oracle?
a) To enforce data integrity
b) To provide a backup of the database
c) To improve query performance
d) To create primary keys
Answer: c) To improve query performance
12. What is a foreign key in Oracle?
a) A key that allows duplicate values
b) A key used for encryption
c) A key that references a primary key in another table
d) A unique identifier for a row in a table
Answer: c) A key that references a primary key in another table
13. What is normalization in the context of databases?
a) The process of organizing data into tables and columns
b) The process of reducing redundancy and dependency by organizing data efficiently
c) The process of optimizing queries for better performance
d) The process of securing the database
Answer: b) The process of reducing redundancy and dependency by organizing data efficiently
14. What is an Oracle trigger?
a) A database object that stores data
b) A stored procedure that is automatically invoked in response to certain events
c) A data structure that holds indexes
d) A function that performs mathematical operations
Answer: b) A stored procedure that is automatically invoked in response to certain events
15. In Oracle, what is the purpose of a view?
a) To store data permanently
b) To create a virtual table based on the result of a SELECT query
c) To index a table for faster retrieval
d) To enforce data integrity
Answer: b) To create a virtual table based on the result of a SELECT query
16. What is a synonym in Oracle?
a) A stored procedure
b) A virtual table
c) An alias for a table or view
d) A data type
Answer: c) An alias for a table or view
17. What is the purpose of the COMMIT statement in Oracle?
a) To discard changes made in the current transaction
b) To save all changes made in the current transaction
c) To undo specific changes in the current transaction
d) To create a new transaction
Answer: b) To save all changes made in the current transaction
18. What is the purpose of the ROLLBACK statement in Oracle?
a) To discard changes made in the current transaction
b) To save all changes made in the current transaction
c) To undo specific changes in the current transaction
d) To create a new transaction
Answer: a) To discard changes made in the current transaction
19. What is a deadlock in Oracle?
a) A situation where two or more transactions are waiting for each other to release locks
b) A situation where a table is corrupted
c) A situation where the database server is down
d) A situation where a table is full
Answer: a) A situation where two or more transactions are waiting for each other to release locks
20. What is the purpose of the UNION operator in Oracle?
a) To combine rows from two or more tables
b) To sort the result set in ascending order
c) To filter rows based on a condition
d) To perform a cross join
Answer: a) To combine rows from two or more tables
21. What is the purpose of the HAVING clause in Oracle?
a) To filter rows based on a condition
b) To sort the result set in ascending order
c) To restrict the number of rows returned
d) To filter aggregated results based on a condition
Answer: d) To filter aggregated results based on a condition
22. What is an Oracle sequence?
a) A stored procedure
b) A schema object that generates unique numbers
c) A group of related tables
d) A virtual table
Answer: b) A schema object that generates unique numbers
23. What is a stored procedure in Oracle?
a) A set of SQL statements that perform a specific task
b) A unique identifier for a row in a table
c) A key that references a primary key in another table
d) A key used for encryption
Answer: a) A set of SQL statements that perform a specific task
24. What is the purpose of the NVL function in Oracle?
a) To return the maximum value in a column
b) To return the minimum value in a column
c) To replace NULL values with a specified value
d) To concatenate two strings
Answer: c) To replace NULL values with a specified value
25. What is the purpose of the GROUP BY clause in Oracle?
a) To filter rows based on a condition
b) To sort the result set in ascending order
c) To group rows based on a column's values
d) To join multiple tables
Answer: c) To group rows based on a column's values
26. What is the purpose of the ORDER BY clause in Oracle?
a) To filter rows based on a condition
b) To sort the result set in ascending order
c) To restrict the number of rows returned
d) To join multiple tables
Answer: b) To sort the result set in ascending order
27. What is the purpose of the TRUNCATE TABLE statement in Oracle?
a) To delete all rows from a table
b) To remove a column from a table
c) To drop a table
d) To remove a constraint from a table
Answer: a) To delete all rows from a table
28. Which statement is used to update existing data in a table in Oracle?
a) INSERT
b) UPDATE
c) SELECT
d) DELETE
Answer: b) UPDATE
29. What is the purpose of the DELETE statement in Oracle?
a) To delete a table from the database
b) To delete specific rows from a table
c) To remove a column from a table
d) To truncate a table
Answer: b) To delete specific rows from a table
30. What is the purpose of the CREATE INDEX statement in Oracle?
a) To create a new table
b) To create a new schema
c) To create an index on a table for faster retrieval
d) To create a foreign key
Answer: c) To create an index on a table for faster retrieval
31. What is the purpose of the GRANT statement in Oracle?
a) To revoke privileges from a user
b) To create a new user
c) To grant privileges to a user
d) To drop a table
Answer: c) To grant privileges to a user
Top comments (0)