Home › Quizzes › Database Management System

Database Management System

SQL Commands Syntax , ER diagrams

25 Questions Published
Play Quiz Practise this topic out loud

Questions

Question 1 Multiple Choice (Single Answer)

What can be called as 'Data about Data'?

  1. Data bank
  2. Folder or Directory
  3. Meta Data
  4. None of these
Question 2 Multiple Choice (Single Answer)

Which of the following types of statements is responsible for specifying database retrieval and updates?

  1. DDL
  2. DCL
  3. DSL
  4. DML
Question 3 Multiple Choice (Single Answer)

Insertion of the data into the B-Tree may cause nodes to

  1. merge
  2. divide tree into two
  3. split
  4. none of these
Question 4 Multiple Choice (Single Answer)

View is also called

  1. distinct table
  2. hierarchy table
  3. virtual table
  4. all of above
Question 5 Multiple Choice (Single Answer)

_____ syntax is restricted to use with GROUP BY clause.

  1. Where
  2. Having
  3. Into
  4. All of these
Question 6 Multiple Choice (Single Answer)

Which of the following is not a property of transaction?

  1. Isolation
  2. Conspiracy
  3. Atomicity
  4. Durability
Question 7 Multiple Choice (Single Answer)

Which of the following is a valid record-based data model?

  1. Entity relationship model
  2. Object oriented model
  3. Relational model
  4. None of these
Question 8 Multiple Choice (Single Answer)

Which of the following does relational algebra inspire?

  1. Non-procedural query language
  2. Data definition language
  3. Procedural query language
  4. None of these
Question 9 Multiple Choice (Single Answer)

Modification of data is avoided by ________ lock.

  1. serialization
  2. read
  3. both (1) and (2)
  4. none of these
Question 10 Multiple Choice (Single Answer)

How can we explain the query with an example?

  1. OBE
  2. EXE
  3. Both (1) and (2)
  4. None of these
Question 11 Multiple Choice (Single Answer)

Deadlock is also known as

  1. Undirected graph
  2. Complete binary tree
  3. AVL tree
  4. None of these
Question 12 Multiple Choice (Single Answer)

In which of the following situations is a particular transaction never compete its task?

  1. Starvation
  2. Join dependency
  3. Weak entity set
  4. None of these
Question 13 Multiple Choice (Single Answer)

Which of following lock modes is used to maintain the serializability?

  1. Shared
  2. Exclusive
  3. Update
  4. Schema
Question 14 Multiple Choice (Single Answer)

What is the meaning of oval shape in E-R diagram?

  1. Weak entity
  2. Entity
  3. Attribute
  4. Relationship
Question 15 Multiple Choice (Single Answer)

The sparse index means

  1. to avoid overflow
  2. an index entry is not created for every value
  3. the entry contains the search key and a pointer in the first data record with that search key value
  4. None of these
Question 16 Multiple Choice (Single Answer)

Which of the following terms confirm(s) deadlock in a graph?

  1. Loop
  2. Cycle in wait for graph
  3. Both (1) and (2)
  4. None of these
Question 17 Multiple Choice (Single Answer)

Which of the following processes is done during the recovery of transaction failure?

  1. Spooling
  2. Concurrency control
  3. Shadow paging
  4. None of these
Question 18 Multiple Choice (Single Answer)

What is the meaning of diamond in ER diagram?

  1. Relationship
  2. Attribute
  3. Entity
  4. None of these
Question 19 Multiple Choice (Single Answer)

Which of the following is a valid TCL statement?

  1. Commit
  2. Rollback
  3. Savepoint
  4. All of these
Question 20 Multiple Choice (Single Answer)

Which of the following is/are the phase(s) of a transaction?

  1. Shadow paging
  2. Growing
  3. Shrinking
  4. Both (2) and (3)
Question 21 Multiple Choice (Single Answer)

We can restrict the number of possible scheduling by

  1. paging
  2. transaction control
  3. concurrency control
  4. all of these
Question 22 Multiple Choice (Single Answer)

Which of the following commands is used to permanently delete the record?

  1. Drop
  2. Truncate
  3. Pack
  4. All of these
Question 23 Multiple Choice (Single Answer)

Which of the following is a definition of Dense index?

  1. The entry contains the search key and a pointer in the first data record with that search key value.
  2. Adding other extra overheads
  3. This index entry is not created for every value.
  4. None of these
Question 24 Multiple Choice (Single Answer)

Which of the following operations automatically eliminates duplicates?

  1. Reunion
  2. Intersection
  3. Union
  4. None of these
Question 25 Multiple Choice (Single Answer)

Which of the following commands or statements is used to recover from dead lock situation?

  1. Commit
  2. Set transaction
  3. Rollback
  4. All of these
← Back to Quizzes