SAP MaxDB placement test question papers - Set 1

SAP MaxDB placement test question papers - Set 1

1) Which command is used to check the backup history?

A)backup_history_open
B)backup_open_history
C)backup_history
D)None of the above
View Answer / Hide Answer


2) If the backup is taken from operational state ADMIN, what does it show in the backup log file?

A) SAVE COLD
B) SAVE WARM
C) SAVE HOT
D) None of the above
View Answer / Hide Answer


3) What is the command used to restore database to point-in-time recovery?

A) recover_start
B) restore_start
C) restore_data
D) recover_data
View Answer / Hide Answer


4) After execution of which DBM command the database will be started to operational state ONLINE automatically?

A) autorecover
B) restore_start
C) restore_data
D) recover_data
View Answer / Hide Answer


5) What is the DBMCLI command for checking the progress of a restore while it is running?

A)recover_state
B)recover_data
C)backup_data
D)recover_data
View Answer / Hide Answer


6) Which activity can we perform from MaxDB database studio?

A) backup and restore databases
B) Import and export data
C) manage users
D) All of the above
View Answer / Hide Answer


7) Using which command you can check the list of backups available?

A) backup_ext_ids_list
B) backup_list
C) backup_list_ids
D) None of the above
View Answer / Hide Answer


8) Select the wrong backup type which does not exist in the database studio?

A) Restore a medium
B) Restore a specific backup from history
C) Restore last backup
D) Restore database backup to specific log
View Answer / Hide Answer


9) The database is consistent and can be restarted. However, there are some logs to be restored. The information needed to decide which log file is the one that fits the current
state of the database is provided by which command?

A)backup_history_list
B)backup_history
C)backup_history_date
D)None of the above
View Answer / Hide Answer


10) The database instance will be automatically restarted after the point in time recovery is successfully done.

A) True
B) False
View Answer / Hide Answer