MCQGeeks
0 : 0 : 1
CBSE
JEE
NTSE
NEET
English
UK Quiz
Quiz
Driving Test
Practice
Games
Quiz
Computer Science
Rdbms
Quiz 3
1
2
3
4
5
6
7
8
9
Q.1
.......... is used to reduce the data duplication.
1 NF
2 NF
3 NF
4 NF
Q.2
................. form disallows the multi-valued attribute, composite attribute, and their combinations.
1 NF
2 NF
3 NF
4 NF
Q.3
.......... is the process of organizing the data in the database.
Schema
Normalization
Instance
Transaction
Q.4
........... is the process of minimizing redundancy from a relation or set of relations.
Normalization
Data redundancy
Data consistency
Schema
Q.5
Which of the following function cannot be performed by SQL ?
Setting permissions on tables
Creating views in a database
Updating records
Creating Complex UI
Delete database
Q.6
Which of the following is NOT a type of SQL constraint?
Primary Key
Foreign Key
Alternate Key
Unique
NOT NULL
Q.7
Which of the following is valid SQL for an Index?
CREATE INDEX ID;
CHANGE INDEX ID;
ADD INDEX ID;
REMOVE INDEX ID;
DELETE INDEX ID;
Q.8
The HAVING clause does which of the following?
Acts like a WHERE clause but is used for groups rather than columns.
Acts like a WHERE clause but is used for rows rather than columns.
Acts like a WHERE clause but is used for columns rather than groups.
Acts EXACTLY like a WHERE clause.
Acts like a WHERE clause but is used for groups rather than rows.
Q.9
The DROP TABLE statement:
deletes the table structure only.
deletes the table structure along with the table data.
works whether or not referential integrity constraints would be violated.
is not an SQL statement.
deletes the data only.
0 h : 0 m : 1 s
1
2
3
4
5
6
7
8
9
Report Question
×
What's an issue?
Question is wrong
Answer is wrong
Other Reason
Want to elaborate a bit more? (optional)
Support mcqgeeks.com by disabling your adblocker.
×
Please disable the adBlock and continue.
Thank you.
Reload page