Sawaal

 Database Questions

Popular Latest Rated
Q:

Which of the following are goals of OLE DB?

A) Create object interfaces for DBMS functionality pieces only. B) Increase flexibility only.
C) Object interface over any type of data only. D) All of the above as goals of OLE DB.
 
Answer & Explanation Answer: D) All of the above as goals of OLE DB.

Explanation:
Report Error

View Answer Report Error Discuss

Filed Under: Database

0 3876
Q:

 Which JDBC driver Type(s) is(are) the JDBC-ODBC bridge?

A) Type 1 B) Type 2
C) Type 3 D) Type 4
 
Answer & Explanation Answer: A) Type 1

Explanation:
Report Error

View Answer Report Error Discuss

Filed Under: Database

0 3582
Q:

88%of 370 +24% of 210-x =118 find x

Answer

From the given equation,


88x370/100 + 24x210/100 - 118 = x


=> x = 325.6 + 50.4 - 118


x = 258.

Report Error

View answer Workspace Report Error Discuss

Subject: Database Exam Prep: CAT , Bank Exams , AIEEE
Job Role: Bank PO , Bank Clerk

7 3490
Q:

 Stored procedures have which of the following advantages?

A) It takes a longer time to write them as compared to writing Visual Basic. B) Data integrity improves as multiple applications access the same stored procedure.
C) Network traffic increases D) Result in thicker client and thinner database server.
 
Answer & Explanation Answer: B) Data integrity improves as multiple applications access the same stored procedure.

Explanation:
Report Error

View Answer Report Error Discuss

Filed Under: Database

0 3435
Q:

An Oracle System Change Number (SCN):

A) is a value that is incremented whenever a dirty read occurs. B) is incremented whenever a deadlock occurs.
C) is a value that keeps track of explicit locks. D) is a value that is incremented whenever database changes are made.
 
Answer & Explanation Answer: D) is a value that is incremented whenever database changes are made.

Explanation:
Report Error

View Answer Report Error Discuss

Filed Under: Database

0 3432
Q:

The command to eliminate a table from a database is

A) REMOVE TABLE CUSTOMER; B) UPDATE TABLE CUSTOMER;
C) DELETE TABLE CUSTOMER; D) DROP TABLE CUSTOMER;
 
Answer & Explanation Answer: D) DROP TABLE CUSTOMER;

Explanation:

The SQL DROP TABLE statement is used to remove a table definition and all data, indexes,...

Report Error

View Answer Report Error Discuss

Filed Under: Database
Exam Prep: AIEEE , Bank Exams
Job Role: Analyst , Bank PO , Database Administration , IT Trainer , Project Manager

3 3385
Q:

The capacity to change the conceptual schema without having to change external schemas or application programs is called

A) Physical Data Independence B) Logical Data Independence
C) Both A and B D) None
 
Answer & Explanation Answer: B) Logical Data Independence

Explanation:

LDI is the capacity to change the conceptual schema without having to change external schemas or application programs.

Report Error

View Answer Report Error Discuss

Filed Under: Database
Job Role: Database Administration

0 3360
Q:

 ________ is a simple object model that is easier to understand and use than OLE DB, and is frequently used for database applications.

A) ASP B) XML
C) ODBC D) ADO
 
Answer & Explanation Answer: D) ADO

Explanation:
Report Error

View Answer Report Error Discuss

Filed Under: Database

0 3248