Database administrators use specialized software to store and organize data. - Wikipedia
Answer : 1
Create a user and Assign privileged to User
CREATE USER A IDENTIFIED BY root;
Grant Connect to A;
GRANT CREATE TABLE GRANT ANY PRIVILEGE TO A;
SELECT 'CREATE TABLE' ||privilege ||' ON '||table_schema||'.'||table_name ||' TO '|| USER B ||' ;' FROM ALL_TAB_PRIVS WHERE grantee ='CREATE TABLE'
Answer : 3
BEGIN
DBMS_SCHEDULER.CREATE_SCHEDULE (
schedule_name => 'my_stats_schedule',
start_date => SYSTIMESTAMP,
end_date => SYSTIMESTAMP + INTERVAL '30' day,
repeat_interval => 'FREQ=HOURLY; INTERVAL=4',
comments => 'Every 4 hours');
END;
Answer : 4
CREATE BIGFILE TABLESPACE bigtbs_01
DATAFILE 'bigtbs_f1.dbf'
SIZE 15M AUTOEXTEND ON;
CREATE UNDO TABLESPACE bigtbs_01
DATAFILE 'bigtbs_01.dbf'
SIZE 15M AUTOEXTEND ON
RETENTION GUARANTEE;
Answer : 6
CREATE PROFILE profile1
LIMIT PASSWORD_REUSE_MAX 3
PASSWORD_REUSE_TIME 90;
create user a1 identifid 12;
grant create session a1;
grant create table a1;
grant create table b1;
begin
sys_dbms_scheduler.create_job(create log table job)
job action begins execute immediate ( create session histort)
snaptim(timestamp local time);
start_date systimestamp;
create table extab employee()
organization external
type oracle_loader default direcyory()
acesee parameter
location empxt1.date
create profile profile_1;
identified by password 12;
set previleges
create table space tbs1 quota 15mb;
extent tbs1 10;