Database Management


31. The process of physically arranging data in a database to optimize its performance is called:
A) Indexing
B) Clustering
C) Partitioning
D) Fragmentation

View Answer >

32. In a database, a unique index is used to:
A) Ensure that the index key has no duplicate values
B) Speed up data retrieval
C) Establish a relationship between two tables
D) Define the primary key for a table

View Answer >

33. Which type of backup includes all the data that has changed since the last full backup?
A) Differential backup
B) Incremental backup
C) Full backup
D) Partial backup

View Answer >

34. Which SQL command is used to remove a table from a database?
A) DELETE TABLE
B) DROP TABLE
C) REMOVE TABLE
D) ERASE TABLE

View Answer >

35. The process of ensuring that data remains confidential and can only be accessed by authorized users is called:
A) Data Protection
B) Data Encryption
C) Data Security
D) Data Backup

View Answer >


Leave a Comment

telegram Join Telegram
Join Now Join Now