Oracle Database Programming MCQs with Answers
Practice important Oracle Database Programming MCQs with answers and explanations.
Chapter: 2
Q21:
What task is simplified by using Oracle 11g on Cloud?
A. Installing database software
B. Database software upgrades and patching
C. Developing custom applications
D. Creating database tables
Correct Answer:
B
Chapter: 2
Q22:
To access Oracle 11g on Cloud, you should visit which website?
A. https://cloud.oracle.com
B. https://apex.oracle.com/en/
C. https://oracle.com/
D. https://virtualuniversity.com
Correct Answer:
B
Chapter: 2
Q23:
What is the first step in logging into Oracle 11g Cloud?
A. Enter username and password
B. Enter SQL commands
C. Access SQL Workshop
D. Visit the Oracle APEX website
Correct Answer:
D
Chapter: 2
Q24:
After clicking the "Sign In" button, what is the next piece of information required?
A. Username
B. Email address
C. Workspace name
D. SQL command
Correct Answer:
C
Chapter: 2
Q25:
Which of the following tabs must you click to access SQL commands?
A. SQL Database
B. SQL Workshop
C. SQL Commands
D. Cloud Workshop
Correct Answer:
B
Chapter: 2
Q26:
What is the purpose of the "SQL Commands" tab in Oracle 11g on Cloud?
A. Run backup and recovery
B. Enter and execute SQL statements
C. Access SQL history
D. Create new database
Correct Answer:
B
Chapter: 2
Q27:
Which tab allows you to see saved code?
A. SQL Commands
B. Run Commands
C. History
D. Backup Codes
Correct Answer:
C
Chapter: 2
Q28:
Fill in the blank: The website to access Oracle 11g Cloud is _______.
A. https://apex.oracle.com/en/
B. https://oracle.com
C. https://cloud.oracle.com
D. https://virtualuniversity.com
Correct Answer:
A
Chapter: 2
Q29:
Fill in the blank: To enter SQL commands in Oracle 11g Cloud, you should click on the _______ tab.
A. SQL Workshop
B. Database Setup
C. SQL Commands
D. Backup History
Correct Answer:
C
Chapter: 2
Q30:
Which step comes directly after entering your login credentials for Oracle 11g Cloud?
A. Click on the SQL Workshop tab
B. Click on the History tab
C. Run SQL commands
D. Set up database
Correct Answer:
A
Chapter: 2
Q31:
What is a feature of Oracle 11g on Cloud that helps simplify database management?
A. Automatic database backups
B. Required manual updates
C. Limited access to cloud storage
D. Full manual control over database upgrades
Correct Answer:
A
Chapter: 3
Q32:
What is the command used to retrieve data from a database in SQL?
A. DELETE
B. SELECT
C. INSERT
D. UPDATE
Correct Answer:
B
Chapter: 3
Q33:
What does the SELECT statement retrieve from a table?
A. All rows and all columns
B. Only specific rows
C. Only specific columns
D. Both specific rows and columns
Correct Answer:
D
Chapter: 3
Q34:
Which SQL clause is used to filter rows returned by a query?
A. GROUP BY
B. HAVING
C. WHERE
D. ORDER BY
Correct Answer:
C
Chapter: 3
Q35:
What does the DISTINCT keyword do in an SQL SELECT statement?
A. Retrieves all values from a column
B. Retrieves unique values
C. Retrieves duplicate values
D. Retrieves null values
Correct Answer:
B
Chapter: 3
Q36:
Which clause is used to filter the results of an aggregated query in SQL?
A. WHERE
B. GROUP BY
C. HAVING
D. ORDER BY
Correct Answer:
C
Chapter: 3
Q37:
In SQL, what symbol is used as a wildcard for one or more characters in a query?
A. %
B. _
C. *
D. ?
Correct Answer:
A
Chapter: 3
Q38:
Which SQL function is used to find the length of a string?
A. ROUND
B. TRUNC
C. LENGTH
D. INSTR
Correct Answer:
C
Chapter: 3
Q39:
Which function in SQL is used to round a number to a specified number of decimal places?
A. ROUND
B. TRUNC
C. LENGTH
D. INSTR
Correct Answer:
A
Chapter: 3
Q40:
Which SQL function would you use to truncate a number without rounding it?
A. ROUND
B. TRUNC
C. LENGTH
D. INSTR
Correct Answer:
B