ResultJob

Time

Email Us

admin@resultjob.com

Database Management System Question

Database Management System Question With Answer & Solution

Que. - In which scenario would you use the ROLLUP operator for expression or columns within a GROUP BY clause?

(A) to ﬁnd the groups forming the subtotal in a row

(B) to create group-wise grand totals for the groups speciﬁed within a group by clause

(C) to create a grouping for expressions or columns speciﬁed within a group by clause in one direction, from right to left for calculating the subtotals

(D) to create a grouping for expressions or columns speciﬁed within a group by clause in all possible directions, which is cross- tabular report for calculating the subtotals

Que. - Which statement is true regarding external tables?

(A) the default reject limit for external tables is unlimited

(B) the data and metadata for an external table are stored outside the database

(D) the create table as select statement can be used to unload data into regular table in the database from an external table

Que. - SNAPSHOT is used for (DBA)

(A) synonym

(B) tablespace

(D) dynamic data replication

Que. - Isolation of the transactions is ensured by

(A) transaction management

(B) application programmer

(D) recovery management

Que. - Which of the following statements is/are not true for SQL proﬁler?

(A) enables you to monitor events

(B) check if rows are being inserted properly

(D) all of the mentioned

Que. - Which of the following is the original purpose of SQL?

(A) to specify the syntax and semantics of sql data deﬁnition language

(B) to specify the syntax and semantics of sql manipulation language

(D) all of the mentioned

Que. - SQL can be used to:

(A) create database structures only

(B) query database data only

(D) all of the mentioned

Que. - A lock that allows concurrent transactions to access diﬀerent rows of the same table is known as a

(A) database-level lock

(B) table-level lock

(D) row-level lock

Que. - Which of the following are introduced to reduce the overheads caused by the log- based recovery?

(A) checkpoints

(B) indices

(D) locks

Que. - Which of the following protocols ensures conﬂict serializability and safety from deadlocks?

(A) two-phase locking protocol

(B) time-stamp ordering protocol

(D) none of the mentioned

Showing 771 To 780 of 1293 results

Result Job

ResultJob.com एक ऐसा प्लेटफ़ॉर्म है जो वर्तमान सामान्य ज्ञान (GK) प्रश्नों, नौकरी के अवसरों, परीक्षा संसाधनों और शैक्षिक उपकरणों से संबंधित जानकारी प्रदान करता है। यह उपयोगकर्ताओं को उनकी परीक्षा की तैयारी और करियर की तलाश में सहायता करने के लिए प्रश्न पत्र, टेस्ट सीरीज़ और टाइपिंग टेस्ट जैसी कई श्रेणियाँ प्रदान करता है।

ResultJob

Time

Email Us

Database Management System Question With Answer & Solution

Question Categories

Question Category Name

Get In Touch

Popular Links

Useful Links

Result Job