SQL Objective Type Question & Answers For Interview

Q.1An entity set that does not have sufficient attributes to form a primary key is a
(A) strong entity set. (B) weak entity set.
(C) simple entity set. (D) primary entity set.
Ans: B

Q.2 Errors occur more often when
a. data is entered by users
b. data is entered by operators
c. when data is handwritten by users and entered by an operator
d. the key board design is bad
Ans: c

Q.3 In an E-R diagram attributes are represented by
(A) rectangle. (B) square.
(C) ellipse. (D) triangle.
Ans: C

Q.4 In on-line data entry it is possible to
a. Give immediate feedback if incorrect data is entered
b. Eliminate all errors
c. Save data entry operators time
d. Eliminate forms
Ans: a

Q.5 In case of entity integrity, the primary key may be
(A) not Null (B) Null
(C) both Null & not Null. (D) any value.
Ans: A

Q.6 In interactive data input a menu is used to
a. enter new data
b. add/delete data
c. select one out of many alternatives often by a mouse click
d. detect errors in data input
Ans: c
Q.7 The language used in application programs to request data from the DBMS is referred
to as the
(A) DML (B) DDL
(C) VDL (D) SDL
Ans: A

Q8  In interactive data input a template is normally used to
a. enter new data
b. add/delete data
c. select one out of many alternatives often by a mouse click
d. detect errors in data input
Ans: a
Q.9 A logical schema
(A) is the entire database.
(B) is a standard way of organizing information into accessible parts.
(C) describes how data is actually stored on disk.
(D) both (A) and (C)
Ans: A
Q.10 Related fields in a database are grouped to form a
(A) data file. (B) data record.
(C) menu. (D) bank.
Ans: B Related data fields in a database are grouped to form a data record.
(A record is a collection of related fields)
Q.11 The database environment has all of the following components except:
(A) users. (B) separate files.
(C) database. (D) database administrator.
Ans: A

Related Posts:

  • Finding the highest salary in SQL Server Table: tbemployee Query to find the first highest salary: Here we can use any one of the following query... SELECT TOP 1  empsalary FROM ( SELECT DISTINCT TOP 1 empsalary   FROM tbemployee   ORDER BY e… Read More
  • Addition in Grid View using Sql Query: Addition in Grid View using Sql Query: Table Data: Here I create two tables department table and employee table: Queries can be used: select * from tbdep select * from tbemployee select empdept, ISNULL (empname,'S.… Read More
  • Paging using store procedure Table : Store Procedure: In this store procedure I used cursor CREATE PROCEDURE Pageing @pagenumber int,  --5 @pagesize int --5 AS BEGIN declare @srec int  --starting record 21 declare @erec int   --… Read More
  • Important SQL Interview Questions What is a subselect?  Is it different from a nested select?  A subselect is a select which works in conjunction with another select. A nested select is a kind of subselect where the inner select passes to the whe… Read More
  • Finding the 3rd highest salary in SQL Server Table: tbemployee select empid, empname ,empsalary from (select empid,empname,empsalary, ROW_NUMBER() over (Order by empsalary desc) as salary_order from tbemployee ) DT where DT.salary_order=3 click here … Read More

0 comments:

Post a Comment