MBA_3

 Which command is used to modifies an existing database object, such as a table?

• Create

• Alter

• Drop

• Modify

Which command is used to modifies records?

• Insert

• Update

• Delete

• Modify

Which command list names and files of attached databases?

Does SQLite is case insensitive?

• TRUE

• FALSE

• Can be true or false

• Can not say

Which of the following command is true regarding SQLite ALTER TABLE Statement (Rename)?

• ALTER TABLE table_name ADD COLUMN column_def...;

• ALTER TABLE table_name RENAME TO new_table_name;

• ALTER TABLE table_name COLUMN column_def...;

• ALTER TABLE table_name TO new_table_name;

Which operator is negation of IN operator?

• NIN

• NOT

• Exists

• NOT IN

An ____, self-contained, stand-alone, transactional relational database engine, SQLite is designed to be embedded within an application without requiring additional configuration.

• Open-source

• Closed-source

• Open-end

• Open-wire

In SQLite, files are ____ directly to disk.

• Read

• Written

• Both A and B

• None of the above

Which of the following command is true regarding ROLLBACK Statement?

• ROLLBACK;

• ROLLBACK TO SAVEPOINT savepoint_name;

• Both A and B

• ROLLBACK TO savepoint_name;

Which of the following is not Storage Class?

• Number

• Integer

• Text

• Blob