Tag: databases

Questions Related to databases

ERD stands for

technology databases

  1. Enterprise Relationship Diagram

  2. Entity Relationship Diagram

  3. Extra Relationship Diagram

  4. Entry Relationship Diagram

Show answer
Correct Option: B

What is true about RDBMS? Choose all that apply

technology databases

  1. A system consisting of tables and relation between the tables

  2. Writes efficient queries itself without user intervention to retrieve and manipulate the data stored

  3. Handles data retrieval and manipulation using a functional programming language called SQL (Structured Query Language)

  4. A system consisting of memory structures and background process

  5. Translates a SQL query into a series of operations that retrieve the actual data from the database

Show answer
Correct Option: A,C,E

SQL stands for

technology databases

  1. Structured Query Language

  2. Stable Query Language

  3. Synchronous Query Language

  4. System Query Language

Show answer
Correct Option: A

As a part of Entity Relationship Modeling conventions, an Entity is represented by a SOFT BOX.

technology databases

  1. True

  2. False

Show answer
Correct Option: A

which is an escape identifier i.e, used to avoid the meaning of wildcard characters, and hence interpret underscore and percentage literally
technology databases

  1. \

  2. /

  3. ESCAPE

  4. *

Show answer
Correct Option: C

In RDBMS, one can NOT have two tables with the same column name
technology databases

  1. True

  2. False

Show answer
Correct Option: B

In RDBMS, a TABLE is two dimensional object

technology databases

  1. True

  2. False

Show answer
Correct Option: A

DATABASE is a PHYSICAL object

technology databases

  1. True

  2. False

Show answer
Correct Option: B

Order by – clause comes last in select statement
technology databases

  1. True

  2. False

Show answer
Correct Option: A

desc - is the default option for sorting rows

technology databases

  1. True

  2. False

Show answer
Correct Option: B