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