MCQ | SQL – Database

by karimhani25
75
10

Sql programming

questions

Title
1. SQL CREATE DATABASE is used to, SQL CREATE DATABASE is used to, Create a table Create a database Create a column Create a row discuss The answer is: B. Create a database
A database does not need to be created in ____. A direct table creation option is provided in ____ A database does not need to be created in ____. A direct table creation option is provided in ____. MySQL Oracle Both A and B None of the above discuss The answer is: C. Both A and B
SQL ___ can be used to delete or drop existing databases in a SQL schema SQL ___ can be used to delete or drop existing databases in a SQL schema. CREATE DATABASE RENAME DATABASE DROP DATABASE SELECT DATABASE discuss The answer is: C. DROP DATABASE
Using the ___ statement, a database can be renamed Using the ___ statement, a database can be renamed. SQL CREATE DATABASE SQL RENAME DATABASE SQL DROP DATABASE SQL SELECT DATABASE discuss The answer is: B. SQL RENAME DATABASE
Which of the following statement is TRUE? Which of the following statement is TRUE? A DATABASE name can be renamed. A TABLE name can be renamed. Both A and B None of the above discuss The answer is: C. Both A and B
Which syntax is correct for Rename Database in MySQL? Which syntax is correct for Rename Database in MySQL? RENAME old_database_name TO new_database_name; RENAME DATABASE old_database_name TO new_database_name; ALTER old_database_name MODIFY NAME = new_database_name; ALTER DATABASE old_database_name MODIFY NAME = new_database_name; discuss The answer is: B. RENAME DATABASE old_database_name TO new_database_name;
Which syntax is correct for Rename Database in SQL? Which syntax is correct for Rename Database in SQL? RENAME old_database_name TO new_database_name; RENAME DATABASE old_database_name TO new_database_name; ALTER old_database_name MODIFY NAME = new_database_name; ALTER DATABASE old_database_name MODIFY NAME = new_database_name; discuss The answer is: D. ALTER DATABASE old_database_name MODIFY NAME = new_database_name;
Which statement is used to select the database in SQL? Which statement is used to select the database in SQL? SELECT USE ALTER CREATE discuss The answer is: B. USE
Which statement is used to select the database in Oracle? Which statement is used to select the database in Oracle? USE SELECT RENAME None of the above discuss The answer is: D. None of the above
Which syntax is used to show all the databases? Which syntax is used to show all the databases? USE DATABASES; SELECT DATABASES; SHOW DATABASES; None of the above discuss The answer is: C. SHOW DATABASES;

total MCQs: 10

MCQs

10

Views

75

Best Answers

299

Points

5