Database Management System - Set 4
यस पेजमा प्रश्न 31–40 (कुल 49 मध्ये)। विकल्पमा थिचेर उत्तर दिनुहोस् — सही/गलत तुरुन्तै देखिन्छ।
- कुल प्रश्न49
- यो पेजमा10 (31–40)
- पृष्ठ4 / 5
- परीक्षा समय30 मिनेट
- जाँचतुरुन्तै
31.
'AS' clause is used in SQL for
उत्तर हेर्नुहोस् (Show answer)
सही उत्तर: B. Rename operation
32.
DML is provided for
उत्तर हेर्नुहोस् (Show answer)
सही उत्तर: C. Manipulation & processing of database system
33.
Which are the physical structures that constitute the oracle database ?
उत्तर हेर्नुहोस् (Show answer)
सही उत्तर: D. All of the these
34.
What is the type of oracle backup in which all uncommitted changes have been removed from the Data files ?
उत्तर हेर्नुहोस् (Show answer)
सही उत्तर: B. Consistent backup
35.
Which privilege is required to create a database ?
उत्तर हेर्नुहोस् (Show answer)
सही उत्तर: A. SYSDBA
36.
When is the SGA created in an oracle database environment ?
उत्तर हेर्नुहोस् (Show answer)
सही उत्तर: A. When the database is created
37.
What type of failure occurs when oracle fails due to an operating system or computer hardware failure ?
उत्तर हेर्नुहोस् (Show answer)
सही उत्तर: B. Instance Failure
38.
For which two constraints are indexes created `when the constraint is added ?
उत्तर हेर्नुहोस् (Show answer)
सही उत्तर: D. d. Both (a) and (b)
39.
Which statements are used to UNLOCK the user ?
उत्तर हेर्नुहोस् (Show answer)
सही उत्तर: C. Alter user Scott account unlock
40.
Which type of file is part of the oracle database ?
उत्तर हेर्नुहोस् (Show answer)
सही उत्तर: A. Control file
पृष्ठ 4 / 5 · प्रश्न 31–40 (कुल 49)

