Databases | Practice Questions | Aliensbrain

Multiple choice technology databases

ERD stands for

Reveal answer Fill a bubble to check yourself

Multiple choice technology databases

What is true about RDBMS? Choose all that apply

A system consisting of tables and relation between the tables
Writes efficient queries itself without user intervention to retrieve and manipulate the data stored
Handles data retrieval and manipulation using a functional programming language called SQL (Structured Query Language)
A system consisting of memory structures and background process
Translates a SQL query into a series of operations that retrieve the actual data from the database

Reveal answer Fill a bubble to check yourself

Multiple choice technology databases

SQL stands for

Reveal answer Fill a bubble to check yourself

Multiple choice technology databases

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

Reveal answer Fill a bubble to check yourself

Multiple choice technology databases

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

Reveal answer Fill a bubble to check yourself

Multiple choice technology databases

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

Reveal answer Fill a bubble to check yourself

Multiple choice technology databases

In RDBMS, a TABLE is two dimensional object

Reveal answer Fill a bubble to check yourself

Multiple choice technology databases

DATABASE is a PHYSICAL object

Reveal answer Fill a bubble to check yourself

Multiple choice technology databases

Order by – clause comes last in select statement

Reveal answer Fill a bubble to check yourself

Multiple choice technology databases

desc - is the default option for sorting rows

Reveal answer Fill a bubble to check yourself

Tag: databases