gs gs118 SQLite MCQs - SQLite MCQs - Quiz No.9

gs gs118 Data Mining Quiz

This quiz belongs to book/course code gs gs118 Data Mining of gs organization. We have 15 quizzes available related to the book/course Data Mining. This quiz has a total of 10 multiple choice questions (MCQs) to prepare and belongs to topic SQLite MCQs. NVAEducation wants its users to help them learn in an easy way. For that purpose, you are free to prepare online MCQs and quizzes.

NVAEducation also facilitates users to contribute in online competitions with other students to make a challenging situation to learn in a creative way. You can create one to one, and group competition on an topic of a book/course code. Also on NVAEducation you can get certifications by passing the online quiz test.

Question 1: What is the syntax of ALTER TABLE statement (Rename)?

ALTER TABLE table_name RENAME FOR new_table_name;

ALTER TABLE table_name RENAME OF new_table_name;

ALTER TABLE table_name RENAME TO new_table_name;

ALTER TABLE table_name RENAME FROM new_table_name;

Question 2: What is the syntax of SQLite ATTACH DATABASE statement?

ATTACH DATABASE 'DatabaseName' As 'Alias-Name';

ATTACH DATABASE 'DatabaseName' For 'Alias-Name';

ATTACH DATABASE 'DatabaseName' Of 'Alias-Name';

ATTACH DATABASE 'DatabaseName' To 'Alias-Name';

Question 3: What is/are the syntax of BEGIN TRANSACTION statement?

BEGIN;

BEGIN EXCLUSIVE TRANSACTION;

Both A and B

None of the above

Question 4: What is the syntax of CREATE INDEX statement?

CREATE INDEX index_name OF table_name ( column_name COLLATE NOCASE );

CREATE INDEX index_name ON table_name ( column_name COLLATE NOCASE );

CREATE INDEX index_name AT table_name ( column_name COLLATE NOCASE );

CREATE INDEX index_name AS table_name ( column_name COLLATE NOCASE );

Question 5: What is the syntax of CREATE UNIQUE INDEX statement?

CREATE INDEX index_name ON table_name ( column1, column2,...columnN);

CREATE UNIQUE INDEX index_name AS table_name ( column1, column2,...columnN);

CREATE UNIQUE INDEX index_name ON table_name ( column_name COLLATE NOCASE );

CREATE UNIQUE INDEX index_name ON table_name ( column1, column2,...columnN);

Question 6: What is the syntax of CREATE VIEW statement?

CREATE VIEW database_name.view_name AT SELECT statement...;

CREATE VIEW database_name.view_name ON SELECT statement...;

CREATE VIEW database_name.view_name AS SELECT statement...;

CREATE VIEW database_name.view_name FOR SELECT statement...;

Question 7: What is/are the syntax of CREATE VIRTUAL TABLE statement?

CREATE VIRTUAL TABLE database_name.table_name USING weblog( access.log );

CREATE VIRTUAL TABLE database_name.table_name USING fts3( );

Both A and B

None of the above

Question 8: What is the syntax of SQLite COUNT Clause?

SELECT COUNT(column_name)

WHERE CONDITION;

SELECT COUNT(column_name)

FROM database_name WHERE CONDITION; SELECT COUNT(column_name) FROM table_name NULL CONDITION; SELECT COUNT(column_name) FROM table_name WHERE CONDITION; SELECT COUNT(column_name) FROM table_name WHERE CONDITION;

Question 9: What is the syntax of SQLite DELETE statement?

DROP FROM table_name WHERE {CONDITION};

DELETE OF table_name WHERE {CONDITION};

DELETE TO table_name WHERE {CONDITION};

DELETE FROM table_name WHERE {CONDITION};

Question 10: What is the syntax of SQLite DETACH DATABASE statement?

ATTACH DATABASE 'Alias-Name';

DETACH TABLE 'Alias-Name';

DETACH DATABASE 'Alias-Name';

DETACH DATABASE;