Database Management System Set 24

Computer Science Engineering (CSE),

Bachelor of Science in Computer Science FY (BSc CS),

Bachelor of Science in Computer Science SY (BSc CS),

Bachelor of Science in Information Technology SY (BSc IT),

Bachelor of Computer Applications (BCA),

Bachelor of Business Administration in Computer Applications (BBA [CA]),

Bachelor of Science in Information Technology (BSc IT),

Bachelor of Science in Computer Science (BSc CS),

Master of Business Administration (MBA)

Learning Mode Previous Next
On This Page

This set of DataBase Management System (DBMS) Multiple Choice Questions & Answers (MCQs) focuses on Database Management System Set 24

Q1 | Which of the following pair of regular
Q2 | Which feature converts row data to a column for better analytical view?
Q3 | What is the default “SORT” order for a SQL?
Q4 | How inserting data through stored procedure do reduces network traffic and increase database performance?
Q5 | Stored procedures are safe from SQL injection attacks
Q6 | Which of the following connection type supports application role permissions and password encryption?
Q7 | Cursor that reflects the changes made to the database table even after the result set is returned
Q8 | 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
Q9 | Which one of the following statements about normal forms is FALSE?
Q10 | Which of the following is TRUE?
Q11 | 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
Q12 |                                is a procedural extension of Oracle – SQL that offers language constructs similar to those in imperative programming languages.
Q13 |                        combines the data manipulating power of SQL with the data processing power of Procedural languages.
Q14 |                                has made PL/SQL code run faster without requiring any additional work on the part of the programmer.
Q15 | A line of PL/SQL text contains groups of characters known as
Q16 | We use                              name PL/SQL program objects and units.
Q17 | A                                        is an explicit numeric, character, string or Boolean value not represented by an identifier.
Q18 | If no header is specified, the block is said to be an                                PL/SQL block.
Q19 |                                    is a sequence of zero or more characters enclosed by single quotes.
Q20 | In                                the management of the password for the account can be handled outside of oracle such as operating system.
Q21 | In                                  of Oracle, the database administrator creates a user account in the database for each user who needs access.
Q22 | 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?
Q23 | A transaction is delimited by statements (or function calls) of the form                      
Q24 | Identify the characteristics of transactions
Q25 | Which of the following has “all-or-none” property?
Previous Next