What is the difference between Memory_target and
Memory_max_target? Why its required to resize these parameter?
Can you export a table along with partition?
Enlist some commands of ddl, dml, and dcl.
Why do we need database?
1.If we have a Salary coloumn in Staff entity with this description the salary must be monetary and >=$35450.00, how we can write it in into schemain SQL? 2. If we have Weight and Marks in Assessment entity and the Weight has the description of this it must be Non-zero percentage. And also the Marks attribute stores the maximum possible raw mark for assessment (e.g., 30), while Weight stores of the weight of this assessment for the paper as a whole (e.g., 10%). If Marks is not specified, then Weight is used for both. How we can convert this into schema in SQL????
Which parameters are optional in init.ora parameter file?
What is atomicity in dbms?
What is foreign key in dbms?
Explain the use of assign statement in progress database?
What is data model example?
What is the use of CONSTRAINTS option in EXP command ?
What is rdbms and also explain its components?
when A set of Dictionary tables are created ?
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)