Oracle Interview Questions and Answers
Question - 191 : - How does one connect to an administrative user?
Answer - 191 : - If an administrative user belongs to the "dba" group on Unix, or the "ORA_DBA" (ORA_sid_DBA) group on NT, he/she can connect like this:
connect / as sysdba
No password is required. This is equivalent to the desupported "connect internal" method.
A password is required for "non-secure" administrative access. These passwords are stored in password files. Remote connections via Net8 are classified as non-secure. Look at this example:
connect sys/password as sysdba
Question - 192 : - How does one create a password file?
Answer - 192 : - The Oracle Password File ($ORACLE_HOME/dbs/orapw or orapwSID) stores passwords for users with administrative privileges. One needs to create a password files before remote administrators (like OEM) will be allowed to connect.
Follow this procedure to create a new password file:
. Log in as the Oracle software owner
. Runcommand: orapwd file=$ORACLE_HOME/dbs/orapw$ORACLE_SID password=mypasswd
. Shutdown the database (SQLPLUS> SHUTDOWN IMMEDIATE)
. Edit the INIT.ORA file and ensure REMOTE_LOGIN_PASSWORDFILE=exclusive is set.
. Startup the database (SQLPLUS> STARTUP)
NOTE: The orapwd utility presents a security risk in that it receives a password from the command line. This password is visible in the process table of many systems. Administrators needs to be aware of this!
Question - 193 : - Is it possible to modify an external query in a report which contains it?
Answer - 193 : - No.
Question - 194 : - Does a grouping done for objects in the layout editor affect the grouping done in the data model editor?
Answer - 194 : - No.
Question - 195 : - How does one add users to a password file?
Answer - 195 : - One can select from the SYS.V_$PWFILE_USERS view to see which users are listed in the password file. New users can be added to the password file by granting them SYSDBA or SYSOPER privileges, or by using the orapwd utility. GRANT SYSDBA TO scott;
Question - 196 : - If a break order is set on a column would it affect columns which are under the column?
Answer - 196 : - No
Question - 197 : - Why are OPS$ accounts a security risk in a client/server environment? (for DBA)
Answer - 197 : - If you allow people to log in with OPS$ accounts from Windows Workstations, you cannot be sure who they really are. With terminals, you can rely on operating system passwords, with Windows, you cannot.
If you set REMOTE_OS_AUTHENT=TRUE in your init.ora file, Oracle assumes that the remote OS has authenticated the user. If REMOTE_OS_AUTHENT is set to FALSE (recommended), remote users will be unable to connect without a password. IDENTIFIED EXTERNALLY will only be in effect from the local host. Also, if you are using "OPS$" as your prefix, you will be able to log on locally with or without a password, regardless of whether you have identified your ID with a password or defined it to be IDENTIFIED EXTERNALLY.
Question - 198 : - Do user parameters appear in the data modal editor in 2.5?
Answer - 198 : - No
Question - 199 : - Can you pass data parameters to forms?
Answer - 199 : - No
Question - 200 : - Is it possible to link two groups inside a cross products after the cross products group has been created?
Answer - 200 : - no