MCQs on Introduction to Oracle SQL | SQL Language
1. Introduction to Oracle SQL
Overview of Oracle Database
- What is an Oracle Database primarily used for?
- A. Storing only text data
- B. Storing and managing structured data
- C. Generating graphics
- D. Managing file systems
- Which of the following describes Oracle Database?
- A. A type of operating system
- B. A system that allows data to be stored, retrieved, and managed
- C. A web-based software for creating presentations
- D. A file-sharing software
- The Oracle Database architecture is based on which type of structure?
- A. Layered
- B. Hierarchical
- C. Client-Server
- D. Monolithic
SQL Basics and Terminology
- What does SQL stand for?
- A. Structured Query Language
- B. System Query Language
- C. Sequential Query Language
- D. Standard Query Language
- Which of the following SQL commands is used to retrieve data from a database?
- A. SELECT
- B. INSERT
- C. DELETE
- D. UPDATE
- In SQL, which clause is used to filter the records?
- A. ORDER BY
- B. WHERE
- C. GROUP BY
- D. HAVING
- What is a result set in SQL?
- A. The tables in a database
- B. The output of a SQL query
- C. The records stored in the database
- D. The primary key of a table
- In SQL, which operator is used to combine two conditions?
- A. OR
- B. IF
- C. AND
- D. JOIN
Working with Oracle SQL Developer and SQL*Plus
- Oracle SQL Developer is primarily used for:
- A. Programming applications
- B. Managing Oracle databases and running SQL statements
- C. Debugging Java programs
- D. Creating web pages
- Which of the following is true about SQL*Plus?
- A. It’s a tool for directly managing the Oracle server files
- B. It’s a command-line tool for running SQL and PL/SQL
- C. It’s a graphical user interface for writing SQL queries
- D. It’s a tool for creating operating system-level scripts
- Which command is used to exit SQL*Plus?
- A. STOP
- B. EXIT
- C. LEAVE
- D. CLOSE
- What is the extension of the files saved by Oracle SQL Developer?
- A. .txt
- B. .sql
- C. .ora
- D. .db
Understanding Data Types in Oracle
- In Oracle SQL, which data type is used to store text data?
- A. NUMBER
- B. VARCHAR2
- C. DATE
- D. BLOB
- Which data type is suitable for storing large binary files in Oracle?
- A. VARCHAR
- B. BINARY
- C. BLOB
- D. INTEGER
- What data type is used to store dates in Oracle SQL?
- A. TIMESTAMP
- B. DATE
- C. INTEGER
- D. TIME
- Which of the following data types can hold decimal values?
- A. CHAR
- B. VARCHAR2
- C. DATE
- D. NUMBER
- In Oracle SQL, which data type is used to store true or false values?
- A. BOOLEAN
- B. CHAR
- C. NUMBER
- D. VARCHAR2
Introduction to DDL, DML, and DCL Statements
- Which SQL statement is used to create a new table?
- A. CREATE
- B. SELECT
- C. INSERT
- D. ALTER
- Which type of SQL command is used to insert data into a table?
- A. DDL
- B. DML
- C. DCL
- D. TCL
- Which statement is part of DCL (Data Control Language)?
- A. CREATE
- B. GRANT
- C. INSERT
- D. SELECT
- What does DDL stand for in SQL?
- A. Data Definition Language
- B. Data Description Language
- C. Database Definition Language
- D. Data Decision Language
- The
DELETEstatement in SQL is part of which category?- A. DCL
- B. TCL
- C. DML
- D. DDL
- Which command is used to modify the structure of an existing table?
- A. CREATE
- B. UPDATE
- C. ALTER
- D. SELECT
- In SQL, the command to remove all records from a table without deleting the table structure is:
- A. DROP
- B. TRUNCATE
- C. DELETE
- D. REMOVE
- Which command is used to change data in existing rows?
- A. CREATE
- B. INSERT
- C. UPDATE
- D. SELECT
- Which SQL statement is used to delete a table from a database?
- A. TRUNCATE
- B. REMOVE
- C. DELETE
- D. DROP
- Which of the following is a DML command?
- A. CREATE
- B. GRANT
- C. INSERT
- D. ALTER
- Which command in SQL is used to remove access permissions?
- A. REMOVE
- B. GRANT
- C. DENY
- D. REVOKE
- The term ‘commit’ in SQL refers to:
- A. Committing data permanently to the database
- B. Saving changes temporarily
- C. Deleting data permanently
- D. Rolling back a transaction
- Which command is used to give access permissions in Oracle?
- A. ADD
- B. GIVE
- C. GRANT
- D. PERMIT
Answers
| QNo | Answer (Option with text) |
|---|---|
| 1 | B. Storing and managing structured data |
| 2 | B. A system that allows data to be stored, retrieved, and managed |
| 3 | C. Client-Server |
| 4 | A. Structured Query Language |
| 5 | A. SELECT |
| 6 | B. WHERE |
| 7 | B. The output of a SQL query |
| 8 | C. AND |
| 9 | B. Managing Oracle databases and running SQL statements |
| 10 | B. It’s a command-line tool for running SQL and PL/SQL |
| 11 | B. EXIT |
| 12 | B. .sql |
| 13 | B. VARCHAR2 |
| 14 | C. BLOB |
| 15 | B. DATE |
| 16 | D. NUMBER |
| 17 | A. BOOLEAN |
| 18 | A. CREATE |
| 19 | B. DML |
| 20 | B. GRANT |
| 21 | A. Data Definition Language |
| 22 | C. DML |
| 23 | C. ALTER |
| 24 | B. TRUNCATE |
| 25 | C. UPDATE |
| 26 | D. DROP |
| 27 | C. INSERT |
| 28 | D. REVOKE |
| 29 | A. Committing data permanently to the database |
| 30 | C. GRANT |