Oracle Admin Quiz

 



Oracle Admin Quiz contain set of 10 MCQ questions for Oracle Admin MCQ which will help you to clear beginner level quiz.



1.      Which of the following are valid table-partitioning methods?

• 1. Value
  2. Freelist
  3. Hash
  4. Index

 
2.      Which of the following views contains statistics about the usage of an index?

• 1. DBA_INDEXES
  2. DBA_IND_INDEXES
  3. V$OBJECT_USAGE
  4. V$INDEX

 
3.      Which of the following statements can be used to make the constraints either DEFERRED or IMMEDIATE? (Choose two)

• 1. ALTER CONSTRAINT
  2. ALTER SYSTEM
  3. ALTER SESSION
  4. SET CONSTRAINT

 
4.      What does the PASSWORD_LIFE_TIME parameter of the CREATE PROFILE command specify?

• 1. The number of days for which an account will be locked after a number of unsuccessful logon attempts.
  2. The number of days after which a password has to be changed in order to connect
  3. The number of days after which the same password can be reused
  4. The number of days after which the password is automatically changed

 
5.      Suppose the following command is issued:
CREATE USER rob IDENTIFIED GLOBALLY
Which of the following statements is true?

• 1. User rob is authenticated by operating system.
  2. User rob is authenticated by remote systems.
  3. User rob is authenticated using a password file.
  4. User rob is authenticated by directory services dependent upon the OS.

 
6.      Which of the following views provides all the grants on all the objects in the database?

• 1. DBA_SYS_PRIVS
  2. DBA_COL_PRIVS
  3. DBA_OBJ_PRIVS
  4. DBA_TAB_PRIVS

 
7.      Which command can be used to disable all the roles including the default roles?

• 1. Set Role Off
  2. Drop Role All
  3. Revoke Role All
  4. Set Role None

 
8.      Default values of which of the following parameters are determined by the NLS_LANGUAGE initialization parameter? (Choose two)

• 1. NLS_CURRENCY
  2. NLS_DATE_LANGUAGE
  3. NLS_DATE_FORMAT
  4. NLS_SORT

 
9.      Which of the following are valid recommendations for locating redo log files? (Choose two)

• 1. Datafiles and redo log files must be placed on different disks.
  2. Log members of the same log group must be placed on different disks.
  3. Archive log files and redo log files must be placed on the same disk.
  4. Each log group must be placed on a different disk.

 
10.  Which of the following are the characteristics of the LOB datatype? (Choose two)

• 1. It supports replication.
  2. It stores all data inline.
  3. It supports sequential access to the data.
  4. Multiple columns of this datatype can exist in the same table.