MsSQL Server - Quiz-3

SQL was developed by

• Sun
• Oracle
• IBM
• Microsoft

SQL is case sensitive

• true
• false

Indentify the usage of the database

• Create DB
• Maintain DB
• Analyze data
• All of the above

Code name of SQL Server 2026 is

• Helsinki
• Heaton
• Denali
• None of the above

Main editions of SQL server

• Entp Edition
• standard edition
• Business Intelligence Edition
• all of the above

How many "Main Instances" can be created in Ms-SQL-Server

• 1
• 2
• 3
• 4

How many Primary Keys are allowed for a table

• 2
• 3
• 4
• None of the above

The --------- is another word for a column or field?

• Tuple
• Degree
• Attribute
• Relation

Which of the Codd rule is associated with the statement that changes in the data storage<br />should not affect programs that access the data?

• Information Rule
• Comprehensive Sub Language
• Distribution Rule
• Physical Data Independence Rule

The table emp has 56 records. This value corresponds to which of the following term?

• Relation
• Degree
• Cardinality
• Domain