DataBase,SQL Server 2000,SQL Server 2000 I

Online Exam >> DataBase >> SQL Server 2000 >> SQL Server 2000 I_1

1 . Update Employee set Sal = Sal + (Sal * .20) where Sal between 2000 and 4000
What is the output of the above query?

A.The query will increase the salary by 20% for the employees whose salary is 2000 and 4000

B.The query will increase the salary by 20% for the employees whose salary is between 2000 and 4000. It will also include the employees whose salary is 2000 and 4000.

C.The query will increase the salary by 20% for the employees whose salary is between 2000 and 4000. It will exclude the employees whose salary is 2000 and 4000.

2 . In MS Access, the alphanumeric data type is referred as Text data type, and is of variable length holding a maximum of ________ characters?

A.255

B.256

C.1024

D.25

3 . Match the field name �� the kind of data type needed
a Patient_name 1 Autonumber
b Patient_ID 2 Memo
c Patient_Adm_Date 3 Text
d Patient _History 4 date/Time

A.a-3, b-1, c-4, d-2

B.a-2, b-1, c-4, d-3

C.a-4, b-3, c-1, d-2

D.a-3, b-4, c-1, d-2

4 . Identify the minimum hardware requirement for installing SQL server 2000 and connecting to the clients

A.60MB disk space

B.NIC

C.128 MB RAM

D.95 MB disk space

E.Intel compatible 32-bit CPU

5 . Unlike SQL server 2000, MS Access maps a database over a set of operating-system files. Data and log information are never mixed on the same file

A.True

B.False

6 . What roles does the SQL server Enterprise Manager play?

A.It allows users to define groups of servers running SQL server 2000

B.It register individual servers in a group

C.It configures all SQL server options for each registered server

D.It creates and administraters all SQL server 2000 databases, objects, logins, users, and permissions in each registered server.

7 . Identify correct syntax to create a table with constraint

A.CREATE TABLE <table constraint> <table name>
(<column_definition> <table_constraint>)

B.CREATE TABLE <table name>
(<table_constraint> <column_definition> )

C.CREATE TABLE <table name>
(<column_definition> <table_constraint> )

D.CREATE TABLE <table name>
(<table_constraint> )

8 . Statement 1: If we have an option of choosing from a simple primary key and a composite key to be a primary key, we need to select the simple primary key
Statement 2: Manipulating a single column is faster than manipulating multiple columns

A.Both the statements are true and statement 2 is the reason for statement 1 being True

B.Both the statements are true but statement 2 is not the reason for statement 1 being True

C.Only statement 2 is True

D.Both the statements are false

9 . You want to delete all the rows of an Employee table. This should be done without using much system and transaction log resources. Which command will you use?

A.Truncate

B.Delete

C.Drop

D.We can use of he commands provided by SQL server for deleting the records. All the commands have the same performance w.r.t to the usage of log resources.

10 . State the use of the AS clause in a SQL query?

A.State the use of the AS clause in a SQL query?

B.It is used to assign a name to a derived column

C.It is used with the scalar function in SQL for calculating large equations.

D.It is used with the group by clause to give the name to the last resultset

11 . ________ ensures that relationships defined between tables are valid and accidental deletion or modification of related data is not possible

A.Entity integrity

B.Use-defined integrity

C.Domain integrity

D.Referential integrity

12 . Which normal form specifies that non-key field in a table must relate to the key fields in the table

A.First Normal form

B.Fourth Normal form

C.Second Normal form

D.Fifth Normal form

E.Third Normal form

13 . Following mechanisms are provided by SQL Server 2000 for entity integrity?

A.Primary key

B.Identity property

C.Unique key

D.Check key

E.Foreign key

14 . Identify the valid query for viewing only those records wherein the customers have a phone number

A.SELECT * from customer where phone IS NOT NULL

B.SELECT * from customer where phone = NOT NULL

C.SELECT * from customer where phone NOT NULL

D.SELECT * from customer where HAVING phone NOT NULL

15 . MS Access stores date in the __________ format

A.mm/dd/yy

B.dd-mon-yy

C.dd-mm-yy

D.dd/mm/yy

E.yy-mon-dd

16 . Among all these versions, __________ offers a complete range of advanced scalability and reliability options

A.SQL Server 2000 Enterprise Edition

B.SQL Server 2000 Standard Edition

C.SQL Server 2000 Developer Edition

D.SQL Server 2000 Desktop Edition

E.SQL Server 2000 Windows CE Edition

17 . James chooses to install SQL Server 2000 relational database with both server and client tools. In this case, he should select

A.Named instance of SQL Server 2000

B.Default instance of SQL Server 2000

C.Both named nd default instance of SQL Server 2000

D.Either named or default instance of SQL Server 2000

18 . A primary key constraint cannot be deleted if it is being referenced by a foreign key constraint in another table; the foreign key constraint must be deleted first

A.True

B.False

19 . Statement 1: The secondary data files of SQL Server 2000 database include all the data files including the primary data files
Statement 2: There must be maximum one log file for each SQL Server 2000 server
Statement 3: The primary data files is starting point of the SQL Server 2000 database
Statement 4: Every database has one secondary data file

A.Statement 1 is True
Statement 2 is False
Statement 3 is True
Statement 4 is False

B.Statement 1 is False
Statement 2 is False
Statement 3 is True
Statement 4 is False

C.Statement 1 is False
Statement 2 is True
Statement 3 is False
Statement 4 is True

D.Statement 1 is False
Statement 2 is False
Statement 3 is False
Statement 4 is False

E.Statement 1 is False
Statement 2 is False
Statement 3 is True
Statement 4 is True

20 . Which of the following statements with respect to the autoshrink feature of SQL Server 2000 are True

A.When using SQL Server Enterprise Edition, the autoshrink option is set to True

B.When using SQL Server Desktop Edition, the autoshrink option is set to False

C.The autoshrink option is set to False for all other editions regardless of the operation system except for the SQL Server Standard Edition

D.It is not possible to shrink a read-only database

21 . Identify the SQL server 2000 tools available for enforcing Domain integrity

A.DEFAULT definition

B.PRIMARY key constraint

C.FOREIGN key constraint

D.CHECK constraint

E.NOT NULL property

22 . Statement 1: FOREIGN key constraint has to be linked only to column with PRIMARY key constraint in another table
Statement 2: a FOREIGN key constraint can be defined to refer to columns with the UNIQUE constraint in a another table

A.Only statement 1 is True

B.Only statement 2 is True

C.Both the statements are True

D.Both the statements are False

23 . What will happen, if there are records in another tables linked to the records being deleted?

A.The deletion will not take place

B.The records from the current table will be deleted

C.The records from the current table as well as the linked records will be deleted

24 . You want to check what will be the salary of all employees, if their basic is increased by 10%. What SQL statement will show you this result?

A.SELECT emp_code, basic * .10 from employee order by emp_code

B.SELECT emp_code, basic + basic * .01 from employee order by emp_code

C.SELECT emp_code, basic + 10 from employee order by emp_code

D.SELECT emp_code, basic + basic * .10 from employee order by emp_code

25 . Which of the following database file/s is/are always present in the database?

A.Primary data files

B.Log files

C.Secondary data files

D.Command data files

26 . If SQL server is using Windows Authentication, you have to provide a login ID each time you access a registered SQL server

A.True

B.False

27 . In MS Access, the field size of a Text field has a default setting is ________

A.10

B.20

C.25

D.40

E.50

28 . Microsoft Windows NT Server 4.0 Service Pack 5 or later must be installed as a minimum requirement for all SQL Server 2000 editions. Do you agree with this statement?

A.Yes

B.No, SP5 must be installed as a minimum requirement only for SQL Server Enterprise Edition

C.No, SP5 must be installed as a minimum requirement only for SQL Server Standard Edition

D.No. You need not install any Service Pack

29 . What command will you give, to set the emp database file eligible for automatic periodic shrinking?

A.EXEC sp_dboption 'emp', autoshrink, true

B.EXEC sp_dboption 'emp', autoshrink, Yes

C.EXECUTE sp_dboption 'emp', autoshrink, Yes

D.EXE 'emp', autoshrink, true

30 . Can we say that two Null are equal?

A.Yes

B.No

31 . _________ enforces restrictions on the values entered for a particular column

A.Entity integrity

B.Use-defined integrity

C.Domain integrity

D.Referential integrity

32 . Which of the following statements with respect to UNIQUE constraint are TRUE

A.A UNIQUE constraint is used when we want to enforce the uniqueness of a column that is not the primary key

B.Only one UNIQUE key constraint can be defined on a table

C.A UNIQUE constraint can be referenced by a FOREIGN key constraint

D.UNIQUE constraints can be defined on columns that allow null values

33 . What command must Sam use to delete all the rows from a table

A.DROP table

B.DELETE TABLE

C.DELETE ROWS

D.TRUNCATE TABLE

34 . Identify the query which will increase the cost of all books by about 10%

A.UPDATE BookDetails SET Book_Price *10/100

B.UPDATE BookDetails SET Book_Price = Book_Price * 10/100

C.UPDATE Book_Price = Book_Price + Book_Price * 10/100 FROM BookDetails

D.UPDATE BookDetails SET Book_Price = Book_Price + Book_Price * 10/100

35 . To view only those records form 'Studen' table, where regis_dt field values is in between 10/02/2004 and 12/02/2004, then following SQL statement can be used

A.SELECT * FROM Student
WHERE regis_dt
BETWEEN '10/02/2004' AND '12/02/2004'

B.SELECT * FROM Student
WHERE regis_dt
BETWEEN #10/02/2004# AND #12/02/2004#

C.SELECT * FROM Student
WHERE regis_dt
NOT BETWEEN #10/02/2004# AND #12/02/2004#

Test Name :	SQL Server 2000 I_1
Category :	SQL Server 2000
Number of Question :	35
Pass Score :	80

Test Result

Your Score :
Passing Score :	80

Result :

Menu

SQL Server 2000 I_1