I need the previous placement questions for automata programming test
Posts: 14,118
Threads: 61
Joined: Oct 2014
Here are some examples of questions to get you scared.
1 minute. Permission needed to execute the drop database command
- DB Admin
- Owner of DB
- Control
- User
2. You want to create an index in a column such that the select statement requires min time to retrieve the data. The column is unique and if the data is physically ordered, the query will be faster. What index would I see.
- Grouped
- Not grouped
- Only
- Compound
3. Which of the following may appear in any order, so the relation will be the same and therefore convey the same meaning.
- Attributes
- Entity
- Tuples
- Entity set
4. How will you enable SQL 2005 to physically store calculated values in the table and update when other columns are updated?
- Use calculated expressions and provide expression
- Use persistent option during table creation
- Create a Clustered Index in the Calculated Column
- Create a default constraint on computed expr.
5. Which of the stmt. Is it related to the next created view?
- Create VIEW emp_dept_outerjoin1 AS SELECT empno, ename, e.deptno, dname, loc FROM emp_tab e, dept_tab d WHEN e.deptno = d.deptno (+);
- View correctly created
- Views involving external joins are not modifiable
- Column in the base empt_tab table of emp_dept_outerjoin1 are modifiable through the view
- The columns in table dept_tab of emp_dept_outerjoin1 are modifiable through the view
- The column in the emp_tab base of emp_dept_outerjoin1 is not modifiable through the view
6. Which of the following is included in DML
- release
- Alter
- Insert
- Create