GAMMA-AN-06.05.2024

To uniquely identify a record in database, the key used is

• key
• Primary key
• Secondary key
• Third level key

The issues that deals with the collection and use of data about individuals is

• Accuracy
• Access
• Privacy
• Publicity

The database administrator is, in effect, the coordinator between them ____ and the ____

• Database, users
• Application program; database
• DBMS; database
• Application programs; users

In order to understand DBMS, it is important to understand?

• The physical schema
• One sub schema
• All sub schema that are system support
• Both (a) and (b)

Where will we find the referential integrity command?

• Table
• Tools
• Format
• None of these

The DBMS that is most difficult to use is ____

• Oracle Corporation’s Oracle
• Microsoft’s Access
• Microsoft’s SQL Server
• None of these

In a relational schema, each tuple is divided into fields called

• Domains
• Queries
• Relations
• None of these

An indexing operation

• Establishes an index for a file
• Sorts a file using two keys
• Sorts a file using a single key
• Both (b) and (c)

The modify operation is likely to be done after

• Insert
• Delete
• Look-up
• None of these

Which command creates and initializes one or more memory variables?

• RELEASE
• KEEP
• STORE
• UPDATE