Each question in this quiz is timed.
Click the button below to start the quiz.
Database __________ , which is the logical design of the database, and the database _______,which is a snapshot of the data in the database at a given instant in time.
Here the course_id,sec_id and semester are __________ and course is a _________ .
Department (dept name, building, budget) and Employee (employee_id , name, dept name,salary)
Here the dept_name attribute appears in both the relations .Here using common attributes in relation schema is one way of relating ___________ relations.
Attributes of common
Tuple of common
Tuple of distinct
Attributes of distinct
A domain is atomic if elements of the domain are considered to be ____________ units.
The tuples of the relations can be of ________ order.
_________ were among the first to use databases in a geographically distributed manner?
Data independence is usually considered from _____ points of view?
What is the purpose of MEARGE in sql server 2008?
Merge statement allows a single statement for INSERT, DELETE and UPDATE a row that depends on a condition
Merge statement allows multiple statements for INSERT, DELETE and UPDATE a row that depends on a condition
Merge statement allows a single statement for INSERT, DELETE and UPDATE a row that independent on a condition
Merge statement allows multiple statements for INSERT, DELETE and UPDATE a row that is independent on a condition
SQL Server 2000 always returns the result of a FOR XML query directly to the client in XML form
Dynamic Page Repair is a type of database mirroring.
CPUs can dynamically be added to a running system, by using _________ feature
Cold Add CPU
Hot Add CPU
Dynamic add CPU
Passive add CPU
The identifiers in SQL can have a character range from?
1 to 100
1 to 128
1 to 64
1 to 132
Which of the following rules below are true to use the ROWGUICOL property to define a globally unique identifier column?
A table can have only one ROWGUICOL column
A ROWGULCOL column must not be defined by using the unique identifier data type.
Both a and c
NEWID function to generate a globally unique value.
A column with an optimized storage for null values is known as ________ column
______________ is a feature that is used for tracking the changes on a table
Change schema Capture
Change table Capture
Change Data Capture
Change database Capture
A relation is in this form if it is in BCNF and has no multivalued dependencies:
second normal form.
third normal form.
fourth normal form.
domain/key normal form.
Row is synonymous with the term: