Top 1000+ Database Subject Mcqs Pdf Download Set No 11

by
Print/Downlaod pdf

501.You want to create a composite PK using the first and third fields in the table. How is this done?

  1. Hold down the Shift key and click the first and third fields. Click the Key icon on the toolbar.
  2. Access warns you that no primary key is defined, but lets you save the table if you want to.
  3. Hold down the Ctrl key and click the first and third fields. Click the Key icon on the toolbar.
  4. Hold down the Shift key and click the first and third fields. Select Primary Key under the Table.
  5. Hold down the Ctrl key and click the first and third fields. Select Primary Key under the Table.

502.What is required to establish a

  1. 1:1 relationship between two tables that do not contain a super type and subtype?
  2. 1:1 relationships are only possible if the tables contain a super type and subtype.
  3. Make sure that the PK in the related table has unique values.
  4. Nothing special is required.
  5. Make sure that the FK in the related table has an index property that specifies unique values.

503. In Access, how do you tell if referential integrity is enforced for a relationship

  1. The relationship lines are thick and dark, and the nature of the relationships is labeled.
  2. The relationship lines are thin, and the nature of the relationships is labeled.
  3. Right-click the relationship line to see if enforce referential integrity is checked.
  4. Right-click the relationship line, select referential integrity, and look at the relationship’s properties.

 504.The relationship between STORE and EMPLOYEE is defaulted to mandatory, that is, the FK value in EMPLOYEE is required. How do you eliminate a record from STORE?

  1. Delete the employees from the STORE to be deleted.
  2. Permanently remove the referential integrity enforcement.
  3. Open the EMPLOYEE table in the design format; then change the Required property of the        EMPLOYEE’s FK to No and make sure that its default value is set to null.
  4. Delete all relationships between STORE and EMPLOYEE.
  5. Redesign the database to work without them.

 505. What does Access use to handle SQL code generation?

  1. SQL forms
  2. Query Code Generator
  3. Query by Example

506.What does the wildcard ? match?

  1. Zero or more of the preceding character
  2. Any one character in the position held by the ?
  3. Multiple characters in the position held by the ?
  4. Any letter in the position held by the ?   
  1.              

507.Which of the following are not functions of forms?

  1. Forms are used to tie together the database components through menu structures.
  2. Forms  program and control user responses
  3. Forms extend data validation rules through queries, value lists, and other input control device
  4. Forms are used to enter new data and to edit existing data.

   508.Which of the following correctly describes the relationship between forms and tables?

  1. A form is based on exactly one table. The table must exist before the form is created.
  2. A form is based on exactly one table. The table may be created before or after the form is created.
  3. A form may be based on one or more tables. The table(s) must exist before the form is created.
  4. A form may be based on one or more tables. The table(s) may be created before or after the form is created.

509.What are the advantages of form-based dialog boxes?

  1. They have more prompting options than dialog boxes generated by Access.
  2. They allow the use of combo boxes.
  3. Access-generated dialog boxes are likely to disrupt interface layout schemes, while form-based dialog boxes are not.
  4. All .

 506.Which of the following is not an advantage of a menu driven database system

  1. Help make the database applications system user-friendly by eliminating the need to remember command languages.
  2. Provide security though user-level logins.
  3. Control access by providing only those options that allow people to do their jobs.
  4. Create an environment that is tailored to specific types of applications and end use

507.Which of the following accurately describes a crosstab query?

  1. Crosstab queries have very limited summary capabilities
  2. .  You can select row totals and also column totals.
  3. Crosstab queries are seldom used to generate reports.
  4. If you select row totals in the crosstab query, you cannot also select column totals.

508.What kind of query works best with the Chart Wizard?

  1. Select
  2. Append
  3. Update
  4. Action

     509. A collection of conceptual tools for describing data, relationships, semantics and constraints is referred to as ……….

  1. Database
  2. E- Data Model
  3. R Model
  4. All

510. Dr. E.F. Coded represented ……. rules that a database must obey if it has to be considered truly relational.

  1. 10
  2. 14 
  3. 12  
  4. 10

511.In E-R Diagram, weak entity is represented by…….

  1. Rectangle
  2. Double Rectangle
  3. Square
  4. Circle

512. An entity that is related with itself is known as…….

  1. binary relationship
  2. recursive relationship
  3. ternary relationship
  4. None of the above

513.……. is a bottom-up approach in which two lower level entities combine to form a higher level entity.

  1. Aggregation
  2. Generalization
  3. Specialization  
  4. All

514.An entity set that does not have sufficient attributes to form a primary key, is a ……

  1. Primary entity set
  2. Weak entity set
  3. Strong entity set

516.Which SQL command delete all the records and does not remove the structure?

  1. Drop      
  2. Insert   
  3. Truncate
  4. None of the above

517.Which of the following is a Data Definition Language (DDL) command?

  1. Drop 
  2. Delete
  3. Insert   
  4. Alter  

518.In …….. database, data is organized in the form of trees with nodes.

  1. Hierarchical
  2. Relational
  3. Network
  4. None of the above

519.Which command is used to retrieve records from one or more table?

  1. Delete
  2. Insert   
  3. Drop    
  4. Select

520.Rows of a relation are called             

  1. Entity
  2. degree
  3. tuple
  4. None

521.The number of tuples in a relation is termed as       

  1. cardinality
  2. entity
  3. column
  4. (D) None of the above

522.In SQL, Which of the following is a Data Manipulation Language(DML) command?

  1. create
  2. alter
  3. drop
  4. merge  

523….. is a top-down approach in which one higher level entity can be divided into two lower level entities.

  1. Aggregation
  2. Specialization
  3. Generalization
  4. None of the above

524.Which of the following is not a type of database?

  1. Hierarchical
  2. Relational
  3. Network
  4. transition

525. In a relational database, each tuple is divided into fields called     

  1. Domains
  2. Relations   
  3. Queries
  4. None of the above

526.In E-R Diagram, attribute is represented by…….

  1. Rectangle
  2. Eclipse
  3. Square
  4. Double Rectangle

527.In SQL, TCL stands for           

  1. Control Language
  2. Transaction Central Language
  3. Ternary Control Language
  4. Transaction Control Language

528.Which of the following is a part of the Oracle database system?

  1. Free lists
  2. Front end
  3. Network
  4. None of the above

529.Which of the following is used with database?

  1. Data Mining
  2. ATM
  3. Payment gateway
  4. None of the above

530.Which of the following is used with database?

  1. ATM
  2. Payment gateway
  3. Mining
  4. None

531.Which of the following is used with database?

  1. ATM
  2. Payment gateway
  3. Mining
  4. None

532.The language used in application programs to request data from the DBMS is referred to as

the        

  1. DML
  2. DDL
  3. DCL

533.In Oracle, who owns the data dictionary?

  1. DBA
  2. SYS
  3. SYSTEM
  4. None

534.n SQL, which command is used to update existing row in a table?

  1. Insert
  2. Delete
  3. Update
  4. (D) None of the above

535. A                    contains the smallest unit of meaningful data, so you might call it the basic building block for a data file.

  1. Record
  2. Field
  3. Table
  4. None of the above

536.A relation between two entities is treated as a single entity is called           

  1. Aggregation  
  2. Specialization
  3. Generalization
  4. None

537.Data mining evolve as a mechanism to cater the limitations of                 systems to deal massive data sets with high dimensionality.

  1. OLAP 
  2. OLTP 
  3. DWH
  4. None of the above

538.In Relational table, the term “Attribute” is also used to represent                 

  1. row
  2. column (or) field
  3. entity
  4. None

539.Which of the following categories of the data integrity RDBMS will enforce specific business rules?

  1. Entity Integrity
  2. User-Defined Integrity
  3. Domain Integrity
  4. None

540.E-R Modeling technique is a             

  1. bottom-up approach
  2. top-down approach
  3. User-Define
  4. None

541.The number of attributes in a relation is called its

  1. row
  2. column
  3. Tuple
  4. Record

542.top to bottom relationship among the items in a database is established by a          

  1. Network Schema ()
  2. Relational Schema ()
  3. Hierarchical Schema ()
  4. None of the above

543.Aggregation is a special form of  

  1. Specialization
  2. association
  3. Generalization
  4. None of the above

544.In E-R diagrams,                      represents Key attribute

  1. Ellipse with underlying line
  2. Rectangle with underlying line
  3. Double rectangle
  4. None of the above

<Previous Page
Take Quiz No 11
Next Page >
Post Views: 799