We are proud to announce the launch of the new brand of sharecodepoint.


Like Us Fanpage




Tuesday, 24 April 2018

INT401 : Database Administration Class Test CA4 (Practical) with Solution - INT 401

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;

0 comments:

Post a Comment

 

ShareCodePoint : Version 17.0.8 - 2016 - 2018 - © Sachin Yadav Production Made in India.