Database Management System MCQs
749+ questions with answers
Which view that contains more than one table in the top-level FROM clause of the SELECT statement:
Pictorial representation of an expression is called
The results of each intermediate operation are created and then are used for evaluation of the next-level operations. This is called
______________ allows the algorithm to execute more quickly by performing CPU activity in parallel with I/O activity.
In a _________ the system makes repeated requests for tuples from the operation at the top of the pipeline.
In a _____________ operations do not wait for requests to produce tuples, but instead generate the tuples eagerly.
The iterator maintains the __________ of its execution in between calls so that successive next() requests receive successive result tuples.
Tuples are generated ___________ in producer-driven pipelining, they are generated ________ on demand, in demand-driven pipelining.
When two inputs that we desire to pipeline into the join are not already sorted it is the _____________ technique.
Consider the following relational schemes for a library database: Book (Title, Author, Catalog_no, Publisher, YEAR, Price) Collection (Title, Author, Catalog_no) WITH the following functional dependencies: I. Title Author -> Catalog_no II. Catalog_no -> Title Author Publisher YEAR III. Publisher Title YEAR -> Price
Let R(A,B,C,D,E,P,G) be a relational schema in which the following FDs are known to hold: AB->CD DE->P C->E P->C B->G
Which of the following is/are false for RAW mode of FOR XML?
___________ refers to the ability of the system to recover committed transaction updates if either the system or the storage media fails.
Which utilities can we use to export data from sql server to a text file?
Problems occurs if we don’t implement a proper locking strategy
Which of the following fixed database roles can add or remove user IDs?
By default sql server has ___________ isolation level
Which of the following pair of regular expression are not equivalent?
Which feature converts row data to a column for better analytical view?
Which of the following statements is/are not true for SQL profiler?
Which global variables can be used to determine if a transaction is still open?
Which statement is used to define a cursor?
What is the default “SORT” order for a SQL?
Capabilities of RAISERROR
Stored procedures are safe from SQL injection attacks
Which of the following connection type supports application role permissions and password encryption?
Cursor that reflects the changes made to the database table even after the result set is returned
Which normal form is considered adequate for normal relational database design?
Consider a schema R(A, B, C, D) and functional dependencies A -> B and C -> D. Then the decomposition of R into R1 (A, B) and R2(C, D) is
Relation R with an associated set of functional dependencies, F, is decomposed into BCNF. The redundancy (arising out of functional dependencies) in the resulting set of relations is
Which one of the following statements about normal forms is FALSE?
A table has fields F1, F2, F3, F4, and F5, with the following functional dependencies: F1->F3 F2->F4 (F1,F2)->F5
Consider the following functional dependencies in a database. Date_of_Birth->Age Age->Eligibility Name->Roll_number Roll_number->Name Course_number->Course_name Course_number->Instructor (Roll_number, Course_number)->Grade
The relation schema Student_Performance (name, courseNo, rollNo, grade) has the following FDs: name,courseNo->grade rollNo,courseNo->grade name->rollNo rollNo->name
The relation EMPDT1 is defined with attributes empcode(unique), name, street, city, state, and pincode. For any pincode, there is only one city and state. Also, for any given street, city and state, there is just one pincode. In normalization terms EMPDT1 is a relation in
Which one of the following statements is FALSE?
_______________ is a procedural extension of Oracle – SQL that offers language constructs similar to those in imperative programming languages.
___________ combines the data manipulating power of SQL with the data processing power of Procedural languages.
_______________ has made PL/SQL code run faster without requiring any additional work on the part of the programmer.
A line of PL/SQL text contains groups of characters known as
We use ______________ name PL/SQL program objects and units.
A ___________________ is an explicit numeric, character, string or Boolean value not represented by an identifier.
_________________ is a sequence of zero or more characters enclosed by single quotes.
In _______________ the management of the password for the account can be handled outside of oracle such as operating system.
In ________________ of Oracle, the database administrator creates a user account in the database for each user who needs access.
Consider money is transferred from (1)account-A to account-B and (2) account-B to account-A. Which of the following form a transaction?
A transaction is delimited by statements (or function calls) of the form __________
Identify the characteristics of transactions
Which of the following has “all-or-none” property?