DBMS Class 121

SQL Stands for............................?

• Structured Query Language

• Sequential Query Language   

  
  

• Structured Question Language

• Sequential Question Language

Which of the following is not an example of DBMS?

• MySQL
  

• Microsoft Access
  

• IBM DB2
  

• Google

A Primary Key is Selected From the .......

• Composite Keys

• foreign Keys

• Candidate Keys

• Super Keys

Which one of the following commands is used to modify a column inside a table?

• 1. Drop

• 1. Update

• 1. Alter

• 1. Set

SQL query to retrieve all records from a table named 'Students'.

• SELECT * FROM Users;

• SELECT * FROM Classes;

• SELECT * FROM Students;

• SELECT * FROM Teachers;

Which of the following is the full form of DDL?

• Data Definition Languages

• Data Derivation Languages

• Dynamic Data Languages

• Detailed Data Languages

Which of the following is not a DDL Statement ?

• CREATE

• SELECT

• ALTER

• DROP

Which of the following is not a DML Statement?

• CREATE

• SELECT

• INSERT

• DELETE

What are some common techniques used for database security?

• Ignoring software updates and patches

• Storing passwords in plain text

• Encryption, access control, authentication mechanisms, auditing and logging, regular security updates and patches, implementing firewalls

• Database sharing with unauthorized users

Duplication of Data in Database is known as

• Data Integrity

• Data Consistency

• Data Redundancy

• Data Repetition