Oracle Quiz

 



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



Question: 1
Your database is open and the LISTENER listener is running. The new DBA of the system stops the listener by using the command: LSNRCTL> STOP What happens to the sessions that are presently connected to the database instance?
A. The sessions are able to perform only queries.
B. The sessions are not affected and continue to function normally.
C. The sessions are terminated and the active transactions are rolled back.
D. The sessions are not allowed to perform any operations till the listener is started.
Answer: B
 
Question: 2
A user, who is authenticated externally, logs in to a remote machine and connects to the database instance. What action would you take to ensure that a user cannot connect to the database instance by merely logging in to a remote machine?
A. Set REMOTE_OS_ROLES to FALSE.
B. Set the OS_ROLES parameter to FALSE.
C. Set the REMOTE_OS_AUTHENT parameter to FALSE.
D. Set the REMOTE_LOGIN_PASSWORD_FILE parameter to NONE.
Answer: C
 
Question: 3
User A executes the following command to drop a large table in your database: SQL> DROP TABLE trans; While the drop table operation is in progress, user B executes the following command on the same table:
SQL> DELETE FROM trans WHERE tr_type=’SL’; Which statement is true regarding the DELETE command?
A. It fails to delete the records because the records are locked in SHARE mode.
B. It deletes the rows successfully because the table is locked in SHARE mode.
C. It fails to delete the records because the table is locked in EXCLUSIVE mode.
D. It deletes the rows successfully because the table is locked in SHARE ROW EXCLUSIVE mode.
Answer: C
 
Question: 4
For which database operation would you need the database to be in the MOUNT state?
A. Renaming the control files
B. Re-creating the control files
C. Dropping a user in your database
D. Dropping a tablespace in your database
E. Configuring the database instance to operate in the ARCHIVELOG or NOARCHIVELOG modes
Answer: E
 
Question: 5
In a system, large online transaction processing (OLTP) jobs run during the daytime that require a large database buffer cache. In the night, the system supports batch jobs that require a higher value to be set for the large pool. You must simultaneously configure the memory components to accommodate the peak requirement. What would you do to automate this configuration for the memory components with change in mode of working?
A. Set the SGA_TARGET initialization parameter to zero.
B. Set the PRE_PAGE_SGA initialization parameter to TRUE.
C. Set the MEMORY_MAX_TARGET initialization parameter to zero.
D. Set the SGA_TARGET initialization parameter to a nonzero value.
Answer: D
 
Question: 6
The instance abnormally terminates because of a power outage. Which statement is true about redo log files during instance recovery?
A. Inactive and current redo log files are required to accomplish recovery.
B. Online and archived redo log files are required to accomplish instance recovery.
C. All redo log entries after the last checkpoint are applied from redo log files to data files.
D. All redo log entries recorded in the current redo log file until the checkpoint position are applied to data files.
Answer: C
 
Question: 7
The TRANS_SUMMARY table contains product-wise transaction details that get updated with every transaction in the system. Each row has cumulative transaction details of a single product and every product is identified by a product code, which is the primary key. As part of the archival process, the company wants to transfer the rows in the TRANS_SUMMARY table to the TRANS_SUMMARY_DUP table at the end of every quarter of the year. Along with existing products, the company deals with many new products during every quarter. Which method is best suited for this quarterly data transfer?
A. Using the MERGE command
B. Using the SQL*Loader utility
C. Using the correlated UPDATE command
D. Using the INSERT command to perform bulk operation
Answer: A
 
Question: 8
You executed the following command to perform a backup of the USERS tablespace:
SQL> ALTER TABLESPACE users BEGIN BACKUP; ALTER TABLESPACE users BEGIN BACKUP*
ERROR at line 1: ORA-01123: cannot start online backup; media recovery not enabled What could be the reason for this error?
A. The MTTR Advisor is disabled.
B. The database is in NOARCHIVELOG mode.
C. The tablespace is already in backup mode.
D. The Flash Recovery Area is not configured.
Answer: B
 
Question: 9
In your database instance, the user sessions are connected to the database server from the remote machines. You want to achieve the following for these users:
1. The user account must be locked after four unsuccessful login attempts.
2. The user must be prompted to change the password at regular intervals.
3. The user may not have more than three simultaneous sessions.
4. The user session must automatically be logged off if more than 10 minutes elapsed time used.
How would you accomplish the above?
A. By assigning profiles for the users
B. By implementing Fine-Grained Auditing (FGA)
C. By granting a secure application role to the users
D. By implementing the Database Resource Manager plan
Answer: A
 
Question: 10
You execute the following command to audit database activities:
SQL> AUDIT DROP ANY TABLE BY scott BY SESSION WHENEVER SUCCESSFUL; What is the effect of this command?
A. One audit record is created for every successful DROP TABLE command executed in the session of SCOTT.
B. One audit record is generated for the session when SCOTT grants the DROP ANY TABLE privilege to other users.
C. One audit record is created for the whole session if user SCOTT successfully drops one or more tables in his session.
D. One audit record is created for every session of any other user in which a table owned by SCOTT is dropped successfully.
E. One audit record is created for every successful DROP TABLE command executed by any user to drop tables owned by SCOTT.
Answer: C