Oracle Tables and Views: Beginners-Level Quiz

Oracle Tables and Views

Welcome to the "Oracle Tables and Views" quiz! In this quiz, you'll explore fundamental concepts related to database tables, which store structured data, and views, which provide virtual representations of that data. Delve into their creation, management, and practical applications, as well as the differences between tables and views. Test your knowledge and enhance your understanding of how to effectively organize and access data within an Oracle Database. Let's get started!

1 / 20

What is the syntax to create a table?

CREATE TABLE

CREATE DATABASE

CREATE COLUMN

CREATE ROW

2 / 20

What does the "table_name" in syntax specifies?

Specifies the table row that you would like to create

Specifies the table name that you would like to create

Specifies the table column that you would like to create

Specifies the table number that you would like to create

3 / 20

Oracle automatically creates the SYSTEM tablespace.

True

False

4 / 20

When you join two or more tables, views, or materialized views, you combine ____ from both tables, views, or materialized views.

Columns

Rows

Both A and B

None of the above

5 / 20

While creating a table, the column should be specified as either NULL or NOT NULL. True or False?

True

False

6 / 20

What is/are the parameter(s) in DROP TABLE?

PURGE

CASCADE CONSTRAINTS

Schema_name and table_name

All of the above

7 / 20

A new table will contain records from the ___ table if it is created using the CREATE TABLE AS method.

Redundant

New

Existing

None

8 / 20

Tables are created by _____ types for each column.

Naming them

Specifying the Data

Defining their Columns

All of the above

9 / 20

The ____________ contains a set of tables and views that Oracle uses as a reference to the database.

SGA

PGA

Library cache

Data dictionary

10 / 20

Views are stored in Databases?

True

False

11 / 20

What the column must have while creation?

Datalink

Datatype

Dataset

Database

12 / 20

What is the value of the column by default, if the value is left blank?

NULL

NOT NULL

13 / 20

Primary keys can only be found in ____ table at a time.

14 / 20

Oracle will ____ the table if there is a referential integrity constraint on table_name that is not specified as CASCADE CONSTRAINTS on the DROP TABLE statement.

Drop

Not drop

Delete

Not delete

15 / 20

How many tables may be included with a join?

All of the above

16 / 20

In relational databases, the joining of two tables is?

Combination of union and filtered Cartesian product

Cartesian product always

Combination of selection and filtered Cartesian product

Combination of projection and filtered Cartesian product

17 / 20

You can delete a VIEW by using the ____ statement

DELETE DROP VIEW

DROP VIEW

DELETE VIEW

DROP DELETE VIEW

18 / 20

Views are also called as ____.

Virtual tables

Complex tables

Simple tables

Actual Tables

19 / 20

By copying the columns of an existing table, the CREATE TABLE __ statement creates a new table based on an existing table.

FOR

20 / 20

You can add a datafile to a tablespace by using the ALTER TABLESPACE ADD DATAFILE SIZE; statement. True or False?

True

False

Your score is

The average score is 0%

Oracle tables and views focus on the foundational concepts of storing and presenting data in Oracle databases.

This includes creating, managing, and modifying tables (the primary data storage structures) and views (virtual tables derived from queries).

This quiz is designed for those wanting to learn how to structure and retrieve data effectively and use views for improved query performance and security.

Good luck!