MCQOPTIONS
Saved Bookmarks
MCQOPTIONS
This section includes 55 Mcqs, each offering curated multiple-choice questions to sharpen your ORACLE knowledge and support exam preparation. Choose a topic below to get started.
| 1. |
Which of the following statements is true after execution of the program? int a[10],I,*p; a[0]=1; a[1]=2; p=a; (*p)++; |
| A. | a[0]=2 |
| B. | a[1]=3 |
| C. | a[1]=1 |
| D. | a[0]=3 |
| Answer» B. a[1]=3 | |
| 2. |
using' in C++ is for. |
| A. | using does not exist in C++ |
| B. | used for library functions |
| C. | using is a literal in C++ |
| D. | used for pointers |
| Answer» C. using is a literal in C++ | |
| 3. |
Analyse the following code snippet: ClassTemp { private: charm_acEmpName[25]; public: char*GetFirstChar() { strcpy(m_acEmpName,"Hello"); returnthis->m_acEmpName; } }; intmain(intargc,char**argv)v { Temp oTempObject; cout< } . |
| A. | Displays the first character of the string |
| B. | Displays the complete string Hello |
| C. | Error |
| D. | Displays the last character of the string |
| Answer» C. Error | |
| 4. |
Choose the proper statement |
| A. | :volatileisareserved keywordinC++ |
| B. | :userdefinedvariablescanalsobeoverloadedalongwithmethodandoperators. |
| C. | :bool keywordisusedforlogicalvalues |
| D. | :Both Aand C |
| Answer» E. | |
| 5. |
NULL is |
| A. | the same as 0 for integer |
| B. | the same as blank for character |
| C. | the same as 0 for integer and blank for character |
| D. | not a value |
| Answer» E. | |
| 6. |
Which of the following data structures are used in RDBMS. |
| A. | Graph |
| B. | Array of structures |
| C. | Trees |
| D. | None of these |
| Answer» C. Trees | |
| 7. |
When a transaction is committed, what does the LGWR do? |
| A. | Writes redo log entries in the SGAs redo log buffers to the online redo log file |
| B. | Writes the transactions SCN to the online redo log file |
| C. | Both a and b |
| D. | Writes the unique system change number (SCN) to redo log file. |
| Answer» D. Writes the unique system change number (SCN) to redo log file. | |
| 8. |
To ensure that a transaction does not hang if it cannot obtain a lock, which of the following statements below should be executed? |
| A. | UPDATE ... NOWAIT |
| B. | FOR UPDATE ... WAIT |
| C. | FOR UPDATE ... NOWAIT |
| D. | UPDATE ... WAIT |
| Answer» D. UPDATE ... WAIT | |
| 9. |
When does a statement run in a resumable mode? |
| A. | When the client implicitly enables resumable semantics for the session using the ALTER SESSION statement |
| B. | When the client explicitly enables resumable semantics for the session using the ALTER SESSION statement |
| C. | When the client implicitly enables resumable semantics for the session using the CREATE SESSION statement |
| D. | When the client explicitly enables resumable semantics for the session using the CREATE SESSION statement |
| Answer» E. | |
| 10. |
What do we call transactions in which commit was interrupted by any type of system or network failure? |
| A. | in-doubt distributed transactions |
| B. | doubt distributed transactions |
| C. | in-doubt transactions |
| D. | Both a and b |
| Answer» C. in-doubt transactions | |
| 11. |
A constraint in a table is defined with the INITIALLY IMMEDIATE clause. You executed the ALTER TABLE command with the ENABLE VALIDATE option to enable the constraint that was disabled. What are the two effects of this command? |
| A. | It fails if any existing row violates the constraint |
| B. | It does not validate the existing data in the table |
| C. | It prevents insert, update, and delete operations on the table while the constraint is in the process of being enabled. |
| D. | Both A & B |
| Answer» E. | |
| 12. |
Data changes in a snap shot can be triggered ________. |
| A. | Manually |
| B. | Automatically |
| C. | Both a and b |
| D. | Scheduled |
| Answer» D. Scheduled | |
| 13. |
The delay between the time a DML change is applied at the originating database and the time the transaction reaches the destination databases is called as _______ . |
| A. | Propagation |
| B. | Propagation latency |
| C. | Conflict |
| D. | Conflict latency |
| Answer» C. Conflict | |
| 14. |
The Remote File Server process which is required when archiving to a remote destination, is responsible for which the following tasks? |
| A. | Consuming network I/O from the ARCn process |
| B. | Creating file names on the standby database by using the STANDBY_ARCHIVE_DEST parameter |
| C. | Populating the log files at the remote site |
| D. | All mentioned above |
| Answer» E. | |
| 15. |
Each committed transaction has an associated number to uniquely identify the changes made by the statements within the transaction and that number is called, _________ . |
| A. | Supply change number |
| B. | System change number |
| C. | Oracle change number |
| D. | Commit change number |
| Answer» C. Oracle change number | |
| 16. |
In distributed SQL statements, which of the following retrieves information from two or more nodes? |
| A. | Distributed query |
| B. | Distributed update |
| C. | Both A & B |
| D. | None of the above |
| Answer» B. Distributed update | |
| 17. |
In ________ type of link users connect as themselves. This means that they must have an account on the remote database with the same username as their account on the local database. |
| A. | Connected user link |
| B. | Fixed user link |
| C. | Current user link |
| D. | Both A & B |
| Answer» B. Fixed user link | |
| 18. |
Which schema does this window group reside? |
| A. | system |
| B. | sysdba |
| C. | sys |
| D. | Both B and C |
| Answer» D. Both B and C | |
| 19. |
After creating a job, you may need to set job arguments if- |
| A. | The inline job action is a stored procedure or other executable that requires arguments. |
| B. | The job references a named program object and you want to override one or more default program arguments. |
| C. | The job references a named program object and one or more of the program arguments were not assigned a default value. |
| D. | All mentioned above. |
| Answer» E. | |
| 20. |
In the Scheduler, most components are database objects like a table, which enables you to use normal oracle privileges. Select the correct basic elements of the scheduler. |
| A. | Programs |
| B. | Schedules |
| C. | Events |
| D. | All of the above. |
| Answer» E. | |
| 21. |
The Scheduler can pass an event-based job for the message content of the event that started the job. To pass an event-based job which of the following rules will be applied? |
| A. | The job must use a named program of type STORED_PROCEDURE |
| B. | One of the named programs arguments must be a metadata argument with metadata_attribute set to EVENT_MESSAGE |
| C. | The stored procedure that implements the program must have an argument at the position corresponding to the named programs metadata argument. The argument type must be the data type of the queue where your application queues the job-start event |
| D. | All mentioned above |
| Answer» E. | |
| 22. |
Select the correct method for creating jobs. |
| A. | Named Program |
| B. | Named Schedule |
| C. | Named Program and Schedule |
| D. | All mentioned above |
| Answer» E. | |
| 23. |
A chain can become stalled when no steps are running, no steps are scheduled to run, no event steps are waiting for an event, and the evaluation_interval for the chain is NULL. |
| A. | True |
| B. | False |
| Answer» B. False | |
| 24. |
Which scenario are the chains automatically disabled by the scheduler? |
| A. | The program that one of the chain steps points to is dropped |
| B. | The nested chain that one of the chain steps points to is dropped |
| C. | The event schedule that one of the chain event steps points to is dropped |
| D. | All mentioned above |
| Answer» E. | |
| 25. |
The disks in a disk group are referred to as ASM disks on Windows operating systems an ASM disk is always a partition, on all other platforms an ASM disk can be _________. |
| A. | A partition of a logical unit number (LUN) |
| B. | A network-attached file |
| C. | Both A & B |
| D. | None of the above |
| Answer» D. None of the above | |
| 26. |
Single-table hash cluster, provides fast access to rows in a table and this table must be the only table in the hash cluster. Essentially, there must be which mapping between hash keys and data rows? |
| A. | many-to-one mapping |
| B. | one-to-many mapping |
| C. | One-to-one mapping |
| D. | Both A & B |
| Answer» C. One-to-one mapping | |
| 27. |
To create a cluster index, one of the following conditions must be true? |
| A. | Your schema contains the cluster |
| B. | You have the CREATE ANY INDEX system privilege |
| C. | Your schema does not contain cluster |
| D. | Both A & B |
| Answer» E. | |
| 28. |
A _____________ is a set of tables physically stored together as one table that shares a common column. |
| A. | Index |
| B. | Object |
| C. | Datafiles |
| D. | Cluster |
| Answer» E. | |
| 29. |
What are the elements of the redo log buffer and Shared pool? |
| A. | PGA |
| B. | Buffer cache |
| C. | Both a and b |
| D. | SGA |
| Answer» E. | |
| 30. |
Which of these components forms a global database name? |
| A. | A database name |
| B. | A domain name |
| C. | Both A & B |
| D. | None of the above |
| Answer» D. None of the above | |
| 31. |
A session is INACTIVE when it is making a SQL call to Oracle Database. A session is ACTIVE if it is not making a SQL call to the database. |
| A. | True |
| B. | False |
| Answer» C. | |
| 32. |
A synonym is an alias for which object? |
| A. | Schema |
| B. | Segment |
| C. | Extents |
| D. | Rollback Segments |
| Answer» B. Segment | |
| 33. |
A system change number (SCN) is not an internal timestamp for a committed version of the database. |
| A. | True |
| B. | False |
| Answer» C. | |
| 34. |
RECO can use an existing connection or establish a new connection to other nodes involved in the failed transaction. When a connection is established, RECO automatically resolves all in-doubt transactions. |
| A. | True |
| B. | False |
| Answer» B. False | |
| 35. |
Applications should always _____________ commit or roll back transactions before program termination. |
| A. | Implicitly |
| B. | Explicitly |
| C. | Either of a and b |
| D. | None of the above |
| Answer» C. Either of a and b | |
| 36. |
Which parameter specifies the exported file containing the metadata for the tablespaces to be imported? |
| A. | TRANSPORT_DATAFILES |
| B. | DUMPFILE |
| C. | DIRECTORY |
| D. | REMAP_SCHEMA |
| Answer» C. DIRECTORY | |
| 37. |
The UNDO_RETENTION parameter in your database is set to 1000 and undo retention is not guaranteed. Which statement regarding retention of undo data is correct? |
| A. | Undo data becomes obsolete after 1,000 seconds |
| B. | Undo data gets refreshed after every 1,000 seconds |
| C. | Undo data will be stored permanently after 1,000 seconds |
| D. | Committed undo data would be retained for 1,000 seconds if free undo space is available |
| Answer» E. | |
| 38. |
Oracle Database provides a mechanism to make table structure modifications with significantly affecting the availability of the table. The mechanism is called online table redefinition. |
| A. | True |
| B. | False |
| Answer» C. | |
| 39. |
Which DBA System Privilege used for the operations authorized for drops a table in any schema? |
| A. | CREATE USER |
| B. | DROP USER |
| C. | BACKUP ANY TABLE |
| D. | DROP ANY TABLE |
| Answer» E. | |
| 40. |
Using PL/SQL Packages to Display Information About Schema Object Space Usage which Returns information about free data blocks in an object (table, index, or cluster) whose segment space management is AUTO? |
| A. | DBMS_SPACE.FREE_BLOCKS |
| B. | DBMS_SPACE.UNUSED_SPACE |
| C. | DBMS_SPACE.SPACE_USAGE |
| D. | None of the above |
| Answer» D. None of the above | |
| 41. |
A _____________ is a database object existing on multiple servers in a distributed database system. |
| A. | Replication object |
| B. | replica object |
| C. | replication groups |
| D. | Both A and C |
| Answer» B. replica object | |
| 42. |
What is the minimum size permitted for a redo log file? |
| A. | 10 MB |
| B. | 6 MB |
| C. | 8 MB |
| D. | 4 MB |
| Answer» E. | |
| 43. |
Which parameter uses all MANDATORY destinations plus some number of non-standby OPTIONAL destinations to determine whether LGWR can overwrite the online log? |
| A. | LOG_ARCHIVE_DEST_n |
| B. | LOG_ARCHIVE_MIN_SUCCEED_DEST=n |
| C. | Both A & B |
| D. | None of the above |
| Answer» C. Both A & B | |
| 44. |
Archived logs in RMAN backups are created in the flash recovery area. |
| A. | True |
| B. | False |
| Answer» B. False | |
| 45. |
While considering Costs and Benefits of Coalescing or Rebuilding Indexes which has lower costs and does not require more disk space? |
| A. | Coalesce Index |
| B. | Rebuild Index |
| C. | Both A & B |
| D. | None of the above |
| Answer» B. Rebuild Index | |
| 46. |
In ALTER TABLE Maintenance Operations for Table Partitions which maintenance operation partition is used by range, hash, list, composite(range/hash), composite(range/list) from the following? |
| A. | Coalescing Partitions |
| B. | Dropping Partitions |
| C. | Adding partitions |
| D. | Both A & B |
| Answer» D. Both A & B | |
| 47. |
In a distributed database environment, while coordinating with the database administrator to determine the best location for the data, which of these issues will be considered? |
| A. | Number of transactions posted from each location |
| B. | Amount of data (portion of table) used by each node |
| C. | Performance characteristics and reliability of the network |
| D. | All mentioned above |
| Answer» E. | |
| 48. |
Generic connectivity is to access non-oracle database data stores as long as the non-oracle database system supports the ODBC or OLE DB protocols. |
| A. | True |
| B. | False |
| Answer» B. False | |
| 49. |
After creating the chain object with CREATE_CHAIN, you define chain steps and chain rules separately. What is the correct argument which is set to NULL? |
| A. | Evaluation_interval |
| B. | Define_chain_step |
| C. | Define_chain_event |
| D. | Schedules |
| Answer» B. Define_chain_step | |
| 50. |
Which view shows the state of information on all jobs that are currently being run in the viewing Scheduler information? |
| A. | _scheduler_running_jobs |
| B. | *_scheduler_job_run_details |
| C. | _scheduler_windows |
| D. | scheduler_job_classes |
| Answer» B. *_scheduler_job_run_details | |