Quiz 5 SEC A

Approved & Edited by ProProfs Editorial Team
The editorial team at ProProfs Quizzes consists of a select group of subject experts, trivia writers, and quiz masters who have authored over 10,000 quizzes taken by more than 100 million users. This team includes our in-house seasoned quiz moderators and subject matter experts. Our editorial experts, spread across the world, are rigorously trained using our comprehensive guidelines to ensure that you receive the highest quality quizzes.
Learn about Our Editorial Process
| By Mujmuj2019
M
Mujmuj2019
Community Contributor
Quizzes Created: 1 | Total Attempts: 106
Questions: 10 | Attempts: 106

SettingsSettingsSettings
Computer Science Quizzes & Trivia

.


Questions and Answers
  • 1. 

    You can add a row using SQL in a database with which of the following?

    • A.

      ADD

    • B.

      CREATE

    • C.

      INSERT

    • D.

      MAKE

    Correct Answer
    C. INSERT
    Explanation
    In SQL, the INSERT statement is used to add new rows to a database table. It allows you to specify the values for each column in the new row or select values from another table. Therefore, the correct answer is INSERT.

    Rate this question:

  • 2. 

     The term attribute refers to a ___________ of a table.

    • A.

      Record

    • B.

      Column

    • C.

      Tuple

    • D.

      Key

    Correct Answer
    B. Column
    Explanation
    The term attribute refers to a characteristic or property of a table. In the context of a database, a column represents an attribute as it defines the specific type of data that can be stored in that column. Each column in a table corresponds to a specific attribute, such as a person's name, age, or address. Therefore, the correct answer is "Column."

    Rate this question:

  • 3. 

    For each attribute of a relation, there is a set of permitted values, called the ________ of that attribute.

    • A.

      Domain

    • B.

      Relation

    • C.

      Set

    • D.

      Schema

    Correct Answer
    A. Domain
    Explanation
    The correct answer is "Domain." In the context of a relation, a domain refers to the set of permitted values for each attribute. It defines the data type and range of values that an attribute can take. The domain ensures data integrity and consistency within the relation by specifying the allowed values for each attribute.

    Rate this question:

  • 4. 

    Database __________ which is the logical design of the database, and the database _______ which is a snapshot of the data in the database at a given instant in time.

    • A.

      Instance, Schema

    • B.

      Relation, Schema

    • C.

      Relation, Domain

    • D.

      Schema, Instance

    Correct Answer
    D. Schema, Instance
    Explanation
    A schema refers to the logical design of a database, which includes the structure, organization, and relationships between the database objects such as tables, views, and constraints. It defines the blueprint for how the data is organized and stored in the database. On the other hand, an instance refers to a snapshot of the data in the database at a specific moment in time. It represents the actual data that is currently stored in the database. Therefore, the correct answer is "Schema, Instance."

    Rate this question:

  • 5. 

    Objects in database description is called

    • A.

      Concept construct

    • B.

      Entity construct

    • C.

      Schema construct

    • D.

      Attribution construct

    Correct Answer
    C. Schema construct
    Explanation
    In a database, the objects are organized and described using a schema construct. A schema is a collection of database objects, such as tables, views, and relationships, that define the structure, organization, and constraints of the data. It provides a blueprint for how the data is stored and accessed in the database. Therefore, the correct answer is "schema construct" as it refers to the objects in a database description.

    Rate this question:

  • 6. 

    Complete description of database which is described in design phase and is changed rarely is called ​​​​​

    • A.

      Schema

    • B.

      Structure

    • C.

      Path of design

    • D.

      Data cycle scheme

    Correct Answer
    A. Schema
    Explanation
    In the design phase of a database, a complete description of the database is created, which includes the structure and organization of the data. This description is called a schema. The schema defines the tables, columns, relationships, and constraints in the database. It serves as a blueprint for creating and managing the database. Since the schema is rarely changed once it is designed, it provides a stable foundation for the database structure.

    Rate this question:

  • 7. 

    Which one of the following attribute can be taken as a primary key ?

    • A.

      Name

    • B.

      Street

    • C.

      Id

    • D.

      Department

    Correct Answer
    C. Id
    Explanation
    The attribute "Id" can be taken as a primary key because it is likely to be unique for each record in the database table. Primary keys are used to uniquely identify each row in a table, and the "Id" attribute is commonly used for this purpose.

    Rate this question:

  • 8. 

    A attribute in a relation is a foreign key if the _______ key from one relation is used as an attribute in that relation 

    • A.

      Candidate

    • B.

      Primary

    • C.

      Super

    • D.

      Sub

    Correct Answer
    B. Primary
    Explanation
    If an attribute in a relation is a foreign key, it means that the attribute is referencing the primary key from another relation. In this case, the foreign key attribute in the relation is using the primary key from another relation as its value.

    Rate this question:

  • 9. 

    Architecture of the database can be viewed as (A) . (B). (C)

    • A.

      Two levels

    • B.

      Four levels

    • C.

      Three levels

    • D.

      One level

    Correct Answer
    C. Three levels
    Explanation
    The architecture of a database can be viewed as having three levels. These levels include the external level, which is the user's view of the data and how it is presented; the conceptual level, which represents the overall logical structure of the database; and the internal level, which deals with the physical storage and implementation details of the database. This three-level architecture allows for separation between the different aspects of the database, providing flexibility, security, and ease of use.

    Rate this question:

  • 10. 

    The language used in application programs to request data from the DBMS is referred to as the (A) (B)(C) (D)

    • A.

      DML

    • B.

      DDL

    • C.

      VDL

    • D.

      SDL

    Correct Answer
    A. DML
    Explanation
    DML stands for Data Manipulation Language, which is the language used in application programs to request data from the DBMS (Database Management System). It allows users to retrieve, insert, update, and delete data in the database. DDL (Data Definition Language) is used to define the database structure, VDL and SDL are not commonly used terms in relation to database programming. Therefore, the correct answer is DML.

    Rate this question:

Related Topics

Back to Top Back to top
Advertisement
×

Wait!
Here's an interesting quiz for you.

We have other quizzes matching your interest.