Query Maestro - Round 1(Set 1)
-
What does SQL stand for?
-
Structured Question Language
-
Strong Question Language
-
Structured Query Language
-
String Query Language
-
QUERY MAESTRO - Round 1(Set 1) assesses foundational knowledge in SQL and database management. It covers SQL commands, database queries, and key relational database concepts, essential for anyone learning or working in data management and manipulation.
Quiz Preview
- 2.
Student(ID, name, dept, name, tot_cred) In this query which attribute form the primary key?
-
Name
-
ID
-
Tot_cred
-
Dept
Correct Answer
A. IDExplanation
The attribute "ID" forms the primary key in the given query. The primary key is a unique identifier for each record in a database table, and it ensures the uniqueness and integrity of the data. In this case, the "ID" attribute is most likely a unique identifier for each student, making it suitable to be the primary key.Rate this question:
-
- 3.
With SQL, how do you select all the columns from a table named "Persons"?
-
SELECT [all] FROM PERSONS
-
SELECT * FROM Persons
-
SELECT *.Persons
-
SELECT Persons
Correct Answer
A. SELECT * FROM PersonsExplanation
The correct answer is "SELECT * FROM Persons". This query selects all the columns from the table named "Persons". The asterisk (*) is a wildcard character that represents all columns in the table. By using this query, all the data from all columns will be retrieved from the "Persons" table.Rate this question:
-
- 4.
Using which language can a user request information from a database?
-
Relational
-
Structural
-
Compiler
-
Query
Correct Answer
A. QueryExplanation
A user can request information from a database using the Query language. Query language allows users to retrieve, manipulate, and manage data stored in a database. It provides a standardized way to communicate with the database and perform various operations such as selecting specific data, updating records, and sorting information. By using the Query language, users can effectively interact with the database and retrieve the desired information based on their specific requirements.Rate this question:
-
- 5.
An entity set that does not have sufficient attributes to form a primary key is termed as _____.
-
Strong entity set
-
Variant set
-
Weak entity set
-
Variable set
Correct Answer
A. Weak entity setExplanation
A weak entity set is an entity set that does not have sufficient attributes to form a primary key. Unlike a strong entity set, which has a unique identifier, a weak entity set relies on its relationship with a strong entity set to determine its identity. The primary key of a weak entity set includes the primary key of the related strong entity set, along with its own partial key. This ensures that the weak entity set is uniquely identified within the context of its relationship with the strong entity set.Rate this question:
-
- 6.
In SQL the spaces at the end of the string are removed by ______ function.
-
Upper
-
Lower
-
String
-
Trim
Correct Answer
A. TrimExplanation
The Trim function in SQL is used to remove any leading or trailing spaces from a string. So, in this case, the spaces at the end of the string will be removed by the Trim function.Rate this question:
-
- 7.
The DROP TABLE statement :
-
Deletes the table structure only
-
Works whether or not referential integrity constraints would be violated
-
Deletes the table structure along with the table data
-
Is not an SQL statement
Correct Answer
A. Deletes the table structure along with the table dataExplanation
The DROP TABLE statement is used to delete a table from a database. It not only deletes the table structure but also deletes all the data stored in the table. This means that all the rows and columns within the table will be permanently removed. It is a valid SQL statement and can be used to effectively remove a table and its associated data from the database.Rate this question:
-
- 8.
Which of the following indicates the maximum number of entities that can be involved in a relationship?
-
Greater Entity Count(GEC)
-
Minimum cardinality
-
ERD
-
Maximum cardinality
Correct Answer
A. Maximum cardinalityExplanation
Maximum cardinality indicates the maximum number of entities that can be involved in a relationship. It represents the upper limit of the number of entities that can participate in a relationship. In an entity-relationship diagram (ERD), the maximum cardinality is typically represented by a symbol such as "1" for one entity, "N" for any number of entities, or a specific number indicating the maximum count. This helps in defining the scope and constraints of the relationship between entities in a database system.Rate this question:
-
- 9.
Course(course_id, sec_id, semester) Here the course_id, sec_id and semester are _______ and course is a______.
-
Relations,Attribute
-
Tuple,Relation
-
Attributes, Relation
-
Tuple, Attributes
Correct Answer
A. Attributes, RelationExplanation
In the given question, the attributes are course_id, sec_id, and semester, which are the characteristics or properties of the relation "Course". The relation "Course" represents a collection of tuples or rows that contain information about different courses. Therefore, the correct answer is "Attributes, Relation".Rate this question:
-
- 10.
For each attribute of a relation, there is a set of permitted values, called the _____of the attribute.
-
Relation
-
Domain
-
Set
-
Schema
Correct Answer
A. DomainExplanation
The term "domain" refers to the set of permitted values for each attribute of a relation. In other words, it represents the range of values that an attribute can take within a relation. The domain helps define the type and constraints of the data that can be stored in a specific attribute. It ensures that only valid and meaningful values are allowed for each attribute in a relation.Rate this question:
-
- 11.
A relational database consists of a collection of
-
Records
-
Tables
-
Fields
-
Keys
Correct Answer
A. TablesExplanation
A relational database consists of tables, which are used to organize and store data. Tables contain rows, also known as records, which represent individual instances or entries in the database. Each record is made up of fields, which store specific pieces of information. Keys are used to uniquely identify each record within a table. Therefore, the correct answer is "Tables" as they are the main structure in a relational database that hold the data.Rate this question:
-
- 12.
With SQL, how can you return all the records from a table named "Persons" sorted descending by "FirstName"?
-
SELECT * FROM Persons ORDER FirstName DESC
-
SELECT * FROM Persons SORT 'FirstName' DESC
-
SELECT * FROM Persons ORDER BY FirstName DESC
-
SELECT * FROM Persons SORT BY 'FirstName' DESC
Correct Answer
A. SELECT * FROM Persons ORDER BY FirstName DESCExplanation
The correct answer is "SELECT * FROM Persons ORDER BY FirstName DESC". This query will retrieve all the records from the "Persons" table and sort them in descending order based on the "FirstName" column. The "ORDER BY" clause is used to specify the sorting order in SQL queries.Rate this question:
-
- 13.
Key to represent relationship between tables is called
-
Foreign Key
-
Primary Key
-
Super Key
-
Secondary key
Correct Answer
A. Foreign KeyExplanation
A foreign key is a key used to establish a relationship between two tables in a database. It is a column or a set of columns in one table that refers to the primary key in another table. This relationship ensures data integrity and enables the tables to be linked together. Therefore, the correct answer is "Foreign Key".Rate this question:
-
- 14.
The tuples of the relations can be of ______ order.
-
Same
-
Sorted
-
Any
-
Constant
Correct Answer
A. AnyExplanation
The tuples of the relations can be of any order. This means that the tuples can have any number of attributes or fields. There is no restriction on the number of attributes that a tuple can have in a relation.Rate this question:
-
- 15.
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 of time.
-
Instance, Schema
-
Relation, Schema
-
Relation, Domain
-
Schema, Instance
Correct Answer
A. Schema, InstanceExplanation
In a database, the schema refers to the logical design of the database, including the structure, organization, and relationships between the data elements. It defines the tables, columns, data types, constraints, and other attributes of the database. On the other hand, an instance of a database is a snapshot of the data in the database at a specific moment in time. It represents the actual data stored in the database at that particular instant. Therefore, the correct answer is "Schema, Instance."Rate this question:
-
- 16.
A ________ is a special kind of a store procedure that executes in response to certain action on the table like insertion, deletion or updation of data.
-
Triggers
-
Functions
-
Procedures
-
None of the above
Correct Answer
A. TriggersExplanation
Triggers are a special kind of store procedure that execute in response to certain actions on a table, such as insertion, deletion, or updating of data. They are used to enforce business rules, maintain data integrity, and automate tasks. When a trigger is activated, it can perform a series of actions, such as inserting or updating data in other tables, sending notifications, or performing calculations. Therefore, triggers are the correct answer in this case.Rate this question:
-
- 17.
In the ______ normal form, a composite attribute is converted to individual attributes.
-
First
-
Second
-
Third
-
Fourth
Correct Answer
A. FirstExplanation
In the first normal form, a composite attribute is converted to individual attributes. This means that instead of having a single attribute that stores multiple values, each value is stored in its own separate attribute. This helps to eliminate data redundancy and ensures that each attribute contains atomic values.Rate this question:
-
- 18.
A domain is atomic if elements of the domain are considered to be ______units.
-
Different
-
Indivisible
-
Constant
-
Divisible
Correct Answer
A. IndivisibleExplanation
An atomic domain refers to a domain where its elements are considered to be indivisible units. This means that the elements cannot be divided or broken down into smaller parts. In this context, the correct answer is "Indivisible" as it accurately describes the characteristic of an atomic domain.Rate this question:
-
- 19.
Which of the following is not Armstrong's Axiom?
-
Transitivity rule
-
Pseudotransitivity rule
-
Reflexive rule
-
Augmentation rule
Correct Answer
A. Pseudotransitivity ruleExplanation
The given correct answer, "Pseudotransitivity rule," is not Armstrong's Axiom. Armstrong's Axioms are a set of inference rules used in functional dependency theory to derive all functional dependencies in a relational database schema. The three main axioms are Reflexivity, Augmentation, and Transitivity. The Pseudotransitivity rule is not one of Armstrong's Axioms and is therefore the correct answer.Rate this question:
-
- 20.
-To remove a relation from an SQL database, we use the ____ command.
-
Delete
-
Remove
-
Drop table
-
Purge
Correct Answer
A. DeleteExplanation
To remove a relation from an SQL database, we use the "Delete" command. This command is specifically designed to delete data from a table in the database. It allows us to remove specific rows or all rows from a table, effectively removing the relation associated with that data. The other options mentioned in the question, such as "Remove," "Drop table," and "Purge," are not valid commands in SQL for removing a relation from a database.Rate this question:
-
Quiz Review Timeline (Updated): Mar 14, 2023 +
Our quizzes are rigorously reviewed, monitored and continuously updated by our expert board to maintain accuracy, relevance, and timeliness.
-
Current Version
-
Mar 14, 2023Quiz Edited by
ProProfs Editorial Team -
Feb 26, 2019Quiz Created by
QueryMaestro
Back to top