News:

SQL Table To C# Entity Model ConverterEntity Model (Class Properties) to SQL Table ConverterIf you encounter any trouble visiting our site, please contact us.

Online Test MS SQL Server 2000

  1. select * from employee where department LIKE "[^F-M]%";
  2. Select * from employee where department = "[^F-M]%";

Select the correct option:

  1. Query 2 will return an error

  2. Both the queries will return the same set of records

  3. Query 2 is perfectly correct

  4. Query 2 would return one record less than Query 1

Answer: Answer is c

SELECT name     

FROM Student     

WHERE name LIKE '_a%';

Which names will be displayed?

  1. Names starting with "a"

  2. Names containing "a" as the second letter

  3. Names starting with "a" or "A"

  4. Names containing "a" as any letter except the first

Answer: Answer is b
Further Reading:

Useful resources, LIKE operator


  1. CREATE [UNIQUE] INDEX index_name OF tbl_name (index_columns)

  2. CREATE [UNIQUE] INDEX OF tbl_name (index_columns)

  3. CREATE [UNIQUE] INDEX ON tbl_name (index_columns)

  4. CREATE [UNIQUE] INDEX index_name ON tbl_name (index_columns)

Answer: Answer is d
Further Reading:

Useful resources, SQL CREATE INDEX Statement


  1. Views are a logical way of looking at the logical data located in the tables

  2. Views are a logical way of looking at the physical data located in the tables

  3. Tables are physical constructs used for storage and manipulation of data in databases

  4. Tables are logical constructs used for storage and manipulation of data in databases

Answer: Answer is a
Further Reading:

Useful resources, Views


  1. SELECT * FROM myTable WHERE column1 is null

  2. SELECT * FROM myTable WHERE column1 = null

  3. SELECT * FROM myTable WHERE column1 EQUALS null  

  4. SELECT * FROM myTable WHERE column1 NOT null  

  5. SELECT * FROM myTable WHERE column1 CONTAINS null

Answer: Answer is a

1 Create table Pers

2(EmpNo Int not null,

3 EName Char not null,

4 Join Datetime not null,

5 Pay Smallmoney)

Which line contains an error?

  1. 1

  2. 2

  3. 3

  4. 4

  5. 5

Answer: Answer is d
Further Reading:

Useful resources, creating a table


A cursor is a pointer that identifies a specific working row within a set

  1. True

  2. False

Answer: Answer is b
Further Reading:

Useful resources, Cursors


Each student can enroll into more than one class. Each class can accommodate more than one student.

  1. 1 to N

  2. 1 to 1

  3. M to N to 1

  4. M to N

  5. N to 1

Answer: Answer is d
Further Reading:

Useful resources, Many-to-Many Data Relationships


  1. customers( customer_id, customer_name)
  2. branch ( branch_id, branch_name )

What will be the output if the following query is executed:

Select *, branch_name from customers,branch

  1. It will return the fields customer_id, customer_name, branch_name

  2. It will return the fields customer_id, customer_name, branch_id, branch_name

  3. It will return the fields customer_id, customer_name, branch_id, branch_name, branch_name

  4. It will return an empty set since the two tables do not have any common field name

  5. It will return an error since * is used alone for one table only

Answer: Answer is c

  1. No, SQL doesn't support user-defined datatypes

  2. Yes, but it allows the user to subclass an existing datatype only

  3. Yes, it allows a user to define new datatypes without new storage characterstics

  4. Yes, it allows a user to define new datatypes with new storage characteristics

Answer: Answer is b
Further Reading:

Useful resources, user-defined datatypes


Advertisement

BCS Preparation now even more easy. ReadBD is the place where you can find all kind of resources to be successful in BCS,Bank,Islami Bank exam and interview.

Looking for job. Try JobLoader- First ever job search engine in Bangladesh. All open bd jobs now a single mouse click away.

;