DBMS

What is a database?

• Organized collection of information that cannot be accessed, updated, and managed

• Collection of data or information without organizing
  

• Organized collection of data or information that can be accessed, updated, and managed
  

• Organized collection of data that cannot be updated

1. SELECT emp_name  

2. FROM department  

3. WHERE dept_name LIKE ' _____ Computer Science';  

4. In the above-given Query, which of the following can be placed in the Query's blank portion to select the "dept_name" that also contains Computer Science as its ending string?

• 1. &

• 1. _

• 1. %

• 1. $

Which of the following is not a function of the database?

• Managing stored data

• Manipulating data
  

• Security for stored datA

• Analysing code

Which of the following is known as a set of entities of the same type that share same properties, or attributes?

• Relation set

• Tuples

• Entity set
  

• Entity Relation model

Which command is used to remove a relation from an SQL?

• Drop table
  

• Delete
  

• NONE
  

• Remove

After groups have been established, SQL applies predicates in the ___________ clause, allowing aggregate functions to be used.

• Where
  

• Having
  

• Group by
  

• With

Rows of a relation are known as the _______.

• 1. Degree

• 1. Tuples

• 1. Entity

• 1. All of the above

Which of the following establishes a top-to-bottom relationship among the items?

• Relational schema
  

• Network schema
  

• Hierarchical schema
  

• All of the mentioned

Which of the following refers to the number of tuples in a relation?

• 1. Entity

• 1. Column

• 1. Cardinality

• 1. None of the above

What represents an ‘attribute’ in a relational database?

• Table
  

• Row
  

• Column
  

• Object