Oracle MCQ Questions Answers

1. In the odbc architecture, a(n) _____ is in charge of managing all database connections.

2. The column definition of number(7, 4) indicates a precision of ____.

3. In a(n) ____ cluster, every server in the cluster performs useful work.

4. Columns in a database table contain data with the same _________:

5. In oracle, dates have the format ____.

6. An index can be created ____.

7. WebLogic provides various options for deploying applications:

8. Which web application modules can run on a weblogic server?

9. Which of the following are WebLogic Server deployment tools?

10. Which EJB modules can run on a weblogic server?

11. What platform is weblogic based on?

12. Which file contains the configuration information about the entire WebLogic Server domain?

13. Does WebLogic support multi threading applications?

14. How does weblogic provide performance and scalability of applications in production?

15. What is the WebLogic workshop used for?

16. How many types of containers does the weblogic server have?

17. A system change number (SCN) is not an internal timestamp for a committed version of the database.

18. The database uses SCNs to coordinate distributed transactions among different databases. The database uses SCNs in which of the following ways?

19. Distributed transactions can become in-doubt in which of the following way?

20.

Which of the following performs the following operations during a distributed transaction?

1) Sends all of the distributed transaction SQL statements, remote procedure calls, and so forth to the directly referenced nodes, thus forming the session tree.

2) Instructs all directly referenced nodes other than the commit point site to prepare the transaction.

3) Instructs the commit point site to initiate the global commit of the transaction if all nodes prepare successfully.

21. When a node is told to prepare, it can respond in several ways, one of the ways is “no data on the node has been or can be modified, so no preparation is necessary”. This response is called as?

22. Which of the following are supported by transaction control statements?

23. If all statements of a transaction reference to only a single remote node, then the transaction is remote and it is not distributed.

24. Select the correct case for which only queries are issued at one or more nodes.

25. Which condition is applied while determining the commit point site?

26. In the session tree what is the role that has a node which is forced to reference data on other nodes to complete its part of the transaction.

27. In Referencing a Sequence with each new sequence number is generated by a reference to the sequence pseudocolumn?

28. Which is a database objects from which multiple users can generate unique integers?

29. OPTION clause and these statements are not permitted?

30. You cannot use an ALTER VIEW statement to change the definition of a view, you can replace views in the following which of the ways?

31.

A sequence is referenced in SQL statements with the NEXTVAL and CURRVAL pseudocolumns, which can be used in the following places

1) VALUES clause of INSERT statements

2) The SELECT list of a SELECT statement

3) The SET clause of an UPDATE statement

32. In UPDATABLE_COLUMNS VIEWS which view Shows all columns in all tables and views accessible to the user that are modifiable?

33. To create a private synonym in another user's schema, you must have which privilege from the following?

34. When a view is dropped, all grants of corresponding object privileges are revoked from roles and users. After the view is re-created, privileges must be regranted?

35. You can also create views that specify more than one base table or view in the FROM Clause. These are called join views?

36. The rules for updatable join views in which rule Any INSERT, UPDATE, or DELETE operation on a join view can modify only one underlying base table at a time?

37. Data files of which tablespaces can be recovered by performing an open recovery?

38. Identify the common Dynamic Performance views which are accessible in NOMOUNT stage?

39. You require the Oracle server to manage the undo segments and space among various active sessions automatically. You created an undo tablespace, UNDO_TBS1, in your database. Which two additional steps would you perform to achieve this?

40. The Database Resource Manager directive UNDO_POOL allows DBAs to limit the amount of undo space consumed by a group of users?

41. Which three pieces of information are considered while deciding the size of the undo tablespace in your database?

42. In the following which is the default permanent tablespace?

43. The switch operation waits for transactions in the old undo tablespace to commit?

44. Which two statements about Flashback Query are true?

45. Which two operations can be flashed back using the Flashback technology?

46. In viewing information about undo which view is useful for monitoring the effects of transaction execution on undo space in the current instance?

47. In which parameter used in the CREATE DATABASE statement determines the maximum number of groups of redo log files for each database?

48. When speaking in the context of multiple database instances, the redo log for each database instance is also referred to as a?

49. Which mode protects a database from instance failure but not from media failure?

50. In Redo Log Information which view Identifies redo log groups and members and member status?

51. The minimum size permitted for a redo log file is?

52. Redo log files that are no longer required for instance recovery are called?

53. A log switch is the point at which the database starts writing to one redo log file and begins writing to another?

54. Which of these statements overcomes two situations where dropping redo logs is not possible?

55. Which log shows the following statement? ALTER SYSTEM SWITCH LOGFILE;

56. If the ARCHIVE_LAG_TARGET initialization parameter is set to a very low value, there can be which impact on performance?

57. A set of bitmap blocks has media corruption which tasks call the procedure, either on all bitmap blocks, or on a single block if only one is corrupt?

58. In Viewing Tablespace Information which view gives Information for all extents in all locally managed temporary tablespaces?

59. A transportable tablespace set consists of datafiles for the set of tablespaces being transported and an export file containing structural information (metadata) for the set of tablespaces we use?

60. You can use transportable tablespaces to perform tablespace point-in-time recovery (TSPITR)?

61. To create a new tablespace, we use the SQL statement?

62. Transporting tablespaces with XMLTypes has the following additional limitations?

63. Which utility ensure that the CONSTRAINTS and TRIGGERS parameters are set to Y the default?

64. In Viewing Tablespace Information which view shows the Name and number of all tablespaces from the control file?

65. The DBMS_SPACE_ADMIN package provides maintenance procedures for locally managed tablespaces?

66. AUTOALLOCATE causes the tablespace to be system managed with a minimum extent size of 6K?

67. Which method enables you to add rows to a table, either by specifying the column values or by specifying a subquery that selects data from another existing table?

68. Which type of table is a group of tables that share the same data blocks because they share common columns and are often used together?

69. A Synonym is another name for an object. It is used to simplify access to objects such as tables owned by another user or to shorten lengthy object name?

70. If START_REDEF_TABLE fails for any reason, you must call ABORT_REDEF_TABLE, otherwise subsequent attempts to redefine the table will fail?

71. In Viewing and querying Objects in the recycle bin which view gives administrators visibility to all dropped objects in the recycle bin?

72. For external tables which privileges are required for directory objects containing bad, log, or discard files?

73. The NOLOGGING clause causes minimal redo information to be generated during the table creation this has which of the benefits?

74. All data in a database is stored in a table to include user data and the Data Dictionary?

75. In which INSERT operation the database reuses free space in the table, interleaving newly inserted data with existing data. During such operations, the database also maintains referential integrity constraints?

76. 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?

77. 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?

78. DBMS_ADVISOR package procedures relevant to the segment advisor which package procedure name Use this procedure to create the Segment Advisor task. Specify 'Segment Advisor ‘as the value of the ADVISOR_NAME parameter?

79. In the AFTER SUSPEND trigger whenever a resumable statement is suspended in any session, this trigger can have which effects?

80. In a distributed transaction, sessions or remote instances are suspended only if RESUMABLE has been disabled in the remote instance?

81. INITRANS specifies the number of update transaction entries for which space is initially reserved in the data block header?

82. In the following which errors are correctable?

83. In Managing Tablespace Alerts which way is used to specify alert thresholds for both locally managed and dictionary managed tablespaces?

84. Storage parameters of an index segment created for the index used to enforce a primary key or unique key constraint can be set in either of the following ways?

85. In DBMS_RESUMABLE Package which function returns the current timeout value of resumable space allocation for the current session. The returned value is in seconds?

86. As for SQL*Loader, a command line parameter controls whether statements are resumable after recoverable errors in which operations?

87. In which partition this form of composite partitioning is well suited for historical data, but lets you further group the rows of data based on unordered or unrelated column values?

88. You cannot drop the only partition in a table. Instead, you must drop the table?

89. You can compress some or all partitions of a B-tree index using key compression. Key compression is applicable only to B-tree indexes?

90.

In the following example the index-organized table, sales, is partitioned by which method?

CREATE TABLE sales(acct_no NUMBER(5),

acct_name CHAR(30),

amount_of_sale NUMBER(6),

week_no INTEGER,

sale_details VARCHAR2(1000),

PRIMARY KEY (acct_no, acct_name, week_no))

ORGANIZATION INDEX

INCLUDING week_no

OVERFLOW

PARTITION BY HASH (week_no)

PARTITIONS 16

STORE IN (ts1, ts2, ts3, ts4)

OVERFLOW STORE IN (ts3, ts6, ts9);

91. The rules for creating range-partitioned global indexes are similar to those for creating range-partitioned tables?

92. How many partitioning keys columns are specified for range-and-hash-partitioning tables?

93. 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?

94. To create which partitions you specify the following?

95. While Using the MOVE PARTITION clause of the ALTER TABLE statement to?

96.

Which of the following operations support the UPDATE INDEXES clause?

A)The following operations support the UPDATE INDEXES clause:

97. Select the correct SQL statement for disabling recovery.

98. A DML statement that requires locks on a remote database can be blocked if any another transaction own locks on the requested data. If these locks continue to block the requesting SQL statement then which sequence of events occurs?

99. Give the exact reason for which you can force the failure of a distributed transaction.

100. The job of the commit point site is to initiate a commit or roll back operation as instructed by _____________.