Latest Answer: Meta Data provides a context for data. It is used to faciliate the understanding,characteristics, and management usage of data. E.g. we have as:metadata for :Book: author,publisher,ISBN,and number or other data.Camera: the photographtaken details like ...
Latest Answer: once we using truncate 100 rows(table have 100 rows )delete at once and not a chance to rollback in truncate. ...
Latest Answer: yes we can create table by using pl/sql progarm.ravi ...
What is the output of the programvoid main(){struct a{int i;char *st1;};typedef struct a ST;ST *str1;str1=(ST*)malloc(100);str1->i=100;strcpy(str1->st1,"Welcome to Oracle");printf(" %d%sn",str1->i,str1->st1);getch();}A. core dumpB. will not compileC. 100,Welcome to OracleD. None of these
C
Which of the following statements is not true about views?A. You can create an index on viewsB. Views do not have permanent dataC. Views can be based on one or more tablesD. Views can be dropped without dropping tables
What is the result of the fallowing code?PieceInsert into table A value(a1):CREATE TABLE B AS SELECT * FROM A;ROLLBACK;A. Table B gets created with the row inserted in the first statement.B. Table B is not createdC. Table B gets created, but no row gets inserted into Table AD. Rollback throws up an exception.
How many JOIN conditions are needed in JOIN query to avoid a cartesian product?A. No of tables + 1B. No of tables - 1C. No of columns + 1D. No of columns - 1
What will be the output of the fallowing SELECT statement?SELECT count(*)FROM empWhere exist (select 'X' From deptwhere dept_name ='Stores' and dept.dept_id=emp.dept_id)A. select total number of employees belonging to department " stores "B. select all employees belonging to department "X"C. select all employees belonging to department "stores"D. select total number of employees belonging to department "X"
Latest Answer: Where clause is the correct answer. Order of execution iswheregroup byhaving ...
Latest Answer: LIKE ...
View page [1] 2 3 4 Next >>
Go Top
