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 SQL

  1. Inner join

  2. Left outer join

  3. Right outer join

  4. Self join

Answer: Answer is c
Further Reading:

Useful resources, Join, Types of Joins


  1. Alter table t add primary key(c1);

  2. Alter table t add constraint pk primary key(c1);

  3. Alter table t add (constraint pk primary key(c1));

  4. Alter table t add pk constraint primary key(c1);

Answer: Answer is a
Further Reading:

Useful resources,ALTER TABLE, SQL PRIMARY KEY Constraint


  1. primary query -> sub query -> sub sub query and so on

  2. sub sub query -> sub query -> prime query

  3. the whole query is interpreted at one time

  4. there is no fixed sequence of interpretation, the query parser takes a decision on the fly

Answer: Answer is b
Further Reading:

Primary query results depend on the sub query results, so sub query my execute first then primary query will execute.   Useful resources, Subquery Fundamentals


  1. Data Description Language

  2. Dynamic Data Language

  3. Data Definition Language

  4. Data Derived Language

  5. Descriptive Data Language

Answer: Answer is c
Further Reading:

Useful resources, DDL


Books

------

BookId

BookName

AuthorId

SubjectId

PopularityRating       (the popularity of the book on a scale of 1 to 10)

Language               (such as French, English, German etc)

Subjects

---------

SubjectId

Subject   (such as History, Geography, Mathematics etc)

Authors

--------

AuthorId

AuthorName

Country

What is the query to determine the names of the Authors who have written more than 1 book?

  1. select AuthorName from Authors where AuthorId in

         (select AuthorId from Books group by AuthorId having count(*)>1)

  2. select AuthorName from Authors, Books

         where Authors.AuthorId=Books.AuthorId and count(BookId)>1

  3. select AuthorName from Authors, Books

         where Authors.AuthorId=Books.AuthorId

         group by AuthorName having count(*)>1

  4. select AuthorName from Authors where AuthorId in

         (select AuthorId from Books having count(BookId)>1)

Answer: Answer is a, c
Further Reading:

Useful resources, GROUP BY,SQL basic queries, query fundamental, HAVING Clause, COUNT, SQL IN


select (2/2/4) from tab1; where tab1 is a table with one row.

This would give a result of:

  1. 4

  2. 2

  3. 1

  4. 5

  5. 25

  6. 0

  7. 8

  8. 24

Answer: Answer is f

  1. Conceptual level

  2. View level

  3. Procedural level

  4. None of the above

Answer: Answer is b
Further Reading:

Useful resources,data abstraction


  1. A simple view is one which derives data from only one table

  2. A simple view is one which contains no functions or groups of data

  3. A complex view is one which derives data from many tables

  4. A complex view is one which may contain functions

  5. A complex view cannot contain groups of data

  6. A complex view is a combination of more than one simple view

  7. A table can either have a simple or complex view, not both

Answer: Answer is a, b, c, d

select (age + 3 * 4 / 2 - 8) from emp

  1. +

  2. -

  3. /

  4. *

Answer: Answer is d
Further Reading:

Useful resources, Operator Precedence


  1. Recover from the transaction failure

  2. Update the transaction

  3. Retrieve old records

  4. None of the above

Answer: Answer is a
Further Reading:

Useful resources,ROLLBACK TRANSACTION


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.

;