Accenture
Primers
Assessments
Accenture Dumps
Coding Bank
Blog
Topics
Must Know
Mock Assessment 2026
Complete Question Index
Browse through all 2134 assessment questions (Page 3 of 15)
Agile & DevOps • Introduction To Agile
Which of the following agile methodologies depends on the cohesiveness of the team and individual commitment of the team members?
Agile & DevOps • Introduction To Agile
From the options select the configuration items that are eligible for configuration management Select one or more: a. Source code document b. SRS c. D...
Agile & DevOps • Introduction To Agile
________ is the process during which the changes of a system are implemented in a controllable manner by following a predefined model, with some reaso...
Agile & DevOps • Introduction To Agile
Which is the software configuration concept that ensures that change should be done in a controlled and authorized environment
Agile & DevOps • Introduction To Agile
Tom and Peter works on the same project. Tom does his work and update the local copy back to the configuration management server. This process is call...
Agile & DevOps • Introduction To Agile
____________ ensures that when two different people does the work and update parallelly, one should not over write the other
Agile & DevOps • Introduction To Agile
Collaborative and co-operative approach among all the stake holders is important. This is a feature of the _______________ Agile Methodology
Agile & DevOps • Introduction To Agile
Which of these is not an agile methodology
Agile & DevOps • Introduction To Agile
Scrum divides the development into short cycles called as ______
Agile & DevOps • Introduction To Agile
________ methodology is useful when the client requirements are not clear and stable
Agile & DevOps • Introduction To Agile
DSDM is iterative and incremental
Database Management • 01 Rdbms Concepts
Tom has designed a payroll software for XYZ technology.The sofware will store the salary details into the database and later he can retreive the same ...
Database Management • 01 Rdbms Concepts
In SQL is a case sensitive language and the data stored inside the table are case in-sensitive. Say true or false?
Database Management • 01 Rdbms Concepts
Which of the following is not a valid relational database?
Database Management • 01 Rdbms Concepts
Database is a shared collection of logically unrelated data, designed to meet the needs of an organization. State True or False.
Database Management • 01 Rdbms Concepts
Which of the following represents the degree of the relation?
Database Management • 03 Data Definition Language
A table consists of ______ primary keys.
Database Management • 03 Data Definition Language
We need to ensure that the amount withdrawn should be less then the credit card limit amount, to ensure this integrity what type constraint will be us...
Database Management • 03 Data Definition Language
Which of the following options is not correct?
Database Management • 03 Data Definition Language
An emp table contains fields employ name, desig and salary. How do you drop column salary?
Database Management • 03 Data Definition Language
Which of the following is not modification of the database
Database Management • 03 Data Definition Language
In a relational database a referential integrity constraint can be done using
Database Management • 03 Data Definition Language
___________ removes data from the table, but structure remains the same.
Database Management • 03 Data Definition Language
A relational database consists of a collection of
Database Management • 03 Data Definition Language
Column header is referred as
Database Management • 04 Data Manipulation Language
Consider the below table structure: Column Name DataType Constraint Empname Varchar(20) Not Null EmpId int(10) PK Phoneno bigint(10) Not Null insert i...
Database Management • 04 Data Manipulation Language
Examine the structure of the STUDENT table: Column Name DataType Constraint Stud_id int(3) PK Name Varchar(20) Not Null Address Varchar(30) DOB Date W...
Database Management • 04 Data Manipulation Language
State True or False. COMMIT ends the current transaction by making all pending data changes permanent.
Database Management • 04 Data Manipulation Language
Merge is not supported by MySQL. The other possible way of doing the work of merge statement, is by using ON DUPLICATE KEY UPDATE in the insert statem...
Database Management • 04 Data Manipulation Language
Which of the below is a reference option for deleting rows from a table?
Database Management • 04 Data Manipulation Language
To remove a relation from SQL database, we use ___________ command.
Database Management • 04 Data Manipulation Language
What is the Default format for Date datatype?
Database Management • 04 Data Manipulation Language
Numeric datatype is used to store_______
Database Management • 05 Sql Select Statement
Which statement about SQL is true?
Database Management • 05 Sql Select Statement
Select the suitable option for retrieving all the employees who have a manager?
Database Management • 05 Sql Select Statement
Select the suitable option for retrieving all the employees whose last name is "kumar"?
Database Management • 05 Sql Select Statement
How to retrieve department_id column without any duplication from employee relation?
Database Management • 05 Sql Select Statement
Which statement is true when a DROP TABLE command is executed on a table?
Database Management • 05 Sql Select Statement
Which statements are true regarding constraints? Select one or more: A constraint is enforced only for the INSERT operation on a table. A foreign key ...
Database Management • 05 Sql Select Statement
You need to remove all the data from the employee table while leaving the table definition intact. You want to be able to undo this operation. How wou...
Database Management • 05 Sql Select Statement
The SQL statements executed in a user session as follows: create table product(pid int(10),pname varchar(10)); Insert into product values(1,'pendrive'...
Database Management • 06 Function-Scalar & Aggregate
All columns in the SELECT list that are not in group functions must be in the GROUP-BY clause. State True or False.
Database Management • 06 Function-Scalar & Aggregate
Group functions can be used in the where clause. State True or False.
Database Management • 06 Function-Scalar & Aggregate
Single row functions can be nested to any level. State true or False.
Database Management • 06 Function-Scalar & Aggregate
What will be the output for the below query: select ceil(5.3) from dual;
Database Management • 06 Function-Scalar & Aggregate
We need to create a report to display the order id, ship date and order total of your ORDER table. If the order has not been shipped, your report must...
Database Management • 06 Function-Scalar & Aggregate
To generate a report that shows an increase in the credit limit by 15% for all customers. Customers whose credit limit has not been entered should hav...
Database Management • 06 Function-Scalar & Aggregate
To display the names of employees that are not assigned to a department. Evaluate this SQL statement: SELECT last_name, first_name FROM employee WHERE...
Database Management • 06 Function-Scalar & Aggregate
Which statement is true regarding the default behavior of the ORDER BY clause?
Database Management • 06 Function-Scalar & Aggregate
ABC company wants to give each employee a $100 salary increment. You need to evaluate the results from the EMP table prior to the actual modification....
Database Management • 06 Function-Scalar & Aggregate
Select the suitable option for fetching the output of the following query. select substr("Oracle World",1,6) from dual;
Database Management • 07 Joins & Subquery
Which operator is NOT appropriate in the join condition of a non-equi join SELECT statement?
Database Management • 07 Joins & Subquery
In which cases would you use an outer join?
Database Management • 07 Joins & Subquery
To display the names of employees who earns more than the average salary of all employees. SELECT last_name, first_name FROMemployee WHEREsalary > AVG...
Database Management • 07 Joins & Subquery
To create a report displaying employee last names, department names, and locations. Which query should you use to create an equi- join?
Database Management • 07 Joins & Subquery
Which statement would display the highest credit limit available in each income level in each city in the Customers table?
Database Management • 07 Joins & Subquery
Which SQL statement produces an error?
Database Management • 07 Joins & Subquery
The COMMISSION column shows the monthly commission earned by the employee. Emp_Id Dept_Id Commission 1 10 500 2 20 1000 3 10 4 10 600 5 30 800 6 30 20...
Database Management • 07 Joins & Subquery
What statement would display the age of Customers with the alias name as AGE?
Database Management • 08 Dcl & Database Objects
Which SQL statement would you use to remove a view called EMP_DEPT_VU from your schema?
Database Management • 08 Dcl & Database Objects
CREATE INDEX emp_dept_id_idx ON employee(dept_id); Which of the following statements are true with respect to the above index?
Database Management • 08 Dcl & Database Objects
An owner can give specific privileges on the owner's objects to others. State True or False.
Database Management • 08 Dcl & Database Objects
The owner has all the privileges on the object. State true or False.
Database Management • 08 Dcl & Database Objects
Which SQL statement grants a privilege to all the database users?
Database Management • 08 Dcl & Database Objects
Equijoin is called as ______.
Database Management • 08 Dcl & Database Objects
_____ is used to retrieve records that do not meet the join condition
Database Management • 08 Dcl & Database Objects
Joining a table to itself is called as ______.
Database Management • 08 Dcl & Database Objects
The _______ join is based on all columns in the two tables that have the same data type.
Database Management • 08 Dcl & Database Objects
The _______ join produces the cross product of two tables.
Database Management • 1. Rdbms Concepts
Tom has designed a payroll software for XYZ technology.The sofware will store the salary details into the database and later he can retreive the same ...
Database Management • 1. Rdbms Concepts
Which of the following is not a valid relational database?
Database Management • 1. Rdbms Concepts
SQL is a case sensitive language and the data stored inside the table are case in-sensitive. Say true or false?
Database Management • 1. Rdbms Concepts
Which of the following represents the degree of the relation?
Database Management • 1. Rdbms Concepts
Database is a shared collection of logically unrelated data, designed to meet the needs of an organization. State True or False.
Database Management • 3. Data Definition Language
We need to ensure that the amount withdrawn should be less then the credit card limit amount, to ensure this integrity what type constraint will be us...
Database Management • 3. Data Definition Language
A table consists of ______ primary keys.
Database Management • 3. Data Definition Language
An emp table contains fields employ name, desig and salary. How do you drop column salary?
Database Management • 3. Data Definition Language
Which of the following options is not correct?
Database Management • 3. Data Definition Language
Which of the following is not modification of the database
Database Management • 3. Data Definition Language
A relational database consists of a collection of
Database Management • 3. Data Definition Language
Column header is referred as
Database Management • 3. Data Definition Language
___________ removes data from the table, but structure remains the same.
Database Management • 3. Data Definition Language
In a relational database a referential integrity constraint can be done using
Database Management • 4. Data Manipulation Language
Merge is not supported by MySQL. The other possible way of doing the work of merge statement, is by using ON DUPLICATE KEY UPDATE in the insert statem...
Database Management • 4. Data Manipulation Language
Consider the below table structure: Column Name DataType Constraint Empname Varchar(20) Not Null EmpId int(10) PK Phoneno bigint(10) Not Null insert i...
Database Management • 4. Data Manipulation Language
Examine the structure of the STUDENT table: Column Name DataType Constraint Stud_id int(3) PK Name Varchar(20) Not Null Address Varchar(30) DOB Date W...
Database Management • 4. Data Manipulation Language
State True or False. COMMIT ends the current transaction by making all pending data changes permanent.
Database Management • 4. Data Manipulation Language
Numeric datatype is used to store_______
Database Management • 4. Data Manipulation Language
Which of the below is a reference option for deleting rows from a table?
Database Management • 4. Data Manipulation Language
To remove a relation from SQL database, we use ___________ command.
Database Management • 4. Data Manipulation Language
What is the Default format for Date datatype?
Database Management • 5. Sql Select Statement
How to retrieve department_id column without any duplication from employee relation?
Database Management • 5. Sql Select Statement
Select the suitable option for retrieving all the employees who have a manager?
Database Management • 5. Sql Select Statement
Select the suitable option for retrieving all the employees whose last name is "kumar"?
Database Management • 5. Sql Select Statement
Which statement about SQL is true?
Database Management • 5. Sql Select Statement
Which statement is true when a DROP TABLE command is executed on a table?
Database Management • 5. Sql Select Statement
Which statements are true regarding constraints? Select one or more: Af i k t t i NULL l A foreign key cannot contain NULL values. A constraint is enf...
Database Management • 5. Sql Select Statement
The SQL statements executed in a user session as follows: create table product(pid int(10),pname varchar(10)); Insert into product values(1,'pendrive'...
Database Management • 5. Sql Select Statement
You need to remove all the data from the employee table while leaving the table definition intact. You want to be able to undo this operation. How wou...
Database Management • 6. Function-Scalar & Aggregate
What will be the output for the below query: select ceil(5.3) from dual;
Database Management • 6. Function-Scalar & Aggregate
Single row functions can be nested to any level. State true or False.
Database Management • 6. Function-Scalar & Aggregate
All columns in the SELECT list that are not in group functions must be in the GROUP-BY clause. State True or False.
Database Management • 6. Function-Scalar & Aggregate
Group functions can be used in the where clause. State True or False.
Database Management • 6. Function-Scalar & Aggregate
We need to create a report to display the order id, ship date and order total of your ORDER table. If the order has not been shipped, your report must...
Database Management • 6. Function-Scalar & Aggregate
Select the suitable option for fetching the output of the following query. select substr("Oracle World",1,6) from dual;
Database Management • 6. Function-Scalar & Aggregate
To display the names of employees that are not assigned to a department. Evaluate this SQL statement: SELECT last_name, first_name FROM employee WHERE...
Database Management • 6. Function-Scalar & Aggregate
ABC company wants to give each employee a $100 salary increment. You need to evaluate the results from the EMP table prior to the actual modification....
Database Management • 6. Function-Scalar & Aggregate
To generate a report that shows an increase in the credit limit by 15% for all customers. Customers whose credit limit has not been entered should hav...
Database Management • 6. Function-Scalar & Aggregate
Which statement is true regarding the default behavior of the ORDER BY clause?
Database Management • 7. Joins & Subquery
To display the names of employees who earns more than the average salary of all employees. SELECT last_name, first_name FROMemployee WHEREsalary > AVG...
Database Management • 7. Joins & Subquery
In which cases would you use an outer join? Selectone: Seec o e: The tables being joined have only unmatched data. Only when the tables have a primary...
Database Management • 7. Joins & Subquery
Which operator is NOT appropriate in the join condition of a non-equi join SELECT statement?
Database Management • 7. Joins & Subquery
Which statement would display the highest credit limit available in each income level in each city in the Customers table?
Database Management • 7. Joins & Subquery
What statement would display the age of Customers with the alias name as AGE?
Database Management • 7. Joins & Subquery
Which SQL statement produces an error?
Database Management • 7. Joins & Subquery
The COMMISSION column shows the monthly commission earned by the employee. Emp_Id Dept_Id Commission 1 10 500 2 20 1000 3 10 4 10 600 5 30 800 6 30 20...
Database Management • 7. Joins & Subquery
To create a report displaying employee last names, department names, and locations. Which query should you use to create an equi-join?
Database Management • 8. Dcl & Database Objects
An owner can give specific privileges on the owner's objects to others. State True or False.
Database Management • 8. Dcl & Database Objects
Which SQL statement grants a privilege to all the database users?
Database Management • 8. Dcl & Database Objects
CREATE INDEX emp_dept_id_idx ON employee(dept_id); Which of the following statements are true with respect to the above index?
Database Management • 8. Dcl & Database Objects
Which SQL statement would you use to remove a view called EMP_DEPT_VU from your schema?
Database Management • 8. Dcl & Database Objects
The owner has all the privileges on the object. State true or False.
Database Management • 8. Dcl & Database Objects
Joining a table to itself is called as ______.
Database Management • 8. Dcl & Database Objects
Equijoin is called as ______.
Database Management • 8. Dcl & Database Objects
The _______ join is based on all columns in the two tables that have the same data type.
Database Management • 8. Dcl & Database Objects
The _______ join produces the cross product of two tables.
Database Management • 8. Dcl & Database Objects
_____ is used to retrieve records that do not meet the join condition
Database Management • Data Definition Language
Which command is used to change a table's behavior?
Database Management • Data Definition Language
We need to ensure that the amount withdrawn should be less then the credit card limit amount, to ensure this integrity what type constraint will be us...
Database Management • Data Definition Language
An emp table contains fields employ name, desig and salary. How do you drop column salary?
Database Management • Data Definition Language
How would you add a foreign key constraint on the dept_no column in the EMP table, referring to the id column in the DEPT table?
Database Management • Data Definition Language
A table consists of ______ primary keys.
Database Management • Data Definition Language
__________ command is used to delete the records and _________ command is used to delete the db objects?
Database Management • Data Definition Language
Which of the following options is not correct?
Database Management • Data Definition Language
Which of the following is not modification of the database?
Database Management • Data Definition Language
Which of the following data models supports many-to-many relationships?
Database Management • Data Definition Language
Which of the following is not a part of RDBMS?
Database Management • Data Definition Language
Which of these are standard and best practises for SQL?
Database Management • Data Manipulation Language
Which are auto-commit statements?
Database Management • Data Manipulation Language
Which of the update statement produces the following error in the employee table? ORA-02291: integrity constraint (SYS_C23) violated - parent key not ...
Database Management • Data Manipulation Language
Which of the following is not a DML statement?
Database Management • Data Manipulation Language
Which SQL statement needs both insert and update privilege on the target table and select privilege on the source table?
Database Management • Data Manipulation Language
On delete restrict is used to restrict the deletion of child records. State True or False.
Database Management • Data Manipulation Language
Delete statement supports up to two conditions only. State True or False
Database Management • Data Manipulation Language
Which statement inserts a new row into the STUDENT table?
Database Management • Data Manipulation Language
insert into employee(empid,empname)values(123,'John'); When we issue the above insert command and if the statement fails, what would be the reason.
Database Management • Data Manipulation Language
DELETE FROM dept WHERE dept_id = 901; The above delete statement throws an integrity constraint error because a child record was found. What could we ...
Database Management • Data Manipulation Language
Which query is used to delete employee records whose age is greater than 55?
Database Management • Data Manipulation Language
By using _____ datatype we can store numeric and character values as an input .
Database Management • Data Manipulation Language
To permanently remove all the data from the STUDENT table, and you need the table structure in the future. Which single command performs this?
Previous
Page 3 of 15
Next