Test Your Programming Skills with Safcode!

---

Here is all important interview / exams questions.
Student doing practice apptitude test on safcode platform.
Instruction: "Total Number of Questions: 20
Each question carry 10 mark , no negative marking"

---

Quiz Start

1. Which of the following command is used to select a particular database? Select
Show
Display
USE

View Answer

2. A view is a __________ Table. Virtual
Real
Dynamic
Static

View Answer

3. What is a candidate key? Used to identify a column
None of Them
Alias for foreign key
Used to uniquely identify a Tuple

View Answer

4. Which MySQL statement is used to delete data from a database? EDIT
REMOVE
DELETE
COLLAPSE

View Answer

5. Character? limit to create database name in mysql? 64
44
40
54

View Answer

6. A__________ is used to group related files that together store a database object Filegroup
MetaData
Data file
Data Sheet

View Answer

7. Hot data means: Data in Database
Data which is not processed
Data not in use
Data being processed

View Answer

8. Which of the following command is used to get current date/time? select currenttime();
select curdate();
All of Them
select curtime();

View Answer

9. How much storage space does DATETIME require? 2 bytes
8 bytes
1 byte
4 bytes

View Answer

10. A view is nothing but a ________ table. Dynamic
Static
Real
Virtual

View Answer