Q.1
Which of the following levels is considered as the level closed to the end-users?
  • Internal Level
  • External Level
  • Conceptual Level
  • Physical Level
Q.2
Which one of the following command is used to delete the existing row in a table?
  • Delete
  • Update
  • Insert
  • None of the above
Q.3
A DBMS makes it possible for users to:-
  • CREATE
  • UPDATE
  • DELETE
  • ALL THE ABOVE
Q.4
SQL Query to delete all rows in a table without deleting the table (structure, attributes, and indexes)
  • DELETE FROM table_name;
  • DELETE TABLE table_name;
  • DROP TABLE table_name;
  • None
Q.5
The term "Data independence" refers to____
  • Data is defined separately and not included in the programs
  • Programs are not dependent on the logical attributes of the data
  • Programs are not dependent on the physical attributes of the data
  • Both B & C
Q.6
The term "SQL" stands for
  • Standard query language
  • Sequential query language
  • Structured query language
  • Server-side query language
Q.7
Which of the following refers collection of the information stored in a database at a specific time?
  • Independence
  • Instance of the database
  • Schema
  • Data domain
Q.8
The ______ clause allows us to select only those rows in the result relation of the ____ clause that satisfy a specified predicate.
  • Where, from
  • From, select
  • Select, from
  • From, where
Q.9
Which one of the following commands is used to restore the database to the last committed state?
  • Save point
  • Rollback
  • Commit
  • Both A & B
Q.10
For what purpose the DML is provided?
  • Addition of new structure in the database
  • Manipulation & processing of the database
  • Definition of the physical structure of the database system
  • All of the above
Q.11
Which of the following commands is used to save any transaction permanently into the database?
  • Commit
  • Rollback
  • Save point
  • None of the above
Q.12
Which one of the following refers to the total view of the database content?
  • Conceptual view
  • Physical view
  • Internal view
  • External view
Q.13
The Database Management Query language is generally designed for the _____
  • Support end-users who use English like commands
  • Specifying the structure of the database
  • Support in the development of the complex applications software
  • All of the above
Q.14
Which one of the following commands is used for removing (or deleting) a relation forms the SQL database?
  • Delete
  • Drop
  • Remove
  • All of the above
Q.15
Which of the following keys is generally used to represents the relationships between the tables?
  • Primary key
  • Foreign key
  • Secondary key
  • None of the above
Q.16
Data redundancy occurs
  • when the same piece of data exists in multiple places.
  • when there is mismatch of data.
  • when there is NULL values.
  • when there is multiple values for an attribute.
Q.17
In the given query which of the keyword has to be inserted?
  • table
  • values
  • from
  • relation
Q.18
SELECT * FROM employee WHERE dept_name="Comp Sci";In the SQL given above there is an error . Identify the error.
  • Dept_name
  • Employee
  • “Comp Sci”
  • From
Q.19
Which of the following is the most important feature of DBMS:
  • Command language like SQL
  • Ability to back up data
  • Ease of use
  • Ability to automate some tasks
Q.20
Which of the following is NOT Advantages of DBMS
  • Increased data consistency
  • Reduced data redundancy
  • Improved data security
  • Increase data isolation
0 h : 0 m : 1 s