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