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
  • 1(01)* and (10)*1
  • x(xx)* and (xx)*x
  • (ab)* and a*b*
  • x+ and x*x+
Q2 | Which feature converts row data to a column for better analytical view?
  • views
  • join
  • pivot
  • trigger
Q3 | What is the default “SORT” order for a SQL?
  • ascending
  • descending
  • as specified by the user
  • none of the mentioned
Q4 | How inserting data through stored procedure do reduces network traffic and increase database performance?
  • stored procedure can accept parameter
  • permission check is not required
  • the execution plan is stored in the cache after it was executed the first time
  • none of the mentioned
Q5 | Stored procedures are safe from SQL injection attacks
  • true
  • false
  • depends on the result
  • always safe
Q6 | Which of the following connection type supports application role permissions and password encryption?
  • ole db
  • dblib
  • odbc
  • ole db and odbc
Q7 | Cursor that reflects the changes made to the database table even after the result set is returned
  • static
  • dynamic
  • forward_only
  • keyset
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
  • dependency preserving and lossless join
  • lossless join but not dependency preserving
  • dependency preserving but not lossless join
  • not dependency preserving and not lossless join
Q9 | Which one of the following statements about normal forms is FALSE?
  • bcnf is stricter than 3nf
  • lossless, dependency-preserving decomposition into 3nf is always possible
  • lossless, dependency-preserving decomposition into bcnf is always possible
  • any relation with two attributes is in bcnf
Q10 | Which of the following is TRUE?
  • every relation in 2nf is also in bcnf
  • a relation r is in 3nf if every non-prime attribute of r is fully functionally dependent on every key of r
  • every relation in bcnf is also in 3nf
  • no relation can be in both bcnf and 3nf
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
  • 1nf only
  • 2nf and hence also in 1nf
  • 3nf and hence also in 2nf and 1nf
  • bcnf and hence also in 3nf, 2nf and 1nf
Q12 |                                is a procedural extension of Oracle – SQL that offers language constructs similar to those in imperative programming languages.
  • sql
  • pl/sql
  • advanced sql
  • pql
Q13 |                        combines the data manipulating power of SQL with the data processing power of Procedural languages.
  • pl/sql
  • sql
  • advanced sql
  • pql
Q14 |                                has made PL/SQL code run faster without requiring any additional work on the part of the programmer.
  • sql server
  • my sql
  • oracle
  • sql lite
Q15 | A line of PL/SQL text contains groups of characters known as
  • lexical units
  • literals
  • textual units
  • identifiers
Q16 | We use                              name PL/SQL program objects and units.
  • lexical units
  • literals
  • delimiters
  • identifiers
Q17 | A                                        is an explicit numeric, character, string or Boolean value not represented by an identifier.
  • comments
  • literals
  • delimiters
  • identifiers
Q18 | If no header is specified, the block is said to be an                                PL/SQL block.
  • strong
  • weak
  • empty
  • anonymous
Q19 |                                    is a sequence of zero or more characters enclosed by single quotes.
  • integers literal
  • string literal
  • string units
  • string label
Q20 | In                                the management of the password for the account can be handled outside of oracle such as operating system.
  • database authentication
  • operating system authentication
  • internal authentication
  • external authentication
Q21 | In                                  of Oracle, the database administrator creates a user account in the database for each user who needs access.
  • database authentication
  • operating system authentication
  • internal authentication
  • external authentication
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?
  • only 1
  • only 2
  • both 1 and 2 individually
  • either 1 or 2
Q23 | A transaction is delimited by statements (or function calls) of the form                      
  • begin transaction and end transaction
  • start transaction and stop transaction
  • get transaction and post transaction
  • read transaction and write transaction
Q24 | Identify the characteristics of transactions
  • atomicity
  • durability
  • isolation
  • all of the mentioned
Q25 | Which of the following has “all-or-none” property?
  • atomicity
  • durability
  • isolation
  • all of the mentioned