What does SQL stand for?

• Structured Question Language
• Sequential Query Language
• Structured Query Language
• Simple Query Language

Which command is used to retrieve data from an Oracle database?

• GET
• FETCH
• SELECT
• RETRIEVE

Which of these is a valid Oracle data type?

• VARCHAR2
• STRING
• TEXT
• CHAR2

What is the default port number for Oracle Database Listener?

• 8080
• 1521
• 3306
• 1433

What is a tablespace in Oracle?

• A space to create tables
• Logical storage unit
• Physical data file
• Temporary directory

What is the purpose of a cursor in PL/SQL?

• To execute DDL statements
• To loop through trigger events
• To handle multiple rows returned by a query
• To perform commit operations

What is an explicit cursor?

• A cursor that opens automatically
• A cursor defined and controlled by the user
• A cursor used only for DDL
• A cursor created during compilation

Which component of Oracle architecture manages memory structures?

• Oracle Net
• SQL*Loader
• System Global Area (SGA)
• Control File

What is the function of the PL/SQL %ROWTYPE attribute?

• Declares a cursor
• Creates a new table
• Declares a variable based on a table row
• Specifies transaction type

In PL/SQL, what does the %FOUND attribute indicate?

• If the loop is over
• If a row was successfully fetched
• If memory is full
• If cursor is still open

What is RMAN used for in Oracle?

• Performance tuning
• Memory management
• Backup and recovery
• Query execution

Which Oracle feature allows you to undo changes to data?

• Savepoint
• Flashback
• Rollforward
• Trigger

What is Oracle Data Guard primarily used for?

• Query optimization
• High availability and disaster recovery
• Index compression
• Auditing users

What does the Oracle RAC system allow?

• Reporting across databases
• Parallel database creation
• Multiple nodes to access one database instance
• External indexing

What does the AWR report provide?

• Transaction logs
• Archive details
• Performance diagnostics
• Memory usage history