Exam (elaborations)
DBI-202 Exam |Questions with 100% Correct Answers
- Course
- Institution
DBI-202 Exam |Questions with 100% Correct Answers
[Show more]
Seller
Follow
Content preview
DBI-202 Exam |Questions with 100% CorrectAnswers
1. The relational model is based on the concept that data is organized and stored in two-
dimensional tables called ............................ - ✔️✔️Relations
2. .................... contains information that defines valid values that are stored in a column or
data type. - ✔️✔️Index
3. Which of the syntax is correct for insert statement? - ✔️✔️Both of them
4. ................... First proposed the process of normalization. - ✔️✔️Edgar F. Codd
5. For using a specific database ............... command is used. - ✔️✔️use database
6. Which of the following is not comparison operator? - ✔️✔️=<
7. An outstanding functionality of SQL is its support for automatic ............ to the target data. -
✔️✔️navigation
8. ..................... is a special type of integrity constraint that relates two relations & maintains
consistency across the relations. - ✔️✔️Referential.....Constraints
9. .................specifies a search condition for a group or an aggregate. - ✔️✔️HAVING Clause
10. Drop Table cannot be used to drop a table referenced by a ............... constraint. -
✔️✔️Foreign Key
,1. ............... joins are SQL server default - ✔️✔️Inner
2. The ..................... is essentially used to search for patterns in target string. - ✔️✔️Like
Predicate
3. Which of the following is/are the Database server functions? 1.Data 2.Transaction 3.Compile
queries 4.Query optimization - ✔️✔️i, ii, and iv only
4. To delete a database ................... command is used - ✔️✔️drop ....database_name
5. .............. is a combination of two of more attributes used as a primary key - ✔️✔️Composite
Key
6. Which of the following is not the function of client? - ✔️✔️Query optimization
7. ............. is a special type of stored procedure that is automatically invoked whenever the
data in the table is modified. - ✔️✔️Trigger
8. ................. requires that data should be made available to only authorized users. -
✔️✔️Security
9. Some of the utilities of DBMS are ............. - ✔️✔️Loading,Backup,FileOrganization
10. ................. allows individual row operation to be performed on a given result set or on the
generated by a selected by a selected statement. - ✔️✔️Curser
1. Processed data is called .................... - ✔️✔️Information
,2. ................. is a utility to capture a continuous record of server activity and provide auditing
capability. - ✔️✔️SQL server service manager
3. Data items grouped together for storage purposes are called a - ✔️✔️record
4. ............. contains data assisting day to day activities of the organization. - ✔️✔️Operational
database
5. ..................... approach reduces time and effort required for design and lesser risk in
database management. - ✔️✔️Multiple databases
6. HSAM stands for .......... - ✔️✔️Hierarchic Sequential Access Method
7. SQL server stores index information in the ............ system table - ✔️✔️sys indexes
8. The one guideline to be followed while designing the database is - ✔️✔️It should avoid/reduce
the redundancy.
9. Which of the following is not a logical database structure? - ✔️✔️Chain
10. ................ is a preferred method for enforcing data integrity - ✔️✔️Constraints
1. Reflexivity property says that X - Y is true if Y is ...................... - ✔️✔️Subset of X
2. Anything that affects the database schema is a part of - ✔️✔️DDL
3. An instance of a relation is a time varying set of ...................... - ✔️✔️Both of them
, 4. In the ..................... mode any record in the file can be accessed at random - ✔️✔️Random
access
5. Which can be used to delete all the rows if a table? - ✔️✔️Delete * from table_name
6. Which if the following is not the type of data integrity. - ✔️✔️Key integrity
7. 4NF stands for .. - ✔️✔️Fourth Normal Form
8. A .................. allows to make copies of the database periodically to help in the cases of
crashes & disasters. - ✔️✔️Backup Utility
9. ................... Allows definitions and query language statements to be entered; query results
are formatted and displayed. - ✔️✔️Terminal Interface
10. The main task carried out in the ............... is to remove repeating attributes to separate
tables - ✔️✔️Fourth Normal Form
1. ............................ is the powerful language for working with RDBMS. - ✔️✔️Query Language
2. The file in DBMS is called as .................. in RDBMS. - ✔️✔️table
3. In ..................... , we have a strict parent-child relationship only. - ✔️✔️hierarchical databases.
4. Which normal form is considered adequate for relational database design? - ✔️✔️3 NF
5. What operator tests column for the absence of data? - ✔️✔️IS NULL operator
The benefits of buying summaries with Stuvia:
Guaranteed quality through customer reviews
Stuvia customers have reviewed more than 700,000 summaries. This how you know that you are buying the best documents.
Quick and easy check-out
You can quickly pay through credit card or Stuvia-credit for the summaries. There is no membership needed.
Focus on what matters
Your fellow students write the study notes themselves, which is why the documents are always reliable and up-to-date. This ensures you quickly get to the core!
Frequently asked questions
What do I get when I buy this document?
You get a PDF, available immediately after your purchase. The purchased document is accessible anytime, anywhere and indefinitely through your profile.
Satisfaction guarantee: how does it work?
Our satisfaction guarantee ensures that you always find a study document that suits you well. You fill out a form, and our customer service team takes care of the rest.
Who am I buying these notes from?
Stuvia is a marketplace, so you are not buying this document from us, but from seller Examcheatcode. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $13.49. You're not tied to anything after your purchase.
Can Stuvia be trusted?
4.6 stars on Google & Trustpilot (+1000 reviews)
75632 documents were sold in the last 30 days
Founded in 2010, the go-to place to buy study notes for 14 years now