All Topics
Topic104 questions
Accenture Database ManagementQuestions & Answers
Practice 104 verified Accenture Database Management questions with detailed answers and explanations. Tap any question below to study the full solution — perfect for last-minute Accenture primer and dumps prep.
Database Management question list
Tom has designed a payroll software for XYZ technology.The sofware will store the salary details into the database and later he ca…In SQL is a case sensitive language and the data stored inside the table are case in-sensitive. Say true or false?Which of the following is not a valid relational database?Database is a shared collection of logically unrelated data, designed to meet the needs of an organization. State True or False.Which of the following represents the degree of the relation?A table consists of ______ primary keys.We need to ensure that the amount withdrawn should be less then the credit card limit amount, to ensure this integrity what type c…Which of the following options is not correct?An emp table contains fields employ name, desig and salary. How do you drop column salary?Which of the following is not modification of the databaseIn a relational database a referential integrity constraint can be done using___________ removes data from the table, but structure remains the same.A relational database consists of a collection ofColumn header is referred asConsider the below table structure: Column Name DataType Constraint Empname Varchar(20) Not Null EmpId int(10) PK Phoneno bigint(1…Examine the structure of the STUDENT table: Column Name DataType Constraint Stud_id int(3) PK Name Varchar(20) Not Null Address Va…State True or False. COMMIT ends the current transaction by making all pending data changes permanent.Merge is not supported by MySQL. The other possible way of doing the work of merge statement, is by using ON DUPLICATE KEY UPDATE …Which of the below is a reference option for deleting rows from a table?To remove a relation from SQL database, we use ___________ command.What is the Default format for Date datatype?Numeric datatype is used to store_______Which statement about SQL is true?Select the suitable option for retrieving all the employees who have a manager?Select the suitable option for retrieving all the employees whose last name is "kumar"?How to retrieve department_id column without any duplication from employee relation?Which statement is true when a DROP TABLE command is executed on a table?Which statements are true regarding constraints? Select one or more: A constraint is enforced only for the INSERT operation on a t…You need to remove all the data from the employee table while leaving the table definition intact. You want to be able to undo thi…The SQL statements executed in a user session as follows: create table product(pid int(10),pname varchar(10)); Insert into product…All columns in the SELECT list that are not in group functions must be in the GROUP-BY clause. State True or False.Group functions can be used in the where clause. State True or False.Single row functions can be nested to any level. State true or False.What will be the output for the below query: select ceil(5.3) from dual;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 shipp…To generate a report that shows an increase in the credit limit by 15% for all customers. Customers whose credit limit has not bee…To display the names of employees that are not assigned to a department. Evaluate this SQL statement: SELECT last_name, first_name…Which statement is true regarding the default behavior of the ORDER BY clause?ABC company wants to give each employee a $100 salary increment. You need to evaluate the results from the EMP table prior to the …Select the suitable option for fetching the output of the following query. select substr("Oracle World",1,6) from dual;Which operator is NOT appropriate in the join condition of a non-equi join SELECT statement?In which cases would you use an outer join?To display the names of employees who earns more than the average salary of all employees. SELECT last_name, first_name FROMemploy…To create a report displaying employee last names, department names, and locations. Which query should you use to create an equi- …Which statement would display the highest credit limit available in each income level in each city in the Customers table?Which SQL statement produces an error?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 …What statement would display the age of Customers with the alias name as AGE?Which SQL statement would you use to remove a view called EMP_DEPT_VU from your schema?CREATE INDEX emp_dept_id_idx ON employee(dept_id); Which of the following statements are true with respect to the above index?An owner can give specific privileges on the owner's objects to others. State True or False.The owner has all the privileges on the object. State true or False.Which SQL statement grants a privilege to all the database users?Equijoin is called as ______._____ is used to retrieve records that do not meet the join conditionJoining a table to itself is called as ______.The _______ join is based on all columns in the two tables that have the same data type.The _______ join produces the cross product of two tables.SQL is a case sensitive language and the data stored inside the table are case in-sensitive. Say true or false?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.…In which cases would you use an outer join? Selectone: Seec o e: The tables being joined have only unmatched data. Only when the t…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 …Which command is used to change a table's behavior?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?__________ command is used to delete the records and _________ command is used to delete the db objects?Which of the following data models supports many-to-many relationships?Which of the following is not a part of RDBMS?Which of these are standard and best practises for SQL?Which are auto-commit statements?Which of the update statement produces the following error in the employee table? ORA-02291: integrity constraint (SYS_C23) violat…Which of the following is not a DML statement?Which SQL statement needs both insert and update privilege on the target table and select privilege on the source table?On delete restrict is used to restrict the deletion of child records. State True or False.Delete statement supports up to two conditions only. State True or FalseWhich statement inserts a new row into the STUDENT table?insert into employee(empid,empname)values(123,'John'); When we issue the above insert command and if the statement fails, what w…DELETE FROM dept WHERE dept_id = 901; The above delete statement throws an integrity constraint error because a child record was f…Which query is used to delete employee records whose age is greater than 55?By using _____ datatype we can store numeric and character values as an input .To permanently remove all the data from the STUDENT table, and you need the table structure in the future. Which single command pe…Which statement would you use to add a primary key constraint to the patient table using the id_number column, immediately enablin…Composite key is used in one to one relationship. State true or false.Which CREATE TABLE statement is valid?Cascade constraints are used only in drop statements. State True or False.select substr("Oracle World",1,6) from dual;To display the names of all promos done after January 1, 2001 starting with the latest promo. Which query would give the required …To calculate the number of days from 1st Jan 2007 till date: Dates are stored in the default format of dd-mm-rr. Which SQL stateme…The CUSTOMERS table has these columns: CUSTOMER_ID NUMBER(4) NOT NULL; CUSTOMER_NAME VARCHAR2(100) NOT NULL; CUSTOMER_ADDRESS VARC…Generate a list of all customer last names with their credit limits from the CUSTOMERS table. Customers who do not have a credit l…To update the CUST_CREDIT_LIMIT column to NULL for all the customers, where CUST_INCOME_LEVEL has NULL in the CUSTOMERS table. Whi…Tom has designed a payroll software for XYZ technology.The software will store the salary details into the database and later he c…Which statement is used to manipulate data without affecting the data in the table?Which operator is equivalent to the ‘or’ operator?Select the suitable option for retrieving all the employees whose name ends with "kumar"?Select the suitable option for retrieving all the employees whose salary range is between 40000 and 100000?Which statement is true regarding distinct keywords?Which option is used to delete data from both parent and child tables?How do we represent comments in oracle?Which query will change the cust_address to 'Panama' for those who are from ‘Los Angeles’?Which statement is used to update multiple rows in a single query?A DML statement is used to modify the structure of the database. State True or false.Which statements are true regarding constraints?Which query will delete all the data in the Employee table that belongs to the employee id 1207?Create table subjects(Sub_id number(2) primary key,Subj_name varchar(50)); Insert into subjects values (null,’Oracle’); What will …Practice more Accenture topics
PrimerDumps has 1400+ primer questions, 2026 mocks and coding hands-on — all free.