×
Detail Form
We will send your result on your email id and phone no. please fill detail
1.
In Oracle, which of the following statements about profiles is true?
A. Profiles can control the use of passwords.
B. Profile-assignments do not affect current sessions.
C. All the limits of the DEFAULT profile are initially unlimited.
D. Profiles can be assigned to users and roles, but cannot be assigned to other profiles.
E. Profiles can ensure that the users log off the database when they have left their session idle for a period of time.
A. Profiles can control the use of passwords.
B. Profile-assignments do not affect current sessions.
C. All the limits of the DEFAULT profile are initially unlimited.
D. Profiles can be assigned to users and roles, but cannot be assigned to other profiles.
E. Profiles can ensure that the users log off the database when they have left their session idle for a period of time.
2.
In Oracle, you intend to use only password authentication. You have used the password file utility to create a password file as follows:
The connection fails because _______________________.
orapwd file = $ORACLE_HOME / dbs / orapwDB01 password = orapass entries = 5
The REMOTE_LOGIN_PASSWORDFILE initialization parameter is set to NONE. You created a user and granted only the SYSDBA privilege to that user as follows:
CREATE USER dba_user IDENTIFIED BY dba_pass;
GRANT sysdba TO dba_user;
The user attempts to connect to the database as follows:
GRANT sysdba TO dba_user;
connect dba_user / dba_pass as sysdba;
The connection fails because _______________________.
3.
In Oracle, which of the following steps is NOT mandatory to open the database in archive log mode?
STEP 1: Shutdown the database, if it is running.
STEP 2: Take a full offline backup.
STEP 3: Set the archiving-related parameters in the parameter file.
STEP 4: Start and mount the database.
STEP 1: Shutdown the database, if it is running.
STEP 2: Take a full offline backup.
STEP 3: Set the archiving-related parameters in the parameter file.
STEP 4: Start and mount the database.
4.
In Oracle, if a new role is created as follows:
CREATE ROLE role1;
CREATE ROLE role2 IDENTIFIED BY pass2;
What will be the privileges that role1 and role2 will have by default?
CREATE ROLE role2 IDENTIFIED BY pass2;
5.
In Oracle, which of the following queries will you use to find the space occupied by the table T?
1) select segment_name,bytes from dba_segments where segment_name=‘T’
2) select segment_name, bytes from dba_extents where segment_name=‘T’
3) select segment_name,bytes from dba_spaces where segment_name=‘T’
1) select segment_name,bytes from dba_segments where segment_name=‘T’
2) select segment_name, bytes from dba_extents where segment_name=‘T’
3) select segment_name,bytes from dba_spaces where segment_name=‘T’
6.
In Oracle, what is the output of the following DELETE statement?
begin
DELETE temp a where a.rowid > (select min(x.rowid) from temp x where x.id = a.id)
RETURNING sum(a.cnt) INTO tot_cnt;
end;
where tot_cnt is a bind variable
DELETE temp a where a.rowid > (select min(x.rowid) from temp x where x.id = a.id)
RETURNING sum(a.cnt) INTO tot_cnt;
end;
where tot_cnt is a bind variable
7.
In Oracle, if a role is a group of privileges assigned a name, what is the output of the following command:
create role public;
8.
An airlines company that should operate 24 hours a day depends on an Oracle database that must run continuously. However, the data in the tablespace is very volatile and must be backed up frequently.
Which of the following commands sets the tablespace in the backup mode?
Which of the following commands sets the tablespace in the backup mode?
9.
In Oracle, which of the following commands are valid for backing up a control file:
a) The backup current controlfile; command
b) ALTER DATABASE BACKUP CONTROLFILE
c) ALTER DATABASE BACKUP CONTROLFILE TO TRACE
a) The backup current controlfile; command
b) ALTER DATABASE BACKUP CONTROLFILE
c) ALTER DATABASE BACKUP CONTROLFILE TO TRACE
10.
Which of the following commands is valid for ARCHIVE LOG backup?
a) The BACKUP ARCHIVELOG command
b) The BACKUP ... PLUS ARCHIVELOG command
c) An O/S utility
a) The BACKUP ARCHIVELOG command
b) The BACKUP ... PLUS ARCHIVELOG command
c) An O/S utility