Oracle and SQL Sub languages

Question 1

T/F – Oracle has market dominance in Online Transaction Processing (OLTP)

Answer 1

True

Question 2

• What is Oracles command line administration tool?

Answer 2

o Sqlplus

Question 3

• T/F - sqlplus will prompt for a password

Answer 3

True

Question 4

Name this: Web-based admin tool for managing remote DB instances like replication, storage, provides usage data in graphics

Answer 4

Oracle Enterprise Manager

Question 5

Name this: Recovery manager, manages full and incremental backups

Answer 5

Oracle RMAN

Question 6

Name the 4 SQL sub languages

Answer 6

DDL, DML, TCL, and DCL

Question 7

Explain what DDL does

Answer 7

Create, Alter, Truncate – Create the structures

Question 8

Explain DML

Answer 8

Insert, Update, Delete – Popular the structures

Question 9

Explain TCL

Answer 9

Commit, Rollback – Version control

Question 10

Explain DCL

Answer 10

Grant, Revoke – Set privileges, control who uses your DB and how

Question 11

Name the 4 oracle users that are automatically added to your system:

Answer 11

SYS, SYSTEM, SCOTT, HR

Question 12

• What is SYS in oracle?

Answer 12

o SYS is the top level admin user of any oracle DB

Question 13

• To login to SYS you must use the keyword ‘___ __ ______’ in the username field

Answer 13

o SYS AS SYSDBA

Question 14

• What is SYSTEM in oracle DB?

Answer 14

o Another admin user

Question 15

• To create another user in oracle you must be logged in as ___

Answer 15

SYS

Question 16

Name this: The right to execute an SQL statement, or right to access another users object

Answer 16

Object privilege

Question 17

• There are 2 types of auto-divided privileges, what are they?

Answer 17

System privilege, Object privilege

Question 18

• System privileges and object privileges differ by who they can be granted by, explain who can grant what:

Answer 18

o System privileges can only be granted by the DBA,
o Object privileges can be granted by the owner of the object or the DBA

Question 19

• What is a role? How can they be determined/defined?

Answer 19

o A role is a group of privileges
o They can be built in (DBA, Connect, Resource) or they can be user defined

Question 20

• How can you give someone almost all of the privileges a DB developer could require, without giving them access to SYS?

Answer 20

o Login as SYS, grant them connect and resource
o SQL> GRANT connect,resource TO Sarfraz

Question 21

System privileges allow

Answer 21

o System allows the creation of sessions, tables, views, and procedures in the DB

Question 22

Object allows

Answer 22

o Object allows someone to access another users objects, I.E. Insert, Update, Delete, Execute

Question 23

o T/F – You require object privileges for objects created by you

Answer 23

 False. As owner of the object you have all privileges for that object