Exploring Oracle9i Fundamentals

What is Oracle9i primarily used for?

• Data visualization tool

• Web server software

• Operating system

• Relational database management system (RDBMS)

Define the term 'Client/Server Database'.

• A Client/Server Database is a database system where the database is hosted on a server and accessed by clients over a network.

• A Client/Server Database is a database that runs entirely on a client device.

• A Client/Server Database is a single-user database application.

• A Client/Server Database is a type of cloud storage service.

What command is used to log into SQL *Plus?

• sql login username/password

• connect username/password

• enter username/password in SQL

• sqlplus username/password

List two types of SQL *Plus commands.

• DDL commands and DML commands

• CREATE commands and DELETE commands

• JOIN commands and INDEX commands

• SELECT commands and UPDATE commands

What are the naming rules for Oracle tables?

• Table names can start with a number.

• Table names can only include letters.

• Table names must start with a letter, can be up to 30 characters long, and can include letters, numbers, and underscores.

• Table names can be up to 50 characters long.

Explain the purpose of constraints in Oracle tables.

• The purpose of constraints in Oracle tables is to enforce data integrity and ensure that the data adheres to specific rules.

• To improve database performance by indexing tables.

• To automatically delete old data from the database.

• To allow users to create unlimited records in a table.

How do you create a new table in Oracle?

• CREATE TABLE table_name (column1 datatype, column2 datatype, ...);

• DROP TABLE table_name;

• ALTER TABLE table_name ADD column_name datatype;

• INSERT INTO table_name (column1, column2);

What command would you use to display information about a table?

• SHOW TABLE table_name;

• DESCRIBE table_name;

• INFO table_name;

• SELECT * FROM table_name;

What is the difference between truncating and dropping a table?

• Truncating is a permanent action; dropping can be undone.

• Truncating deletes all data and structure; dropping keeps data.

• Truncating keeps the table structure; dropping removes the table entirely.

• Truncating removes the table structure; dropping keeps it.

What is spooling in the context of SQL *Plus?

• Spooling refers to the process of caching SQL queries in memory.

• Spooling is the process of writing SQL query output to a file in SQL *Plus.

• Spooling is the technique of compressing SQL output for faster retrieval.

• Spooling is a method for executing SQL commands in parallel.