Database AND Sql

What is fullform of DBMS?

• Data of Binary Management System
• Database Management System
• Database Management Service
• Data Backup Management System

Wha 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

What type of data can be stored in database?

• Image oriented data
• Text files containing data
• Data in the form of audio or video
• All of the above

Which of the following is not a function of database?

• Analyzing code
• Managing stored data
• Manipulating data
• Security for stored data

What is information about data called?

• Hyper data
• Tera data
• Meta data
• Relations

______ offers the ability to query data and insert, delete and alter tuples.

• TCL
• DCL
• DDL
• DML

_____ is a set of one or more attributes taken collectively to uniquely identify a record.

• Primary Key
• Foreign Key
• Super Key
• Candidate Key

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

• Drop
• Delete
• Purge
• Remove

Which of the folloing refers to the copies of same data occupying the memory space at multiple places?

• Data Repository
• Data Inconsistency
• Data Mining
• Data Redundancy

The term SQL stands for?

• Standard Query Language
• Sequential Query Language
• Structured Query Language
• Server-side Query Language