Intelligent MS SQL Basic Assessment Test

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 Cripstwick
C
Cripstwick
Community Contributor
Quizzes Created: 636 | Total Attempts: 785,233
Questions: 10 | Attempts: 150

SettingsSettingsSettings
Intelligent MS SQL Basic Assessment Test - Quiz

We sincerely welcome you to this informative Intelligent MS SQL basic assessment test! Developed by Microsoft, MS SQL is a relational database management system. Take this short basic assessment test to assess your knowledge of MS SQL. Please make sure to read all the questions very carefully before answering. All the questions in the quiz are mandatory and your scores are dependent on how many questions you get correct. Your scores will be reflected once you've completed answering the quiz. Keep learning and have fun!


Questions and Answers
  • 1. 

    What is a database?

    • A.

      A collection of data

    • B.

      A collection of structured data

    • C.

      A collection of similar data

    • D.

      A large collection of desimilar data

    Correct Answer
    B. A collection of structured data
    Explanation
    A database is a collection of structured data because it organizes and stores information in a systematic way. Structured data refers to data that is organized into predefined categories and follows a consistent format. In a database, data is typically stored in tables with rows and columns, allowing for efficient storage, retrieval, and manipulation of information. This structure enables users to easily search, sort, and analyze the data, making it a valuable tool for managing and accessing large amounts of information.

    Rate this question:

  • 2. 

    Which of these is referred to as a specified number of columns in a table?

    • A.

      Row

    • B.

      Records

    • C.

      Fields

    • D.

      Data

    Correct Answer
    C. Fields
    Explanation
    Fields are referred to as a specified number of columns in a table. In a database table, each field represents a specific piece of information or attribute. It is used to define the structure and organization of the data stored in the table. Fields can contain different types of data such as text, numbers, dates, etc. They are essential for categorizing and organizing data in a table, allowing for efficient storage and retrieval of information.

    Rate this question:

  • 3. 

    Which of these is a combination of fields which uniquely specify a row?

    • A.

      Unique key

    • B.

      Foreign key

    • C.

      Surrogate key

    • D.

      Primary key

    Correct Answer
    D. Primary key
    Explanation
    A primary key is a combination of fields that uniquely identifies each row in a database table. It ensures that each row has a unique identifier, which helps in maintaining data integrity and enforcing uniqueness constraints. Other keys such as unique key, foreign key, and surrogate key may also have unique values, but a primary key is specifically designed to uniquely identify each row in a table.

    Rate this question:

  • 4. 

    The first normal form (1NF) is used to...

    • A.

      Remove all duplicate columns

    • B.

      Remove all duplicate rows

    • C.

      Remove all duplicate records

    • D.

      Remove all duplicate files

    Correct Answer
    A. Remove all duplicate columns
    Explanation
    The first normal form (1NF) is used to remove all duplicate columns from a database table. This means that each column in the table should contain only atomic values and not repeat any information. This helps in organizing the data in a structured manner and avoids redundancy. By removing duplicate columns, the database becomes more efficient and easier to manage.

    Rate this question:

  • 5. 

    Which of these is a not a type of index?

    • A.

      Unique index

    • B.

      Ordinary index

    • C.

      Clustered index

    • D.

      Unclustered index

    Correct Answer
    B. Ordinary index
    Explanation
    An ordinary index is not a type of index because it is not a commonly recognized or defined type of index in database systems. Unique index, clustered index, and unclustered index are all well-known types of indexes used to optimize data retrieval and improve database performance. However, there is no standard definition or widely accepted concept of an "ordinary index" in the field of database management.

    Rate this question:

  • 6. 

    How many cluster indexes can be found in a table?

    • A.

      1

    • B.

      2

    • C.

      3

    • D.

      4

    Correct Answer
    A. 1
    Explanation
    A table can have only one cluster index. A cluster index determines the physical order of the data in a table. It reorganizes the table's data rows to match the index's order, which can improve query performance. Having multiple cluster indexes would contradict the purpose of a cluster index, as it is meant to define the physical order of the data in the table. Therefore, the correct answer is 1.

    Rate this question:

  • 7. 

    A code written to get information back from the database is called...

    • A.

      Command

    • B.

      Query

    • C.

      Question

    • D.

      SERP

    Correct Answer
    B. Query
    Explanation
    A code written to get information back from the database is called a query. Queries are used to retrieve specific data from a database by specifying the criteria for the search. They allow users to extract the required information by requesting it from the database. Therefore, a query is the correct term to describe this type of code.

    Rate this question:

  • 8. 

    What are the types of subquery?

    • A.

      Correlated and non-correlated

    • B.

      Query and question

    • C.

      Regular and irregular

    • D.

      Centralized and decentralized

    Correct Answer
    A. Correlated and non-correlated
    Explanation
    The correct answer is correlated and non-correlated. A subquery is a query nested within another query. In a correlated subquery, the inner query depends on the result of the outer query, and it is executed for each row of the outer query. On the other hand, a non-correlated subquery is independent of the outer query and can be executed separately. These types of subqueries are used to retrieve specific data based on certain conditions and are commonly used in SQL queries.

    Rate this question:

  • 9. 

    The Scala user function is primarily used to return _____ from the database.

    • A.

      Table

    • B.

      Unit

    • C.

      Clause

    • D.

      Row

    Correct Answer
    B. Unit
    Explanation
    The Scala user function is primarily used to return nothing from the database. In Scala, the Unit type represents the absence of a value, similar to void in other programming languages. When a function in Scala does not need to return any specific value, it can be declared as having a return type of Unit. Therefore, the correct answer is Unit.

    Rate this question:

  • 10. 

    Which of these operators is used to return rows from the first query but not from the second query?

    • A.

      INTERSECT

    • B.

      UNION

    • C.

      MINUS

    • D.

      MULTIPLE

    Correct Answer
    C. MINUS
    Explanation
    The MINUS operator is used to return rows from the first query but not from the second query. It compares the result sets of two queries and returns the rows from the first query that are not present in the second query. This allows for finding the differences between two result sets and obtaining only the unique rows from the first query.

    Rate this question:

Quiz Review Timeline +

Our quizzes are rigorously reviewed, monitored and continuously updated by our expert board to maintain accuracy, relevance, and timeliness.

  • Current Version
  • Aug 31, 2023
    Quiz Edited by
    ProProfs Editorial Team
  • Mar 14, 2018
    Quiz Created by
    Cripstwick

Related Topics

Back to Top Back to top
Advertisement
×

Wait!
Here's an interesting quiz for you.

We have other quizzes matching your interest.