Sharecodepoint App Download Qrcode Sharecodepoint Android App Banner
Now You can search anything in sharecodepoint using your voice. Click on mic button. Sharecodepoint Youtube Channel

Hi All, Please give your feedback on google. Your Feedback is Important to Us Write Feedback





Sharecodepoint popular queries

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

 

Version 23.2.3.4 - 2016 - 2019 - © Sharecodepoint | Made in India. | Copyright Content