SQL -Structured Query Language - SQL Delete - Delete Table Quiz

#	Quiz
1 Discuss	Delete Table Which of the following is used to access the database server at the time of executing the program and get the data from the server accordingly? 1] Embedded SQL 2] Dynamic SQL 3] SQL declarations 4] SQL data analysis Solution
2 Discuss	Delete Table If DBA modify the structure of the data record then this modification do not affect other application is called as _____________. 1] Data Independence 2] Data Integrity 3] Data Isolation 4] Data Security Solution
3 Discuss	Delete Table Collection of information stored in database at particular instance of time is called as __________. 1] Data Structure 2] Database Schema 3] Instance of Database 4] Objects in Database Solution
4 Discuss	Delete Table Overall design of the database is called as _________. 1] Database Instance 2] Database Abstraction 3] Database Schema 4] None of these Solution
5 Discuss	Delete Table __________ is collection of operations that performs a single logical function in database application. 1] Interaction 2] Operation 3] Transaction 4] None of these Solution
6 Discuss	Delete Table Database Manager Performs following query related operation 1] Drop Table 2] Creating Schema 3] Retrieving Record 4] Creating View Solution
7 Discuss	Delete Table User which interact with the system using database query language is called as ___________ 1] Application Programmer 2] Sophisticated User 3] Naive User 4] Specialized User Solution
8 Discuss	Delete Table Which of the user write programs in the host language and embed the DML statements into it? 1] Specialized User 2] Sophisticated User 3] Application Programmer 4] Naive User Solution
9 Discuss	Delete Table Database Manager is also known as _________ 1] Sophisticated User 2] System Manager 3] Application Programmer 4] Storage Manager Solution
10 Discuss	Delete Table Granting and Authorization for data access is provided by _____________ 1] DBA 2] Application Developer 3] Storage Manager 4] Database Manager Solution
11 Discuss	Delete Table Duty of Database manager is to enforce integrity and _________ checks. 1] Complexity 2] Security 3] Multiplicity 4] None of these Solution
12 Discuss	Delete Table Farmer goes to ATM Center to withdraw an amount of Rs.300/-. Which type of user farmer is? 1] Unsophisticated User 2] Sophisticated User 3] Application Programmer 4] Specialized User Solution
13 Discuss	Delete Table Schema Definition is written by ___________. 1] Application Programmer 2] Naive User 3] Database Administrator 4] Sophisticated user Solution
14 Discuss	Delete Table Person A is Java Developer interacts with Person D to understand the complete database schema written by him. Person B knows the database Schema and he is able to hit complex queries. Unlike Person B, Person C does not use traditional database processing frameworks. Who among the 4 users will be called as Sophisticated User. 1] Person B 2] Person A 3] Person C 4] Person D Solution
15 Discuss	Delete Table An extranet is which of the following? 1] The use of Internet protocols with limited access to company data by the company's customers and suppliers. 2] The use of Internet protocols with unlimited access to company data by the company's customers and suppliers. 3] The use of Internet protocols with limited access to company data by people within an organization. 4] The use of Internet protocols with unlimited access to company data by people within an organization. Solution
16 Discuss	Delete Table Data administrators are responsible for 1] physical database design 2] managing technical issues in the database environment 3] overall management of data resources in an organization 4] writing application programs Solution
17 Discuss	Delete Table Some advantages of the database approach include all, but 1] minimal data redundancy 2] improved data consistency 3] improved data sharing 4] program-data dependency Solution
18 Discuss	Delete Table Which of the following types of databases are the most common? 1] Personal 2] Workgroup 3] Department 4] Enterprise Solution
19 Discuss	Delete Table Duplicate data often results in loss of data integrity because 1] the data formats may be inconsistent 2] data values may not agree 3] Both A & B 4] Neither A & B Solution
20 Discuss	Delete Table Metadata enables database designers and users to do all of the following except 1] sample data 2] understand what data exist 3] what the fine distinctions are between similar data items 4] what the data mean Solution
21 Discuss	Delete Table Structured data may include which of the following? 1] Photo image 2] Video clip 3] Dates 4] None of the above Solution
#	Quiz

SQL -Structured Query Language - SQL Delete - Delete Table Quiz

Solution

Solution

Solution

Solution

Solution

Solution

Solution

Solution

Solution

Solution

Solution

Solution

Solution

Solution

Solution

Solution

Solution

Solution

Solution

Solution

Solution

About Fresherbell

Important Links

Social Media