Top 1000+ Database Subject Mcqs Pdf Download Set No 10

by
Print/Downlaod pdf

451.Which of the following is used with INSERT command to insert values in a DB table?

Select correct option:

  1. ONTO
  2. INTO
  3. UPTO
  4. WITH

 452.Which of the following is a correct way of selecting all the columns from a table called PERSONS?

Select correct option:

  1. SELECT FROM * Persons
  2. SELECT * FROM Persons
  3. SELECT * WHERE Persons
  4. SELECT WHERE * Persons

453.The ________ operator allows to use wild cards in the where clause of an SQL statement.

Select correct option:

  1. IN
  2. FROM
  3. LIKE
  4. None .

 454.Which of the following statements creates a database named IMDB.

Select correct option:

  1. CREATE DATABASE IMDB;
  2. CREATE DB IMDB;
  3. ADD DATABASE named IMDB;
  4. CREATE IMDB DATABASE;

455.Which of the following is not a part of an INSERT statement?

Select correct option:

  1. INTO
  2. VALUES
  3. INSERT
  4. MODIFY

456.In SQL, which command is used to delete rows from table.

Select correct option:

  1. DELETE
  2. REMOVE
  3. TRUNCATE
  4. Both I and II

 457.Which of the following is the correct syntax for adding a new column into an existing table.

Select correct option:

  1. ALTER TABLE table_name { ALTER [COLUMN] column type [(size)] [DEFAULT default] }
  2. ALTER TABLE table_name { ADD [COLUMN] column type [(size)] [DEFAULT default] }
  3. Both I and II.
  4. None .

 458.GRANT belongs to which type of SQL commands classification

Select correct option:

  1. DML
  2. DCL
  3. DDL
  4. DQL

459.What happens if the WHERE clause is omitted from a DELETE statement?

Select correct option:

  1. All records from the table are deleted
  2. No record from the table will be deleted
  3. First record of the table will be deleted
  4. The statement will not be executed and will give a syntax error

460.What does the abbreviation DBMS stand for?

Select correct option:

  1. Database Manipulation Software.
  2. Database Management System.
  3. Data Borrowing and Movement Software
  4. Digital Base Mapping System.

461.Which of the following is used to filter rows according to some condition(s)?

Select correct option:

  1. SELECT
  2. FROM
  3. WHERE
  4. UPDATE

 462.REATE TABLE and CREATE index belongs to which type of SQL commands

Select correct option:

  1. DML
  2. DDL
  3. DCL
  4. DQL

463.Which of the following justifies the inclusion of derived attributes in a database?

  1. Inclusion of derived attributes is a standard procedure and does not require justification.
  2. Derived attributes should be used when they add to design elegance.
  3. Query speed is enhanced by not computing derived attributes.
  4. Poor design is the only excuse for the inclusion of derived attributes.

464.Select the statement that best defines a candidate key.

  1. An attribute or combination of attributes that allows the user to search for non-unique data
  2. An attribute or combination of attributes that could be, but is not, used as a PK
  3. An attribute or combination of attributes that is calculated from existing data.
  4. An attribute or combination of attributes that establishes relationships between tables.

465.A __________ is established when the value of one attribute is dependent on the value of another attribute.

  1. primary key
  2. data anomaly
  3. dependency
  4. transitive relationship

466.The room ID + building ID determines the room schedule. This is written:

  1. ROOM_ID, BUILD_ID ? ROOM_SCH
  2. ROOM_ID + BUILD_ID ? ROOM_SCH
  3. ROOM_ID, ROOM_SCH ? BUILD_ID
  4. ROOM_ID, BUILD_ID ? ROOM_SCH

 467.The database data storage standard requires that, with some exceptions, data must occur in only one place at one time. What are the exceptions?

  1. Foreign key and replicated data requirements
  2. Transitive dependencies and foreign keys
  3. Replicated data and primary keys
  4. Transitive dependencies and primary keys

468.Data redundancies produce unusual and undesirable data management problems caused by __

  1. transitive requirements
  2. dependencies
  3. normalization
  4. data anomalies

  469.Removing the __________ is part of the database design process.

  1. foreign keys
  2. partial and transitive dependencies
  3. primary key dependencies
  4. recursive relationships

470.In a POS system, what do the major transaction modules define?

  1. Inventory management, shipping, invoice calculations, and product returns
  2. Sales, inventory management, shipping, back ordering, and product returns
  3. Sales, invoice calculations, back ordering, and product returns
  4. Inventory management, shipping, invoice calculations, back ordering, and product returns

471.What are the fourth and fifth steps in developing a POS?

  1. Define the entities, attributes, relationships, connectivity’s, cardinalities, and constraints.    
  2. Create the initial ERD segments.
  3. Develop business rules. Create the initial ERD segments.
  4. Develop business rules. Define the entities, attributes, relationships, connectivity’s, cardinalities, and constraints.
  5. the major transaction modules. Create the initial ERD segments.

472.After creating the initial ERD segments, the next step is to

  1. define the major transaction modules.
  2. perform the appropriate normalization checks based on the data dictionary contents.
  3. create a basic data dictionary for all the components found in each ERD segment.
  4. define the entities, attributes, relationships, connectivity’s, cardinalities, and constraints.

473.What will the following questions help you define? What types of transactions take place? How many different types of transactions are there?

  1. Available resources
  2. Data environment
  3. Current operations
  4. Business objective

474.Which of the following is an advantage of having a precisely written set of current operations.

  1. It clarifies the assignment of data types.
  2. It highlights the best possible way to perform each task.
  3. It forces careful assessment of the procedures.
  4. It makes the creation of the data dictionary much easier.

 475.You have created a table in Access, but not yet designated a PK. What happens if you save the table now?

  1. The save fails because no PK is defined.
  2. The save works as usual.
  3. Access warns you that no primary key is defined, and forces you to define a PK before   saving.
  4. Access warns you that no primary key is defined, but lets you save the table if you want to

476.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. Select Primary Key under the Table.
  2. Hold down the Shift key and click the first and third fields. Click the Key icon on the toolbar.
  3. Hold down the Ctrl key and click the first and third fields. Click the Key icon on the toolbar.
  4. Hold down the Ctrl key and click the first and third fields. Select Primary Key under the Table.  
  1.                   

478.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 supertype and subtype.
  3. Make sure that the PK in the related table has unique values.
  4. Make sure that the FK in the related table has an index property that specifies unique values.
  5. Nothing special is required.

479.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 labele
  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  
  5. properties.

480.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. Redesign the database to work without them

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

  1. SQL form
  2. Query by Example
  3. Query Code Generate
  4. SQL compiler              
  1.      

482.Two basic query types exist. They are

      static and change queries.

  1. static and action queries.
  2. select and action queries.
  3. select and change queries.

483.What criteria matches dates from January 1, 1996 to the present?

  1. >= “01/01/1996”
  2. >= 01/01/1996
  3. >= #01/01/1996#
  4. >= ’01/01/1996′

484.EMP_DOB holds employee birth dates. Which format will display the month in number format, such as 01 or 11?

  1. Month: Format([EMP_DOB],”m”)
  2. Month: Format([EMP_DOB],”mm”)
  3. Month: Format([EMP_DOB],”mmm”)
  4. Month: Format([EMP_DOB],”mmmm”)      
  1.       

485.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 ?

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

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

487.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.

488.What is the most common form type?

  1. A single-source form, based on a tabular format
  2. A single-source form, based on a columnar format
  3. A multi-source form, based on a tabular for
  4. A multi-source form, based on a columnar format

489.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. All
  4. Access-generated dialog boxes are likely to disrupt interface layout schemes, while form-   based dialog boxes are not.

490.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 users.
  5. Reports and Labels

491.You want month names to be sorted in order (Jan, Feb, Mar, etc.) when they appear on a report. What do you need to do?

  1. Sort by month name.
  2. Sort by month number.
  3. Define the field with the data type month and sort Ascending.
  4. Define the field with the data type month and sort Descending.

492.What functions would you use to put the current time and data output in a report header?

  1. Time() and Now()
  2. Time() and CurrentDate()
  3. CurrentTime() and Now()
  4. CurrentTime() and CurrentDate ()

493. Which syntax will concatenate employee first and last names, with a space in between the names?

  1. ([EMP_FNAME] & ” ” [EMP_FNAME])
  2. ([EMP_FNAME] & ” ” & [EMP_FNAME])
  3. ([EMP_FNAME] ” ” & [EMP_FNAME])
  4. ([EMP_FNAME] ” ” [EMP_FNAME])

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

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

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

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

 496.Which of the following justifies the inclusion of derived attributes in a database?

  1. Inclusion of derived attributes is a standard procedure and does not require justification.
  2. Derived attributes should be used when they add to design elegance.
  3. Query speed is enhanced by not computing derived attributes.
  4. Poor design is the only excuse for the inclusion of derived attributes.
  1.  

497.Select the statement that best defines a candidate key.

  1. An attribute or combination of attributes that allows the user to search for non-unique data.
  2. An attribute or combination of attributes that is calculated from existing data.
  3. An attribute or combination of attributes that establishes relationships between table
  4. An attribute or combination of attributes that could be, but is not, used as a PK

 A __________ is established when the value of one attribute is dependent on the value of another attribute.

  1. primary key
  2. data anomaly
  3. dependency
  4. transitive relationship

498.Removing the __________ is part of the database design process.

  1. foreign keys
  2. partial and transitive dependencies                   
  3. primary key dependencies
  4. recursive relationships

499.Which of the following is an advantage of having a precisely written set of current operations.

  1. It clarifies the assignment of data types.
  2. It highlights the best possible way to perform each task.
  3. It forces careful assessment of the procedures.
  4. It makes the creation of the data dictionary much easier. 
  1.               

500.You have created a table in Access, but not yet designated a PK. What happens if you save the table now?

  1. The save fails because no PK is defined.
  2. The save works as usual.
  3. Access warns you that no primary key is defined, and forces you to define a PK before saving.

<Previous Page
Take Quiz No 10
Next Page >

Post Views: 658