Relational Database Management System MCQ : Relational Database Design - Views : Link4

RDBMS MCQ : Relational DB Design - Views : Link4

RDBMS MCQ & Answers

       Are you worried about the answers to Relational Database Management System questions-Relational Database Design : Views problems? We have arranged the Show Answer button under the each question. Candidates can click on it to know the right option among the given alternatives. Furthermore, the applicants can check our web portal @ www.totalmcq.com to take part in more MCQ on various subject. Wish, the given information about the Relational Database Management System MCQ will helpful to the advance and can learn the various types of questions and answers.

Q.1. Which one is not applicable while querying on a view?

A. From
B. SELECT
C. Order By
D. Where

Q.2. Refer below query which leads to create a view named employee.
CREATE worker VIEW
AS
SELECT nothing
FROM dbo.Employee
WHERE ID < 100
Which of the following statement is true about the above view.

A. Above query is correct.
B. View name must be after keyword view and ‘nothing’ is not a keyword , so should be replaced with *.
C. Replace nothing with view name.
D. Replace nothing with column names.

Q.3. How can you drop more than one View in single command?

A. Drop viewname1 + viewname2 + viewname(n);
B. Drop viewname1; Drop viewname2; Drop viewname(n);
C. Drop viewname1; viewname2; viewname(n);
D. Drop viewname1, viewname2,viewname(n);

Q.4. Which of the following statements is true about views

A. View never references actual table for which it is created.
B. View can’t use JOIN in it’s query.
C. The performance of the view degrades if they are based on other views.
D. Only option to safeguard data integrity.

Q.5. What is a view?

A. A view is a special stored procedure executed when certain event occurs
B. A view is a virtual table which results of executing a pre-compiled query
C. A view is a database diagram
D. None of the Mentioned

Q.6. Which of the following is not a limitation of view?

A. ORDER BY Does Not Work
B. Index Created on View Used Often
C. Cross Database Queries Not Allowed in Indexed View
D. Adding Column is Expensive by Joining Table Outside View

Q.7. Views are also called as ----------.

A. Complex tables                              B. Simple tables
C. Virtual tables                                            D. Actual Tables

Q.8. Syntax for creating views is -------

A. CREATE VIEW view_name AS SELECT
B. CREATE VIEW view_name AS UPDATE
C. CREATE VIEW AS UPDATE
D. DROP VIEW view_name AS SELECT

Q.9. Delete a view using ------ command.

A. DROP VIEW
B. REMOVE VIEW
C. TRUNCATE VIEW
D. DELETE VIEW

Q.10. What is SCHEMABINDING VIEW?

A. Schema binding binds your views to the dependent physical columns of the accessed tables specified in the contents of the view
B. These are stored only in the Master database
C. These types of view are defined by users on a specified schema
D. These are used to show database self describing information

Relational Database Management System MCQ : Relational Database Design - Controlling the program flow : Link3

RDBMS MCQ : Relational DB Design - Controlling the program flow, conditional statements, loops : Link3

RDBMS MCQ & Answers

       Are you worried about the answers to Relational Database Management System questions-Relational Database Design : Controlling the program flow, conditional statements, loops problems? We have arranged the Show Answer button under the each question. Candidates can click on it to know the right option among the given alternatives. Furthermore, the applicants can check our web portal @ www.totalmcq.com to take part in more MCQ on various subject. Wish, the given information about the Relational Database Management System MCQ will helpful to the advance and can learn the various types of questions and answers.

Q.1. Which of the following is not true about labeling PL/SQL loops?

A. PL/SQL loops can be labeled.
B. The label should be enclosed by angle brackets (< and >).
C. The label name appears at the beginning of the LOOP statement.
D. The label name can also appear at the end of the LOOP statement or with an EXIT statement.

Q.2. What is the initial value of index for a reverse for loop?

A. UPPER bound
B. Lower bound
C. 1
D. Upper bound-Lower bound/2

Q.3. Which of the following is not true about PL/SQL decision making structures?

A. The IF statement associates a condition with a sequence of statements enclosed by THEN and END IF.
B. The IF statement also adds the keyword ELSE followed by an alternative sequence of statement.
C. The IF-THEN-ELSIF statement allows you to choose between several alternatives.
D. PL/SQL does not have a CASE statement.

Q.4. Which of the following statements can be used to terminate a PL/SQL loop?

A. GOTO                                                                           B. EXIT WHEN
C. KILL                                                                                 D. CONTINUE WHEN

Q.5. Which of the following is equivalent to multiple IF-ELSIF statements?

A. LOOP statement
B. FOR statement
C. CASE statement
D. WHILE statement

Q.6. How many ELSE clauses can an IF statement have?

A. 0 or 1
B. Always 1
C. 1 or 2
D. 1 to 10

Q.7. For which Exception, if a SELECT statement attempts to retrieve data based on its conditions, this exception is raised when no rows satisfy the SELECT criteria?

A. TOO_MANY_ROWS                              B. NO_DATA_FOUND
C. VALUE_ERROR                                            D. DUP_VAL_ON_INDEX

Q.8. Which of the following is true about PL/SQL program?

A. PL/SQL programs can exist with or without any SQL statements.
B. PL/SQL programs can exist only with any SQL statements.
C. PL/SQLprograms can exist only without any SQL statements.
D. SQL programs can exist only with PL/SQL statements.

Q.9. How many parts of a PL/SQL block are optional?

A. 1
B. 2
C. 3
D. 0

Q.10. What is an anonymous block in PL/SQL?

A. A PL/SQL unit without decalarationA
B. PL/SQL unit without a body to execute
C. A PL/SQL unit without an exception handler
D. A PL/SQL unit without a name

Q.11. How does an execution block start and end in PL/SQL?

A. Starts with START and ends with END
B. Starts with BEGIN and ends with END
C. Starts with START and ends with ; (semi colon)
D. Starts with BEGIN and ends with ; (semi colon)

Q.12. How can a PL/SQL block be executed?

A. By using a semi colon at the end.
B. By using a colon at the end.
C. By using a slash (/)at the end.
D. By pressing "Enter"

Q.13. Which command should be used to turn on the output of PL/SQL commands in SQL*Plus?

A. set serveroutput on                                     B. showserveroutput on
C. set output on                                    D. set PL/SQL on

Q.14. What is a package in PL/SQL?

A. A package is a named PL/SQL unit stored in the database to perform action based on an event.
B. A package is an anonymous block in PL/SQL.
C. A package is a schema object that groups logically related PL/SQL objects.
D. A package is a subprogram in the database.

Q.15. What are composite variables in PL/SQL?

A. Variables having internal components                                     B. Native datatypes
C. Scalar variables                                               D. User defined datatypes

Relational Database Management System MCQ : PL/PgSqL: Datatypes, Language structure : Link2

Relational Database Management System MCQ : Relational Database Design - PL/PgSqL: Datatypes, Language structure : Link2

RDBMS MCQ & Answers

       Are you worried about the answers to Relational Database Management System questions-Relational Database Design : PL/PgSqL: Datatypes, Language structure? We have arranged the Show Answer button under the each question. Candidates can click on it to know the right option among the given alternatives. Furthermore, the applicants can check our web portal @ www.totalmcq.com to take part in more MCQ on various subject. Wish, the given information about the Relational Database Management System MCQ will helpful to the advance and can learn the various types of questions and answers.

Q.1. Which of the following is true about scalar data types in PL/SQL?

A. They hold single values with no internal components.
B. Examples of scalar data types are NUMBER, DATE, or BOOLEAN.
C. PL/SQL provides subtypes of data types.
D. All of the above

Q.2.Which of the following is not true about PL/SQL constants and literals?

A. A constant holds a value that once declared, does not change in the program.
B. The CONSTANT declaration cannot impose the NOT NULL constraint.
C. A constant is declared using the CONSTANT keyword.
D. A CONSTANT declaration requires an initial value.

Q.3. What value will be assigned to the variable declared as − counter binary_integer;

A. 0                                                                                 B. 1
C. NULL                                                                                  D. None of the above

Q.4. Which of the following is explicit numeric, string, or BOOLEAN value not represented identifier?

A. Delimiters                                                                           B. Literals
C. Comments                                                                                 D. None of the above

Q.5. Which of the following is not true about large object data types and in PL/SQL?

A. BFILE is used to store large binary objects in operating system files outside the database.
B. BLOB is used to store character data in the database.
C. CLOB is used to store large blocks of character data in the database.
D. NCLOB is used to store large blocks of NCHAR data in the database.

Q.6. Which of the following is true about comments in PL/SQL?

A. Comments are explanatory statements.
B. The PL/SQL single-line comments start with the delimiter — (double hyphen)
C. Multi-line comments are enclosed by /* and */.
D. All of the above.

Q.7. Which is a simple or compound symbol that has a special meaning to PL/SQL?

A. Delimiters                              B. Identifiers
C. Literals                                            D. Comments

Q.8. PL/SQL is a procedural language that has which of the following advantages?

A. Integration with database                                                             B. Better Performance
C. Portability                                                             D. All of the above

Q.9. Which data type supports only sequential access of objects?

A. LONG
B. LOB
C. Both A & B
D. None of the above

Q.10. Is it possible to define a CONSTANT value in a record?

A. Yes                                                                                       B. No
C. Depends upon                                                                                       D. None of the above

Q.11. Which datatypes can be used with a RECORD Type?

A. NUMBER,VARCHAR2                                B. %TYPE OR %ROWTYPE
C. BOTH A & B                                           D. REF,CURSOR

Q.12. Which of the following is used to declare a record?

A. %ROWTYPE
B. %TYPE
C. Both A & B
D. None of the above.

Q.13. Which keyword is used instead of the assignment operator to initialize variables?

A. NOT NULL                                     B. DEFAULT
C. %TYPE                                    D. %ROWTYPE

Q.14. What is the advantage of using the %ROWTYPE datatype?

A. It is useful to retrieve an entire row from a table. If you do not use the %ROWTYPE datatype, then you have to declare variables for each column separately.
B. It can be used even if data type of the table columns is not known.
C. It ensures that data type of the variable changes dynamically if the underlying table is altered.
D. All of the above

Q.15. The LOB objects can be stored in-line or out-of-line. The in-line storage means that objects are stored-------

A. Along with the row                                     B. Outside the row
C. Both A & B                                               D. None of the above

Relational Database Management System MCQ : Transaction Concepts and concurrency control: Link1

Relational Database Management System MCQ : Transaction Concepts and concurrency control : MCQ1

RDBMS :Transaction MCQ & Answers

       Are you worried about the answers to Relational Database Management System questions :transaction, properties of transaction, state of the transaction, Schedules, types of schedules, concept of Serializability, precedencegraph for Serializability? We have arranged the Show Answer button under the each question. Candidates can click on it to know the right option among the given alternatives. Furthermore, the applicants can check our web portal @ www.totalmcq.com to take part in more MCQ on various subject. Wish, the given information about the Relational Database Management System: Transaction Concepts and concurrency control MCQ will helpful to the advance and can learn the various types of questions and answers.

Q.1. Collections of operations that form a single logical unit of work are called ----------.

A. Views                                                                                B. Units
C. Tables                                                                                 D. Transactions

Q.2. Either all of them should be executed or none property is commonly referred to as---------

A. Isolation                                                                              B. Durability
C. Atomicity                                                                                    D. Consistency

Q.3. Which of the following is a property of transactions?

A. Durability                                                                                 B. Atomicity
C. Consistency                                                                                  D. All of the above

Q.4. Execution of translation in isolation preserves the ------- of a database.

A. Consistency                                                                           B. Atomicity
C. Durability                                                                                 D. All of the above

Q.5. A transaction that has not been completed successfully is called as--------

A. Compensating transaction                                                                                 B. Active transaction
C. Aborted transaction                                                                                      D. Partially committed transaction

Q.6. ---------systems is responsible for ensuring Isolation.

A. Recovery system                                                                          B. Compiler system
C. Atomic system                                                                                  D. Concurrency control system

Q.7. Which of the following systems is responsible for ensuring durability?

A. Recovery system                              B. Compiler system
C. Atomic system                                            D. Concurrency control system

Q.8. Which of the following is not a property of a transaction?

A. Atomicity                                                             B. Isolation
C. Durability                                                             D. Simplicity

Q.9. A chronological execution sequence of a transaction is called a -----------.

A. schedule
B. Serials
C. Organizations
D. Concurrent

Q.10. The scheme that controls the interaction between executing transactions is called as --------scheme

A. Concurrency control                                                                                       B. Multiprogramming
C. Serialization                                                                                       D. Schedule

Q.11. The statement given below describes which of the ACID properties of transactions?
"The changes applied to the database by a committed transaction must persist in the database, and these changes must not be lost because of any failure."

A. Atomicity                                B. Isolation
C. Durability                                           D. Consistency preservation

Q.12. Consider the following transaction involving two bank accounts x and y.

read (x); x := x - 50 ; write (x) ; read (y) ; y≔ y + 50 ; write (y)
The constraint that the sum of the accounts x and y should remain constant is that of-------

A. Atomicity
B. Consistency
C. Isolation
D. Durability

Q.13. ACID properties of a transactions are-------

A. Atomicity, Consistency, Isolation, Database                                     B. Atomicity, consistency, Isolation, Durability
C. Atomicity, Consistency, Integrity, Durability                                    D. Atomicity, Consistency, Integrity, Database

Q.14. Consider a simple checkpointing protocol and the following set of operations in the log.
(start, T4); (write, T4, y, 2, 3); (start, T1); (commit, T4); (write, T1, z, 5, 7); (checkpoint);
(start, T2); (write, T2, x, 1, 9); (commit, T2); (start, T3), (write, T3, z, 7, 2);
If a crash happens now and the system tries to recover using both undo and redo operations, what are the contents of the undo list and the redo list?

A. Undo: T3, T1; Redo: T2                                               B. Undo: T3, T1; Redo: T2, T4
C. Undo: none; Redo: T2, T4, T3, T1                                            D. Undo: T3, T1, T4; Redo: T2

Q.15. Which property of database transaction create an allusion than only 1 transaction is executed in system in spite of more than one transaction is executed in parallel manner?

A. Atomicity                                     B. Durability
C. Isolation                                               D. Consistency

Relational Database Management System MCQ : Preliminaries, Functional Dependencies : Link1

Relational Database Management System MCQ : Preliminaries, Functional Dependencies : MCQ1

RDBMS MCQ & Answers

       Are you worried about the answers to Relational Database Management System questions :Preliminaries, Functional Dependencies? We have arranged the Show Answer button under the each question. Candidates can click on it to know the right option among the given alternatives. Furthermore, the applicants can check our web portal @ www.totalmcq.com to take part in more MCQ on various subject. Wish, the given information about the Relational Database Management System MCQ will helpful to the advance and can learn the various types of questions and answers.

Q.1. A relational database consists of a collection of-----------.

A. Tables                                                                                B. Records
C. Fields                                                                                 D. Keys

Q.2.A--------in a table represents a relationship among a set of values.

A. Column                                                                              B. Row
C. Key                                                                                     D. Entry

Q.3. A functional dependency is a relationship between or among:----------

A. tables                                                                                 B. Attributes
C. rows                                                                                  D. relations

Q.4. The term--------is used to refer to a row.

A. Attribute                                                                           B. Field
C. Tuple                                                                                 D. Instance

Q.5. The term attribute refers to a--------- of a table.

A. Record                                                                                 B. Tuple
C. Key                                                                                      D. Column

Q.6. The functional dependency of two sets E and F are considered as equivalent if----------

A. E + F = E - F                                                                          B. E * = F2
C. E * =F*                                                                                  D. E2 = F2

Q.7. For some relations, changing the data can have undesirable consequences called--------

A. referential integrity constraints                              B. normal forms
C. modification anomalies                                            D. transitive dependencies

Q.8. If attributes A and B determine attribute C, then it is also true that-------

A. A → C                                                             B. (A,B) is a composite determinant
C. B → C                                                             D. C is a determinant

Q.9. One solution to the multivalued dependency constraint problem is to -----------.

A. split the relation into two relations, each with a single theme.
B. change the theme.
C. create a new theme.
D. add a composite key.

Q.10. A function that has no partial functional dependencies is in-------form.

A. 2NF                                                                                       B. 3NF
C. 4NF                                                                                       D. BCNF

Q.11. 4NF is designed to cope with----------

A. Transitive dependency                                B. Multi valued dependency
C. Join dependency                                           D. None of the above

Q.12. A BCNF is --------

A. loss less join and dependency preserving.
B. loss less join but not dependency preserving.
C. not loss less join but dependency preserving.
D. None of the above.

Q.13. A functional dependency between two or more non-key attributes is called-------

A. Transitive dependency                                     B. Partial transitive dependency
C. Functional dependency                                    D. Partial functional dependency

Q.14. Every Boyee-Codd normal form is in---------.

A. First normal form                                               B. Second normal form
C. Third normal form                                             D. All of the above

Q.15. 5NF is designed to cope with-------

A. Transitive dependency                                     B. Multi valued dependency
C. Join dependency                                               D. All of the above