Oracle Database

Question 1

What does the database do?

Answer 1

A database collects data, store, and organizes data, and retrieves related data.

Question 2

What is DBMS and what does it do?

Answer 2

Database management System controls the storage, organization, and retrieval of data.

Question 3

SQL is the

Answer 3

code and language used to retrieve data from the database.

Question 4

What is RDBMS and what does it do?

Answer 4

Relational database management system is an organized model of subjects and characteristics that have relationships among the subjects.

Question 5

3 Characteristics of a Relational Database:

Answer 5

■ Structures are objects that store or access data from the database. Tables, views, and indexes are examples of structures in Oracle.
■ Operations are the actions that are used to define the structures or to manipulate data between the structures. SELECT statements and CREATE statements are examples of operations in Oracle.
■ Integrity rules govern what kinds of actions are allowed on data and the database structure. These rules protect the data and the structure of the database. The primary keys and foreign keys are examples of integrity rules in Oracle.

Question 6

ER model has [Blank], [Blank], and [Blank].

Answer 6

An ER model has entity, relationship, and attributes.

Question 7

ER model: Entities and Attributes

Answer 7

An entity in a logical model is much like a noun in grammar—a person, place, or thing. The characteristics of an entity are known as its attributes. Attributes
are detailed information about an entity that serves to qualify, identify, classify, or quantify it.

Question 8

ER model: Relationships and Unique Identifiers

Answer 8

In the ER model, a solid line represents a mandatory relationship, and a crowfoot represents the “many.” But in some departments, there may not be any employees at all. Optional occurrence is represented by a dotted line.

Question 9

How do you create a physical model?

Answer 9

The physical model is created by taking the logical model and creating a database and database objects to represent the entities and relationships.

Question 10

In the physical model, each entity becomes a [Blank] and attributes of the entity become columns of the table.

Answer 10

table

Question 11

What is DML and what is it used for?

Answer 11

Database Manipulation Language is used to access, insert, modify, or delete data in the existing structures of the database.

DML Statements: SELECT, INSERT, UPDATE, DELETE, MERGE, EXPLAIN PLAN, LOCK TABLE,

Question 12

What is DDL and what is it used for?

Answer 12

Data Definition Language is used to define, alter, or drop database objects and their privileges.

DDL Statements: CREATE, ALTER, DROP, RENAME, TRUNCATE, GRANT, REVOKE, AUDIT, NOAUDIT, COMMENT

Question 13

How do you write the concatenation operator?

Answer 13

||’Oracle12c’ || ‘Database’ results in ‘Oracle12cDatabase’.

Question 14

What is a query?

Answer 14

A query is a request for information from the database tables.

Question 15

Does query modify data? If not, what does it do?

Answer 15

Queries do not modify data; they read data from database tables and views.

Question 16

A table is used to [Blank] and is [Blank] in rows and columns.

Answer 16

A table is used to store data and is stored in rows and columns.

Question 17

Keyword to ensure unique rows

Answer 17

DISTINCT

Question 18

What is the DUAL table and what is it used for?

Answer 18

The DUAL table is a special table available to all users in the database. The DUAL table is mostly used to select system variables or to evaluate an expression.

Question 19

What is the LIKE keyword?

Answer 19

Using the LIKE operator, you can perform pattern matching.
The pattern-search character % is used to match any character and any number of characters.
The pattern-search character _ is used to match any single character.

Question 20

What is the ORDER BY keyword?

Answer 20

ORDER BY clause to sort the resulting rows in a specific
order based on the data in the columns.
ASC
DESC

Question 21

What is the EXIST operator?

Answer 21

The EXISTS operator checks for the existence of a row in the subquery based on the condition.

Question 22

What is the DESCRIBE command?

Answer 22

list the table columns, the columns are listed in that order.

Question 23

COMMIT statement

Answer 23

Ends the current transaction, making data changes permanent

and visible to other sessions.

Question 24

ROLLBACK statement

Answer 24

Undoes all data changes in the current transaction.

Question 25

What is a constraint?

Answer 25

A constraint can be considered as a rule or policy defined in the database to enforce data integrity

Question 26

What is a table?

Answer 26

A table is defined with columns, and it stores rows of data. A table should have
at least one column. In Oracle, a table normally refers to a relational table. You can also
create object tables.

Question 27

What is a view?

Answer 27

A view is a customized representation of data from one or more tables and/or views.
Views are used as windows to show information from tables in a certain way or to restrict
the information. Views are queries stored in the database that select data from one or more
tables. Unlike tables, views do not store data—they can be considered as stored queries. They also provide a way to restrict data from certain users, thereby providing an additional
level of security

Question 28

What is a schema?

Answer 28

A schema is a collection of database objects owned by a single user. For example, a schema
can have tables, views, triggers, synonyms, and PL/SQL programs such as procedures. A
schema is owned by a database user and has the same name as the user. If the database user
does not own any database objects, then no schema is associated with the user. A schema is
a logical grouping of database objects.

Question 29

What is PL/SQL Programs?

Answer 29

PL/SQL stored programs include procedures, functions, and packages.
A procedure is a PL/SQL programmatic construct. A function is similar to a procedure but
always returns a value. A package is a grouping of related PL/SQL objects.