Download Oracle Databases 11g MCQ's and more Exams Database Management Systems (DBMS) in PDF only on Docsity!
DBA McQs for final term
- DML always executes as part of a transaction a. insert b. update c. delete d. merge e. ALL OF THE ABOVE
Ans =e
undo contain what type of data (a) original ( b)premodefied(c) both(d) none ans=b
undo old data are present in (a)Undo table space (b)redo log file (c)data in buffer cache (d)redo log buffer Ans=a 4)new change detail are present in (a)Undo table space (b)redo log file (c)data in buffer cache (d)redo log buffer Ans=b 5)each transection is assigned to ___undo segments (a)1(b)2(c)3(d)
Ans=a
- an udo segment can service ___at time
(a)one (b)more than one (c)have no transition(d)depends on redo Ans=b
- which operation can cause a transection to use more than one undo segment (a)DML (b)DDL(c)both (d)insert Ans=c
- by which command you can check which transection are assigned to which undo segment (a)V$ transection (b)v$ insistence (c)both (d)none Ans=a
- undo segment has ___buffer (a)rectangular (b)circular(c)incremental(d)diagonal Ans=b 10)table space can be recover only while the instant is in following state (a)mount (b)update (c)redo (d)log Ans=a
- each undo act as ____buffer (a)simple buffer (b)liner buffer(c)circular buffer d)both b&c Ans=c 12)undo segment contain ____minimum extent
(a)unexpird undo information(b)expire undo information(c)both (d)none of these Ans=a 19)if a transection generate more undo than there is space than the it will (a)roll back (b)gives error (c)ask for information(d)fail Ans=d 20)which undo information over written when space required by active transaction (a)expird undo information (b)committed undo information (c)un committed undo information(d)unexpired undo information Ans=a 21)which undo retention is needed to meet undo retention interval (a)expired undo information (b)committed undo information (c)un committed undo information(d)none ofe these(e)ab&c Ans=b 22undo data retain attend the time for which it is retain depend on (a)data base activity (b)data base configuration (c)table space configuration(d) a&b (e)b&c Ans=d 23)undo table space show the table space size
(a)in mb by day of month(b)in mb by day of month (c)in mb by day of month (d)none Ans=a
- – Data manipulation language (DML) consists of the SQL statements:
(a)insert (b)update (c)delete (d)merge (e)ALL OF THE ABOVE
Ans=e
- Undo data is.
a. A copy of original, premodified data b. Original data c. Only modified data d. Recovered data Ans=a
- DML always executes as part of a transaction, which can be Committed using. a) ROLLBACK command (b)COMMIT command
(a) Are used only for undo segments (b)Have special recovery considerations
1.The DBA and the administration must be a. at same place b. at different place c.within same place d.within same server ans: b 2.which permits outgoing network connection to be established by the database server to any receiveing or waiting network service a.UTL_SMTP b.UTL_HTTP c.UTL_TCP d.UTL_FILE
ans: c 3.which allows the database server to request and retrieve data a.UTL_SMTP b.UTL_HTTP c.UTL_TCP d.UTL_FILE ans: b
4.which is properly configured when the package limit user, accesses to specific directory location a.UTL_SMTP b.UTL_HTTP c.UTL_TCP d.UTL_FILE ans: d
5.which is improperly configured which allows text level access to any file on the host operating system a.UTL_SMTP b.UTL_HTTP c.UTL_TCP d.UTL_FILE
ans=d
6.when the password file is used to authenticate the previliged user
a.remote connection b.local connection c.both d.none ans: a
7.when does the user is authenticated by the local operating system a.remote connection b.local connection c.both d.none ans: b
8.when does the database is created by using DCA (database configuration assistant) a. case sensitive b.non-case sensitive c. both d.none
ans: a
9.which auditing is by default a.mandatoy b.standard c.value-based d.fine grained ans: a
10.which captures not only audited event that occurred but also the actual file
ans: d
- How can we change the block size of database after database creation? a. Re-creating the database. b. Directly changing oracle data block c. Resizing table space d. None Ans. a
- In block header, the size of transaction slots is: a. 18 bytes each b. 24 bytes each c. (^) 20 bytes each d. 120bits each
Ans. B
- Free space is in the middle of the block, the header and the row data is enabled for: a. For increasing the storage capacity b. For the data inconsistency. c. For error removal.
d. Space to grow when necessary. Ans. d
- The Oracle database stores data: a. physically in tablespaces and logically in data files b. logically in data blocks and physically in oracle server c. Logically in tablespaces and physically in data files. d. A and c
Ans. c
- A bitmap is used to record a. Block headers managed by user b. free extents managed by oracle c. row data d. all of above
Ans. b
- You can easily view the logical structures of your database: a. through oracle server b. through listener c. both a and b d. through Enterprise Manager (EM) Ans. d
- The extents of a locally managed tablespace are managed efficiently in the tablespace by:
c. free spaces d. both b and c
Ans. C
- No of files the tablespace must have: a. four b. one c. ten d. (^) zero Ans. B
- ________ tablespaces are supported only for backward compatibility. a. Dictionary managed tablespaces b. Locally managed tablespaces c. Both a and b d. None.
Ans. A
- Permanent tablespaces store _________ database objects that are created by the system or users. a. Temporary b. Arbitrary c. Configuring d. Permanent
Ans. d
- Data files can belong to only: a. Three tablespaces and one database b. one tablespace and one database c. one segment and one database d. none
Ans. b
- In Enterprise Manager (EM), you can see a pie chart of the contents of ________ tablespace. a. SYSTEM tablespace b. Logical tablespace c. SYSAUX tablespace d. Both a and c
Ans. c
- ___________ tablespace contains the sample schemas that can be installed when you create the database. a. UNDOTBS b. USERS c. EXAMPLE d. TEMP
Ans. c
- A tablespace can be in one of________ different states.
b. Read Only c. Both a and b d. None Ans. A
- Locally managed tablespaces will increase the performance. a. True b. False
Ans. a
- __________ action of tablespace shows objects on which this tablespace depends, or objects that depend on this tablespace. a. Run Segment Advisor b. Show Dependencies c. Show Tablespace Contents d. Take Offline
Ans. B
- You must have the DROP TABLESPACE system privilege to drop a tablespace. a. Yes b. No c. None of above Ans. A
- DB_CREATE_FILE_DEST describes:
a. Defines the location of the default file system directory for data files and temporary files b. Defines the location for redo log files and control file creation c. Default location for the flash recovery area d. Both A and C
Ans. A
- You can enlarge the database by: a. Adding a data file to an existing tablespace b. Adding a log file into an existing tablespace c. Adding a redo log file d. All Ans. a
- Automatic storage management is a portable and
cluster file system. a. Low performance b. Normal performance c. Ordinary performance d. High performance
Ans. d
- ASM is _____________. a. separate file system
Ans. d
- The merge command is used to perform commands: a) Shut down database b) update database c) insert and update data base d) none of these (C)
- Pl/sql language supports which technique. a) probability of errors b) instance start up c) both a & c d) object oriented.
(d)
- Locks are automatically obtained for a given statement at : a) first level b) highest level c) lowest level d) all of above. (C)
- Each DML transaction must acquire. a) Two locks b) four locks c) no need for locks d) one lock. (a)
- Procedures pass values in and out by using. a) data list b) control files c) redo log files d) argument list. (d)
- Describe command Is used to view. a) Details of a session b) details of a statement c) sub programs details d) all of above.
(C)
- Locks held until the transaction ends with commit or role back. a) true b) false. (a) 8.Enqueue mechanism keeps track of.
a) session waiting for locks b) requested lock mode c) both a & b d)none of these. (c)
- Which of these is not a pl/sql database object. a) type body b) trigger c) procedure d) schema.
(d)
- Packages are collections of functions and schema. a) true b) false. (b) 11.Pick up a database event. a) create b) delete c) revoke d) start up. (d) 12.Pick up a DDL event. a) insert b) server error c) suspend d) grant. (d) 13.Package body fully defines following terms.
