Question 1
Question
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.
Answer
-
Instance, Schema
-
Relation, Schema
-
Relation, Domain
-
Schema, Instance
Question 2
Question
Course(course_id,sec_id,semester)
Here the course_id,sec_id and semester are __________ and course is a _________ .
Answer
-
Relations, Attribute
-
Attributes, Relation
-
Tuple, Relation
-
Tuple, Attributes
Question 3
Question
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.
Answer
-
Attributes of common
-
Tuple of common
-
Tuple of distinct
-
Attributes of distinct
Question 4
Question
A domain is atomic if elements of the domain are considered to be ____________ units.
Answer
-
Different
-
Indivisbile
-
Constant
-
Divisible
Question 5
Question
The tuples of the relations can be of ________ order.
Question 6
Question
_________ were among the first to use databases in a geographically distributed manner?
Answer
-
Airlines
-
Database
-
Automated teller
-
Telecommunication
Question 7
Question
Data independence is usually considered from _____ points of view?
Answer
-
Two
-
Physical
-
Logical
-
Difficult
Question 8
Question
What is the purpose of MEARGE in sql server 2008?
Answer
-
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
Question 9
Question
SQL Server 2000 always returns the result of a FOR XML query directly to the client in XML form
Question 10
Question
Dynamic Page Repair is a type of database mirroring.
Question 11
Question
CPUs can dynamically be added to a running system, by using _________ feature
Answer
-
Cold Add CPU
-
Hot Add CPU
-
Dynamic add CPU
-
Passive add CPU
Question 12
Question
The identifiers in SQL can have a character range from?
Answer
-
1 to 100
-
1 to 128
-
1 to 64
-
1 to 132
Question 13
Question
Which of the following rules below are true to use the ROWGUICOL property to define a globally unique identifier column?
Answer
-
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.
Question 14
Question
A column with an optimized storage for null values is known as ________ column
Answer
-
spatial
-
optimum
-
dense
-
sparse
Question 15
Question
______________ is a feature that is used for tracking the changes on a table
Answer
-
Change schema Capture
-
Change table Capture
-
Change Data Capture
-
Change database Capture
Question 16
Question
A relation is in this form if it is in BCNF and has no multivalued dependencies:
Answer
-
second normal form.
-
third normal form.
-
fourth normal form.
-
domain/key normal form.
Question 17
Question
Row is synonymous with the term:
Answer
-
record
-
relation
-
column
-
field